Job Description :
Job Title: Informatica ETL Developer
Location: Hoboken, NJ, United States
Duration: 6+ Months
Requisition Details:
Experience of 6 to 10 years in Informatica 9.x Power Centre and Informatica Data Quality IDQ.
Hands-on experience in Oracle 10g/11g, PLSQL and SQL Server skills with fine tune the queries for performance improvement SQL, PL/SQL and ETL.
Strong experience in developing ETL mappings and scripts using Informatica Power Center
Proficient in developing strategies for extracting, transforming and loading using Informatica Power Center 9.1/8.6/8.1
Implemented data strategies, build data flows and developed conceptual, logical and physical data models to support new and existing projects.
Extensive experience on End-to-End implementation of Data warehouse and Strong understanding of Data warehouse concepts and methodologies.
Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse
Strong understanding of Dimensional Modelling and Data Warehousing concepts
Good understanding of the commonly used transformations like Source qualifier, joiners, union, aggregator, sorter, expression, transaction control, xml transformation, lookups etc
Good understanding on the parameter file concepts and how they can leveraged for good design and solutions
Ability to debug production and UAT issues and also good understanding of performance tuning techniques
Ability to analyze, design, implement and test medium to complex mappings independently. Ability to design and implement easily scalable ETL components