Job Summary
Design and develop scalable data integration solutions using Informatica IDMC (Cloud Data Integration - CDI)
Build, enhance, and maintain mappings, mapplets, and taskflows for enterprise data pipelines
Implement end-to-end ETL/ELT processes for data ingestion, transformation, and loading
Develop complex transformation logic using expression, lookup, joiner, aggregator, and router
Process and transform JSON, XML, and flat file data within CDI mappings
Implement parameterization and reusable frameworks to support dynamic processing
Design and develop file-based ingestion frameworks handling multiple file formats and patterns
Implement robust error handling, logging, and restart mechanisms in taskflows and mappings
Optimize performance using pushdown optimization, partitioning, and caching techniques
Work with relational databases and write optimized SQL queries for data processing
Implement incremental load strategies, CDC patterns, and data validation rules
Troubleshoot and resolve issues in mappings, taskflows, and production jobs
Collaborate with business and technical teams to gather requirements and design solutions
Develop and support real-time and API integrations using CAI (Cloud Application Integration)
Implement and maintain B2B/EDI integrations using Informatica B2B Gateway
Key Responsibilities
2. Collaborate with stakeholders to gather requirements and design data management solutions that align with business needs.
3. Develop data governance frameworks using informatica axon to ensure data integrity and compliance with regulatory standards.
4. Implement informatica edc to perform data profiling, cataloging, and lineage tracking for effective data governance.
5. Utilize python programming for data analysis, automation, and integration with informatica tools.
6. Monitor and optimize data workflows, data quality, and performance of informatica solutions.
7. Provide technical guidance and support to troubleshoot and resolve complex technical issues related to data management.
Skill Requirements
2. Experience in implementing and configuring informatica axon for data governance and compliance.
3. Strong programming skills in python for data analysis, automation, and integration.
4. In-depth knowledge of data management principles, practices, and technologies.
5. Excellent communication and leadership abilities to guide a team and collaborate with stakeholders effectively.