ETL Tester

1 month ago

india Mastek Full time

ETL Tester

As an ETL Tester, your primary responsibilities include manual testing for ETL testing, such as SQL, scripting languages, and tools like SSIS and Query surge. Able to test ETL processed efficiently. With 5 years of experience will have a strong foundation in data validation and be able to handle complex ETL processes. Here are some key roles and responsibilities:

Advanced Test Design and Execution:

  • Design and execute comprehensive test plans covering all aspects of the ETL process (extract, transform, load).
  • Create detailed test cases for functional, non-functional, and data quality testing.
  • Utilize SQL to write complex queries for data validation across source, staging, and target systems.
  • Perform performance testing to identify bottlenecks and ensure efficient data flow.

Data Quality Expertise:

  • Analyze data lineage to understand the flow of data throughout the ETL process.
  • Implement data profiling techniques to identify anomalies and inconsistencies in the data.
  • Design and execute test scripts to verify data accuracy, completeness, and validity based on business rules.
  • Work with data engineers to define and enforce data quality standards.

Automation and Tool Proficiency:

  • Develop and maintain automated test scripts using ETL testing tools or scripting languages (e.g., Python).
  • Integrate ETL testing into CI/CD pipelines for continuous validation.
  • Utilize data profiling tools to automate data quality checks.
  • Stay up-to-date on the latest ETL testing tools and technologies.

Collaboration and Communication:

  • Participate in requirements gathering sessions to understand business needs.
  • Effectively communicate test results and identify data quality issues to stakeholders (developers, data engineers, business analysts).
  • Work collaboratively with developers and data engineers to resolve data quality issues and improve ETL processes.
  • Document test plans, test cases, and defects clearly and concisely.


Must have:

• Strong understanding of DWH concepts and ETL testing methodology

• Design and execute comprehensive test plans covering all aspects of the ETL process and experience in testing Data Warehousing solutions using the MSBI stack (SSIS, SSAS, SSRS)

• Create detailed test cases for functional, non-functional, and data quality testing.

• Utilize SQL to write complex queries for data validation across source, staging, and target systems

• Good exposure migration approach for the cloud-based Data platform using Microsoft Azure.

• Work with data engineers to define and enforce data quality standards.

• Excellent documentation skills around producing and maintaining the Testing artifacts for BI projects.

• Hands on experience to carry out automation POCs by using Automation tool

• Effectively communicate test results and identify data quality issues to stakeholders (developers, data engineers, business analysts).

• Work collaboratively with developers and data engineers to resolve data quality issues and improve ETL processes.

• Document test plans, test cases, and defects clearly and concisely.

• Develop and maintain automated test scripts using ETL testing tools or scripting languages using Querysurge

Prefer to have:

• Integrate ETL testing into CI/CD pipelines for continuous validation.

• Utilize data profiling tools to automate data quality checks.

• Azure certification

• Participate in code reviews for ETL logic.

• Contribute to the development of ETL testing best practices within the organization.

• Explore and implement new data quality tools and methodologies


In summary, an ETL Tester developer plays a crucial role to support business intelligence and analytics initiatives within an organization.

  • Data Tester Etl Tester

    2 months ago

    India Motifworks Full time

    Data Tester **Location**: Pune, Hybrid **Total experience**: 5+ years **Responsibilities**: - Overall hands-on experience in ETL Testing. - Understanding of data model, ETL architecture, Good Data warehouse concepts. - Knowledge of writing Medium to complex SQL queries. - Strong knowledge on Database concepts (DDL, DML and hands-on experience on writing...

  • ETl tester

    2 months ago

    India Stratus Full time

    Job Description:Overall 3+ years of industry experience as an ETL tester.Create and execute strategies and test cases for applications that use ETL components.Expert in DWH testing with excellent SQL skills.Experience testing Waterfall/Agile Development ProjectsHands on experience in relational databases and database architectureGood understanding of QA...

  • ETl tester

    3 weeks ago

    India Stratus Full time

    Job Description:Overall 3+ years of industry experience as an ETL tester.Create and execute strategies and test cases for applications that use ETL components.Expert in DWH testing with excellent SQL skills.Experience testing Waterfall/Agile Development ProjectsHands on experience in relational databases and database architectureGood understanding of QA...

  • ETl tester

    3 weeks ago

    India Stratus Full time

    Job Description: Overall 3+ years of industry experience as an ETL tester. Create and execute strategies and test cases for applications that use ETL components. Expert in DWH testing with excellent SQL skills. Experience testing Waterfall/Agile Development Projects Hands on experience in relational databases and database architecture Good understanding of...

  • ETl tester

    2 months ago

    India Stratus Full time

    Job Description: Overall 3+ years of industry experience as an ETL tester. Create and execute strategies and test cases for applications that use ETL components. Expert in DWH testing with excellent SQL skills. Experience testing Waterfall/Agile Development Projects Hands on experience in relational databases and database architecture Good understanding of...

  • Data Tester Etl Tester

    6 days ago

    India Motifworks Full time

    Data TesterLocation: Pune, HybridTotal experience: 5+ yearsResponsibilities: Overall handson experience in ETL Testing. Understanding of data model, ETL architecture, Good Data warehouse concepts. Knowledge of writing Medium to complex SQL queries. Strong knowledge on Database concepts (DDL, DML and handson experience on writing SQL queries specially Joins...

  • ETL Tester

    4 hours ago

    India Sequantix Full time

    We seek a highly skilled and experienced Test Lead to oversee the quality assurance of our data warehousing and business insight projects. The Test Lead will manage a team of testers, define the test strategy, implement best practices, identify automation areas, and collaborate with customers. The projects involve creating Tableau dashboards and using data...

  • ETL Tester

    1 month ago

    india TMF Group Full time

    We never ask for payment as part of our selection process, and we always contact candidates via our corporate accounts and platforms. If you are approached for payment, this is likely to be fraudulent. Please check to see whether the role you are interested in is posted on  our career website. About TMF Group TMF Group helps its clients...

  • ETL Tester

    3 weeks ago

    india TMF Group Full time

    We never ask for payment as part of our selection process, and we always contact candidates via our corporate accounts and platforms. If you are approached for payment, this is likely to be fraudulent. Please check to see whether the role you are interested in is posted on  our career website. About TMF Group TMF Group helps its clients...

  • Etl Testing

    2 weeks ago

    India Bloom Consulting Services Full time

    **ETL TESTING ( Job ID : 522247882 )**: ETL Testing, SQL, SSIS NA Full Time Experience **06.0 - 08.0 years** Offered Salary **14.00 - 16.00** Notice Period **Not Disclosed** Looking for a strong ETL Tester and Data tester who has the following: - 6 to 8 Year of SQL, ETL Testing Experience in Large BI & Data Warehouses. -Should be able to take source...

  • ETL Tester

    3 weeks ago

    india Kanerika Software Full time

    Job Description ETL Tester About KanerikaWho we are Kanerika Inc. is a premier global software products and services firm that specializes in providing innovative solutions and services for data-driven enterprises. Our focus is to empower businesses to achieve their digital transformation goals and maximize their business impact through the effective use...

  • ETL Tester

    1 month ago

    india Kanerika Software Full time

    Job Description ETL Tester About KanerikaWho we are Kanerika Inc. is a premier global software products and services firm that specializes in providing innovative solutions and services for data-driven enterprises. Our focus is to empower businesses to achieve their digital transformation goals and maximize their business impact through the effective use...

  • ETL Tester

    6 days ago

    India Kanerika Software Full time

    Job Description ETL TesterAbout KanerikaWho we are Kanerika Inc. is a premier global software products and services firm that specializes in providing innovative solutions and services for data-driven enterprises. Our focus is to empower businesses to achieve their digital transformation goals and maximize their business impact through the effective use of...

  • ETL Tester

    2 months ago

    india Synechron Full time

    Goodday, We have immediate opportunity for QA ETL Test Engineer. Job Role: QA ETL Test Engineer Job Location: Pune Hinjewadi Experience 5 to 8 Years. Notice Perod : Upto 15 days preferred. About Company: At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative...

  • ETL Tester

    2 months ago

    india Synechron Full time

    Goodday, We have immediate opportunity for QA ETL Test Engineer. Job Role: QA ETL Test Engineer Job Location: Pune Hinjewadi Experience 5 to 8 Years. Notice Perod : Upto 15 days preferred. About Company: At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative...

  • ETL & Python, Pyspark Tester

    6 days ago

    India Genpact Full time

    Inviting applications for the role of ETL & Python, Pyspark TesterResponsibilities:In this role, you would be responsible for providing Enhancement & testing services in ETL & Python, Pyspark environment. Candidate will be working with SMEs, Scrum Master, Product Owner & Users to complete end-to-end SDLC. Software Quality Assurance experience on enterprise...

  • ETL & Python, Pyspark Tester

    3 weeks ago

    India Genpact Full time

    Inviting applications for the role of ETL & Python, Pyspark Tester Responsibilities:-In this role, you would be responsible for providing Enhancement & testing services in ETL & Python, Pyspark environment. Candidate will be working with SMEs, Scrum Master, Product Owner & Users to complete end-to-end SDLC.Software Quality Assurance experience on enterprise...

  • ETL & Python, Pyspark Tester

    3 weeks ago

    india Genpact Full time

    Inviting applications for the role of ETL & Python, Pyspark Tester Responsibilities:- In this role, you would be responsible for providing Enhancement & testing services in ETL & Python, Pyspark environment. Candidate will be working with SMEs, Scrum Master, Product Owner & Users to complete end-to-end SDLC. Software Quality Assurance experience on...

  • Software Tester

    1 month ago

    india LTIMindtree Full time

    Hi All, We are hiring- ETL Tester ( 4 to 5 years of Experience only ). Notice should be immediate to 30days . Location-Any location(Except Kolkata and Delhi) Mandatory skill- ETL with SQL - Experienced Manual Tester in E2E Integration Testing with Requirement Analysis, Test Preparation, Test Execution, Basic UNIX & LINUX commands and scripting. Creating...

  • ETL QA Tester

    1 month ago

    india TMF Group Full time

    We never ask for payment as part of our selection process, and we always contact candidates via our corporate accounts and platforms. If you are approached for payment, this is likely to be fraudulent. Please check to see whether the role you are interested in is posted here, on our website. About TMF Group TMF Group is a leading global provider...