ETL Test Lead

Job description

ETL Tester:

As an ETL Test Engineer, you will be responsible for both manual and automated testing to validate data sources, extract data, apply transformation logic, and load data into target tables. You'll work closely with data engineering teams to ensure a sustainable testing approach. Key responsibilities include:


Testing data validation scenarios, data ingestion, pipelines, and transformation processes.


Using automated testing tools and understanding information governance principles in a testing capacity.


Automating tests across multiple platforms and technologies throughout the development lifecycle.


Managing test cases and handling issue and defect management.


Testing systems that capture, verify, and maintain field-generated metadata.


Familiarity with various back-end and front-end languages, libraries, databases, web servers, web services, APIs, and UI/UX design.


Knowledge of modern testing development practices and integrated testing products integration with tools such as GitLab.


Experience with Agile Software Development & Testing methods for cloud deployments.


Must have - Skills required for this role:


1. Insurance domain knowledge is Most


2. Main Frame Background (extracting files from MF and comparing in Db2)


3. Python [Most] ,


4. DB2, Aurora SQL, MySQL, PostgreSQL, Databricks, Snowflake


5. Power BI/SSRS/SSIS for report testing


6. Messaging events (SNS/SQS/Kafka)


7. Informatica tool for ETL


8. AWS Cloud S3

Skills

API/Microservices RestAssured Testing, Azure Cloud data Testing, BI Reports / Data Visualization Testing, Cloud migration and Platform modernization Testing, Python Data Automation Testing, Tosca Data Integrity (DI) Testing