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.

To be successful in this role you should meet the following requirements:

• Data Testing
• SQL, GCP, Big query and Big table
• Experience in STLC concept, BFSI, data analysis and data generation for various source systems
• ETL Process - Data Migration and data validation.
• Experienced with automated test scripts for testing banking data involving source comparison and data reconciliation using python.
• Extensive exposure to ETL testing with high-level of SQL skills is required.
• Should have exposure to large data sets and understand Data Quality Framework
• Experience in data analysis, including profiling, auditing, balancing, and reconciliation, in an Information technology operating environment.
• Experience in tuning SQL queries, Stored Procedures, Views, etc. for performance improvements
• Functional testing
• Experienced in data analysis
• Hands on experience in Python 3.

You’ll achieve more when you join HSBC.

www.hsbc.com/careers

HSBC is committed to building a culture where all employees are valued, respected and opinions count. We take pride in providing a workplace that fosters continuous professional development, flexible working, and opportunities to grow within an inclusive and diverse environment. Personal data held by the Bank relating to employment applications will be used in accordance with our Privacy Statement, which is available on our website.

Issued by – HSBC Software Development India