Description
Job summary Responsibilities and Qualifications:

- 5+ years of experience in ETL

Required Skills -Informatica Power Center Informatica, informatica Data Quality, and SQL

Shift Day 9AM TO 7PM EST

Responsibilities: - 5+ years of experience in ETL Design of new or changing mappings and workflows with the team and prepares technical specifications. - Creates ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter 10.x and prepare corresponding documentation. - Designs and builds integrations supporting standard data warehousing objects (type-2 dimensions, aggregations, star schema, etc.). Develops stored procedures, database triggers and SQL queries where needed. - Implements best practices and tunes SQL code for optimization.

Qualifications
Technical Skills

SNo

Primary Skill

Proficiency Level *

Rqrd./Dsrd.

1

SQL

PL1

Desired

2

Informatica PowerCenter

PL1

Required

3

informatica Data Quality

PL1

Required

4

Informatica

PL1

Required

* 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.