Senior Test Analyst
We are seeking an experienced Senior Test Analyst to lead testing efforts for complex ETL and data warehouse projects in the banking and financial services domain.
The candidate will be responsible for validating data accuracy, integrity, and performance across multiple data layers and ensuring compliance with banking regulations.
Key Responsibilities :
- Analyze ETL design documents, source-to-target mappings, and business rules to develop comprehensive test coverage.
- Develop and execute detailed test strategies, test cases, and scripts to validate end-to-end data flows across staging, bronze, silver, and gold data layers.
- Perform rigorous data validation and reconciliation between source systems and target databases using Teradata SQL, Hive, or Impala.
- Validate Informatica PowerCenter workflows, sessions, and mappings for logic correctness, data accuracy, and performance efficiency.
- Conduct integration, regression, and UAT testing in collaboration with business teams and development partners.
- Utilize synthetic and masked data for functional and performance testing in line with banking security and compliance policies.
- Track and report defects, manage resolution processes, and provide daily and sprint-level status updates.
- Ensure traceability of test scenarios to business requirements, emphasizing regulatory compliance and financial data accuracy.
Qualifications :
Experience : 9 to 11 years in ETL / data warehouse testing, preferably within banking or financial services.Expertise in Informatica PowerCenter and Teradata for handling large data volumes and complex transformations.Hands-on experience with Big Data technologies such as Cloudera / Hadoop, Hive, HDFS, and Impala.Strong skills in writing complex SQL queries for data validation and reconciliation.Solid understanding of data quality principles, metadata management, and data lineage validation.Familiarity with Agile methodologies and experience using tools like JIRA for sprint-based testing.Experience in test data creation, data masking, and use of synthetic data aligned with regulatory compliance requirements.Preferred Skills :
Strong knowledge of banking data systems, including customer, transaction, risk, and regulatory reporting domains.Experience with Cognos or Power BI for validating report outputs against data models.Excellent analytical skills and attention to detail.Ability to work effectively with distributed, cross-functional teams.Exposure to test automation or scripting frameworks for large-scale data validation is a plusref : hirist.tech)