Informatica Engineer Lead IDMC MDM Data QualityRole SummaryResponsible

Sierra Business Solution LLC
Quincy, United States of America
1 month ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Quincy, United States of America

Tech stack

CA Workload Automation Ae
Continuous Integration
Data Integration
ETL
Software Debugging
Job Scheduling
PostgreSQL
Oracle Applications
Performance Tuning
Shell Script
SQL Databases
Freeform SQL
GIT
Bitbucket
Data Management
Data Pipelines
Jenkins

Job description

Role Descriptions: Senior Informatica Engineer Lead IDMC MDM Data QualityRole SummaryResponsible for designing developing operating and supporting enterprise data integration and master data solutions using Informatica IDMC MDM and IDQ. The role owns ETL pipelines job scheduling CICD deployments and BAU supportCore ResponsibilitiesInformatica IDMC ETLDesign build and support IDMC-based data integration pipelines including mappings taskflows and synchronization jobs.Manage onprem to cloud and cloudtocloud integrations using IDMC Secure Agent.Perform performance tuning debugging and operational troubleshooting of ETL workflows.Master Data Management (MDM)Hands-on development and support of Informatica MDM workflows batch jobs and hub processes.Execute data loads into MDM landing tables and manage batch group processing.Data Quality (IDQ)Implement and maintain Informatica Data Quality (IDQ) rules and validations.Ensure data completeness consistency and integrity across systems.Scheduling AutomationCreate and maintain Autosys JILs and templates for ETL and replication jobs.Monitor scheduled jobs and resolve failures proactively.SQL Shell CICDDevelop and optimize complex SQL queries across Oracle PostgreSQL and Redshift.Build UnixLinux shell scripts for automation and operational support.Manage CICD pipelines using Git Bitbucket and Jenkins for UAT and PROD deployments.Required Skills ExperienceAdvanced hands-on experience with Informatica IDMC.Strong proficiency in Informatica MDM and Informatica Data Quality (IDQ).Strong ETL fundamentals and data pipeline design expertise.Solid SQL and UnixLinux Shell scripting skills.Experience with Autosys scheduling and CICD tools (Git Bitbucket Jenkins).

Requirements

AutomationCreate and maintain Autosys JILs and templates for ETL and replication jobs.Monitor scheduled jobs and resolve failures proactively.SQL Shell CICDDevelop and optimize complex SQL queries across Oracle PostgreSQL and Redshift.Build UnixLinux shell scripts for automation and operational support.Manage CICD pipelines using Git Bitbucket and Jenkins for UAT and PROD deployments.Required Skills ExperienceAdvanced hands-on experience with Informatica IDMC.Strong proficiency in Informatica MDM and Informatica Data Quality (IDQ).Strong ETL fundamentals and data pipeline design expertise.Solid SQL and UnixLinux Shell scripting skills.Experience with Autosys scheduling and CICD tools (Git Bitbucket Jenkins).

Apply for this position