Etl Testing

5 days ago

Chennai Tamil Nadu, India Virtusa Full time

Key Responsibilities:
Collaborate with the ETL development team and business stakeholders to understand the ETL workflows and data requirements.
Create and execute test plans, test cases, and test scripts for ETL processes and data pipelines.
Perform data validation and verification to ensure that the data extracted, transformed, and loaded by the ETL process is accurate, complete, and consistent with business rules.
Verify the correct transformation logic of data based on requirements, ensuring that the data is properly mapped between source and target systems.
Perform functional, regression, integration, and performance testing for ETL jobs and data integration solutions.
Identify and document defects, track them through resolution, and ensure that they are resolved promptly.
Conduct data quality checks to ensure that data meets the required standards before it is loaded into the target systems.
Test data for correctness, completeness, consistency, and reliability across different environments.
Monitor and evaluate ETL processes, identifying potential performance issues and recommending improvements.
Review and validate the performance and scalability of ETL jobs, particularly with large datasets.
Work with automation tools to automate repetitive ETL testing tasks, improving efficiency and coverage.
Provide detailed reports on test results, issues, and progress to stakeholders.
Ensure that testing is conducted in accordance with the project's defined timelines and quality standards.
Assist in creating and maintaining documentation related to ETL testing processes, test cases, and best practices.
Required Skills and Qualifications:
Proven experience as an ETL Tester or in a similar role focusing on testing data integration processes.
Strong knowledge of ETL tools (e.g., Informatica, Talend, Microsoft SSIS, etc.) and testing techniques for data pipelines.
Proficiency in SQL for validating and querying large datasets, writing complex queries to verify data integrity.
Experience with data validation, data mapping, and data transformation testing.
Understanding of database technologies (e.g., Oracle, SQL Server, MySQL, or similar databases).
Familiarity with different testing methodologies such as functional, regression, integration, and performance testing.
Experience in writing detailed test plans, test cases, and defect reports.
Knowledge of data warehousing concepts, ETL processes, and data modeling.
Familiarity with test automation tools and scripts for ETL testing is a plus.
Strong attention to detail, analytical thinking, and problem-solving skills.

**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 was founded on principles of equal opportunity for all, and so does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. All employment is decided on the basis of qualifications, merit, and business need.

  • Etl Testing

    1 week ago

    Chennai, Tamil Nadu, India Virtusa Full time

    Below is the skillset and JD for the resources needed. 3-5 years of ETL testing/ DW Testing/ Data migration testing experience. Extensive experience in writing complex SQL queries. Solid Understanding of Data warehousing concepts Experience in AWS, Snowflake. Handling aggressive timelines and multiple responsibilities Proficient in creating and maintaining...

  • Etl Testing

    1 week ago

    Chennai, Tamil Nadu, India Virtusa Full time

    Role: ETL Testing Work Mode: Hybrid Work timings: 2pm to 11pm Location: Chennai & Hyderabad Primary Skills: SQL ETL Knowledge DWH Concepts Python JD QA Testing QA Tester Strong SQL Scripting knowledge and writing queries for testing Strong Data warehousing Knowledge and ETL Concepts Examining the business needs to determine the testing technique by...

  • Etl Testing

    2 weeks ago

    Chennai, Tamil Nadu, India Virtusa Full time

    Perform data validation, source-to-target mapping verification, and data reconciliation across different stages of ETL. Use Python scripts for data comparison, automation of test cases, and log analysis. Collaborate closely with developers, data engineers, and business analysts to understand requirements and ensure thorough testing. Identify, report, and...

  • Etl Testing

    2 weeks ago

    Chennai, Tamil Nadu, India Virtusa Full time

    Excellent in writing SQL Scripts to validate data in ODS and Mart. Should be able to develop and execute test plans, test cases, and test scripts. Strong in validation of Visual Analytics reports using tools like Power BI, MicroStrategy, etc., and running different types of tests within the same. Identifies, manages, and resolves defects during testing...

  • Etl Testing

    1 week ago

    Chennai, Tamil Nadu, India Virtusa Full time

    Excellent in writing SQL Scripts to validate data in ODS and Mart. Should be able to develop and execute test plans, test cases, test scripts. Strong in validation of Visual Analytics reports using tools like Power BI, MicroStrategy, etc. and running different types of test within the same. Identifies, manages, and resolves defects during testing cycles...

  • Etl Testing

    7 days ago

    Chennai, Tamil Nadu, India Virtusa Full time

    Role: ETL Tester Work Mode: Hybrid Work timings: 2pm to 11pm Location: Chennai & Hyderabad Primary Skills:SQL ETL Knowledge DWH Concepts Python Secondary Automation testing JD QA Testing QA Tester Strong SQL Scripting knowledge and writing queries for testing Strong Data warehousing Knowledge and ETL Concepts Examining the business needs to determine the...

  • Etl Testing with Python

    1 day ago

    Chennai, Tamil Nadu, India Virtusa Full time

    Proficient in Python for data validation scripts Experience with API testing and integration testing to retrieve data. Understanding of file system data handling and validation Expertise in data ingestion processes Ability to validate logical data models, and associated data products Familiarity with automated testing frameworks Design, develop, and execute...

  • Etl Testing

    5 days ago

    Chennai, Tamil Nadu, India Virtusa Full time

    1. 6+ Years of Experience 2. Good Knowledge of Testing Life cycle 3. Knowledge of Test Automation - This is a must 4. Strong knowledge on SQL 5. Data and Analytics / ETL Testing would be an advantage 6. Banking and Payment knowledge is preferred 7. Excellent Communication **About Virtusa** Teamwork, quality of life, professional and personal development:...

  • ETL Testing Trainer

    1 week ago

    Medavakkam, Chennai, Tamil Nadu, India Intellion Technologies Pvt Ltd Full time ₹ 10,000 - ₹ 15,00,000 per year

    Job Title: ETL Testing Trainer (Part-Time, Freelance)Job Description:We are looking for an experienced ETL Testing Trainer to join us on a part-time freelance basis. This is a remote role with flexible timings.Role Details:Type: Part-TimeWorking Hours:Weekdays: 1 hour/dayWeekends: 2 hours/dayDuration: Syllabus typically takes 30–40 hours to...

  • Etl Snowflake Testing

    2 weeks ago

    Chennai, Tamil Nadu, India Virtusa Full time

    ____________________ 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...