ETL Tester_In-Person Interview

Tata Consultancy Services; Chennai District; On-site; INR 600,000 - 1,000,000; Full time

Job summary

Tata Consultancy Services in Chennai invites applications for an ETL Tester position and invites in-person interviews on Saturday, 29th Aug 2026, 9am–1pm at Chennai location. The role focuses on ETL testing, SQL excellence, and mentoring a tester team within a data warehouse context.

The candidate should possess 5–15 years of experience, expertise in ETL tools, and strong data validation capabilities for source-to-target data accuracy.

Qualifications

• 5 to 15 years of experience in ETL testing and related domains.
• Must have hands-on experience with ETL testing concepts and data validation.

Responsibilities

• Lead and mentor a team of ETL testers, providing technical guidance, training, and support in ETL tools, SQL, and test automation frameworks.

Skills

ETL Testing

Advanced SQL

Shell Scripting

Tools

Datagap

Informatica

Talend

Ab initio

SSIS

SSMS

PowerBI

Cognos

Azure DevOps

JIRA

Job description

TCS hiring In-Person Interview (face to face) on this upcoming Saturday (29th Aug, 2026)

Position - ETL Tester

Skill - ETL Testing, Advanced SQL, Shell Scripting (Mandatory)

Experience - 5 to 15 years

Location - Chennai (TCS-Siruseri, Plot No. 1/G1, SIPCOT IT Park, Navalur Post, Siruseri, Kanchipuram District, Chennai-603103 Tamil Nadu)

Notice - 0 to 45 days

Mode of Interview - Face to Face

Date - 29th Aug, 2026 (Saturday)

Time - 9am to 1pm

Job Descriptions

• 1. SQL - Expert level of knowledge in core concepts of SQL and query.
• 2.Lead and mentor a team of ETL testers, providing technical guidance, training, and support in ETL tools, SQL, and test automation frameworks.
• 3.Create and review complex test cases, test scripts, and test data for ETL processes.
• 4. ETL Automation - Experience in Datagap, Good to have experience in tools like Informatica, Talend and Ab initio.
• 5.Execute test cases, validate data transformations, and ensure data accuracy and consistency across source and target systems
• 6. Experience in query optimization, stored procedures/views and functions.
• 7. Strong familiarity of data warehouse projects and data modeling.
• 8. Understanding of BI concepts - OLAP vs OLTP and deploying the applications on cloud servers.
• 9. Preferably good understanding of Design, Development, and enhancement of SQL server DW using tools (SSIS,SSMS, PowerBI/Cognos/Informatica, etc.)
• 10.Develop and maintain ETL test automation frameworks to enhance testing efficiency and coverage.
• 11. Integrate automated tests into the CI/CD pipeline to ensure continuous validation of ETL processes.
• 12. Azure DevOps/JIRA - Hands on experience on any test management tools preferably ADO or JIRA.