ETL Tester

4 weeks ago

Noida, India Strategic Talent Partner Full time

Role : QA Automation Engineer

Job Description :


As a QA Automation Engineer specializing in Data Warehousing, you will play a critical role in ensuring that our data solutions are of the highest quality. You will work closely with data engineers and analysts to develop, implement, and maintain automated testing frameworks for data validation, ETL processes, data quality, and integration.

Your work will ensure that data is accurate, consistent, and performs optimally across our data warehouse systems.

Responsibilities :

- Develop and Implement Automation Frameworks : Design, build, and maintain scalable test automation frameworks tailored for data warehousing environments.

- Test Strategy and Execution : Define and execute automated test strategies for ETL processes, data pipelines, and database integration across a variety of data sources.

- Data Validation : Implement automated tests to validate data consistency, accuracy, completeness, and transformation logic.

Performance Testing : Ensure that the data warehouse systems meet performance benchmarks through automation tools and load testing strategies.

Collaborate with Teams : Work closely with data engineers, software developers, and data analysts to understand business requirements and design tests accordingly.

Continuous Integration : Integrate automated tests into the CI/CD pipelines, ensuring that testing is part of the deployment process.

Defect Tracking and Reporting : Use defect-tracking tools (e.g., JIRA) to log and track issues found during automated testing, ensuring that defects are resolved in a timely manner.

Test Data Management : Develop strategies for handling large volumes of test data while maintaining data security and privacy.

Tool and Technology Evaluation : Stay current with emerging trends in automation testing for data warehousing and recommend tools, frameworks, and best practices.

Job Qualifications :

Requirements and skills :

- At Least 8+ Years Experience

Solid understanding of data warehousing concepts (ETL, OLAP, data marts, data vault,star/snowflake schemas, etc.).

- Proven experience in building and maintaining automation frameworks using tools like Python, Java, or similar, with a focus on database and ETL testing.

- Strong knowledge of SQL for writing complex queries to validate data, test data pipelines, and check transformations.

- Experience with ETL tools (e.g., Matillion, Qlik Replicate) and their testing processes.

- Performance Testing

- Experience with version control systems like Git

- Strong analytical and problem-solving skills, with the ability to troubleshoot complex data issues.

- Strong communication and collaboration skills.

- Attention to detail and a passion for delivering high-quality solutions.

- Ability to work in a fast-paced environment and manage multiple priorities.

- Enthusiastic about learning new technologies and frameworks.

- Experience with the following tools and technologies are desired.

- QLIK Replicate

- Matillion ETL

- Snowflake

- Data Vault Warehouse Design

- Power BI

- Azure Cloud - Including Logic App, Azure Functions, ADF

(ref:hirist.tech)

  • Senior ETL Tester

    2 weeks ago

    Noida, Uttar Pradesh, India beBee Careers Full time

    Senior ETL Tester - Job DetailsWe are seeking an experienced Senior ETL Tester to join our team. The ideal candidate will have expertise in ETL testing, SQL, and data warehousing with a strong understanding of Agile methodologies and test management tools.Key Responsibilities:• Develop and execute comprehensive ETL test plans to ensure data integrity and...

  • Etl Tester

    2 weeks ago

    Noida, India Veratas Consulting Full time

    **BI Tester Junior** Location: Noida (Sector 142) Type: FULL-TIME Veratas is a custom software development company helping both startups and enterprises streamline and future-proof their analytics process. Our dedicated teams build user-centric, tailor-made solutions empowering clients to harness the power of the insights gathered from across the...

  • Etl Tester

    4 weeks ago

    Hyderabad, Bengaluru, Noida, India TestingXperts Private Limited Full time

    Job Description Position Title:Senior ETL Tester Experience Required:5-8 Years Roles and Responsibilities: - Understand and work with data pipelines, managing data flow between layers (Bronze, Silver, and Gold). - Analyze and interpret mapping documents and PySpark code to support data extraction and validation activities. - Utilize Advanced SQL for data...

  • Etl Tester

    4 weeks ago

    Hyderabad, Bengaluru, Noida, India TestingXperts Private Limited Full time

    Job DescriptionPosition Title:Senior ETL TesterExperience Required:5-8 YearsRoles and Responsibilities:- Understand and work with data pipelines, managing data flow between layers (Bronze, Silver, and Gold).- Analyze and interpret mapping documents and PySpark code to support data extraction and validation activities.- Utilize Advanced SQL for data...

  • ETL Tester

    1 week ago

    Noida, Uttar Pradesh, India beBee Careers Full time

    Job Title: ETL TesterOverview:This role is responsible for ensuring the quality of our data solutions by developing and implementing automated testing frameworks for ETL processes, data validation, and integration.Key Responsibilities:Develop scalable test automation frameworks tailored for data warehousing environments.Define and execute automated test...

  • Etl/automation Tester

    18 hours ago

    Noida, India Crowe Full time

    **Your Journey at Crowe Starts Here**: At Crowe, you have the opportunity to deliver innovative solutions to today’s complex business issues. Crowe’s accounting, consulting, and technology personnel are widely recognized for their in-depth expertise and understanding of sophisticated process frameworks and enabling technologies, along with their...

  • ETL Tester

    4 weeks ago

    Noida, Uttar Pradesh, India VARAISYS PRIVATE LIMITED Full time

    Job Title: ETL Test EngineerWe are seeking a highly skilled and experienced ETL Test Engineer to ensure the quality, reliability, and performance of our data pipelines and ETL processes.Key Responsibilities:Design and execute manual and automated test cases for data pipelines and ETL processes.Validate data extraction, transformation logic, and loading into...

  • ETL Tester

    4 weeks ago

    Noida, Uttar Pradesh, India Strategic Talent Partner Full time

    Job Title: QA Automation Engineer - Data WarehousingJob Summary: We are seeking an experienced QA Automation Engineer to play a critical role in ensuring the highest quality of our data solutions. You will work closely with data engineers and analysts to develop, implement, and maintain automated testing frameworks for data validation, ETL processes, data...

  • ETL Tester

    4 weeks ago

    Noida, Uttar Pradesh, India VARAISYS PRIVATE LIMITED Full time

    Role : ETL Test EngineerExperience : 5+ YearsLocation : Noida/PuneAbout the Job :We are seeking a highly skilled and experienced ETL Test Engineer to join our dynamic team. In this role, you will be responsible for ensuring the quality, reliability, and performance of our data pipelines and ETL processes. You will design and execute test strategies, identify...

  • ETL Tester

    4 weeks ago

    Noida, Uttar Pradesh, India Strategic Talent Partner Full time

    **Job Description for QA Automation Engineer (Data Warehousing)**We are seeking a highly skilled QA Automation Engineer specializing in Data Warehousing to join our team at Strategic Talent Partner. As a key member of our data engineering team, you will play a critical role in ensuring the highest quality of our data solutions.Your primary responsibility...