ETL TESTING

Skill-ETL TESTING
Experaince-5 Years
Location-Pune

Detailed JD-

Technical Skills
• SQL & Database Expertise: Ability to write complex queries for data validation and reconciliation between source and target systems.
• ETL Testing: Understanding of Extract, Transform, Load (ETL) processes to verify data movement and accuracy.
• Data Mapping & Transformation: Experience in analyzing and mapping data from legacy systems to new banking platforms.
• Automation Testing: Knowledge of automation tools to streamline database migration validation.
• API & Interface Testing: Ensuring data integrity when interacting with banking applications and external APIs.
Domain & Business Knowledge
• Banking & Financial Regulations
• Core Banking System Understanding
• Transaction Processing & Security
Quality Assurance & Risk Assessment
• Data Integrity & Accuracy Checks: Ability to validate migrated financial data without discrepancies.
Communication & Reporting
• Stakeholder Collaboration: Effective communication with business analysts, developers, and compliance teams.
• Defect Reporting & Documentation: Clear logging of issues and maintaining audit trails for validation.

Below are Expected Tools:
Database & Query Tools:
• SQL Server Management Studio (SSMS) – Essential for querying and validating data in SQL databases.
• Oracle SQL Developer – Useful for Oracle database migrations.
• Toad for Oracle/SQL Server – Helps with database administration and testing.
ETL & Data Integration Tools
• Informatica PowerCenter – Widely used for ETL operations in banking.
Data Profiling & Validation Tools
• DataStage – IBM's ETL tool for handling complex migrations.
• QuerySurge – Designed for automating data validation in migrations.
• WinSQL – Helps in querying and comparing large datasets.
Automation & Testing Frameworks
IDWT or relevant tools for ETL automation
ETL TEST LEAD