Previous Job
Informatica/ Oracle Developer
Ref No.: 18-72232
Location: Charlotte, North Carolina
Position Type:Direct Placement
Start Date: 10/01/2018
Job Title: Informatica/ Oracle Developer
Job Location: Charlotte, NC
Duration: Fulltime
Required skills-
• 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.