Description

You will design, develop, and maintain Informatica mappings and ETL processes, ensuring data integrity and performance optimization across Oracle, DB2, and SQL Server environments.

This role is remote.

Responsibilities

• Design and implement Informatica 10.1 PowerCenter mappings, leveraging dynamic caching, memory management, and parallel processing for performance.
• Develop and debug complex SQL queries and Oracle PL/SQL procedures to support data extraction, transformation, and loading.
• Translate business requirements into technical architecture, creating test code for integration, SIT, and UAT validation.
• Resolve production issues, maintain technical documentation, and collaborate with application developers and business teams in an Agile environment.

Required Skills

• Bachelor’s degree in Computer Science, Computer Engineering, or a related field.
• 2-4 years of ETL experience with SAS or Informatica.
• 2-3+ years of strong SQL skills, including complex procedures and packages in Oracle PL/SQL.
• Proficiency with relational database management systems: Oracle, DB2, and SQL Server.
• Experience with Informatica server administration, parameter file concepts, and debugging.
• Ability to script macros in MS Excel and write Scala code.
• Familiarity with Jira and Bitbucket for tracking and version control.
• Working knowledge of Agile methodologies.

Key Skills

Education

Bachelor's degree