Description

Design, build, and maintain ETL processes using Informatica to move data from source systems to target applications.

This role is on-site.

Responsibilities

• Design and modify ETL mappings, workflows, and technical specifications.
• Build integrations for data warehousing objects including star schemas, aggregations, and type-2 dimensions.
• Load data from SF Power Exchange to MongoDB using Informatica.
• Collaborate with DBAs and Data Architects to implement data partitioning strategies.

Required Skills

• 5-7 years of experience with Informatica PowerCenter 10.x.
• Proficiency with Informatica PowerExchange and Informatica Data Quality (Analyst and Developer).
• Hands-on experience with MongoDB, IMS, and Relational Databases.
• Working knowledge of XML, XML parser, Java, and HTTP transformations within Informatica.
• Strong SQL skills for code optimization and tuning.
• Bachelor's Degree in Computer Science or equivalent training.

Preferred Skills

• Experience developing stored procedures and database triggers.

Key Skills

Education

Bachelor's Degree