Project Description:
Our client is an EU subsidiary of a Global Financial Bank working in multiple markets and asset classes.
DWH / ETL Tester will work closely with the Development Team to design, build interfaces and integrate data from a variety from internal and external data sources into the new Enterprise Data Warehouse environment. The ETL Tester will be primarily responsible for testing Enterprise Data Warehouse using Automation within industry recognized ETL standards, architecture, and best practices.
Responsibilities
- :Perform intake of new ETL Project & initiatives, make the high level assessment in collaboration with the leadership of the roadmap
- .Design Test Strategy and Test Plan to address the needs of Cloud Based ETL Pipelines
- .Contribute and manage Testing Deliverables
- .Ensure the implementation of test standards and best practices for the agile model & contributes to their development
- .Engage with internal stakeholders in various areas of the organization to seek alignment and collaboration. Deals with external stakeholders / Vendors
- .Identify risks / issues and present associated mitigating actions taking into account the critically of the domain of the underlying business
- .Contribute to continuous improvement of testing standard processes
.
Mandatory Skills Descriptio
- n:Expert level knowledge on Data Warehouse, RDBMS concept
- s.Hands on experience in data analysis, understanding of mappings and data lineag
- e.Hands on experience in SSIS and QuerySurg
- e.Experience in new age cloud based Data Warehouse solutions - ADF, SnowFlake, GCP et
- c.Hands-On expertise in writing complex SQL using multiple JOINS and highly complex functions to test various transformations and ETL requirement
- s.Knowledge and Experience on creating Test Automation for Database and ETL Testing Regression Suit
- e.Automation with Python (or JavaScript), Python Scripts, Shell Scrip
- t.Knowledge of framework designing, REST API Testing of databases using Pytho
- n.Experience using Atlassian tool set, Azure DevOp
- s.Experience in Code & Version Management - GIT, Bitbucket, Azure Repos et
- c.A bachelor's degree or equivalent experience in computer science or simila
- r.Experience in crafting test strategies and supervising ETL DWH test activities on multi-platform & sophisticated Cloud based environment
- s.Strong analytical mind-set with the ability to extract relevant information from documentation, system data, clients and colleagues and analyze the captured informatio
- n.ISTQB Foundation Certificate in Software testi
- ngOptional/Preferred - experience in the financial industry, knowledge of Regulatory Reporting and the terms/terminology use
d.
Nice-to-Have Skills Descripti
- on:Experience in the financial industry, knowledge of Regulatory Reporting and the terms/terminology us
ed.
