Etl Testing
20 hours ago
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
2 weeks ago
Chennai, Tamil Nadu, India Virtusa Full timePosition Summary The ETL Tester is responsible for validating and verifying data extraction transformation and loading processes to ensure data accuracy and integrity This role involves designing and executing test cases identifying data quality issues and collaborating with data engineers to resolve discrepancies The ETL Tester will also develop automated...
-
Etl Testing
2 weeks ago
Chennai, Tamil Nadu, India Virtusa Full timePython, SQL, Snowflake, Oracle PL/SQL, Database Model 3NF, Microsoft Power BI Snowflake, Requirements Engineering, Reporting, Requirement Analysis, DB2- SQL, SQL Server, DWH Testing, SQLite, White Box Testing, Test Requirement Management, Oracle PL SQL, ETL Testing, BI Testing Java, HTML, AWS, C, GCP, Python Software Development, Manual Testing, API Gateway,...
-
Etl Testing
3 days ago
Chennai, Tamil Nadu, India Virtusa Full timeRole: 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
20 hours ago
Chennai, Tamil Nadu, India Virtusa Full time1. 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
2 weeks ago
Medavakkam, Chennai, Tamil Nadu, India Intellion Technologies Pvt Ltd Full time ₹ 1,20,000 - ₹ 1,80,000 per yearJob 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
1 week 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...
-
Testing - Etl
2 weeks ago
Chennai, Tamil Nadu, India Virtusa Full timeReview 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
20 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...
-
Etl Testing
6 days ago
Chennai, Tamil Nadu, India Virtusa Full timeETL QA Assist with the development of QA software for our testing facility Oversee the production of all software products created by our design and programming team Monitor and review quarterly data based on suppliers reports Review and process all purchase orders in accordance with company policy Provide quarterly inspection data and quality assurance...
-
ETL Testing
1 week ago
Chennai, Tamil Nadu, India Kumaran Systems Full time ₹ 2,50,000 - ₹ 7,50,000 per yearRequired Skills & ExperienceTechnical Expertise:Strong hands-on experience in Azure Data Factory (ADF) and Databricks.Proficiency in SQL for data validation and reconciliation (including advanced joins, window functions, aggregates).Hands-on experience with PySpark for large-scale data validation and transformations.Strong programming/scripting skills in...
