Job Description:

Roles and Responsibilities

·                Perform detail design, development, documentation, debugging and implementation of solutions for Informatica ETL requirements.  

·                Should have strong skills on ETL design patterns and data architecture, UNIX and Oracle, DB2, Teradata, Netezza, SQL Server  

·                To provide end to end ETL Design solutions and support Architecture in defining strategies. Leading team of designers and developers  

·                To understand the overall purpose of the projects and contribute to requirements & data analysis, and provide solutions from an ETL perspective  

·                Delivery of low level design documents with ETL & DWH strategy, standards and adhering to ETL & BIW principles & policies.  

·                Strong understanding of ETL, Application Data Integration, DWH and Report designs with functional and non-functional assessment for global implementations.  

·                Identify data source for different type of Customer data and analyze applications / system data  

·                Accountable for project related queries/issues.  

·                Should be well versed with following Informatica PowerCenter Client’s tool set –  

o        Informatica PowerCenter Designer - Mapping Development  

o        Informatica PowerCenter Workflow Manager – Workflow Development  

o        Informatica PowerCenter Workflow Monitor – Job Monitoring  

o        Informatica PowerCenter Repository Manager – Building Code Deployment Queries   

o        Good exposure of Informatica Command line utilities such as pmcmd, pmrep, etc.  

o        Able to design end to end ETL solution for complex case studies.  

·                Working knowledge of at least one Job scheduler tool.  

·                Identify data source for different type of Customer data and analyze applications / system data  

·                Using all of the above components to create and maintain an enterprise data solution and rules execution.  

·                Must have hands-on experience with SQL, Shell Scripting, bash, Korn shell scripting, SQL performance tuning, relational model analysis and data migration.  

·                Should have good communication skills and client handling skills.  

·                Strong knowledge in BI and Data Warehousing.  

Technical Skills

SNo	Primary Skill	Proficiency Level *	Rqrd./Dsrd.
1	Informatica PowerCenter	PL3	Required
2	SQL Scripting	PL3	Desired
3	Oracle	PL2	Desired
4	Unix Shell Scripting	PL1	Desired

 

* Proficiency Legends

Proficiency Level	Generic Reference
PL1	The associate has basic awareness and comprehension of the skill and is in the process of acquiring this skill through various channels.
PL2	The associate possesses working knowledge of the skill, and can actively and independently apply this skill in engagements and projects.
PL3	The associate has comprehensive, in-depth and specialized knowledge of the skill. She / he has extensively demonstrated successful application of the skill in engagements or projects.
PL4	The associate can function as a subject matter expert for this skill. The associate is capable of analyzing, evaluating and synthesizing solutions using the skill.

Apply Now