Job Type: Full Time
Job Location: MA North Quincy
Duration: 6 Months
Role Summary:
- Responsible 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 support Core
Responsibilities:
- Informatica IDMC ETL Design| build| and support IDMC-based data integration mpipelines including mappings| taskflows| and synchronization jobs.
- Manage on prem to cloud and cloud to cloud integrations using IDMC Secure Agent.
- Perform performance tuning| debugging| and operational troubleshooting of ETL mworkflows.
- 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 Automation
- Create and maintain Autosys JILs and templates for ETL and replication jobs.
- Monitor scheduled jobs and resolve failures proactively.
- SQL| Shell CICD Develop and optimize complex SQL queries across Oracle| PostgreSQL| and Redshift.
- Build Unix Linux shell scripts for automation and operational support.
- Manage CICD pipelines using Git| Bitbucket| and Jenkins for UAT and PROD deployments.
Required Skills
- Experience Advanced 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 Unix Linux Shell scripting skills.
- Experience with Autosys scheduling and CICD tools (Git| Bitbucket| Jenkins).
Essential Skills:
- Senior Informatica Engineer Lead IDMC| MDM Data Quality
- Skills: Master Data Management, Informatica (MDM), Informatica Datab Quality (IDQ)
- Experience Required: 10 & Above
