Virtusa Recognized as Global Leader in Gen AI Services by ISG Provider Lens® - Read report

× Success! Job has been saved successfully.

ETL Ab initio Developer

Chennai, Tamil Nadu, India
Posted on: 27-10-2025

Job description

Summary:


We are seeking a detail-oriented Data Test Engineer to join our data migration and cloud modernization team. The ideal candidate will have hands-on experience testing complex ETL pipelines, data migration workflows, and cloud data platforms like Snowflake, with exposure to legacy ETL tools such as Ab Initio or Informatica. Experience in automating data validation, performance testing, and supporting real-time ingestion using Kafka or similar technologies is essential.
________________________________________
Key Responsibilities:
Design, develop, and execute test plans for data migration projects moving data from legacy systems to Snowflake.
Validate data pipelines developed using ETL tools like Ab Initio and Informatica, ensuring data quality, accuracy, and integrity.
Develop automated test scripts and frameworks using Python for data validation, reconciliation, and regression testing.
Perform end-to-end data validation including schema validation, volume checks, transformation logic verification, and performance benchmarking.
Test real-time data ingestion workflows integrating Kafka, Snowpipe, and Snowflake COPY commands.
Collaborate closely with development, data engineering, and DevOps teams to identify defects, track issues, and ensure timely resolution.
Participate in designing reusable test automation frameworks tailored for cloud data platforms.
Ensure compliance with data governance, security, and regulatory requirements during testing.
Document test cases, results, and provide clear reporting to stakeholders.
Support CI/CD pipelines by integrating automated testing into the deployment workflow.
________________________________________
Required Skills and Experience:
5+ years in data testing or quality assurance with strong experience in data validation and ETL testing.
Hands-on experience testing data migrations to Snowflake or other cloud data warehouses.
Familiarity with legacy ETL tools like Ab Initio or Informatica and their testing methodologies.
Proficient in scripting languages such as Python for test automation and data validation.
Knowledge of real-time data streaming platforms such as Kafka, Kinesis, or equivalents.
Strong SQL skills for writing complex queries to validate data integrity and transformations.
Experience with automated testing tools and frameworks for data quality checks.
Understanding of cloud environments, particularly AWS services (S3, Lambda, Glue).
Familiarity with CI/CD tools and practices to integrate automated testing.
________________________________________
Preferred Qualifications:
Bachelors degree in Computer Science, Information Technology, or related field.
Experience with performance and load testing of data pipelines.
Knowledge of data governance and compliance frameworks.
Exposure to BI tools such as Tableau, Power BI for validating data consumption layers.
Certifications in data quality or cloud platforms (Snowflake, AWS) are a plus

Qualification

Summary:


We are seeking a detail-oriented Data Test Engineer to join our data migration and cloud modernization team. The ideal candidate will have hands-on experience testing complex ETL pipelines, data migration workflows, and cloud data platforms like Snowflake, with exposure to legacy ETL tools such as Ab Initio or Informatica. Experience in automating data validation, performance testing, and supporting real-time ingestion using Kafka or similar technologies is essential.
________________________________________
Key Responsibilities:
Design, develop, and execute test plans for data migration projects moving data from legacy systems to Snowflake.
Validate data pipelines developed using ETL tools like Ab Initio and Informatica, ensuring data quality, accuracy, and integrity.
Develop automated test scripts and frameworks using Python for data validation, reconciliation, and regression testing.
Perform end-to-end data validation including schema validation, volume checks, transformation logic verification, and performance benchmarking.
Test real-time data ingestion workflows integrating Kafka, Snowpipe, and Snowflake COPY commands.
Collaborate closely with development, data engineering, and DevOps teams to identify defects, track issues, and ensure timely resolution.
Participate in designing reusable test automation frameworks tailored for cloud data platforms.
Ensure compliance with data governance, security, and regulatory requirements during testing.
Document test cases, results, and provide clear reporting to stakeholders.
Support CI/CD pipelines by integrating automated testing into the deployment workflow.
________________________________________
Required Skills and Experience:
5+ years in data testing or quality assurance with strong experience in data validation and ETL testing.
Hands-on experience testing data migrations to Snowflake or other cloud data warehouses.
Familiarity with legacy ETL tools like Ab Initio or Informatica and their testing methodologies.
Proficient in scripting languages such as Python for test automation and data validation.
Knowledge of real-time data streaming platforms such as Kafka, Kinesis, or equivalents.
Strong SQL skills for writing complex queries to validate data integrity and transformations.
Experience with automated testing tools and frameworks for data quality checks.
Understanding of cloud environments, particularly AWS services (S3, Lambda, Glue).
Familiarity with CI/CD tools and practices to integrate automated testing.
________________________________________
Preferred Qualifications:
Bachelors degree in Computer Science, Information Technology, or related field.
Experience with performance and load testing of data pipelines.
Knowledge of data governance and compliance frameworks.
Exposure to BI tools such as Tableau, Power BI for validating data consumption layers.
Certifications in data quality or cloud platforms (Snowflake, AWS) are a plus

 Key job details

Primary Location
Chennai, Tamil Nadu, India
Job Type
Experienced
Primary Skills
ETL
Years of Experience
6
Travel
No
Job Posting
27/10/2025

Join Virtusa

 

Please enter a valid email address to begin your application.

Thank you for verifying your email. Please proceed with the steps below to apply.

We only accept the following file extensions: .pdf, .docx or .doc
Maximum file size: 1 MB
File name must not include special characters or spaces (e.g. “name_resume.pdf”)

We only accept the following file extensions:

Thank you. You already have an active account with Virtusa's hiring system. Please login to our portal to proceed with your application or apply for more opportunities.

LoginClick to Login

About Virtusa

Teamwork, quality of life, professional and personal development: values that Virtusa is proud to embody. When you join us, you join a team of 27,000 people globally that cares about your growth — one that seeks to provide you with exciting projects, opportunities and work with state of the art technologies throughout your career with us.

Great minds, great potential: it all comes together at Virtusa. We value collaboration and the team environment of our company, and seek to provide great minds with a dynamic place to nurture new ideas and foster excellence.

Virtusa is an Equal Opportunity Employer. All applicants will receive fair and impartial treatment without regard to race, color, religion, sex, national origin, ancestry, age, legally protected physical or mental disability, protected veteran status, status in the U.S. uniformed services, sexual orientation, gender identity or expression, marital status, genetic information or on any other basis which is protected under applicable federal, state or local law.

Applicants may be required to attend interviews in person or by video conference. In addition, candidates may be required to present their current state or government-issued ID during each interview. All candidates must be authorized to work in the USA.

Learn more

Awards and recognition

Find us on Glassdoor.

Have any questions?

What is the best way to find and apply for positions at Virtusa?

To join our bright team of professionals, you can apply directly to our website under the Careers tab and search all open jobs. https://www.virtusa.com/careers

Can I apply for more than one position at the same time?

Yes, you can. Virtusa gives you the flexibility to apply for multiple open positions that excite you about your future and align to your experience and career goals.

Can I apply for a position across multiple geographical locations?

Yes, you can. Virtusa is a global Company, and we serve our clients through our global delivery model.

What happens after I’ve submitted my resume?

Our dedicated recruitment team will review your online application and match it to all our open jobs. We update our open jobs on a daily basis and encourage you to check back often.

How will I be evaluated for a career opportunity with Virtusa?

Our team of recruiters will review your application, relevant job experience, and skills to appropriately align it to our open jobs. From there, the recruitment team will contact the qualified candidate to start the interview process.

Career insights

Want to explore the ways you can engineer your career in technology? Our thought leaders share key career insights for candidates from entry-level job seekers to senior technologists.