ETL Automation Engineer

16 hours 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 QA

    4 days ago

    Noida, Uttar Pradesh, India IRIS software Full time

    Job DescriptionWhy Join UsAre you inspired to grow your career at one ofIndia's Top 25 Best Workplaces in IT industryDo 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...

  • Data Engineering Automation Specialist

    9 hours ago

    Noida, Uttar Pradesh, India beBeeData Full time ₹ 1,00,00,000 - ₹ 2,00,00,000

    As a data automation expert, 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,...

  • ETL Workflow Specialist

    4 days ago

    Noida, Uttar Pradesh, India beBeeData Full time ₹ 16,17,214 - ₹ 21,96,762

    Job Title: ETL Tester">This is a challenging role for an experienced ETL tester to validate, automate and ensure the quality of complex data workflows.">Responsibilities:">Validate ETL processes and tools such as IBM DataStage.Perform data validation using SQL queries.Design and execute test cases and scripts for ETL processes.Develop automation scripts in...

  • ETL QA

    12 hours ago

    Noida, Uttar Pradesh, India IRIS software Full time

    Job DescriptionWhy Join UsAre you inspired to grow your career at one ofIndia's Top 25 Best Workplaces in IT industryDo 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...

  • Etl Developer

    3 weeks ago

    Noida, Uttar Pradesh, India Ameriprise Financial Full time

    We are looking for a highly motivated and experienced individual with fresh ideas having passion great acumen for ETL and data warehousing concepts Strong working experience in Informatica Power Center SQL and at least anyone scripting language is must Good working knowledge in Agile model and should possess strong problem-solving skills and handling...

  • ETL Tester – Functional Testing

    4 weeks ago

    Noida, Uttar Pradesh, India ImpactQA Full time

    Company DescriptionFeatured by Everest Group among the top QA companies to watch out for, ImpactQA is a global software testing and quality assurance consulting company that provides services such as Quality Engineering, AI-based Test Automation, Performance Engineering, Security Testing, and a suite of continuous and automated testing services integrated...

  • ETL Developer

    2 hours ago

    Noida, Uttar Pradesh, India beBeeData Full time ₹ 22,50,000 - ₹ 30,50,000

    **Job Title:** Data EngineerOur team seeks a highly skilled Data Engineer to design, develop, and maintain robust ETL pipelines using Informatica Intelligent Data Management Cloud (IDMC/IICS). The ideal candidate will collaborate with data architects, analysts, and business stakeholders to gather and understand data requirements.Key Responsibilities:Design,...

  • Quality Engineer

    4 weeks ago

    Noida, Uttar Pradesh, India Strategic Talent Partner Full time

    We are looking for an experienced ETL Test Engineer with strong expertise in ETL tools, Automation testing, data warehousing, and cloud-based data pipelines. The role involves building automation frameworks, validating large-scale data transformations, and ensuring data quality across systems.Responsibilities- Develop and Implement Automation Frameworks:...

  • Quality Engineer

    2 weeks ago

    Noida, Uttar Pradesh, India Strategic Talent Partner Full time

    We are looking for an experienced ETL Test Engineer with strong expertise in ETL tools, Automation testing , data warehousing , and cloud-based data pipelines . The role involves building automation frameworks, validating large-scale data transformations, and ensuring data quality across systems. Responsibilities Develop and Implement Automation Frameworks...

  • Cloud Architect

    7 hours ago

    Noida, Uttar Pradesh, India beBeeCloud Full time ₹ 2,00,00,000 - ₹ 2,50,00,000

    Job Title:Cloud Architect & ETL ExpertAbout the Role:We are seeking a seasoned Cloud Architect and ETL expert to lead our cloud strategy. The ideal candidate will have extensive experience in designing, implementing, and overseeing cloud computing strategies.Responsibilities:Cloud Strategy: Develop and implement a comprehensive cloud strategy that aligns...