ETL Informatica QA

People Force Consulting Inc.
Irving, United States of America
4 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English

Job location

Irving, United States of America

Tech stack

API
Amazon Web Services (AWS)
Azure
Software as a Service
Cloud Computing
Cloud Database
Profiling
Data Validation
Data Governance
Database Queries
Role-Based Access Control
Release Management
Data Streaming
Strategies of Testing
Data Processing
Cloud Platform System
Performance Testing
Snowflake
Integration Frameworks
Kafka
Data Management
Data Pipelines
Databricks

Job description

  • Data pipelines using CDI (Cloud Data Integration)
  • Data quality rules using CDQ (profiling, cleansing, validation)
  • Integration workflows using CAI (API-led, event-driven)
  • Perform end-to-end data validation across ingestion, transformation, mastering, and publication layers
  • Validate match/merge logic, survivorship rules, and data consistency mechanisms
  • Test publication frameworks and outbound distribution (APIs, Kafka, event-driven pipelines)

Ensure validation of:

  • RBAC and security models
  • Data governance and stewardship workflows
  • Develop and execute test strategies for performance, scalability, and high-volume data processing
  • Integrate QA processes into CI/CD pipelines and multi-environment deployments

Identify, troubleshoot, and resolve:

  • Data quality issues
  • Integration failures
  • Performance bottlenecks
  • Collaborate with solution architects, MDM developers, and business stakeholders to ensure high-quality delivery

Requirements

  • Engineering Degree BE/ME/BTech/MTech/BSc/MSc.

Technical certification in multiple technologies is desirable., * 8 12+ years of QA experience with recent hands-on Informatica MDM SaaS (Cloud / IDMC)

  • Strong experience in testing Informatica Multi-Domain MDM SaaS (Cloud) implementations
  • Proven expertise in Product and/or Vendor (Supplier) domain validation
  • Strong understanding of data modeling validation, including:
  • Product catalogs, hierarchies, classifications
  • Vendor/supplier domain relationships
  • Cross-domain relationships (Product Vendor)

Hands-on QA experience across:

  • CDI (Cloud Data Integration)
  • CDQ (Cloud Data Quality)
  • CAI (Cloud Application Integration)
  • Strong SQL skills for data validation and reconciliation
  • Experience validating:
  • Match/Merge & survivorship rules
  • Publication frameworks and outbound data flows
  • Familiarity with Kafka or similar event-streaming platforms
  • Experience with RBAC, governance models, and audit validation
  • Experience in performance testing and scalability validation in cloud environments
  • Exposure to CI/CD pipelines, release management, and multi-environment QA

Must-Have Experience

  • QA validation for at least one full Informatica MDM SaaS (Cloud) implementation (Product or Vendor domain) in production
  • Hands-on validation of IDMC pipelines (batch + real-time)
  • Experience testing solutions built directly on Informatica MDM SaaS UI and services

Preferred Skills

  • Experience in Azure/AWS cloud ecosystems
  • Exposure to data platforms like Databricks, Snowflake, or Synapse
  • Domain experience in Healthcare, Supply Chain, or Vendor Management

Apply for this position