ETL Informatica

Job Description: Informatica/ETL Developer
 
Primary Skills: Informatica
 
Role Description: The Informatica/ETL PowerCenter Developer would
need to have at least 5-7 years of experience.
 
Responsibilities and Qualifications:

- Participates 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.).
- Performs source system analysis as required.
- Works with DBAs and Data Architects to plan and implement appropriate
data partitioning strategy in Enterprise Data Warehouse.
- Implements versioning of the ETL repository and supporting code as
necessary.
- Develops stored procedures, database triggers and SQL queries where
needed.
- Implements best practices and tunes SQL code for optimization.
- Loads data from SF Power Exchange to Relational database using
Informatica.
- Works with XML's, XML parser, Java and HTTP transformation within
Informatica.
- Works with Informatica Data Quality (Analyst and Developer)
- Primary skill is Informatica PowerCenter
- 5-7 years of experience.
 Top Three Skills Required:
 - Informatica PowerCenter, Informatica Data Quality.

 
Education: Bachelor’s degree in Computer Science, Electrical/Electronic
Engineering, Information Technology or another related field                      
Experience: Minimum 5-7 years