Manager | Data Migration

Key Responsibilities:

1. Test Strategy and Planning:
2. Develop and document comprehensive testing strategies, plans, and scripts for ETL processes and data migrations, ensuring all data quality requirements are met.
3. Test Case Development and Execution:
4. Design and develop detailed test cases to validate data transformation accuracy, data integrity, and data consistency during ETL and data migration activities.
5. Data Validation and Verification:
6. Perform manual and automated testing to validate the accuracy, completeness, and consistency of data during ETL and data migration processes, identifying any data discrepancies or anomalies.
7. Data Migration Testing:
8. Lead testing efforts for data migration projects, ensuring seamless transitions with minimal disruption to operations and data integrity.
9. Collaboration and Communication:
10. Collaborate with cross-functional teams, including data engineers, business analysts, and developers, to ensure alignment on testing requirements and data quality standards.
11. Defect Management and Reporting:
12. Track, manage, and report on defects and issues identified during testing, providing detailed bug reports and collaborating with development teams to resolve issues.
13. Performance Monitoring and Optimization:
14. Monitor ETL process performance, identify performance bottlenecks, and implement optimization strategies to ensure efficient data processing and migration.
15. Documentation and Training:
16. Maintain detailed documentation of test plans, test cases, and test results, and provide training and guidance to team members on testing methodologies and best practices.
17. Process Improvement:
18. Continuously identify areas for improvement in testing processes, implement best practices, and contribute to the development of efficient and effective QA methodologies.
19. Stakeholder Management:
20. Communicate testing progress, results, and risks to stakeholders, ensuring transparency and alignment with business objectives.

Required Skills and Experience:

1. Extensive experience in ETL testing:
2. Strong understanding of ETL processes, data warehousing concepts, and data modeling techniques.
3. Data migration expertise:
4. Proven experience leading data migration projects and ensuring successful data transitions.
5. Strong SQL proficiency:
6. Ability to write and execute complex SQL queries for data validation and verification.
7. Familiarity with data migration tools:
8. Experience with various data migration tools and platforms used in the banking industry.
9. Experience with test automation tools:
10. Proficiency in using test automation frameworks and tools for automated testing of ETL processes and data migrations.
11. Strong analytical and problem-solving skills:
12. Ability to identify data quality issues, analyze data patterns, and troubleshoot complex problems.
13. Excellent communication and interpersonal skills:
14. Ability to collaborate effectively with cross-functional teams and stakeholders.
15. Understanding of financial regulations and compliance:
16. Familiarity with regulatory requirements and compliance standards in the banking industry.
17. Ability to lead and mentor a team:
18. Proven ability to guide and motivate junior testers.

Educational Background:

1. Bachelors degree in Computer Science, Information Technology, or a related field.

Preferred Qualifications:

1. Experience with cloud-based data migration technologies.
2. Knowledge of big data frameworks and tools.
3. Familiarity with Agile methodologies and tools.