ETL,Oracle,PL/SQL,Control M,Shell Scripting/Senior Software Engineer/Pune/Enterprise Technology[...]

HSBC Group; Boveney; On-site; GBP 44,000; Full time

Job summary

A leading international financial services firm in the UK is seeking a candidate responsible for system design and development. The ideal applicant has hands-on experience in data warehousing and ETL processes, with expertise in technologies like Oracle and PL/SQL. Expect to engage in on-call support and work shifts. Competitive compensation around £43,249 yearly is offered.

Qualifications

• Hands-on experience in working on data warehousing or reporting systems.
• Good debugging skills.
• Ability to translate business level requirements to system level components.
• Ability to review deliverables from other team members.
• Good knowledge on incident management and ability to lead during incident calls.

Responsibilities

• Undertake activities on system level design and development.
• Perform impact assessments, tuning, testing, and deployments.
• Liaise with engineers and stakeholders on product direction.
• Create robust technical design for new components.
• Establish a digital environment to automate processes.
• Ensure service resilience and sustainability.
• Support on-call and work in shifts.

Skills

Data warehousing experience

ETL process implementation

Oracle

PL/SQL

Control M

Shell Scripting

Job description

Responsibilities

• The role is responsible to undertake activities on system level design and development (CTB) of the code, testing and deployment as well as support the production processing (RTB).
• Be involved in actual implementation of solutions, performing impact assessments, performance tuning, testing and deployments throughout the delivery cycle. Utilize the technical skills and expertise to carry out software development, testing and operational support activities with the ability to move between these from time to time according to demand.
• Liaise with other engineers, architects, and business stakeholders to understand and drive the product or service's direction.
• Create robust technical design and a strategy for development of new components to meet requirements. Write test cases, scenarios, test plans including unit and integration tests, within automated test environments to ensure code quality aspect.
• Establish a digital environment and automate processes to minimize variation and ensure predictable high-quality code and data. Apply innovation and creativity to automate manual tasks.
• Working with Ops, Dev and Test Engineers to ensure operational issues (performance, operator intervention, alerting, design defect related issues, etc.) are identified and addressed at all stages of a product or service release / change.
• Ensure the service resilience, service sustainability and recovery time objectives are met for all the software solutions delivered. Actively participate in and drive the mandatory exercises from time to time on resilience, recovery and service management. Support on-call and work in Shifts as per the agreed plans when required.
• Keep up to date and have expertise on current tools, technologies and areas like cyber security and regulations pertaining to aspects like data privacy, consent, data residency etc. that are applicable.

Requirements

• Having past hands‑on experience in working on data warehousing or reporting systems
• Experience in implementing ETL processes and good debugging skills
• Preferred technology skills - Oracle, PL/SQL, Control M, Shell Scripting
• Ability to translate business level requirements to system level components or blocks. Ability to do coding, testing and deliver quality product to the stakeholders (internal and external)
• Ability to review the deliverables from other team members
• Ability to understand the vulnerabilities and subsequent patching for infrastructure
• Role demands working in shifts and provide On‑Call support to production system.
• Good knowledge on incident management and ability to lead the team from the front during incident/crisis calls

About HSBC

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.

Compensation

£43,249 per year - estimated.

Position Status

Full time CLOSING SOON