ETL Developer - Informatica/power Center

Job Description

• - Create LLD/STM documents develop test and deploy data integration processes using Informatica PowerCenter - Collaborate with onshore/offshore lead designers analyze LLD/STM translate & apply business rules to data transformations - Adopt integration standards best practices ABC framework etc while creating ETL jobs. - Performs data validation cleansing and analysis. - Tests debugs and documents ETL processes SQL queries and stored procedures - Analyzes data from various sources including databases and flat files - ETL development deployment optimization support and defect fixes. - Develop error handling processes - Create and implement scheduling strategy - Possess good knowledge of Agile and Waterfall methodologies. - 3-5 years of experience with data integration tools especially Informatica or SSIS - Experience with DataStage Talend or Pentaho are a definite plus - Advanced knowledge of ETL including the ability to read and write efficient robust code follow or implement best practices and coding standards design/implement common ETL strategies (CDC SCD etc.) and create reusable/maintainable jobs - Solid background in database systems (such as Oracle SQL Server and Teradata) along with strong knowledge of PL/SQL and SQL - Knowledge and hands on of Unix commands and Shell Scripting - Good knowledge of SQL including the ability to write stored procedures triggers functions etc. - Knowledge of relational and dimensional database structures theories principles and practices - Knowledge on data model to develop Dimension and Fact mappings/jobs. Please refer to the Job description above

Job Summary