Informatica Developer - Machine Learning & Data Analytics Domain (3-7 Yrs) Chennai (Systems/Product Software)

Opportunity for the position of Informatica Developer & Senior Informatica Developer in an U.S Based Machine Learning & Data Analytics firm in Chennai, Experience : 4 - 7 years Job Location : Chennai Skill Set : Informatica Database : SQL Server/Oracle, Teradata/Netezza/Green Plum BI Skills : - Good knowledge of dimensional modeling and DWH concepts like change data capture (CDC) - SQL Programming: Knowledge in basic and advanced concepts like PL/SQL, analytical functions etc.
-Knowledge in Shell scripting - Data Profiling and Data validation - Ensuring accuracy and integrity of data and applications through analysis, coding, documenting, testing and problem solving - Setting up the development environment and configuration of the development tools - Efficient in coding and understanding the deliverables - Developing of the deliverables with unit testing and code documentation - Knowledge in performance tuning and optimization - Understanding and Implementing QA and various testing process in the project - Co-ordinating with the UAT team. Informatica : - Build the data gathering, collating and modeling process using Scripts and create the final model on MS Excel - Understanding the change data capture (CDC), slowly changing dimensions (SCD), Data Profiling and Data validation concepts - Experience in estimating ETL requirements, designing and architecting integration solutions - Good knowledge in designing and developing ETL mappings using Informatica Designer/any ETL tool - Configuring sessions/workflows using Workflow Manager - Understanding configuration, migration and deployment of ETL mappings - Knowledge in performance tuning and optimization Additional Skills : - Exposure to other tools (MS SQL SSIS, Talend, DataStage, DataServices) a plus - Understanding of/Exposure to Reporting a plus - Good to have if they know one of the database skill Netezza, Green Plum or Teradata. Ramesh Kumar.K

Required Skills : English