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
EnglishJob 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