ETL Tester (Enterprise Datawarehouse)

Job 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. Skills Expert level knowledge on Data Warehouse, RDBMS concepts. Expertise on new age cloud-based Data Warehouse solutions ADF, SnowFlake, GCP etc. Hands-On expertise in writing complex SQL using multiple JOINS and highly complex functions to test various transformations and ETL requirements. Knowledge and Experience on creating Test Automation for Database and ETL Testing Regression Suite. Automation using Selenium with Python (or Java Script), Python Scripts, Shell Script. Knowledge of framework designing, REST API Testing of databases using Python. Experience using Atlassian tool set, Azure DevOps. Experience in Code & Version Management GIT, Bitbucket, Azure Repos etc. Qualifications A bachelor's degree or equivalent experience in computer science or similar. Experience in crafting test strategies and supervising ETL DWH test activities on multi-platform & sophisticated Cloud based environments. Strong analytical mind-set with the ability to extract relevant information from documentation, system data, clients and colleagues and analyze the captured information. ISTQB Foundation Certificate in Software testing Optional/Preferred experience in the financial industry, knowledge of Regulatory Reporting and the terms/terminology used. Important to Have Proficiency in English read/write/speak. Able to demonstrate your ability to learn new technologies. Able to easily adapt to new circumstances / technologies / procedures. Stress resistant and constructive whatever the context. Able to align with existing standards and acting with attention to detail A true standout colleague who demonstrates good interpersonal skills. Able to summarize complex technical situations in simple terms. Solution and customer focused. Good communication skills, a positive attitude, and a competitive, but team-oriented focus are key elements to be successful in this challenging environment. Nice to have Experience in the financial industry, knowledge of Regulatory Reporting and the terms/terminology used.