***** Direct Client Requirement*****
Title : Lead ETL Informatica Developer
Location : Amelia, OH
Rate : DOE /If your experience and skills match call us immediately for submission
Duration : 12 Months
Interview Type : Phone or Skype
Work Status : Successful applicants must be legally authorized to work in the U.S
Job Type : W2
Experience : 8 years
Prefer W2 : U S C/ G C /H1B Transfer/OPT/CPT/H4 EAD and other US work authorization are accepted
Client is doing a migration from Datastage to Informatica. Required experience with Informatica IICS, EDC and AXON
- Expert Knowledge of Informatica PowerCenter and other related components
- Participate in Detailed Technical Design, development, implementation and Support of data applications.
- Manage and customize all ETL processes as per customer requirement and analyze all processes for same.
- Analyze all complex data and identify requirements for business enhancement in project.
- Be able to lead the development effort and coordinate with Offshore team.
- Use acquired knowledge and develop Logical Data Models, Physical Data Models, and Data Element Dictionaries
- Translate Business requirements into Data Requirements. Understand the data elements and their domains; understand relationships among those elements and inter-dependencies between models.
- Working knowledge of RDBMS, dimensional modeling, and data warehousing techniques
- Must understand relational databases and be able to write and execute SQL statements with extensive experience in MS SQL Server and Oracle.
- Experience facilitating group sessions with key SMEs, and driving groups toward consensus on data design matters
- Be able to understand existing code base in DataStage and convert to Informatica mappings
- Troubleshoot and debug Informatica mappings, sessions and workflows
- Performance tuning experience and be able to work with large volumes of data
- Work in Agile projects
Informatica PowerCenter : 6-8 years
SQL Server : 3-4 years
Informatica EDC / AXON : 1-2 years
Informatica EDP : 1-2 yearsIICS – Cloud Services
Informatica MFT : 2 Years
Informatica DQ/BDM/DEI : 2 Years
Microsoft Azure : 1-2 YearsAgile Methodology : 2-3 Years
****Referral Bonus Available: Refer your friends or colleagues, get referral bonus******
Apply here or Please send to firstname.lastname@example.org
Follow us on LinkedIn and Twitter for daily active requirements
Position Keywords: Informatica IICS, EDC AXON,Informatica PowerCenter,SQL Server,Informatica EDC / AXON,Agile Methodology
Pay Rate: DOE/If your experience and skills match call us immediately for submission
Job Duration: 8 Months
% Travel Required: None
Job Posted by: Consulting Services
Job ID: OOJ - 2937
Work Authorization: Successful applicants must be legally authorized to work in the U.S