ETL Automation Engineer

11 hours ago

uttar pradesh, India Strategic Talent Partner Full time

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 4+ 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

  • Etl - Tester

    2 weeks ago

    Noida, Uttar Pradesh, India Iris Software Full time

    **Posted On**:24 Feb 2025 **Location**: Noida, UP, India **Company**:Iris Software **Why Join Us?** Are you inspired to grow your career at one of **India’s Top 25 Best Workplaces in IT industry?**Do you want to do the best work of your life at one of the **fastest growing IT services companies**? Do you aspire to thrive in an award-winning work culture...

  • Etl Tester

    1 week ago

    Andhra Pradesh, India Virtusa Full time

    Role: ETL Tester Work Mode: Hybrid Work timings: 2pm to 11pm Location: Chennai & Hyderabad Primary Skills: ETL ETL Tester Hands on experience in ETL testing Working knowledge in SSIS ETL tools at a QA level. Develop comprehensive test plans, test cases, and test scripts specifically for SSIS (SQL Server Integration Services) ETL processes. Define testing...

  • Etl - Tester

    1 week ago

    Noida, Uttar Pradesh, India Iris Software Full time

    **Posted On**:22 May 2025 **Location**: Noida, UP, India **Company**:Iris Software **Why Join Us?** Are you inspired to grow your career at one of **India’s Top 25 Best Workplaces in IT industry?**Do you want to do the best work of your life at one of the **fastest growing IT services companies**? Do you aspire to thrive in an award-winning work culture...

  • ETL Lead

    1 week ago

    Andhra Pradesh, India Virtusa Full time US$ 1,00,000 - US$ 1,50,000 per year

    ETL Developerlooking for a Senior ETL Developer in our Enterprise Data Warehouse. In this role you will be part of a team working to develop solutions enabling the business to leverage data as an asset at the bank.The Senior ETL Developer should have extensive knowledge of data warehousing cloud technologies.If you consider data as a strategic asset,...

  • Etl QA

    7 days ago

    Andhra Pradesh, India Virtusa Full time

    **JOB DESCRIPTION** **Skill: ETL QA** **Role / Tier**: - **Senior Software Engineer/**Tier 3** Develop comprehensive test plans, test cases, and test scripts specifically for ETL processes. Identify, document, and track defects and inconsistencies in ETL processes. Define testing strategies and methodologies for data integration and data migration...

  • Senior Automation Engineer- Cypress

    15 hours ago

    uttar pradesh, India Coforge Full time

    Job Title: Senior Automation EngineerSkills: Automation Testing, Cypress and API TestingExperience: 6- 11 yearsLocation: Greater Noida, Pune and HyderabadDuration: Full timeWe at Coforge are hiring for Senior Automation Engineer role with following skill sets:Competencies:We are seeking a skilled QA Engineer with a strong foundation in manual testing and...

  • Senior Automation Engineer

    11 hours ago

    uttar pradesh, India R Systems Full time

    Job Title: Senior Automation Engineer - Quality Engineering (QE)Location: Greater Noida West, Uttar Pradesh, IndiaExperience: 7 - 10 YearsAbout the Company:R Systems is a leading technology and consulting company that helps organizations navigate their digital transformation journey. We take pride in our commitment to innovation and excellence, serving...

  • Proposal Engineer

    1 week ago

    Noida, Uttar Pradesh - New Delhi, India Rockwell Automation Full time

    Rockwell Automation is a global technology leader focused on helping the worlds manufacturers be more productive sustainable and agile With more than 28 000 employees who make the world better every day we know we have something special Behind our customers - amazing companies that help feed the world provide life-saving medicine on a global scale and...

  • Etl Datastage

    1 week ago

    Andhra Pradesh, India Virtusa Full time

    P1-C2-TSTS Client is looking for a Lead ETL Developer Lead in our Enterprise Data Warehouse. In this role you will be part of a team working to develop solutions enabling the business to leverage data as an asset at the bank. As a Lead ETL Developer, you will be leading teams to develop, maintain and enhance code ensuring all IT SDLC processes are...

  • Senior Manager Quality Engineering

    14 hours ago

    uttar pradesh, India Iris Software Inc. Full time

    Key Responsibilities:Define and drive QE strategy aligned with BMO’s Enterprise Risk platform architecture, engineering standards, and transformation roadmapLead end-to-end QE delivery across manual, automation, and data validation workstreams – including UI, API, ETL, and batch validationEstablish and scale automation frameworks for:UI (Selenium,...