Job Description
Job Title: PL/SQL Developer
Location : Princeton, NJ (Hybrid Onsite -4 Days Onsite Per Week)
Duration : Fulltime
Teams Meeting Interview
Job Description:
Primary Skill - PL/SQL and UNIX Scripting
- Strong knowledge and hands on engineering and development experience:
- Oracle data model and tables design, complex queries development and tuning
- Oracle PL/SQL and SQL queries development, tuning and optimization experiences, OLTP transaction processing and experience with manipulating large date sets
- Develop triggers to log audit logs and data change history
- Strong experience and ability to work in the team environment as well as deliver tasks with little supervision, analyze issues and proposed solutions are must
- Application Development Experience with Java and/or .Net technologies with use of Web Services APIs, JavaScript, XML, JSON, AJAX and others is highly desired
- Strong knowledge and hands on experience with scripting and ETL data manipulation abilities in Pentaho Data Integration (PDI) is highly desired
- Hands on experience
- API and Integration development leveraging above technology
- Strong SQL Server and tSQL experience a plus
- Experience with Excel pivot tables and graphic chart for data analysis and reporting
- OS UNIX, Windows and SQL database experience and knowledge are a plus
- Participates in unit testing and team data quality efforts
- System Integration Testing including integration with upstream and downstream systems
- Strong and solid understanding of testing and implementation lifecycles for identity access technologies including root cause analysis.