Etl Testing

15 hours 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 leveraging a test management tool like JIRA, HP ALM. Also, supports or leads UAT process, when appropriate.
Should be aware of Quality and Testing related best practices and procedures and adheres to those.

Good knowledge in any RDBMS like AWS Redshift Postgres Oracle SQL Server.
Nice to have Python
Excellent communication skills both verbal and written.
Knowledge of Automation and Automation framework within ETL space. Primary Skills Must have
Understanding of data model, ETL architecture.
Excellent in Data Warehouse concepts.
Collaborate with business analysts and stakeholders to understand the data requirements.

Review functional specifications and ensure they align with the ETL process

Create detailed test plans for ETL testing, including the scope, test cases, and test data.

Define the test environment, required tools, and resources for ETL testing.
Design and write test cases based on functional specifications and ETL mappings.

Ensure coverage of all scenarios, including positive and negative test cases, edge cases, and data validation.

**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

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

  • Etl Testing

    15 hours ago

    Chennai, Tamil Nadu, India Virtusa Full time

    Role: ETL Tester Work Mode: Hybrid Work timings: 2pm to 11pm Location: Chennai & Hyderabad Primary Skills: ETL Design and execute test plans and test cases for ETL processes and data flows on Cloud Validate data extraction, transformation, and loading (ETL) processes from source to target systems. Write and execute complex SQL queries to perform data...

  • Etl Testing

    2 weeks 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

    2 weeks 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

    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, 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

    1 week 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

    5 days 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

    1 week 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:...