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 recent 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 Description:
• Expert level knowledge on Data Warehouse, RDBMS concepts.
• Hands on experience in data analysis, understanding of mappings and data lineage.
• Hands on experience in SSIS and QuerySurge.
• Experience in 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 with Python (or Java Script), Python Scripts, Shell Script.
• Knowledge of framework designing, REST API Testing of databases usi
📌 Senior ETL Tester (India)
🏢 Luxoft
📍 India