Strong ETL, SQL with Hands on Python Automation

Logic Planet; Chennai District, Hyderabad; On-site; INR 2,000,000 - 3,400,000; Full time

Job summary

Logic Planet is seeking a Python Automation Lead to own the design, development, and deployment of a scalable Python-based Data Testing Automation Framework. The role emphasizes end-to-end testing of ETL pipelines, data validation, and data warehouses with strong technical leadership.

The candidate should have hands-on Python development experience, expertise in ETL testing and SQL, and prior team leadership exposure in an Agile environment. Chennai-based, on-site work is expected.

Qualifications

• Hands-on Python development and automation experience in data testing.
• Expertise in ETL testing, data validation, and data quality checks.
• Ability to design and implement a data testing automation framework.
• Strong SQL skills including complex queries and performance tuning.

Responsibilities

• Lead design and development of Data Testing Automation solutions using Python.
• Build robust automation frameworks for ETL and data validation testing.
• End-to-end testing of data pipelines, ETL processes, and warehouses.
• Develop reusable automation scripts and utilities for data quality.
• Write and optimize complex SQL queries for data reconciliation.
• Collaborate with Business, Development, and QA teams to meet testing needs.
• Drive automation strategy and framework adoption across projects.
• Mentor team members and provide technical guidance on automation.

Skills

Python Automation Development

ETL Testing

Data Warehouse Testing

Data Validation

Advanced SQL

Data Testing Frameworks

Agile Methods

Communication Skills

Job description

Job Title: Python Automation Lead - ETL/Data Testing

Experience

• 6+ Years of Overall Experience
• Minimum 4+ Years of Hands-on Python Development & Automation Experience
• Prior Team Lead experience preferred

Job Description

We are seeking an experienced Python Automation Lead with strong expertise in ETL Testing, SQL, and Data Testing Automation. The ideal candidate should be capable of taking end-to-end ownership of designing, developing, and implementing a scalable Python-based Data Testing Automation Framework. This role requires strong technical leadership, hands-on coding expertise, and a good understanding of data validation processes within enterprise environments.

Key Responsibilities

• Lead the design and development of Data Testing Automation solutions using Python.
• Build and maintain robust automation frameworks for ETL and data validation testing.
• Perform end-to-end testing of data pipelines, ETL processes, and data warehouses.
• Develop reusable automation scripts and utilities for data quality validation.
• Write and optimize complex SQL queries for data reconciliation and verification.
• Collaborate with Business, Development, and QA teams to understand testing requirements and deliver automation solutions.
• Drive automation strategy, best practices, and framework adoption across projects.
• Mentor team members and provide technical guidance on automation initiatives.
• Ensure high standards of data integrity, quality, and test coverage.

Required Skills

• Strong hands-on experience in Python Automation Development.
• Expertise in ETL Testing, Data Warehouse Testing, and Data Validation.
• Advanced SQL skills with experience in writing complex queries, joins, stored procedures, and performance optimization.
• Experience in designing and implementing Data Testing Automation Frameworks.
• Strong understanding of Database Testing concepts.
• Experience working in Agile environments.
• Excellent analytical, problem-solving, and communication skills.

Preferred Skills

• Experience in Financial Services, Capital Markets, Investment Banking, or Securities Processing domains.
• Knowledge of data migration, reconciliation, and reporting systems.
• Exposure to cloud platforms (AWS/Azure) is an advantage.Job Title: