ETL Test Engineer

1 week ago

New Delhi, India PalTech Full time

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 Responsibilities- Test 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

    2 weeks ago

    New Delhi, India Tata Consultancy Services Full time

    Role: ETL Test Engineer Experience range: 7-10 years Location: Bangalore (Current location must be Bangalore)NOTE: 1)Minimum 7 years of relevant ETL Tester is required 2) Shortlisted candidate will be called for Walk-in Interview in BangaloreJob description:Min 7 to 10 yrs of Exp in ETL Testing. 1. SQL - Expert level of knowledge in core concepts of SQL and...

  • ETL Test Engineer

    2 weeks ago

    New Delhi, India Tata Consultancy Services Full time

    Role: ETL Test Engineer Experience range: 7-10 years Location: Bangalore (Walk-in drive in Bangalore)NOTE: This is a Walk-in drive in Bangalore and relevant experience in ETL must 7 yearsJob 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,...

  • ETL Test Engineer

    2 days ago

    New Delhi, India Tata Consultancy Services Full time

    Role: ETL Test Engineer Experience range: 7-10 years Location: HyderabadNOTE: Relevant experience in ETL must 7 years5+ 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 modelingJob description:Min 7 to 10 yrs of Exp in ETL Testing. 1. SQL - Expert...

  • ETL Test Engineer

    5 days ago

    New Delhi, India Tata Consultancy Services Full time

    Role: ETL Test EngineerExperience range: 7-10 yearsLocation: HyderabadNOTE: 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 modelingJob description:Min 7 to 10 yrs of Exp in ETL Testing.1. SQL - Expert...

  • ETL Testing

    7 days ago

    New Delhi, India Tata Consultancy Services Full time

    Greetings from TATA CONSULTANCY SERVICES! Skill: ETL Testing Years of Experience: 5 - 10 years Notice Period-0-30 Days Location: Pune, Hyderabad, Chennai, Bangalore, Kochi, BhubaneswarJob Description:- Key Responsibilities: Create test cases, test plans, and perform SIT of ETL tools code Write sql queries to perform QA of ETL code Find defects in ETL code...

  • ETL Testing

    2 weeks ago

    New Delhi, India Tata Consultancy Services Full time

    Greetings from TATA CONSULTANCY SERVICES!Skill: ETL TestingYears of Experience: 5 - 10 yearsNotice Period-0-30 DaysLocation: Pune, Hyderabad, Chennai, Bangalore, Kochi, BhubaneswarJob Description:-Key Responsibilities:- Create test cases, test plans, and perform SIT of ETL tools - code - Write sql queries to perform QA of ETL code - Find defects in ETL code...

  • Senior Software Engineer

    5 hours ago

    New Delhi, India Tata Consultancy Services Full time

    Role**: Senior Software Engineer (ETL Testing)Required Technical Skill Set: Senior Software Engineer (ETL Testing)Desired Experience Range: 5 - 8 yrsNotice Period: Immediate to 90Days onlyLocation of Requirement: BangaloreWe are currently planning to do a Virtual InterviewJob Description:Primary Skill:ETL Testing, Python, SQL, (Databricks or snowflake or...

  • QA Engineer

    1 week ago

    New Delhi, India Talent Worx Full time

    We are looking for a talented QA Engineer specialized in Database and ETL testing to join our dynamic team. The successful candidate will be responsible for ensuring the quality of our data processes by validating ETL workflows, database functionalities, and data integrity across our platforms. Key Responsibilities: Develop and execute thorough testing...

  • ETL Testing

    3 weeks ago

    New Delhi, India Tata Consultancy Services Full time

    Greetings from TATA CONSULTANCY SERVICES! Skill: ETL Testing Years of Experience: 4 - 10 years Location: Chennai/ BangaloreJob Description: - Technical Experience: Must have 4 - 10 years of experience in data warehouse and ETL testing, preferable with ETL tool - Must be proficient in writing SQL queries - Good to have knowledge of Agile methodology, SCRUM,...

  • ETL Testing

    4 hours ago

    New Delhi, India Tata Consultancy Services Full time

    Role-ETL tester Location-Kolkata, Pune, Mumbai, Bangalore, Bhubaneshwar, Chennai Experience-5 to 10 years Required skills-ETL Testing, SQL, DB TestingExtensive knowledge in ETL and Database Extensive knowledge on Test Methodologies Working knowledge on Data Warehouse concepts Validate data quality and Data validation Exp. in executing unit and system test...