LTIMindtree is hiring a Senior QA ETL Automation Engineer for a Pan India opportunity. This role is suitable for QA professionals with 5–7 years of experience who have strong knowledge of ETL concepts, database testing, SQL, Selenium, TOSCA, Unix, and AutoSys. Immediate joiners are preferred, making notice period an important consideration for applicants.
📌 Job Details
🆔 Job ID: 867466
💼 Role: Senior QA ETL Automation Engineer
🧑💻 Experience: 5–7 Years
📍 Location: Pan India
⏳ Joining: Immediate Joiners Preferred
🧪 Mandatory Skill: ETL Concepts
🔧 Automation: Selenium, TOSCA
🗄️ Database: SQL, Database Testing
💻 Environment: Unix
⏰ Scheduling: AutoSys
🔄 Testing: SIT / UAT
📋 Methodology: Agile
🏢 About LTIMindtree
LTIMindtree is a global technology consulting and digital solutions organization formed through the combination of Larsen & Toubro Infotech and Mindtree. The company works with enterprises across areas including cloud, data and analytics, enterprise applications, digital engineering, cybersecurity, and application development.
For QA professionals, an enterprise IT-services environment can provide exposure to large applications, complex data flows, multiple testing stages, Agile delivery teams, and client-facing projects. This particular opening is focused heavily on data quality and ETL validation, making database and backend testing central to the position.
🌟 Why Is This Role Good for Your Experience?
This position can strengthen a QA profile beyond conventional UI automation because ETL and database testing are mandatory requirements. An engineer in this type of role needs to understand how data moves between source and target systems and how to validate transformations, completeness, accuracy, and integrity.
The combination of Selenium and TOSCA also gives exposure to different automation approaches. Meanwhile, SQL, Unix, and AutoSys introduce important backend and enterprise-environment skills.
🛠️ Skills Required
✅ ETL concepts and ETL testing
✅ Source-to-target data validation
✅ SQL and complex queries
✅ Database testing
✅ Selenium WebDriver
✅ TOSCA automation
✅ Unix/Linux commands and scripting basics
✅ AutoSys job scheduling concepts
✅ SIT and UAT testing
✅ Functional and regression testing
✅ Data reconciliation and validation
✅ Defect lifecycle management
✅ Agile/Scrum methodology
✅ Test case design and execution
✅ Root-cause analysis
🎯 Preparation Tips
1. Make ETL your priority: The job specifically identifies ETL concepts as mandatory. Revise ETL architecture, extraction, transformation, loading, staging areas, mappings, incremental loads, full loads, data validation, and reconciliation.
2. Practise SQL beyond basics: Prepare joins, subqueries, CTEs, aggregate functions, GROUP BY/HAVING, CASE statements, window functions, duplicate detection, NULL handling, and source-versus-target validation queries.
3. Prepare ETL testing scenarios: Be ready to explain how you would validate a source-to-target mapping, identify missing records, verify transformed values, test duplicate records, validate rejected records, and investigate data mismatches.
4. Revise TOSCA: Understand modules, test cases, reusable components, execution lists, buffers, synchronization, data-driven testing, and how TOSCA fits into an enterprise automation strategy.
5. Strengthen Selenium: Prepare WebDriver concepts, locators, waits, handling dynamic elements, frames, windows, dropdowns, JavaScript interactions, Page Object Model, and common automation failures.
6. Learn AutoSys fundamentals: Understand jobs, boxes, dependencies, scheduling, conditions, failures, reruns, and how QA teams can validate scheduled ETL workflows.
7. Practise Unix commands: Revise commands such as grep, find, tail, head, cat, ps, chmod, vi, awk, and basic shell scripting. Focus on how they can help investigate application and ETL failures.
🧑💼 Expected LTIMindtree Interview Rounds
🔹 Initial/Recruiter Screening: Experience, current location, notice period, compensation, and role alignment.
🔹 Technical Round: ETL, SQL, database testing, Selenium, TOSCA, Unix, AutoSys, SIT/UAT, and testing fundamentals.
🔹 Project/Managerial Round: Real-world scenarios involving data defects, automation decisions, Agile delivery, ownership, client communication, and production issues.
🔹 HR/Final Discussion: Compensation, joining availability, location, employment details, and other formalities.
💰 Salary Range
The job post does not specify an official salary range. For a 5–7 year Senior QA/ETL Automation profile in India’s IT-services market, candidates may encounter compensation around ₹8 LPA–₹16 LPA, depending on location, current CTC, relevant ETL expertise, automation skills, project requirements, and interview performance. This is a market-oriented reference, not an official LTIMindtree salary figure for Job ID 867466.
Candidates with strong ETL, SQL, TOSCA, Selenium, and enterprise scheduling experience should discuss compensation based on their complete skill set.
📄 Resume Tips
Your resume should put ETL Testing + SQL + Database Testing near the top because ETL is explicitly mandatory for this position. Avoid presenting yourself only as a Selenium QA Engineer.
Use project bullets that demonstrate source-to-target validation, data reconciliation, ETL workflow testing, complex SQL queries, defect investigation, and database validation—provided these accurately reflect your experience.
Mention TOSCA and Selenium separately and explain what you automated. Add Unix and AutoSys experience where applicable, especially if you have monitored or validated scheduled ETL jobs.
📩 How to Apply
📩rahulyadav.referral@gmail.com
Interested candidates can share their updated CV with rahulyadav.referral@gmail.com.
While applying, mention the following details clearly:
📌 Job ID: 867466
📌 Total Experience: 5–7 Years
📌 Notice Period: Mention exact availability
📌 Current Location: Mention current city
🔎 Final Takeaway
LTIMindtree’s Senior QA ETL Automation Engineer opening is centered on a combination of ETL validation, database testing, SQL, enterprise automation, and backend workflow testing. Professionals applying for Job ID 867466 should prioritize ETL concepts and SQL preparation while also revising Selenium, TOSCA, Unix, AutoSys, SIT/UAT, and Agile testing scenarios.
