Consultant Specialist

Hsbc

8 - 10 years

25 - 30 Lacs

pune

Posted:3 hours ago| Platform:

Apply

Skills Required

data analysis data migration bfsi functional testing agile plsql stored procedures information technology sql python

Work Mode

Work from Office

Job Type

Full Time

Job Description

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

More Jobs at Hsbc

Consultant Specialist

Pune

4 - 9 yrs

INR 22 - 27 Lacs

Consultant Specialist

Pune

7 - 12 yrs

INR 22 - 27 Lacs

Agile, Scrum/Consultant Specialist

Pune

8 - 10 yrs

INR 13 - 14 Lacs

Appian Development/Senior Consultant Specialist

Pune

5 - 10 yrs

INR 8 - 13 Lacs

Senior Audit Manager - DBS Ops (Mumbai and Gurgaon)

Pune

5 - 10 yrs

INR 8 - 12 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.