Technical Specialist - II_ETL Testing

Department Icon IT / Software Development & Related
Posted: 14 hours ago
2-5 years
Irving TX, India
IT / Software Development & Related
work from office
Full Time
Closes 15 Jan 2027

Posted: 14 hours ago
Let Jobaaj One apply for you

An AI agent that applies to roles like this on employers' own sites. 25 applications free, no card needed.

Job Description
About Company
Similar Jobs
Please verify your account first! Send OTP

Job Description

Mandatory Skills:

  • Lead team and coordinate difference stakeholder for ETL QA
  • Data Warehouse Testing, Master Data Management (MDM) Validation, Big Data Verification, and Automated Data Testing (SQL, Informatica, Databricks).
  • Advanced SQL & Data Validation: Expert-level SQL skills to write complex queries for source-to-target data validation, data completeness, transformation logic, and reconciliation.
  • Informatica Testing: Hands-on experience testing, validating, and troubleshooting ETL workflows, mappings, and sessions in Informatica PowerCenter or Informatica Intelligent Cloud Services (IICS).
  • Databricks & Lakehouse Verification: Practical experience querying and validating large datasets in Databricks using Spark SQL, PySpark, and Delta Lake tables.
  • Master Data Management (MDM) Testing: Proven experience testing MDM hubs, validating match/merge rules, survivorship logic, golden record creation, and downstream data distribution.
  • QA Methodology & Defect Tracking: Strong understanding of SDLC/STLC, test plan creation, test case execution, and defect lifecycle management using tools like Jira, Zephyr, or Azure DevOps.

Desired Skills:

  • Test Automation: Experience automating ETL and data validation tests using Python, PyTest, Great Expectations, or commercial data testing tools.
  • Cloud Data Platforms: Familiarity with cloud storage and data warehousing ecosystems such as Azure (ADLS, Synapse), AWS (S3, Redshift), or Snowflake.
  • CI/CD Integration: Experience integrating automated data regression suites into CI/CD pipelines (Azure DevOps, Jenkins, or GitHub Actions).
  • Communication & Alignment: Strong analytical and communication skills to collaborate effectively with data engineers, business analysts, and product stakeholders across distributed teams.

We are looking for a detail-oriented ETL Tester to ensure the accuracy, integrity, and reliability of our enterprise data pipelines and Master Data Management (MDM) solutions. In this role, you will design and execute comprehensive data validation strategies across Informatica and Databricks environments to guarantee high-quality data for business reporting and analytics.

Key Responsibilities:

  • Test Planning & Execution: Analyze business requirements, source-to-target mapping documents, and data models to design thorough test plans, test scenarios, and test cases.
  • ETL & Pipeline Validation: Execute end-to-end validation of batch and incremental ETL jobs built in Informatica and Databricks, verifying data extraction, transformation rules, and target loading.
  • MDM Quality Assurance: Validate MDM workflows, including data cleansing, standardization, match/merge thresholds, and golden record accuracy across source systems.
  • SQL & Root-Cause Analysis: Write complex SQL and Spark SQL queries to detect data anomalies, duplicates, truncation, and referential integrity issues, driving defects to resolution with data engineers.
  • Regression & Reporting: Maintain reusable test data sets, execute regression suites for pipeline releases, and provide clear test execution metrics and sign-off reports to stakeholders

Skills

PythonSQLPySparkSnowflakeDatabricksRedshiftETLData WarehousingInformaticaAWSAzureJenkinsGitHub ActionsCI/CDS3

If a job posting appears fraudulent, asks for payment, contains misleading information, or violates our guidelines, please report it immediately. Our team will review it promptly, Jobaaj does not charge any fee from the applicants.

About Company

CitiusTech is a specialist provider of healthcare technology services and solutions, with strong presence across the globe. As a strategic partner to some of the world’s largest healthcare organizations, CitiusTech plays a deep and meaningful role in accelerating technology innovation and shaping the way healthcare is delivered to patients. CitiusTech works at the edge of digital transformation. It focuses on multiple areas of digital technology, such as Business Intelligence, mobility & IoT, Big Data, cloud computing, predictive analytics & data science. With cutting-edge technology expertise, world-class service quality, strong consulting expertise and a global resource base, CitiusTech consistently delivers best-in-class solutions and an unmatched cost advantage to healthcare organizations worldwide.

Read More

Similar Jobs

View all
Loading...

Looking for something similar?

Bag Logo
Jobaaj
Get jobs like this by email

New IT / Software Development & Related roles in Irving TX.

Job Alert
Google hiring for Specific Roles Apply Now!
1 min ago
New Opportunity
Amazon is hiring freshers Apply Now!
5 min ago
Featured Jobs
Microsoft opening 50+ positions Apply Now!
10 min ago

One email a day. Unsubscribe any time.