HYDERABAD · FULLTIME
ETL Testing & Data Validation Engineer
HCA Healthcare
Hyderabad · onsite · Posted 30d ago
Sourced from
Undisclosed2–6 yrsfulltimeHyderabad
About a minute. You'll make an account on the way through.
agent · working
- Read this posting0.4s
- Found the form on Naukri · 15 questions to answer1.4s
- Decided the answers for all of them2.6s
- Tailor your résumé to this role
- Waiting for you
Section · 01
About this role
Role: ETL Testing DataValidation Engineer
Experience: 5+ years ofrelevant experience.
Role Overview:
We are seeking a highly motivated and detail-oriented ETL Testing DataValidation Engineer to join our Data Engineering and Quality Assurance team.The ideal candidate will be responsible for validating data extraction,transformation and loading (ETL) processes, ensuring the accuracy,completeness, consistency and integrity of data across enterprise dataplatforms, data warehouses and reporting systems.
We are seeking a highly motivated and detail-oriented ETL Testing DataValidation Engineer to join our Data Engineering and Quality Assurance team.The ideal candidate will be responsible for validating data extraction,transformation and loading (ETL) processes, ensuring the accuracy,completeness, consistency and integrity of data across enterprise dataplatforms, data warehouses and reporting systems.
The candidate should possess strong Analytical skills, hands-on experience inETL testing, Advanced SQL expertise and a solid understanding of Data Warehousingconcepts.
Key Responsibilities:
1. RequirementsAnalysis: Analyze business requirements, functional specificationsand Source-to-Target Mapping (STTM) documents to define test scope andcriteria.
2. TestPlanning Execution: Design, develop and executecomprehensive ETL test plans, test scenarios, test cases and test scripts.
3. ETLData Pipeline Validation: Validate data extraction,transformation and loading (ETL) processes to ensure compliance with businessrules, data mappings and technical specifications.
4. DataReconciliation: Perform source-to-target data validation andreconciliation to ensure data accuracy, completeness, consistency, referentialintegrity and compliance with business rules across multiple databases,applications and data platforms.
5. BackendTesting Querying: Execute advanced SQL queries to performbackend data validation, data profiling and root cause analysis.
6. DataWarehouse Verification: Validate data warehouse and dataintegration solutions, including fact and dimension models, aggregations,Slowly Changing Dimensions (SCDs), full-load and incremental-load processes andChange Data Capture (CDC) mechanisms to ensure data accuracy and integrity.
7. TestData Management: Develop, maintain and manage comprehensivetest data sets covering positive, negative, boundary and exception scenarios tosupport ETL testing, data migration, data reconciliation and end-to-end datavalidation activities.
8. Automation: Design and implement automated data validation, reconciliation and qualityassurance frameworks wherever feasible.
9. Defect Management: Identify, track,prioritize and manage defects through resolution using defect management tools.
10. Cross-Functional Collaboration: Collaborate with Data Engineers, Business Analysts, Developers and businessstakeholders to investigate and resolve data-related issues.
11. Test Cycle Support: Support SystemIntegration Testing (SIT), Regression Testing, User Acceptance Testing (UAT)and Production Validation activities. Participate in requirement reviews andprovide input on testability, data quality risks and validation strategies.
12. Documentation Reporting: Createand maintain test execution reports, defect metrics and testing documentation.
13. Mentorship Best Practices: Contribute to continuous improvement initiatives focused on test automation,data quality monitoring and process optimization. Mentor junior team membersand promote best practices in ETL testing, data validation and qualityassurance.
Required Skills Qualifications:
1. Education: Bachelorsdegree in computer science, Information Technology, Engineering or a relatedquantitative field.
2. Experience: 5+years of relevant hands-on experience in ETL testing, data warehousetesting, or database quality assurance.
3. SQLProficiency: Advanced SQL skills (subqueries, windowfunctions, CTEs, complex joins, stored procedures, performance tuning).
4. DataWarehousing Knowledge: Strong understanding of dimensionalmodeling (Star/Snowflake schema), OLAP concepts, normalization / denormalizationand data lineage.
5. ETLTool Familiarity: Hands-on experience working with or Testingpipelines built with tools such as Informatica/ Talend/ SSIS, Azure DataFactory (ADF), AWS Glue or dbt.
6. RDBMSData Platforms: Strong experience with relational databases(e.g., PostgreSQL, Oracle, SQL Server) and modern Cloud Data Warehouses (e.g.,BigQuery, Snowflake, Databricks.)
7. DefectTest Management: Proficiency with tools such as Jira,Confluence, HP ALM/Quality Center or Zephyr.
8. Experiencein the healthcare domain, project execution, and/or knowledge of HL7 or FHIRstandards and regulations would be an added advantage.
Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.
Sourced from naukri
Section · 02
Skills
data extractionAws GlueCdcAlmAutomationData lineageanalytical thinkingConfluenceadvanced sqlamazon web servicesBusiness Requirementsbigquerydata captureCloud DataData EngineeringData MigrationcloudData ManagementcomplianceMicrosoft Azure
Section · Company
About HCA Healthcare
HCA Healthcare
Healthcare
4.0k+
employees
Nashville, TN
USA
₹17.9L PA avg
Avg at HCA Healthcare
About
HCA Healthcare - India is an integral innovation and operational hub in support of HCA Healthcare and our mission: Above all else, we are committed to the care and improvement of human life. HCA Healthcare is a company focused on creating healthier tomorrows through the delivery of patient-centered care across approximately 190 hospitals and 2,400 sites of care in the United States and United Kingdom.
Every day, our colleagues around the world go to work with a collective focus: our patients. This focus positively impacts the care experience at the bedside and beyond. HCA Healthcare - India serves as a vital hub for operations and supports HCA Healthcares work to enhance healthcare delivery through technology and innovation.
Industries
Healthcare
Employee ratings
9 reviews
4.7/ 5
Culture
4.3
Career growth
3.3
Work-life
4.1
Employees rate it well for
Company Culture47Job Security47
Find them on