Erudite Innovation Hiring! Full Time ETL Tester - Banking in Selangor, Earn up to MYR 9,088.73 - Ricebowl

Job Summary

Responsible for validating the Extract, Transform and Load (ETL) processes used to move and transform banking data between source systems, data warehouses, data lakes and downstream applications. The role ensures data is complete, accurate, consistent, secure and correctly transformed according to business requirements.

Key Responsibilities

• Analyse business and technical requirements for ETL and data integration projects.
• Develop ETL test strategies, test plans, test scenarios and test cases.
• Validate data extraction from multiple banking source systems.
• Verify transformation rules, calculations, mappings and business logic.
• Validate data loading into:
• Data Warehouse
• Data Mart
• Data Lake
• Reporting platforms
• Regulatory systems
• Downstream banking applications
• Perform Source-to-Target (S2T) data validation.
• Validate data completeness, accuracy, consistency and integrity.
• Perform data reconciliation between source and target systems.
• Validate record counts, totals, balances and control totals.
• Execute database queries to verify transformed and loaded data.
• Perform data migration and reconciliation testing.
• Validate incremental and full data loads.
• Test ETL batch processing and scheduled jobs.
• Validate error handling, rejected records and exception processes.
• Perform regression testing following ETL code or mapping changes.
• Identify, document and track data defects.
• Participate in defect triage with Developers, Data Engineers, Business Analysts and Project Managers.
• Perform defect retesting and validate fixes.
• Prepare test execution reports and data quality reports.
• Support SIT, UAT and production validation.
• Validate data following production migration and deployment.
• Ensure ETL processes meet banking data governance, security, audit and regulatory requirements.

Banking Data Experience

Experience working with data from:

• Core Banking
• Customer / CIF systems
• Account and deposit systems
• Loans / financing
• Credit cards
• Debit cards
• Payments
• Transaction processing
• AML / KYC
• Fraud management
• Treasury
• Regulatory reporting
• Risk management
• Digital banking
• Customer analytics
• Finance / GL
• Data warehouse / data lake

Technical Skills

Database / SQL

• Strong SQL
• Oracle
• SQL Server
• DB2
• PostgreSQL
• Teradata

ETL Tools

• Informatica
• IBM DataStage
• Talend
• SSIS
• Ab Initio
• Pentaho

Big Data / Cloud – beneficial

• Hadoop
• Spark
• Databricks
• AWS
• Azure
• Snowflake

Testing / Data Tools

• SQL Developer
• DBeaver
• Excel
• Jira
• ALM / Quality Center
• Azure DevOps

Key Testing Activities

A strong ETL Tester should be able to perform:

Source → ETL Transformation → Target

• Source data validation
• Data mapping validation
• Transformation validation
• Business rule validation
• Target data validation
• Record count reconciliation
• Duplicate checking
• Null / mandatory field validation
• Data type validation
• Data format validation
• Aggregation and calculation validation
• Referential integrity testing
• Historical data validation
• Incremental load testing
• Batch processing validation
• Data reconciliation

Required Skills & Experience

• Bachelor's Degree in Computer Science, Information Technology, Data Engineering or related field.
• 3–8+ years of experience in ETL Testing / Data Testing / Data Warehouse Testing.
• Strong hands-on SQL skills.
• Experience with at least one ETL tool such as Informatica, DataStage, Talend or SSIS.
• Strong understanding of data warehouse concepts.
• Experience with Source-to-Target mapping and data reconciliation.
• Good understanding of SDLC and STLC.
• Experience in SIT, regression and UAT.
• Banking or financial-services experience is highly preferred.
• Strong analytical and problem-solving skills.
• Good communication and defect management skills.

Preferred Certifications

• ISTQB Foundation
• ISTQB Advanced Test Analyst
• Data Testing / Data Quality certification
• ETL / Informatica certification
• Cloud certification
• Agile / Scrum certification

Key Deliverables

• ETL Test Strategy
• ETL Test Plan
• Test Scenarios
• Test Cases
• Source-to-Target Mapping Validation
• SQL Validation Scripts
• Data Reconciliation Reports
• Test Execution Reports
• Defect Reports
• Data Quality Reports
• Regression Test Results
• ETL Test Summary Report

Pay: RM5,393.60 - RM9,088.73 per month

Benefits:

• Health insurance
• Maternity leave
• Opportunities for promotion
• Professional development

Work Location: In person