ETL Testing Lead/Data Analysis Specialist

ETL Testing & Data Validation

• Lead end-to-end ETL testing activities across enterprise data integration programs.
• Validate source-to-target data mappings and transformation logic across complex data platforms.
• Design, develop, and execute ETL test strategies, test cases, test scripts, and validation processes.
• Verify data movement, transformation accuracy, completeness, and consistency across systems.
• Conduct regression, integration, system, and user acceptance testing for data initiatives.
• Identify, document, track, and resolve data-related defects and production issues.

Data Analysis & Quality Engineering

• Analyze large and complex datasets to identify trends, anomalies, patterns, and business insights.
• Perform data profiling, data reconciliation, and root cause analysis to support quality initiatives.
• Validate business rules and data transformation requirements to ensure accurate processing.
• Drive data quality improvements and support enterprise data governance initiatives.
• Execute data cleansing and validation activities to improve data integrity and accuracy.
• Collaborate with stakeholders to define and implement data quality standards and metrics.

SQL Development & Query Analysis

• Develop, optimize, and maintain complex SQL queries for testing and analysis activities.
• Create data validation scripts and automated validation processes where appropriate.
• Support ongoing analysis of data quality issues and performance optimization opportunities.
• Conduct source-to-target reconciliations across multiple databases and cloud environments.

Cloud & Data Platform Testing

• Validate data pipelines and workflows across cloud-based architectures.
• Support testing activities involving AWS services and enterprise data platforms.
• Verify data integrations between cloud systems, APIs, and downstream applications.
• Monitor and assess data movement processes to ensure operational stability.

Stakeholder Collaboration

• Work closely with business analysts, data engineers, developers, architects, and product owners.
• Participate in requirements reviews and contribute to test strategy development.
• Provide testing status updates, risk assessments, and quality metrics to project stakeholders.
• Support defect triage sessions and help drive issue resolution efforts.

Continuous Improvement

• Recommend improvements to ETL testing processes, automation approaches, and quality assurance practices.
• Identify opportunities to increase testing efficiency and improve data quality outcomes.
• Mentor junior team members on data validation, ETL testing, and quality engineering best practices.
• Contribute to the development of reusable testing frameworks and accelerators.

The ideal candidate will possess strong expertise in ETL testing, data quality engineering, and data analysis, with hands-on experience validating large-scale data pipelines and cloud-based data platforms. This individual will collaborate closely with business stakeholders, developers, architects, and quality engineering teams to ensure high-quality, reliable, and accurate data solutions.

Healthcare industry experience is required for this role., * Bachelor’s degree in Computer Science, Information Systems, Engineering, Data Analytics, or a related field, or equivalent work experience.

• 10+ years of experience in:
• ETL Testing
• Data Testing
• Data Quality Validation
• Data Analysis
• Strong hands-on experience with:
• SQL
• ICEDQ
• AWS S3
• BMC
• Informatica CDI-PC
• Informatica Intelligent Cloud Services (IICS)
• PySpark
• API Testing
• Postman
• SAS
• AWS Athena
• Apache Airflow
• AWS CloudWatch
• Strong experience performing source-to-target data validation and reconciliation.
• Expertise in data quality engineering and data management best practices.
• Strong analytical, troubleshooting, and problem-solving capabilities.
• Excellent verbal and written communication skills.
• Experience working in Agile delivery environments.
• Healthcare industry experience.

Preferred Qualifications

• Experience with cloud-based data lakes and modern data warehouse architectures.
• Knowledge of data governance and master data management concepts.
• Experience with test automation frameworks for data validation.
• Familiarity with healthcare data standards and regulatory requirements.
• Exposure to big data technologies and distributed data processing frameworks.
• Experience working in large-scale enterprise data transformation programs.

Domain Expertise

Candidates should demonstrate experience in:

• ETL Testing
• Data Quality Engineering
• Data Management
• Data Validation and Reconciliation
• Data Warehousing
• Cloud Data Platforms
• API Testing
• Healthcare Data Ecosystems
• Enterprise Reporting and Analytics
• Quality Engineering Best Practices

The annual salary for this position is anticipated to be between $115,000 and $120,000 USD , depending on experience, qualifications, geographic location, skills, and other factors permitted by law.

In addition to base salary, this position may be eligible for:

• Annual performance-based bonus
• Merit-based compensation increases
• Employee referral bonuses, where applicable

The compensation information provided is accurate as of the date of this posting. Cognizant reserves the right to modify compensation information based on business needs and applicable laws., Cognizant offers a comprehensive benefits package, including:

• Medical, Dental, and Vision Insurance
• Health Savings Account (HSA) and Flexible Spending Accounts (FSA)
• Life Insurance and AD&D Coverage
• Short-Term and Long-Term Disability Insurance
• Paid Time Off (PTO) and Company Holidays
• 401(k) Plan with Company Contributions (subject to eligibility)
• Employee Stock Purchase Plan (where available)
• Employee Assistance Program (EAP)
• Parental Leave and Family Care Benefits
• Tuition Reimbursement and Professional Development Programs
• Access to Learning, Certification, and Career Development Opportunities

Benefits are subject to eligibility requirements and plan terms.

Why Cognizant

• Work on large-scale data modernization and cloud transformation initiatives.
• Collaborate with leading healthcare and enterprise clients.
• Gain exposure to cutting-edge data platforms, ETL technologies, and cloud ecosystems.
• Be part of a highly collaborative and innovative data engineering and quality assurance organization.
• Access continuous learning, certifications, and career advancement opportunities.
• Join a global organization committed to creating business value through data and technology.

Cognizant (NASDAQ: CTSH) is one of the world’s leading professional services companies, helping clients modernize technology, reimagine processes, and transform experiences. We engineer modern businesses to improve everyday life. Our associates around the globe help clients build stronger, more agile, and innovative organizations.

At Cognizant, we help clients unlock the value of data through advanced analytics, cloud transformation, data modernization, and quality engineering solutions. We are committed to delivering innovative, scalable, and data-driven solutions that empower organizations to make better business decisions and improve outcomes., Cognizant is seeking an experienced ETL Testing Lead / Data Analysis Specialist to join our Quality Engineering and Assurance team. This role is responsible for leading data validation initiatives, ensuring data quality, and supporting enterprise data transformation programs within complex cloud and data warehouse environments.