5 Informatica Cai Jobs

Experience in IDQ development around data profiling, cleansing, parsing, standardization, verification, matching and data quality exception monitoring and handling Designing, developing, testing, deploying, and documenting a project s data quality procedures and its outputs. Profile the project source data, define or confirm the definition of the metadata, cleanse and accurately check the project data, check for duplicate or redundant records, and provide information on how to proceed with backend ETL processes. Experiences with creating SQL procedures, views, subqueries, multiple SQL joins, unions to perform various data extraction tasks and developing PL/SQL triggers for updating or inserting new records Minimum 9-13 years of hands-on experience with Informatica Data Quality (IDQ) toolset (Version 10.x preferred) Working experience in Informatica PowerCenter Strong SQL skills with the ability to tune and optimize complex queries Experience in the fllowing will be added advantage. Reporting tools-AXON,EDC

Experience in IDQ development around data profiling, cleansing, parsing, standardization, verification, matching and data quality exception monitoring and handling Designing, developing, testing, deploying, and documenting a project s data quality procedures and its outputs. Profile the project source data, define or confirm the definition of the metadata, cleanse and accurately check the project data, check for duplicate or redundant records, and provide information on how to proceed with backend ETL processes. Experiences with creating SQL procedures, views, subqueries, multiple SQL joins, unions to perform various data extraction tasks and developing PL/SQL triggers for updating or inserting new records Minimum 9-13 years of hands-on experience with Informatica Data Quality (IDQ) toolset (Version 10.x preferred) Working experience in Informatica PowerCenter Strong SQL skills with the ability to tune and optimize complex queries Experience in the fllowing will be added advantage. Reporting tools-AXON,EDC

Experience in IDQ development around data profiling, cleansing, parsing, standardization, verification, matching and data quality exception monitoring and handling Designing, developing, testing, deploying, and documenting a project s data quality procedures and its outputs. Profile the project source data, define or confirm the definition of the metadata, cleanse and accurately check the project data, check for duplicate or redundant records, and provide information on how to proceed with backend ETL processes. Experiences with creating SQL procedures, views, subqueries, multiple SQL joins, unions to perform various data extraction tasks and developing PL/SQL triggers for updating or inserting new records Minimum 9-13 years of hands-on experience with Informatica Data Quality (IDQ) toolset (Version 10.x preferred) Working experience in Informatica PowerCenter Strong SQL skills with the ability to tune and optimize complex queries Experience in the fllowing will be added advantage. Reporting tools-AXON,EDC

As a valued member of McGraw Hill, you will have the opportunity to contribute to the development of digital learning experiences that revolutionize education for both learners and educators. Our organization is committed to creating impactful products that enhance user experiences and facilitate growth and collaboration among teams. We prioritize innovation, teamwork, and a harmonious balance between professional advancement and personal well-being within our culture. In the role of an IDMC (Informatica Data Management Cloud) Developer/Administrator, you will be instrumental in the design, development, implementation, and maintenance of seamless integration solutions across McGraw Hill's software systems and workflows. Your primary responsibility will be to ensure efficient and reliable data flow and connectivity to support the organization's operations effectively. Your key responsibilities will include: - Developing high volume, mission-critical cloud-native applications using IDMC. - Creating Service Connectors and Application Connections for real-time integration with third-party applications. - Automating file lifecycle management and administrative tasks through a combination of IDMC and Python scripting. - Providing guidance to third-party developers to ensure adherence to design standards, coding best practices, and accountability throughout the software development lifecycle. - Establishing and maintaining a robust operational support framework for the Informatica IDMC platform. - Monitoring, identifying, and resolving production issues as needed. The ideal candidate for this role would possess: - 5 years of hands-on experience with Informatica IICS/IDMC, specifically in IDMC Development. - Over 2 years of Administrator Experience in IICS/IDMC. - More than 2 years of experience with Informatica CAI and CDI Applications/tools. - 2+ years of experience with Python scripting for development purposes. - Proficiency in SQL, ETL development, data warehousing, and performance tuning would be advantageous. By joining McGraw Hill, you will be part of a team that is shaping the future of education through meaningful work. Your contributions will play a crucial role in designing content that has a lasting impact on the educational landscape. Join us and experience a sense of fulfillment that will drive you to achieve even greater heights in your career. Please note that all official correspondence from McGraw Hill recruiters will be sent from an @mheducation.com email address or through our Applicant Tracking System, iCIMS. Any deviations from this email domain should be treated as suspicious. Furthermore, our recruiters and authorized representatives will never request sensitive information via email.,

#Job Title: Informatica CDI Developer with Ref360 experience. #Location : India (Remote). #Client : Genpact. #Payroll : Edge Soft #Experience : 6+ Years. Job Title: Informatica CDI Developer with MDM Ingress and Egress with Ref360 experience. Note : Don't share without CDI with Ref360 experience. Job Description: The role involves designing and developing data integration workflows using Informatica Cloud Data Integration (CDI) to manage master data flows between source systems and Informatica MDM for both Ingress (data ingestion) and Egress (data extraction) jobs. The main goal is to ensure that master data is accurate, complete, and consistent across enterprise systems. Key Responsibilities: Informatica CDI Development: Design, build, and maintain ETL workflows using Informatica CDI to ingest and extract data from various data sources to/from Informatica MDM. Implement data integration patterns for MDM Ingress and Egress processes. Work with source system data and load it into the MDM hub to ensure the master data is aligned with business requirements. Perform data cleansing, transformation, and enrichment tasks to support MDM ingestion. MDM Ingress: Configure and develop MDM Ingress jobs to load data from operational systems (e.g., CRM, ERP, and transactional databases) into the MDM hub. Leverage Informatica MDM data governance and matching functionality to ensure accurate master records. Implement business rules, data validations, and matching logic during the ingestion process. MDM Egress: Design and implement MDM Egress jobs to extract the master data from the MDM hub and synchronize it with downstream systems such as data warehouses, analytics platforms, or external applications. Ensure data consistency and integrity when exporting data to various operational systems. Data Transformation & Quality: Use Informatica transformation capabilities to clean, transform, and enrich master data. Ensure data quality standards are met and implement data validation logic to ensure accuracy. Monitoring and Optimization: Set up monitoring, logging, and alerting for all MDM-related processes. Optimize data integration jobs for performance, scalability, and reliability. Required Skills: Informatica Cloud Data Integration (CDI): Hands-on experience with Informatica Cloud Data Integration (CDI) for building ETL workflows. Strong knowledge of designing and implementing data pipelines using CDI. Informatica MDM: Strong knowledge of Informatica MDM for managing master data, including configuration, administration, and integration. Experience with MDM Ingress (data ingestion) and Egress (data extraction) processes. Familiarity with data governance, matching, and merge logic in MDM. ETL and Data Integration: Experience in data mapping, transformation, and data flows between systems. Understanding of the full ETL lifecycle: extract, transform, load. SQL and Databases: Strong SQL skills to work with databases and data warehouses. Experience in working with relational databases, data lakes, and cloud-based storage solutions. Data Quality and Cleansing: Experience in data quality tools and techniques for ensuring data integrity, consistency, and completeness. Scripting and Automation: Experience in automating repetitive tasks using scripting languages (e.g., Python, Shell). Cloud Platforms: Familiarity with cloud platforms (AWS, Azure, Google Cloud) and cloud data storage solutions (e.g., S3, Blob Storage). Preferred Skills: Informatica PowerCenter (optional, but useful if dealing with legacy systems). Knowledge of Data Governance frameworks and standards. Big Data Technologies: Hadoop, Spark, or similar technologies if integrating with big data platforms. MDM Match and Merge Rules: Experience with configuring matching and merge rules in MDM solutions. 6. Experience: 35 years of experience in Informatica CDI development. 24 years of hands-on experience in working with Informatica MDM. Experience with cloud technologies and data integration platforms. 7. Education: Bachelors degree in Computer Science, Information Technology, or a related field. Tools/Technologies: Informatica Cloud Data Integration (CDI) Informatica MDM SQL (MySQL, Oracle, SQL Server, etc.) Cloud Platforms (AWS, Azure, Google Cloud) Data Governance Tools (optional) #Send resumes to sarahk@edgesoftcorporation.com +91 7893197593