ETL and Automation Test Engineer (SDET)

Keyrus; Maharashtra; On-site; INR 1,500,000 - 3,000,000; Full time

Benefits offered by this job

Hybrid work model

Job summary

Keyrus India in Pune or Bangalore (Hybrid — 3 days per week in the office) is seeking an ETL and Automation Test Engineer (SDET) to help organisations transform complexity into measurable outcomes by combining technology, data, intelligence, and human decision‑making. This role blends hands‑on test automation with data validation to ensure data quality across enterprise platforms.

We require 5+ years in software testing, experience with Snowflake and MS SQL Server, and proficiency in English.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, Engineering, or related field.
• 5+ years in software testing, test automation, data engineering, or quality engineering roles.
• Strong experience with enterprise data platforms and database testing.
• Experience in Agile delivery environments.
• Proficiency in English.

Responsibilities

• Design, develop, and maintain SQL‑based testing and data validation frameworks to ensure data quality across enterprise platforms.
• Create, execute, and optimise database and API test automation solutions while supporting ETL processes, data pipelines, and metadata management.
• Analyse, organise and validate raw data to ensure accuracy and reliability.
• Collaborate with business SMEs and data analytics experts to enhance functionality and efficiency within our data ecosystem.
• Maintain and enhance automated testing frameworks.
• Create appropriate standards and processes to ensure data quality and consistency in the platform.

Skills

SQL testing

Database validation

Test automation

ETL knowledge

Data pipelines

Data quality

English proficiency

Java

Python

Analytical

Education

Bachelor's degree in CS/IT/Engineering

Related field degree

Tools

Snowflake

MS SQL Server

API testing

Jenkins

Git

Job description

Why Keyrus, Why Now!

AI does not transform businesses. Architected intelligence does. For more than 30 years, we have been building the data foundations that make intelligent systems work — designing the Operating System of the intelligent enterprise, where intelligence is embedded into the core of business processes to create sustainable value:

we operationalise intelligence. AI does not replace humans. It repositions us to a place no system can follow:

understanding, deciding, designing, and creating. At Keyrus, you will not just develop skills — you will develop judgment. Your expertise sharpens with every system you architect, every client challenge you solve, and every deployment that compounds on the last.

Why Keyrus, Why Now!

Keyrus is an international group of 2,800 consultants and experts across 28 countries, built on a single conviction: AI does not transform businesses. Architected intelligence does. For more than 30 years, we have been building the data foundations that make intelligent systems work — designing the Operating System of the intelligent enterprise, where intelligence is embedded into the core of business processes to create sustainable value: we operationalise intelligence. AI does not replace humans. It repositions us to a place no system can follow: understanding, deciding, designing, and creating. At Keyrus, you will not just develop skills — you will develop judgment. Your expertise sharpens with every system you architect, every client challenge you solve, and every deployment that compounds on the last. Over time, you grow into one of the rarest professionals of the intelligence era: someone who bridges data, AI, and human decision‑making at scale, across industries and geographies. This is not a role you fill. It is a discipline you master and a story you help write to become a Keyrus Architect of Intelligence. Technology amplifies. Keyrus culture differentiates. Industrial discipline connects the two.

Role Details

Job location: Pune or Bangalore (Hybrid — 3 days per week in the office)

Contract type: Permanent

Target start date: ASAP

Working hours: Full-time (40h/week), aligned with the GMT timezone (starting at 1:00 PM IST)

Compensation: INR 15,00,000 – 30,00,000 per year

What You'll Architect

As an ETL and Automation Test Engineer (SDET), you will help organisations transform complexity into measurable outcomes by combining technology, data, intelligence, and human decision‑making. This role is both technical and consultative - perfect for someone who can combine hands‑on test automation and data validation, ensuring the accuracy, stability, and reliability of complex data platforms. We’re looking for professionals who think like architects and act like builders.

Key Responsibilities

• Design, develop, and maintain SQL‑based testing and data validation frameworks to ensure data quality across enterprise platforms
• Create, execute, and optimise database and API test automation solutions while supporting ETL processes, data pipelines, and metadata management
• Analyse, organise and validate raw data to ensure accuracy and reliability
• Collaborate with business SMEs and data analytics experts to enhance functionality and efficiency within our data ecosystem.
• Maintain and enhance automated testing frameworks
• Create appropriate standards and processes to ensure the quality and consistency of data in the platform

Who You Are

• You are curious, analytical, and motivated by solving meaningful business challenges.
• You enjoy turning complexity into clarity and action.
• You balance technical thinking with business understanding.
• You are comfortable working in collaborative and international environments.
• You take ownership of your work and follow through on commitments.
• You value continuous learning and are motivated by long‑term professional growth.
• You communicate clearly and effectively with a variety of stakeholders.

What You Bring

Qualifications & Experience

• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field (or equivalent professional experience).
• 5+ years of experience in software testing, test automation, data engineering, or quality engineering roles.
• Strong experience working with enterprise data platforms and database testing.
• Experience working within Agile delivery environments.
• Professional proficiency in English.

Technical & Professional Skills

• Strong experience with SQL testing and database validation, preferably including Snowflake and Microsoft SQL Server
• Experience with database and API test automation
• Basic to intermediate proficiency in Java and/or Python for automation development
• Understanding of ETL processes, data pipelines, and data quality validation practices
• Strong analytical, troubleshooting, and root cause analysis capabilities
• Experience developing and maintaining automated testing frameworks
• Familiarity with Git version control and software development best practices
• Ability to collaborate effectively with both technical and business stakeholders.

Nice to Have

• UI test automation using Selenium
• Experience executing automated tests through CI/CD platforms (Jenkins or equivalent).
• Knowledge of Power BI reporting and dashboards
• Familiarity with Airflow or similar workflow orchestration tools
• Understanding of cloud‑based data platforms and architectures
• Experience in consulting, client‑facing environments, or global delivery teams
• Relevant certifications in testing, automation, cloud, or data technologies.

What Makes You Successful

• You focus on outcomes rather than activity.
• You approach challenges with curiosity and pragmatism.
• You communicate complex concepts in a clear and accessible way.
• You are comfortable navigating ambiguity and finding practical solutions.
• You contribute to collective intelligence by sharing knowledge and supporting others.
• You combine autonomy with collaboration.
• You continuously look for opportunities to improve systems, processes, and results.

What We Offer At Keyrus India

• Hybrid work model (3 days/week in office)
• 18 paid leaves + 9 public holidays
• ₹5L medical insurance + ₹10L accident insurance
• Competitive fixed salary with EPF & statutory benefits
• International consulting exposure with Keyrus clients
• Discretionary Bonus Scheme
• Referral Bonus Scheme
• Training & Development via KLX (Keyrus Learning Experience)

How Our Salary Ranges Work

At Keyrus, salary ranges reflect different levels of mastery and impact within the same role — not different job titles.

• Bottom of the range You meet the core requirements and will need ramp-up time and support.
• Middle of the range You are fully autonomous from Day 1 and deliver consistently.
• Top of the range You are a reference for the role, mentor others, and raise the bar for the team.

Final offers are based on experience, autonomy, scope, and market context, and are discussed transparently during the process.

Responsible AI & Recruitment

At Keyrus, all stages of our recruitment process are conducted and evaluated by human recruiters and interviewers.

To support accuracy and efficiency, AI may occasionally be used internally by our team exclusively for note‑taking purposes during interviews. AI is never used to make decisions.

To ensure fairness, authenticity, and the protection of confidential and proprietary information, the use of AI tools by candidates during the recruitment process is strictly prohibited.

Our commitment to responsible AI practices ensures that hiring decisions are based solely on each candidate’s own skills, experience, judgment, and expertise.

Equal Opportunity Statement

We are committed to building an inclusive workplace and encourage applications from all backgrounds, regardless of race, ethnicity, gender identity, sexual orientation, age, disability, or any other protected characteristic..