Tester - Data Warehouse for Reg Reporting

7 Hours ago • 5 Years +

Job Summary

Job Description

The job involves testing the bank's data warehouse system, changes, and user stories. The responsibilities include writing and executing test cases, building test automation, and supporting IT integration and UAT. The role requires validating regulatory reports, contributing to process improvement, and working in a cross-functional team. The candidate will be responsible for ensuring the implementation of test standards and best practices for the agile model. The role also includes identifying risks and issues and presenting mitigating actions.
Must have:
  • Tester and Test Automation experience in Data Warehouse.
  • At least 5 years testing with Data Warehouse & RDBMS knowledge.
  • Strong SQL scripting knowledge with ETL and Databases experience.
  • Expertise on new cloud-based Data Warehouse solutions.
  • Hands-on expertise in complex SQL for transformations and ETL.
  • Knowledge of test automation for Database and ETL Testing.
  • Automation using Selenium with Python (or Java Script).
  • Knowledge of framework designing and REST API Testing using Python.
  • Experience using Atlassian tool set, Azure DevOps and code & Version Management.
  • GIT, Bitbucket, Azure Repos experience.
  • Help and provide inputs for Test Plan for Cloud Based ETL Pipelines.
  • Able to work in an agile environment.
  • Experience in working in high priority projects.
  • Some flexibility outside 9-5 working hours.
  • Able to work in demanding environment.
  • Able to work independently and collaborate.
  • Highly developed problem-solving skills with minimal supervision.
  • Able to adapt to new circumstances/technologies/procedures.
  • Stress resistant and constructive.
  • Able to align with existing standards and with attention to detail.
Good to have:
  • Experience of financial regulatory reports.
  • Experience in test automation for data warehouse.
  • Bitbucket.
  • Bamboo.
  • Azure Tech Stack.
  • Azure Data Factory.
  • WKFS OneSumX reporting generator.
  • Analytics tool such as Power BI / Excel / SSRS / SSAS, WinSCP.

Job Details

Project description

Our client is an EU subsidiary of a Global Financial Bank working in multiple markets and asset classes.

The Bank's Data Store has been transformed to a Data warehouse (DWH) which is the central source for Regulatory Reporting. It is also intended to be the core data integration platform which not only provide date for regulatory reporting but also provide data for Risk Modelling, Portfolio Analysis, Ad Hoc Analysis & Reporting (Finance, Risk, other), MI Reporting, Data Quality Management, etc.

Due to high demand of regulatory requirements, a lot of regulatory projects are in progress to reflect regulatory requirements on existing regulatory reports and to develop new regulatory reports on MDS. Examples are IFRS9, AnaCredit, IRBB, the new Deposit Guarantee Directive (DGSD), Bank Data Retrieval Portal (BDRP) and the Fundamental Review of the Trading Book (FRTB).

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
bullet icon

Testing the Bank's data warehouse system changes, testing the changes (user stories), support IT integration testing in TST and support business stakeholders with User Acceptance Testing. It is hands-on position: you will be required to write and execute test cases, build test automation where it is applicable.

bullet icon

Overall Purpose of Job

bullet icon

Test the MDS data warehouse system

bullet icon

Validate regulatory reports

bullet icon

Supporting IT and Business stakeholders during UAT phase

bullet icon

Contribute to improvement of testing and development processes

bullet icon

Work as part of a cross-functional team and take ownership of tasks

bullet icon

Contribute in Testing Deliverables.

bullet icon

Ensure the implementation of test standards and best practices for the agile model & contributes to their development.

bullet icon

Engage with internal stakeholders in various areas of the organization to seek alignment and collaboration.

bullet icon

Deals with external stakeholders / Vendors.

bullet icon

Identify risks / issues and present associated mitigating actions taking into account the critically of the domain of the underlying business.

bullet icon

Contribute to continuous improvement of testing standard processes.

bullet icon

Additional responsibilities include work closely with the systems analysts and the application developers, utilize functional design documentation and technical specifications to facilitate the creation and execution of manual and automated test scripts, perform data analysis and creation of test data, track and help resolve defects and ensure that all testing is conducted and documented in adherence with the bank's standard.

Skills

Must have

bullet icon

Must have experience/expertise : Tester, Test Automation, Data Warehouse, Banking Technical:

bullet icon

At least 5 years of testing experience of which at least 2 years in the finance industry with good level knowledge on Data Warehouse, RDBMS concepts.

bullet icon

Strong SQL scripting knowledge and hands-on experience and experience with ETL & Databases.

bullet icon

Expertise on new age cloud based Data Warehouse solutions

bullet icon

ADF, SnowFlake, GCP etc.

bullet icon

Hands-On expertise in writing complex SQL using multiple JOINS and highly complex functions to test various transformations and ETL requirements.

bullet icon

Knowledge and Experience on creating Test Automation for Database and ETL Testing Regression Suite.

bullet icon

Automation using Selenium with Python (or Java Script), Python Scripts, Shell Script.

bullet icon

Knowledge of framework designing, REST API Testing of databases using Python.

bullet icon

Experience using Atlassian tool set, Azure DevOps and code & Version Management

bullet icon

GIT, Bitbucket, Azure Repos etc.

bullet icon

Help and provide inputs for the creation of Test Plan to address the needs of Cloud Based ETL Pipelines. Non-Technical:

bullet icon

Able to work in an agile environment

bullet icon

Experience in working in high priority projects (high pressure on delivery)

bullet icon

Some flexibility outside 9-5 working hours (Netherlands Time zone)

bullet icon

Able to work in demanding environment and have pragmatic approach with "can do" attitude.

bullet icon

Able to work independently and also to collaborate across the organization

bullet icon

Highly developed problem-solving skills with minimal supervision

bullet icon

Able to easily adapt to new circumstances / technologies / procedures.

bullet icon

Stress resistant and constructive

bullet icon

whatever the context.

bullet icon

Able to align with existing standards and acting with attention to detail.

Nice to have

bullet icon

Experience of financial regulatory reports

bullet icon

Experience in test automation for data warehouse (using bamboo) Software skills:

bullet icon

Bitbucket

bullet icon

Bamboo

bullet icon

Azure Tech Stack

bullet icon

Azure Data Factory

bullet icon

WKFS OneSumX reporting generator

bullet icon

Analytics tool such as Power BI / Excel / SSRS / SSAS, WinSCP

Other
seniority icon

Languages

English: B2 Upper Intermediate

seniority icon

Seniority

Regular

Similar Jobs

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

Similar Skill Jobs

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

Jobs in Pune, Maharashtra, India

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

Similar Category Jobs

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

About The Company

Empower your future with Luxoft: Innovate, thrive and grow in a software-defined world.Luxoft works with companies from all over the globe and offers opportunities for candidates anywhere in the world.

Pune, Maharashtra, India (On-Site)

New York, New York, United States (On-Site)

Gurugram, India (On-Site)

(Remote)

Zürich, Zurich, Switzerland (On-Site)

Hyderabad, Telangana, India (On-Site)

View All Jobs

Get notified when new jobs are added by luxsoft

Level Up Your Career in Game Development!

Transform Your Passion into Profession with Our Comprehensive Courses for Aspiring Game Developers.

Job Common Plug