Primary Responsibilities

• Develop IDQ ETL workflows and mappings to integrate data from various systems and data stores.
• Unit test and troubleshoot IDQ ETL workflows to ensure optimal performance.
• Create and unit test SQL queries and scripts used within workflows and mappings.
• Utilize Address Doctor for data standardization and validation.
• Implement data cleansing processes in IDQ to ensure high-quality data.
• Manage code migrations to production and perform post-migration validation.
• Support daily job processes and nightly batch cycles, ensuring data loads within SLA.
• Integrate data using various methods such as Web services, APIs, JSON, XML, etc.

Informatica MDM Knowledge

• Understand and work with MDM data models to maintain accurate master data.
• Configure MDM match-merge rules and batch groups for data consolidation.
• Experience with provisioning tools and Informatica Data Director (IDD) is a plus.

Required Skills

• Hands-on experience in IDQ ETL development, troubleshooting, and cleansing processes.
• Proficiency in SQL and data integration technologies.
• Experience with MDM, including data models and match-merge rules.

Preferred Exp

• Familiarity with Agile methodologies and tools (e.g., Jira, Sprint Planning).
• Knowledge of automation tools like VB Scripting/Windows Batch Scripts.
• Experience in end-to-end project deployment cycles.
• Strong communication skills, including client handling and change management.
• Banking and financial industry experience is a plus.

Posted By