- Overall accountable and responsible for the delivery of testing services across the Program.
- Manage and oversee the day-to-day delivery of test services by Bank appointed vendors in the conduct of testing
- Works with the testing service providers and other stakeholders to review, provide feedback, and sign off on the test strategy, test plans, and other test service providers’ artifacts for the testing service delivery.
- Lead and manage end-to-end testing efforts for ETL, data warehousing, and big data initiatives.
- Develop and maintain test strategies, test plans, and roadmaps aligning with project goals.
- Validate ETL processes ensuring data is correctly extracted, transformed, and loaded into the data warehouse.
- Develop complex SQL queries to verify data integrity, data migration, and transformation logic.
- Ensure the accuracy of data movement between various systems and adherence to business rules.
- Conduct performance testing for large-scale data migrations and data processing jobs.
- Design and implement test cases for data processing in big data environments like Hadoop, Spark, and similar ecosystems.
- Verify large data sets across distributed systems ensuring data correctness, consistency, and completeness.
- Validate the functionality, performance, and scalability of big data solutions.
- Perform testing on data lakes, data marts, and data pipelines, ensuring data quality and governance.
- Implement test automation frameworks for ETL and big data platforms to enhance testing efficiency.
- Utilize tools like Informatica, Talend, DataStage, and Pentaho for ETL testing.
- Use Apache Hive, Pig, or SparkSQL for validating big data processes.
- Leverage testing tools like Selenium, JMeter, or proprietary solutions for performance and functional testing.
Requirements:
- Minimum of 10 years of experience in IT with 6 – 8 years of experience in test program management.
- Bachelors degree in information technology or relevant education background.
- Expertise in ETL Testing/ Data Warehouse, Data Migration, and Data Base testing.
- Extensive experience in the retail banking industry with domain knowledge of customer servicing, enterprise data, and card platforms.
- Expertise in Payments, Retail Banking, Credit Cards, and Retail Loans domain across technologies like Client Servers, Web-based, and Mainframe.
- Experience implementing Test Automation tools like Selenium Web driver, UFT, API tool, Query Surge (ETL Testing), and Load Runner tools.
- Strong knowledge of ETL tools and frameworks (Informatica, Talend, SSIS).
- Proficiency in SQL and data validation techniques.
- Experience in big data technologies like Hadoop, Spark, Hive, and Kafka.
- Familiarity with data warehousing concepts (Star/Snowflake schema, OLAP, OLTP).
- Knowledge of cloud-based data solutions (AWS, Azure, GCP) is a plus.
- Hands-on experience with tools like QuerySurge, Informatica Data Validation, Apache JMeter, or other data testing automation tools.
