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