SDET - QA Automation Engineer (Python)

Tata Consultancy Services; Bengaluru; On-site; INR 1,500,000 - 2,200,000; Full time

Job summary

Tata Consultancy Services in Bengaluru is seeking an experienced SDET QA Automation Engineer to design scalable automation frameworks and drive data-intensive testing across enterprise applications. You will automate backend, API, database and data validation testing using Python, pytest, SQL Server, PostgreSQL, and AWS cloud services, while mentoring juniors and reinforcing CI/CD practices.

The role emphasizes AI/ML-assisted testing, performance and security testing, and collaboration with

Qualifications

• 5+ years of experience as an SDET or QA Automation Engineer.
• Strong Python programming expertise.
• Hands-on experience with pytest, Pandas and automation framework development.
• Strong experience in Automation Testing, Test Framework Design, Test Case Development.
• Strong SQL experience: SQL Server and PostgreSQL.
• Experience with Liquibase and Flyway.
• Experience automating database and backend testing.
• Knowledge of AI/ML technologies for automated testing and anomaly detection.
• Experience with AWS cloud technologies including EC2, EKS, Lambda.
• Familiarity with CI/CD tools and automation processes.
• Strong understanding of software engineering principles.

Responsibilities

• Design and implement automated testing solutions for large-scale, data-intensive platforms.
• Develop high-quality functional, regression, integration, and end-to-end automation test scenarios.
• Build scalable Python-based automation frameworks and testing utilities.
• Automate backend, middleware, API, database, and data validation testing processes.
• Ensure software quality through automated regression test frameworks and continuous testing practices.
• Develop automation tools and applications using Python.
• Build reusable automation components and testing frameworks.
• Automate SQL Stored Procedure regression, component, and unit testing using pytest and tSQLt.
• Develop maintainable and scalable test automation solutions.
• Perform database testing across SQL Server and PostgreSQL.
• Validate large data sets and complex business logic.
• Automate testing of data-intensive workflows and transformations.
• Support schema migration and deployment testing using Liquibase and Flyway.
• Utilize AI/ML technologies for anomaly detection, data validation, automatic test case generation, drift detection, process optimization.
• Leverage frameworks such as scikit-learn, TensorFlow, PyCaret.
• Conduct Performance Testing, Load Testing, Security Testing.
• Use tools such as JMeter, k6, Apache Benchmark, SQL Profiler.
• Integrate automation into CI/CD pipelines.
• Support continuous testing initiatives.
• Work with AWS cloud environments and cloud-native platforms.
• Collaborate with engineering, DevOps, and business teams.
• Drive testing best practices and quality engineering standards.
• Conduct code reviews and mentor junior engineers.
• Promote automation-first culture.
• Continuously improve testing processes and overall product quality.

Skills

Python

SQL

AWS

CI/CD

Data validation

Tools

pytest

Pandas

Liquibase

Flyway

EC2

EKS

Lambda

Job description

We are seeking an experienced SDET QA Automation Engineer with strong expertise in Python, Test Automation, SQL, AWS, CI/CD, and Data Validation. The ideal candidate will be responsible for designing and implementing scalable automation frameworks, automating complex data-intensive testing scenarios, and driving quality engineering practices across mission-critical applications.

The role requires hands-on experience in automation engineering, database testing, AI/ML-assisted testing, and cloud-based testing strategies within enterprise environments.

Key Responsibilities

Test Automation & Quality Engineering

• Design and implement automated testing solutions for large-scale, data-intensive platforms.
• Develop high-quality functional, regression, integration, and end-to-end automation test scenarios.
• Build scalable Python-based automation frameworks and testing utilities.
• Automate backend, middleware, API, database, and data validation testing processes.
• Ensure software quality through automated regression test frameworks and continuous testing practices.

Python Automation Development

• Develop automation tools and applications using Python.
• Build reusable automation components and testing frameworks.
• Automate SQL Stored Procedure regression, component, and unit testing using:
  
  • pytest
  • tSQLt
• Develop maintainable and scalable test automation solutions.

Database & Data Testing

• Perform database testing across SQL Server and PostgreSQL platforms.
• Validate large data sets and complex business logic.
• Automate testing of data-intensive workflows and transformations.
• Support schema migration and deployment testing using:
  
  • Liquibase
  • Flyway

AI/ML-Based Testing

• Utilize AI/ML technologies for:
  
  • Anomaly detection
  • Data validation
  • Automatic test case generation
  • Drift detection
  • Process optimization
• Leverage frameworks such as:
  
  • scikit-learn
  • TensorFlow
  • PyCaret

Performance & Non-Functional Testing

• Conduct:
  
  • Performance Testing
  • Load Testing
  • Security Testing
• Use tools such as:
  
  • JMeter
  • k6
  • Apache Benchmark
  • SQL Profiler

DevOps & Cloud Testing

• Integrate automation into CI/CD pipelines.
• Support continuous testing initiatives.
• Work with AWS cloud environments and cloud-native platforms.
• Collaborate closely with engineering, DevOps, and business teams.

Leadership & Mentoring

• Drive testing best practices and quality engineering standards.
• Conduct code reviews and mentor junior engineers.
• Promote engineering excellence and automation-first culture.
• Continuously improve testing processes and overall product quality.

Required Skills

• 5+ years of experience as an SDET or QA Automation Engineer.
• Strong Python programming expertise.
• Hands-on experience with:
  
  • pytest
  • Pandas
  • Automation Framework Development
• Strong experience in:
  
  • Automation Testing
  • Test Framework Design
  • Test Case Development
• Strong SQL experience:
  
  • SQL Server
  • PostgreSQL
• Experience with:
  
  • Liquibase
  • Flyway
• Experience automating database and backend testing.
• Knowledge of AI/ML technologies for automated testing and anomaly detection.
• Experience with AWS cloud technologies including:
  
  • EC2
  • EKS
  • Lambda
• Familiarity with CI/CD tools and automation processes.
• Strong understanding of software engineering principles.

Preferred Skills

• C# .NET development exposure.
• Java development experience.
• Angular or Silverlight application testing.
• Financial Markets domain experience.
• Equities and Fixed Income domain knowledge.
• Performance testing expertise.
• Data Science and Machine Learning exposure.
• AWS Native Services.

Desired Candidate Profile

• Strong analytical and problem-solving mindset.
• Excellent written and verbal communication skills.
• Ability to work effectively within Agile teams.
• Strong focus on automation and continuous improvement.
• Proven mentoring and leadership capabilities.
• Passion for engineering excellence and quality assurance.