Job Description:
ETL Automation Develop and maintain automated test scripts Python SQL to validate Informatica or similar ETL workflows ensuring data integrity.
Payments Validation Validate complex financial transactions and payment data movements between source systems and data warehouses Data Quality Assurance Test rules implemented during ETL data movement to ensure accurate extraction transformation and loading ETL.
Automation Frameworks Build and maintain testing frameworks to streamline the testing of data pipelines.
CICD Integration Integrate automation scripts with CICD tools like Jenkins Bitbucket or Git to ensure automated testing within Agile development pipelines.
Data Warehouse Validation Validate Data Warehouse DWH table structures and troubleshoot data storage systems.
Experience 3 years of experience in automation testing specifically focusing on ETL testing or data pipeline verification preferably in fintech payments.
SQL Mastery Strong expertise in writing complex SQL queries for data analysis validation and performance tuning.
Scripting Proficiency in scripting languages such as Python or Java.
ETL Tools Experience with ETL testing tools eg Informatica Talend Apache Airflow.
Database Knowledge Experience with relational databases Oracle PostgreSQL MySQL.
Agile Methodology Experience working in an Agile development environment.
Problem Solving Strong analytical skills to diagnose data inconsistencies and payment bottlenecks.
Skills
Mandatory Skills : ETL / Datawarehouse testing, Payments (SWIFT, ISO20022, Real-Time, Instant, Request to Pay, Domestic, Cross-Border, High Value, Low Value and Mass Payments), Selenium Testing Automation