Description

You will design and implement ETL processes for enterprise data warehousing using Informatica PowerCenter.

This role is on-site.

Responsibilities

• Create ETL mappings, maplets, workflows, and worklets using Informatica PowerCenter 10.x.
• Design integrations for star schemas, aggregations, and type-2 dimensions.
• Develop stored procedures, database triggers, and optimized SQL queries.
• Collaborate with DBAs and Data Architects to implement data partitioning strategies.
• Manage versioning for the ETL repository and perform source system analysis.

Required Skills

• 5+ years of experience with Informatica PowerCenter 10.x.
• Strong proficiency in Oracle SQL.
• Hands-on experience with Java transformations within Informatica.
• Experience with XML, XML Parser, and HTTP transformations.
• Knowledge of ETL design patterns and data warehousing principles.
• Ability to load data from SF Power Exchange to relational databases.
• Experience using Informatica Data Quality (Analyst and Developer).

Preferred Skills

• Any Graduate degree.

Key Skills

Education

Any Graduate