- Design, develop, and execute ETL test strategies for large-scale financial crime detection systems.
- Validate data pipelines, transformations, and integrations across multiple source systems.
- Perform root cause analysis of data discrepancies and ensure data integrity.
- Collaborate with business analysts, developers, and compliance teams to align testing with regulatory requirements.
- Document test cases, results, and defect reports with precision.
- Support performance testing and optimization of ETL workflows.
Required Skills
- Solid expertise in ETL Testing methodologies and tools.
- Hands-on experience with SQL (complex queries, joins, stored procedures, performance tuning).
- Domain knowledge in Financial Crime / AML / Fraud Detection.
- Experience with data warehousing concepts, data validation, and reconciliation.
- Familiarity with BI tools and reporting validation.
- Excellent analytical and problem-solving skills.
Qualifications
- Bachelor's or Master's degree in Computer Science, Information Technology, or related field.
- Proven track record in ETL testing within BFSI or financial crime compliance projects.
Nice to Have
- Exposure to big data platforms (Hadoop, Spark).
- Knowledge of regulatory frameworks (AML, KYC, FATCA).
- Experience with automation in ETL testing.