ETL Automation Engineer

4 weeks ago

Noida, 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 Automation Engineer

    4 days ago

    Noida, Uttar Pradesh, India Strategic Talent Partner Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    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...

  • QA Automation ETL

    2 weeks ago

    Noida, Uttar Pradesh, India Iris Software Full time ₹ 5,00,000 - ₹ 12,00,000 per year

    Posted On: 17 Sept 2025Location: Noida, UP, IndiaCompany: Iris SoftwareWhy Join Iris?Are you ready to do the best work of your career at one of India's Top 25 Best Workplaces in IT industry? Do you want to grow in an award-winning culture that truly values your talent and ambitions?Join Iris Software — one of the fastest-growing IT services companies —...

  • ETL Tester

    3 weeks ago

    Noida, Uttar Pradesh, India Strategic Talent Partner Full time

    Role : QA Automation EngineerJob 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,...

  • ETL Tester

    1 week ago

    Noida, Uttar Pradesh, India Iris Software Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    About Iris SoftwareData & Analytics, Cloud, DevOps, Data & MLOps, Quality Engineering, and Business Automation.Testing Concepts ETL Testing / Python ExperienceNice to HaveAPI Understanding & Testing (Manual / Automation) UI Automation (Able to identify UI elements programmatically. (This is for Selenium).Detailed Description :Critical Thinking - 5/5 High in...

  • ETL Database

    5 days ago

    Noida, Uttar Pradesh, India Iris Software Inc. Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Why Join Us?Are you inspired to grow your career at one ofIndia's Top 25 Best Workplaces in IT industry?Do you want to do the best work of your life at one of thefastest growing IT services companies? Do you aspire to thrive in an award-winning work culture thatvalues your talent and career aspirations? It'shappening right hereat Iris Software.About Iris...

  • Senior ETL

    3 days ago

    Noida, Uttar Pradesh, India Dataflow Full time ₹ 1,04,000 - ₹ 13,08,780 per year

    About the OrganisationDataFlow Group is a pioneering global provider of specialized Primary Source Verification (PSV) solutions, and background screening and immigration compliance services that assist public and private organizations in mitigating risks to make informed, cost-effectivedecisions regarding their Applicants and Registrants.About the Role:We...

  • ETL Tester

    6 days ago

    Noida, Uttar Pradesh, India Iris Software Full time ₹ 6,00,000 - ₹ 12,00,000 per year

    Testing ConceptsETL Testing Python ExperienceNice to HaveAPI Understanding & Testing (Manual Automation)UI Automation (Able to identify UI elements programmatically. (This is for Selenium).Detailed Description :Critical Thinking - 5/5High in logical reasoning and proactivenessShould come up with diverse test cases against requirementsTesting Concepts -...

  • ETL QA

    4 days ago

    Noida, Uttar Pradesh, India Iris Software Inc. Full time ₹ 8,00,000 - ₹ 18,00,000 per year

    Why Join Us?Are you inspired to grow your career at one ofIndia's Top 25 Best Workplaces in IT industry?Do you want to do the best work of your life at one of thefastest growing IT services companies? Do you aspire to thrive in an award-winning work culture thatvalues your talent and career aspirations? It'shappening right hereat Iris Software.About Iris...

  • ETL QA

    6 days ago

    Noida, Uttar Pradesh, India Iris Software Full time ₹ 12,00,000 - ₹ 16,00,000 per year

    Key Responsibilities:Data Testing Strategy & Execution: Design, develop, and execute comprehensive test plans and test cases for data-centric applications, ETL processes, data warehouses, data lakes, and reporting solutions.SQL-Driven Validation: Utilize advanced SQL queries to perform complex data validation, data reconciliation, data integrity checks, and...

  • Plc Programmer, Automation Engineer

    3 weeks ago

    Noida, Uttar Pradesh, India TAC AUTOMATION PRIVATE LIMITED Full time

    About TAC AUTOMATION PVT LTD Established in 2010, TAC Automation Pvt.Ltd.is eminent industrial automation & robotics engineering solution provider company, which involves in offering wide range of Automation, Mechatronics, SPM's Robotics, Machine Vision, Electrical & Electronics products & solutions to our Prestigious customers.We have an experienced and...