Note: The job is a remote job and is open to candidates in USA. Cognizant is a professional services company that helps clients modernize technology, reimagine processes, and transform experiences through data, cloud, and quality engineering solutions. The ETL Testing Lead/Data Analysis Specialist will lead ETL testing and data validation initiatives, analyze complex datasets, ensure data quality across cloud and warehouse environments, and collaborate with cross-functional stakeholders, with a focus on healthcare data programs.
Responsibilities
- 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
- 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
- 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
- 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
- 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
- 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
Skills
- * 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
- * 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
- * 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
Benefits
- Annual performance-based bonus
- Merit-based compensation increases
- Employee referral bonuses, where applicable
- 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
- Fully remote within the United States, offering flexibility while collaborating with cross-functional teams across multiple locations and time zones
Company Overview
Company H1B Sponsorship