Etl Testing

17 hours 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 Test

    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: ETL Examining the business needs to determine the testing technique by automation testing. Maintenance of present regression suites and test scripts is an important responsibility of the tester. The testers must attend agile meetings for backlog...

  • Etl Testing

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

    3 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

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

    5 days ago

    tamil nadu, India LTIMindtree Full time

    Dear Candidate, Greetings from LTIMindtree !!! We are really impressed by your ETL Testing experience. We are having multiple opportunities and projects which are based on ETL Testing, SQL. I’d love to tell you a little more about the position and learn a few things about you, as well. If you are interested, please share your updated resume and also help...

  • 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

    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

    17 hours 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:...

  • Testing - Etl

    2 weeks ago

    Chennai, Tamil Nadu, India Virtusa Full time

    Review and analyze system specifications/requirements. - Collaborate with QA Engineers to develop effective strategies and test plans. - Prepare and Execute test cases. - Create logs to document testing phases and defects. - Report bugs and errors to development teams. - Help troubleshoot issues. - Conduct post-release/ post-implementation testing. - Work...

  • Etl Testing

    17 hours ago

    Chennai, Tamil Nadu, India Virtusa Full time

    **JOB DESCRIPTION** **Skill**:ETL QA** **Role / Tier: - **Architect / Sr. Architect - T0** **Required Qualifications**: 12+ years of experience in IT & minimum 2 years of Architect Experience in Testing area Experience in API Testing using Rest Assured/JSON/Rest API Very good coding skills in Java/Python and SQL Working knowledge of Datawarehouse and Data...