Etl QA with Aws
2 days ago
Chennai, India
Automated Testing Others
BCM Industry
20/12/2024
Req. VR-110556
**Project description**:
You'll be working with colleagues based across the region in at least three distinct locations. We work as a team together with the aspiration to provide trusted IT services and project support to the bank to support the ambitious growth plans. As a test engineer, you'll play an important role in making sure we achieve both business and technology objectives
**Responsibilities**:
Understand the ETL migration requirements and create a detailed test strategy for validating data pipelines.
Develop test plans, test cases, and test scripts for ETL workflows and data transformations (for SIT/UAT/NFT cycles to ensure the solution delivers the required system specifications and capabilities).
Define data quality checks and validation metrics to ensure consistency and accuracy during migration.
Payment domain experience e.g. basic payments domain knowledge, SWIFT messages (MTXXX) etc.
Compare and validate data outputs between the existing SAS DI system and the new Python-based ETL pipelines.
Verify data extraction, transformation, and loading processes on AWS EMR, S3, and Snowflake.
Perform functional, integration, and regression testing for all ETL workflows.
**Skills**:
Must have
Strong SQL skills for querying, comparing, and validating large datasets.
Experience in testing ETL pipelines and data transformations. Familiarity with Python for test automation and scripting.
Hands-on experience with cloud platforms, particularly AWS services like S3, EMR, and Snowflake.
Knowledge of SAS DI is highly desirable for understanding legacy pipelines.
Minimum 8 years of experience in QA/testing, with a focus on ETL and data engineering projects.
Prior experience testing ETL migrations from legacy systems like SAS DI to modern platforms is a plus.
Excellent communication skills to work effectively with cross-functional teams.
Nice to have
N/A
**Other**:
Languages
English: B2 Upper Intermediate
Seniority
Senior
-
Etl QA
5 days ago
Chennai, Tamil Nadu, India Virtusa Full timeRole: ETL QA Experience: 5+ years Work Mode: Hybrid Work timings: 2pm to 11pm Location: Chennai & Hyderabad Primary Skills: ETLQA Good Communication Skills. Python Basics, QA Testing with Automation, Data warehousing. Examining the business needs to determine the testing technique by automation testing. Maintenance of present regression suites and test...
-
Etl QA
2 days ago
Chennai, Tamil Nadu, India Virtusa Full timeP2-C3-TSTS Quality Engineers 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 validation, reconciliation, and analysis. Identify, document, and track defects and...
-
Etl QA
7 days ago
Chennai, Tamil Nadu, India Virtusa Full time**Role - ETL QA** **Experience - 5 to 8 years** **Work Mode - Hybrid** **Work Timings - 2PM to 11 PM** Primary Skill: ETL QA, SQL **Job Description**: 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...
-
Etl QA
1 hour ago
Chennai, Tamil Nadu, India Virtusa Full timeETL QA Develop comprehensive test plans, test cases, and test scripts specifically for SSIS (SQL Server Integration Services) ETL processes. Define testing strategies and methodologies for data integration and data migration projects using SSIS Identify, document, and track defects and inconsistencies in ETL processes. Develop and maintain automated test...
-
Python+aws+etl - Aia
2 weeks ago
Chennai, Tamil Nadu, India Cognizant Full time**Role**: Python+AWS+ETL **Experience**: 6 to 9 Years - We are looking for a Software Lead with the following skill set: - Strong hands-on experience with Python. - Strong hands-on experience with data engineering and ETL/ELT. - Good understanding of Big data engineering principles. - Good understanding of core networking principles as well as cloud infra...
-
ETL QA with automation
3 weeks ago
Chennai, India Virtusa Full timeETL QA with automation - CREQ Description ETL QA with Automation Mandatory Skills Ready API SQL ETL QA Good to have. ETL Automated testing using Java or Python is a plus. Experience in manual testing, Automation Testing, test planning, test case creation, execution, and defect management Good communication and critical thinking Experience with testing...
-
Etl QA
5 days ago
Chennai, Tamil Nadu, India Virtusa Full timeETL Tester P1 C1 TSTS Testing Engineer (ETL Tester) - 5-7 years Primary Skills (Must have) ETL Testing Understanding of data model, ETL architecture. Excellent in Data Warehouse concepts. Excellent in writing complex SQL queries with performance tuned to be run in a tool. Should be proficient in Manual testing fundamentals. Knowledge of Automation...
-
Etl Testing with Pyspark
4 days ago
Chennai, Tamil Nadu, India Virtusa Full timeThe 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 discrepanciesThe ETL Tester will also develop automated testing frameworks...
-
Etl QA
2 weeks ago
Chennai, Tamil Nadu, India Virtusa Full time5+ years relevant work experience as ETL Tester Extensively used ETL methodology for testing and supporting data extraction, transformation and loading processing Experience writing SQL queries for extracting data from multiple tables Understanding of ETL requirements (source-to-target mappings) Knowledge of the Python tool Financial domain...
-
Etl Sas
2 days ago
Chennai, Tamil Nadu, India Virtusa Full timeQA Position 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...