Senior Data Engineer

Role Description

Associate Consultant Informatica IDMC

MDM SaaS Cloud Data Integration Cloud Data Quality Cloud Application Integration

ROLE LEVEL

Associate ConsultantEXPERIENCE

2 to 5 years overall 1 to 2 years handson IDMCCORE PLATFORM

Informatica IDMC

Role Summary

The Associate Consultant will configure develop test and support Informatica IDMC solutions across MDM SaaS Cloud Data Integration Cloud Data Quality and Cloud Application Integration The role requires handson delivery skills disciplined documentation and effective collaboration with business stewardship architecture and integration teams

Mandatory Skills

Mandatory capabilityExpected handson coverage

Informatica MDM SaaSBusiness Entities relationships hierarchies match and merge survivorship Golden Records

Cloud Data Integration CDICDMappings mapping tasks taskflows scheduling parameterization and orchestration

Cloud Data Quality CDQProfiling cleansing standardization validation enrichment monitoring and scorecards

Cloud Application Integration CAIProcess objects service connectors APIs eventdriven processes REST and SOAP

Key Responsibilities

MDM SaaS

Configure and maintain Business Entities relationships hierarchies reference data match and merge rules survivorship logic and Golden Record management

Support multidomain implementations such as Customer Product Supplier Asset and Location including crossdomain relationships

Configure business validations workflows approval processes stewardship queues and exception handling

Assist with master data onboarding reconciliation testing and issue resolution

Cloud Data Integration CDICD

Develop and maintain mappings mapping tasks taskflows parameter files schedules and reusable integration components

Build batch and nearrealtime data pipelines across databases files APIs ERP CRM and cloud applications

Implement transformations reconciliation controls error handling restartability and operational monitoring

Cloud Data Quality CDQ

Develop profiling cleansing parsing standardization validation enrichment and monitoring rules

Create reusable data quality assets scorecards exception outputs and remediation support processes

Analyze data quality results and support rootcause investigation with business and technical teams

Cloud Application Integration CAI

Develop process objects service connectors application connections APIs and eventdriven orchestrations

Integrate applications using REST and SOAP services and implement appropriate error and response handling

Support testing and troubleshooting of synchronous and asynchronous integration processes

Delivery and Collaboration

Participate in requirements gathering design discussions unit testing system integration testing deployment and production support

Prepare technical specifications mapping documents test evidence runbooks and support documentation

Follow coding standards peer review practices security controls and release management processes

Required Qualifications

2 to 5 years of experience in data integration data quality application integration or master data management with 1 to 2 years of handson Informatica IDMC experience

Practical experience with Informatica MDM SaaS CDICD CDQ or CAI is mandatory

Strong SQL data analysis data mapping and troubleshooting skills

Working knowledge of REST SOAP JSON XML relational databases and filebased integration patterns

Ability to communicate clearly work in Agile teams and manage assigned deliverables to agreed quality standards

Preferred Skills

Experience with SAP Salesforce ServiceNow Oracle Workday Snowflake Azure AWS or similar enterprise platforms

Exposure to Data Governance and Catalog Business Glossary Reference 360 or metadata management

Informatica IDMC or MDM SaaS certification