Description

You will own the ETL data pipeline, focusing on data transformation, system reconciliation, and file generation across multiple enterprise systems.

This role is on-site.

Responsibilities

• Design and develop Informatica ETL workflows to convert IMF data into Certifi, Eligibility, and IMF Notes formats.
• Set up CONNX metadata for Eligibility and Billing tables to support data integration.
• Extract data from SQL Server into delimited file formats (CSV) and implement error handling, logging, and debugging processes.
• Support data reconciliation across MMC systems, Javelina, Certifi, and AWS Archive.
• Optimize Informatica performance through session tuning and partitioning for large datasets.

Required Skills

• 5+ years of experience as an ETL data developer.
• Proficiency in Informatica transformations: Source Qualifier, Expression, Lookup, Aggregator, and Filter.
• Experience with CONNX, SQL Server, and Oracle DB.
• Knowledge of Informatica performance optimization, including session tuning and partitioning.
• Experience handling large datasets and ensuring efficient data movement.
• Familiarity with file-level operations, including encoding, delimiter configuration, and column formatting.
• Ability to communicate complex technical concepts to non-technical audiences.

Preferred Skills

• Experience with AWS Archive and Javelina systems.

Key Skills

Education

Any Graduate