ETL Tester for San Antonio, TX (100% Onsite)

[Ishita]

Job Title: Senior ETL Test Engineer – Informatica IDMC / IICS

Work Location: San Antonio, TX (100% Onsite)
Duration: 12+ Months
Experience Required: 8+ Years

---

Job Summary

We are seeking a highly skilled Senior ETL Test Engineer with extensive experience in ETL Testing, Informatica Intelligent Data Management Cloud (IDMC), Informatica Intelligent Cloud Services (IICS), and Data Migration Testing. The ideal candidate will be responsible for validating end-to-end ETL workflows, data transformations, and enterprise data migration processes while ensuring data accuracy, integrity, and performance across complex data integration environments.

---

Key Responsibilities

ETL & Data Migration Testing

• Validate end-to-end ETL workflows, data transformations, and data migration processes.
• Verify source-to-target data mappings, transformation logic, and business rules.
• Perform comprehensive testing of enterprise data movement across multiple source and target systems.
• Validate batch processing, incremental loads, and data synchronization processes.
• Ensure data integrity, completeness, consistency, and accuracy throughout the ETL lifecycle.

SQL & Database Validation

• Develop and execute complex SQL queries for data validation and reconciliation.
• Perform database testing and validate data stored across relational databases.
• Analyze large datasets to identify discrepancies, duplicates, and data quality issues.
• Optimize SQL queries for improved performance during testing activities.
• Conduct source-to-target reconciliation and database validation.

Informatica Testing

• Test ETL processes developed using:
  • Informatica PowerCenter
  • Informatica Intelligent Cloud Services (IICS)
  • Informatica Intelligent Data Management Cloud (IDMC)
  • Informatica Cloud Data Integration (CDI)
• Validate mappings, workflows, sessions, and cloud-based data integration pipelines.
• Support enterprise cloud data integration and migration initiatives.

Test Automation

• Develop Python-based automation scripts for ETL validation.
• Build reusable data comparison frameworks and automated validation utilities.
• Improve testing efficiency through automation and reusable testing assets.
• Support regression testing and continuous validation processes.

Test Planning & Defect Management

• Analyze business and technical requirements to create comprehensive test scenarios and test cases.
• Execute functional, integration, regression, and data validation testing.
• Investigate data-related issues and perform root cause analysis.
• Log, track, and verify defects through resolution.
• Collaborate with developers to ensure timely defect resolution.

Collaboration & Quality Assurance

• Work closely with Business Analysts, ETL Developers, Data Engineers, Architects, and Business Users.
• Participate in requirement reviews, design discussions, and sprint planning.
• Support User Acceptance Testing (UAT) and production validation.
• Ensure adherence to enterprise quality standards and testing best practices.

---

Required Skills

• 8+ years of experience in ETL Testing and Data Validation.
• Strong expertise in ETL workflow validation.
• Informatica PowerCenter.
• Informatica Intelligent Data Management Cloud (IDMC).
• Informatica Intelligent Cloud Services (IICS).
• Informatica Cloud Data Integration (CDI).
• Data Migration Testing.
• Advanced SQL development and database validation.
• Data reconciliation and data quality validation.
• Relational Database Management Systems (RDBMS).
• Data Warehousing concepts.
• ETL architecture and processes.
• Python-based test automation.
• Data comparison frameworks.
• Functional Testing.
• System Integration Testing (SIT).
• Regression Testing.
• Root Cause Analysis.
• Strong analytical, troubleshooting, and problem-solving skills.

---

Preferred Skills

• Cloud-based ETL and Data Integration platforms.
• Performance and scalability testing.
• CI/CD integration for automated testing.
• Data Quality and Governance.
• Agile/Scrum development methodology.
• Enterprise Data Warehouse projects.
• Financial or Healthcare domain experience (preferred).

---

Education

• Bachelor's degree in Computer Science, Information Systems, Engineering, or a related technical field.
• Equivalent professional experience will also be considered.

---
Thanks & Regards
Ishita Bali
Novia Infotech LLC
4421 Avenida Ln, McKinney, TX 75070
Email: ishi...@noviainfotech.com