Job description
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 organisations 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 realise their ambitions.
We are currently seeking an experienced professional to join our team in the role of Consultant Specialist
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 processes
Thorough knowledge of Software Test Life Cycle, Test Case Life Cycle, Defect Life Cycle etc.
Proficiency with Test Case Preparation and Execution.
QA Automation Test tools.
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
Should be detail oriented with analytical mindset.
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.
Should be detail oriented with analytical mind set.
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.
Excellent problem solving and analytical skills, able to handle challenging situations and act appropriately.
Should be a self-starter, takes responsibility and ownership and is self-driven.
Ability to work independently with minimal supervision as well as ability to work within a team.
Good team player
Working experience of Agile methodologies
Requirements
MUST have skills
Data Testing
SQL ,GCP , Bigquery and Bigtable
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.
Functional testing
Experienced in data analysis
Python 3.9
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