ETL Test Engineer
4 days ago
Data Warehouse (DWH) / ETL Test EngineerOverview:We are seeking a highly motivated and skilled Data Warehouse (DWH) / ETL Test Engineer with 3 to 6 years of experience to join our data team. The successful candidate will be responsible for ensuring the accuracy, completeness, and integrity of data flowing through our Extract, Transform, Load (ETL) pipelines and residing in our enterprise Data Warehouse. This role requires expertise in complex SQL queries, a strong understanding of dimensional modeling, and a commitment to data quality assurance.Key ResponsibilitiesTest Strategy & Design: Design, develop, and execute detailed test plans and test cases for ETL processes, data migrations, and DWH reports/dashboards.Data Validation: Perform comprehensive data validation and reconciliation between source systems, staging areas, and the target data warehouse/data marts.Complex SQL Querying: Write and execute complex SQL queries (including multi-table joins, subqueries, and aggregate functions) to validate data transformations and business rules.DWH Testing: Verify data modeling (star, snowflake schemas), fact and dimension table loading, historical data maintenance, and slowly changing dimensions (SCDs).Pipeline & Tool Testing: Test data flow across various ETL tools and technologies (on-premise or cloud-native services).Performance Testing: Execute tests to validate ETL job execution performance, ensuring data loads meet defined service level agreements (SLAs).Defect Management: Identify, log, track, and retest defects using defect management tools (e.g., JIRA, Azure DevOps, ALM) and communicate status updates clearly to stakeholders.Collaboration: Work closely with ETL Developers, Data Architects, Business Analysts, and BI teams to understand requirements and resolve data quality issues.Required Qualifications (3-6 Years)Experience: 3-6 years of professional experience dedicated to Data Warehouse (DWH) and ETL testing.SQL Mastery: Expert-level proficiency in writing and troubleshooting complex SQL queries for data comparison, validation, and manipulation.DWH Fundamentals: Strong conceptual knowledge of Data Warehousing principles, including dimensional modeling, schemas (star and snowflake), OLAP/OLTP concepts, and data mart design.ETL Testing Lifecycle: Proven experience in the full software testing lifecycle (STLC) specific to data projects, including requirement analysis, test planning, execution, and reporting.Tooling: Hands-on experience with at least one major ETL tool (e.g., Informatica PowerCenter, Talend, DataStage) OR cloud-native ETL services (e.g., AWS Glue , Azure Data Factory , or GCP Dataflow/Cloud Composer ).Communication: Excellent written and verbal communication skills, with the ability to explain technical issues to both technical and non-technical audiences.
-
ETL Test Engineer
5 hours ago
Hyderabad, India Tata Consultancy Services Full timeRole: ETL Test Engineer Experience range: 7-10 years Location: Hyderabad NOTE: Relevant experience in ETL must 7 years Job description: Min 7 to 10 yrs of Exp in ETL Testing. 1. SQL - Expert level of knowledge in core concepts of SQL and query. 2.Lead and mentor a team of ETL testers, providing technical guidance, training, and support in ETL tools, SQL, and...
-
ETL Test Engineer
3 hours ago
Hyderabad, India Tata Consultancy Services Full timeRole: ETL Test Engineer Experience range: 7-10 years Location: Hyderabad NOTE: Relevant experience in ETL must 7 years Job description: Min 7 to 10 yrs of Exp in ETL Testing. 1. SQL - Expert level of knowledge in core concepts of SQL and query. 2.Lead and mentor a team of ETL testers, providing technical guidance, training, and support in ETL tools, SQL, and...
-
ETL Test Engineer
2 weeks ago
Hyderabad, India PalTech Full timeData Warehouse (DWH) / ETL Test Engineer Overview: We are seeking a highly motivated and skilled Data Warehouse (DWH) / ETL Test Engineer with 3 to 6 years of experience to join our data team. The successful candidate will be responsible for ensuring the accuracy, completeness, and integrity of data flowing through our Extract, Transform, Load (ETL)...
-
ETL Test Engineer
2 weeks ago
Hyderabad, India PalTech Full timeData Warehouse (DWH) / ETL Test Engineer Overview: We are seeking a highly motivated and skilled Data Warehouse (DWH) / ETL Test Engineer with 3 to 6 years of experience to join our data team. The successful candidate will be responsible for ensuring the accuracy, completeness, and integrity of data flowing through our Extract, Transform, Load (ETL)...
-
ETL Test Engineer
2 weeks ago
Hyderabad, India PalTech Full timeData Warehouse (DWH) / ETL Test Engineer Overview: We are seeking a highly motivated and skilled Data Warehouse (DWH) / ETL Test Engineer with 3 to 6 years of experience to join our data team. The successful candidate will be responsible for ensuring the accuracy, completeness, and integrity of data flowing through our Extract, Transform, Load (ETL)...
-
ETL Test Engineer
2 weeks ago
Hyderabad, India PalTech Full timeData Warehouse (DWH) / ETL Test Engineer Overview: We are seeking a highly motivated and skilled Data Warehouse (DWH) / ETL Test Engineer with 3 to 6 years of experience to join our data team. The successful candidate will be responsible for ensuring the accuracy, completeness, and integrity of data flowing through our Extract, Transform, Load (ETL)...
-
ETL Testing Engineer
3 days ago
Hyderabad, Telangana, India Primera Medical Technologies Full time ₹ 5,00,000 - ₹ 15,00,000 per yearThe primary role of an ETL tester is to ensure that the data integration process is functioning correctly, and that the data being transformed and loaded meets the expected quality standards. Here are some key responsibilities and activities performed by an ETL testerRole & responsibilities :The primary role of an ETL tester is to ensure that the data...
-
ETL Test Engineer
7 days ago
Hyderabad, India Tata Consultancy Services Full timeRole: ETL Test Engineer Experience range: 7-10 years Location: Hyderabad NOTE: Relevant experience in ETL must 7 years 5+ yrs - SQL - Expert level of knowledge in core concepts of SQL and query, Informatica, Talend and Ab initio, BI concepts - OLAP vs OLTP, Data warehouse and data modeling Job description: Min 7 to 10 yrs of Exp in ETL Testing. 1. SQL -...
-
ETL Test Engineer
5 days ago
Hyderabad, India Tata Consultancy Services Full timeRole: ETL Test Engineer Experience range: 7-10 years Location: Hyderabad NOTE: Relevant experience in ETL must 7 years 5+ yrs - SQL - Expert level of knowledge in core concepts of SQL and query, Informatica, Talend and Ab initio, BI concepts - OLAP vs OLTP, Data warehouse and data modeling Job description: Min 7 to 10 yrs of Exp in ETL Testing. 1. SQL -...
-
ETL Test Engineer
6 days ago
hyderabad, India Tata Consultancy Services Full timeRole: ETL Test Engineer Experience range: 7-10 years Location: Hyderabad NOTE: Relevant experience in ETL must 7 years 5+ yrs - SQL - Expert level of knowledge in core concepts of SQL and query, Informatica, Talend and Ab initio, BI concepts - OLAP vs OLTP, Data warehouse and data modeling Job description: Min 7 to 10 yrs of Exp in ETL Testing. 1. SQL -...
