Description

Design, code, and modify ETL processes using Informatica to move data from source to target applications.

Responsibilities

• Design new or changing mappings, workflows, and technical specifications.
• Create ETL mappings, maplets, workflows, and worklets using Informatica PowerCenter 10.x.
• Build integrations for data warehousing objects including star schemas, aggregations, and type-2 dimensions.
• Collaborate with DBAs and Data Architects to implement data partitioning strategies in the Enterprise Data Warehouse.
• Load data from SF Power Exchange to MongoDB using Informatica.

Required Skills

• 5-7 years of experience with Informatica PowerCenter.
• Proficiency with Informatica PowerExchange.
• Experience with 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