Previous Job
Previous
Informatica/Oracle Developer
Ref No.: 18-66558
Location: Jersey City, New Jersey
Position Type:Full Time/Contract
Start Date: 09/11/2018
Informatica/Oracle Developer
Jersey City/Pennington/Charlotte

"Description:
Job Description
• This position is responsible for providing Informatica/Oracle Developer, with strong hands on development of Informatica ,solutions involving complex objects using Oracle pl/sql , Oracle 11g/12c/Exadata experience, including designing tables, stored procedures, triggers, and user-defined functions, performance tuning and should have the ability to lead application development, support and guidance to the other associates should they run into any process, or technical challenge.
• Extensive experience with ETL development using Informatica Power Center (Version 10 (Preferred)) design, development, application troubleshooting, workload management and performance tuning.
• Must have ability to develop complex Informatica ETL mappings and workflows extracting data from various heterogeneous source systems like Flat files, XML, Oracle, SQL Server and Web services.
• Expertise with complex transformations like Normalizer, XML Generator, XML parser to transform XML files.
• Expertise in developing and implementing best practices in ETL specifics to process control, exception management in a data warehouse environment.
• Build, maintain, and enhance all objects packages/functions in PL/SQL to support application process.
• Perform functions including SQL tuning, database application design, and developer support
• Ability to quickly diagnose the problem areas and come up with solutions and/or workarounds
• Write clear, concise, well organized technical documentation to maintain standards and procedures
• Understand the requirement and analyze on a technical feasibility and design.
Coding the requirement and proper Check in / Checkout in Version control.
• Unit Test Cases Preparation and Execution
• Code Review and Checklist document preparation.
• QA, UAT and PROD Release Scripts/Package Preparation and Validation.
• Knowledge in multiple software development lifecycle phases, including design, construction, and testing
• Be a key contributor to initiatives that require technical expertise.
• Communicate with technical partners and come up with solutions.
• Collaborate with the team to coordinate delivery of software application.
• Strong problem solving, analytical and interpersonal skills.
• Experience in Autosys Scheduling tool
• Work in a fast paced environment, under minimal supervision providing technical guidance to the team members.
• Need to work with both the Charlotte/New York/New Jersey as well as India teams. This will mean attending meetings during timings enabling the global teams to meet.
Job Requirements:
• 7+ years of Application Programming experience
• 7+ years - Expert knowledge in Informatica (Power Center)
• 5+ years - Expert knowledge of Oracle, Knowledge of Exadata is an advantage.
• 5+ years - Database design, Data analysis for root cause
• Experience with the development of complex Informatica ETL mappings and workflows extracting data from various heterogeneous source systems like Flat files, XML, Oracle, SQL Server and Web services
• Performance Tuning of SQLs and experience handling Extra Large databases
• Knowledge of Oracle Internals and be able to advice team members of best practices and recommend solutions for performance issues.
• Experience as a DBA is an advantage (Not necessary)
• Unit testing skills, Proficient in problem root cause analysis and Analytical thinking
• Experience with the development models and software development lifecycle
• Experience working in full iterative/Agile development environment
• Relational database experience and demonstrated abilities in SQL and data modeling is required
"