ETL Test Engineer

2 days ago

Remote, India Appzlogic Mobility Solutions Pvt. Ltd Full time ₹ 15,00,000 - ₹ 20,00,000 per year

Job Title : ETL Tester

Job Description : ETL Tester (SQL Azure Synapse Agile)

Role Overview :

We are seeking a skilled ETL Tester with strong SQL expertise to validate and ensure the accuracy of data migration from source to target systems. The ideal candidate should have a solid understanding of ETL testing principles, hands-on experience with writing complex SQL queries, and a decent understanding of the Azure ecosystem, specifically Azure Synapse. Additionally, the candidate must be actively involved in Agile ceremonies and follow best testing practices to support an efficient and high-quality data transformation process.

Key Responsibilities :

1. ETL Testing & Data Validation :

- Write complex SQL queries to validate that source data has been accurately moved to the target database.

- Ensure data consistency, correctness, and completeness between different stages of ETL processing.

- Perform data reconciliation, transformation validation, and duplicate/missing record checks.

2. Azure Synapse Testing :

- Work within an Azure Synapse environment to test data pipelines and transformations.

- Validate data processing, queries, and performance optimization within Azure Synapse.

- Ensure Synapse-based ETL workflows are functioning correctly and efficiently.

3. Agile Testing & Collaboration :

- Be an active participant in Agile ceremonies like Sprint Planning, Stand-ups, Grooming, and Retrospectives.

- Collaborate with developers, business analysts, and product owners to define and refine acceptance criteria.

- Maintain a structured and standardized approach for test cases, documentation, and reporting.

4. Test Strategy & Execution :

- Develop, execute, and maintain test plans, test cases, and test scripts for ETL processes.

- Conduct functional, regression, and system integration testing for ETL workflows.

- Identify performance bottlenecks and provide recommendations for optimization.

5. Defect Reporting & Root Cause Analysis :

- Identify, document, and track ETL defects with detailed analysis and evidence.

- Work closely with developers and data engineers to troubleshoot data inconsistencies and errors.

- Ensure defects are addressed in a timely manner while maintaining quality standards.

Required Skills & Experience :

- Strong SQL expertise with experience in writing complex queries, joins, aggregations, and performance tuning.

- Good understanding of ETL processes and experience with data validation, reconciliation, and transformation testing.

- Basic to intermediate knowledge of Azure Synapse and experience testing data within it.

- Experience working in Agile environments and participating in Agile ceremonies.

- Understanding of data warehousing concepts (star schema, snowflake schema, fact & dimension tables).

- Strong analytical, problem-solving, and troubleshooting skills.

- Ability to write clear and structured test documentation and defect reports.

Nice-to-Have :

- Beginner-level knowledge of Python and pyspark is a plus.

Job Types: Full-time, Permanent

Benefits:

  • Health insurance
  • Internet reimbursement
  • Leave encashment
  • Life insurance
  • Provident Fund
  • Work from home

Schedule:

  • Day shift

Supplemental Pay:

  • Joining bonus
  • Performance bonus
  • Yearly bonus

Experience:

  • total: 5 years (Preferred)
  • ETL: 5 years (Preferred)
  • Data warehouse: 5 years (Preferred)
  • Agile: 5 years (Preferred)
  • Azure: 4 years (Preferred)
  • SQL: 5 years (Preferred)

Work Location: Remote

  • ETL Testing Job Support

    2 days ago

    Remote, India Intellion Technologies Pvt Ltd Full time ₹ 25,000 - ₹ 30,000 per year

    Job Title: ETL Testing Job Support (Part-Time, Remote, Freelance)Job Description:We are looking for an experienced ETL Testing professional who can provide daily job support on a freelance and part-time basis. The role involves helping with ETL testing, SQL queries, and occasional Python scripting.Responsibilities:Support ETL testing activities on ongoing...

  • Etl Tester

    1 week ago

    Remote, India Tech Pundits Full time

    hope you are doing well. Greetings From Tech Pundits Job Title: ETL Tester with PLSQL Role: - Sr ETL Tester Experience: - 8 to 12 years Mode: - Remote Timings: - 5 PM IST to 1 AM IST Location: - India [Remote]/ work from home NP: - Immediate Joiner /1 month Skills: ETL tester with PLSQL background, excellent SQL skills; Good to have - SFDC...

  • Etl Tester SQL

    7 days ago

    Remote, India Data PlatformExperts Full time

    Job Title: ETL Tester (Strong SQL) Experience: 3+ Years Work Mode: Remote Work Timings: 4:00 PM - 1:00 AM IST Joiner: Immediate **Job Description**: Key Responsibilities: - Design, develop, and execute test cases for ETL processes. - Validate data transformations, migration, and integration across multiple sources. - Write and execute complex SQL queries...

  • Etl Tester

    1 week ago

    Remote, India Immersive Infotech Pvt. Ltd Full time

    **ETL Tester | Full-time/ Contract | Experience: 4 Years | Remote ( Need to be present in the office on the onboarding date)** Are you a data enthusiast with expert-level SQL skills and a strong eye for accuracy? We’re looking for a detail-oriented ETL Tester to join our team. In this role, you’ll be responsible for validating data pipelines, ensuring...

  • ETL Tester SQL

    2 days ago

    Remote, India Data PlatformExperts Full time ₹ 50,000 - ₹ 10,00,000 per year

    Job Title: ETL Tester (Strong SQL)Experience: 3+ YearsWork Mode: RemoteWork Timings: 4:00 PM – 1:00 AM ISTJoiner: ImmediateJob Description:We are looking for a skilled ETL Tester with strong SQL expertise to join our team. The ideal candidate should have hands-on experience in testing ETL processes, validating data accuracy, and ensuring high-quality data...

  • Etl Tester

    7 days ago

    Remote, India HIRINGHOUSE TECHNOLOGIES PVT LTD Full time

    **Roles and Responsibilities: - ** - **Collaborate with Data Warehouse teams** **to promote effective utilization of data as well as tools for analytics relevant to the business needs**. - Prepare and deliver reports, recommendations or alternatives that address existing and potential trouble areas in IT systems and projects across the Enterprise. - Test...

  • Etl Admin

    9 hours ago

    Remote, India Softsages Technology Full time

    **Description of Duties**: - Implement procedures to maintain, monitor, backup, and recover the ETL environment. - Report regularly on health and performance of ETL environment and jobs. - Perform import and export ETL jobs across various ETL projects and servers. - Conduct ETL optimization, troubleshooting, and debugging. - Perform and assume other duties...

  • Data QA/etl Tester

    6 days ago

    Remote, India Agilite Global Solutions Company Full time

    **Location**:India, Remote (Work from Anywhere in India) **Minimum Qualification**:B. Tech. (or equivalent) from an accredited institution **Indicative Experience**:5+ Years **Domain**:Preferably in Life-sciences / Pharma. **Customer Profile**:Captive research and development pods for a $ 500 million group of pharma data research companies that help...

  • ETL Developer

    2 days ago

    Remote, India Talent Basket Full time ₹ 18,000 - ₹ 20,00,000 per year

    Brief Comment from the client is as below.We are seeking a highly skilled ETL Developer to design, build, and maintain ETL workflows and SQL Server database solutions that support data migration, integration, and analytics initiatives.The ideal candidate will have hands-on expertise with SQL Server (T-SQL, SSIS, SSRS/SSAS), along with a strong background in...

  • Etl QA Tester

    6 days ago

    Remote, India Renous Consulting Full time

    **Key Responsibilities**: **Database Testing**: - Perform comprehensive database testing, including data validation, integrity checks, and performance testing. - Write and execute complex SQL queries to validate data from source to target databases. - Ensure data accuracy, completeness, and consistency across various systems. - Validate complex data...