Data Test Engineer/ Consultant Specialist

Some careers shine brighter than others.

If you’re looking for a career that will help you stand out, join HSBC, and fulfil your potential. Whether you want a career that could take you to the top, or simply take you in an exciting new direction, HSBC offers opportunities, support and rewards that will take you further.

HSBC is one of the largest banking and financial services organizations in the world, with operations in 64 countries and territories. We aim to be where the growth is, enabling businesses to thrive and economies to prosper, and, ultimately, helping people to fulfil their hopes and realize their ambitions.

We are currently seeking an experienced professional to join our team in the role of consultant specialist 

In this role you will:

• We are currently seeking an experienced Data Test Engineer. You will be a key contributor embedded with in an Agile cross functional team, which driving innovation, delivering HSBC products and utilizes maximum automation.
• As a Data Test Engineer, you will be responsible for validating data sources, extracting data applications of transformation logic and uploading data in target tables. You will be responsible for designing, testing, and troubleshooting the client’s data storage system before it goes live. You must have strong technical capabilities and good knowledge of the coding languages commonly used in ETL development, such as Python, SQL and XML and Data Concepts.
• Experience in writing complex SQL queries, Experience in writing complex SQL queries, ability to determine the types of testing that must be conducted (i.e., data validation, regression, etc.)
• Should have experience testing multiple test phases in medium to large projects.
• Understanding of information governance principles and how they could apply in a testing capacity
• Should have adequate experience and clear understanding of data warehouse and data mart testing
• Identification and Test Data Preparation Techniques.
• Ability to transform complex Business logic into SQL or PL/SQL queries 
• Ability to run, read from, debug batch process
• Thorough knowledge of Software Test Life Cycle, Test Case Life Cycle, Defect Life Cycle
• Proficiency with Test Case Preparation and Execution
• QA Automation Test tools
• Knowledge of data models and entity relationship diagrams.
• Must have the ability to multi-task and adapt quickly to changes while maintaining urgency in completing assigned tasks.
• Good communication skills with a confident personality so that can gather requirement from onsite team as well as demonstrate the output to other members of the team.