ETL, IBM, Oracle / 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 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

In this role, you will

Design, develop, test, and support ETL solutions using IBM DataStage to meet business and technical requirements.

Build and maintain scalable data pipelines to extract, transform, and load data from multiple source systems into target repositories, data warehouses, and reporting platforms.

Work closely with business and technical stakeholders to understand data requirements and translate them into effective ETL designs and mappings.

Develop and optimize DataStage jobs, parallel jobs, sequences, and parameterized workflows for reliability, maintainability, and performance. Ensure the quality, consistency, and integrity of data through validation, reconciliation, and exception handling processes.

Support data architecture and engineering initiatives to improve storage, accessibility, and consumption of data across the bank.

Collaborate with Data Architects, Analysts, QA teams, and support teams to implement data solutions aligned to enterprise standards and controls.

Monitor ETL job performance, troubleshoot production issues, and implement corrective actions for operational stability.

Participate in Agile / DevOps delivery processes, including sprint planning, backlog refinement, release activities, and production support.

Contribute to engineering best practices, standards, and reusable patterns within the data engineering domain. Ensure compliance with internal controls, data governance policies, security standards, and relevant regulatory requirements.

Support service resilience, recovery objectives, and high availability of ETL services in line with business continuity expectations. Stay current with emerging ETL/data engineering tools, technologies, and industry practices relevant to enterprise data platforms.

To be successful, you will

Minimum 9 to 10 years of hands-on experience in software development and/or ETL engineering. Strong experience in IBM DataStage development, including job design, transformations, sequences, job monitoring, and performance tuning.

Solid understanding of ETL principles, data warehousing concepts, and enterprise data integration patterns. Experience working in a global, corporate environment with cross-functional and cross-region teams. Strong SQL skills and experience with relational databases such as Oracle, SQL Server, DB2, or PostgreSQL.

Exposure to data modeling, metadata management, and data quality frameworks. Good understanding of Agile / DevOps practices and use of Jira for delivery tracking. Experience with UNIX/Linux shell scripting and operational support for ETL jobs. Knowledge of scheduling, job orchestration, exception handling, and production support workflows

Exposure to cloud platforms such as GCP, AWS, or Azure is desirable. Experience with tools such as Docker, Kubernetes, Redis, PostgreSQL, and CI/CD tools is beneficial. Ability to work with large volumes of data and optimize ETL processing for performance and scalability.

Understanding of data security, privacy, and governance controls relevant to financial services is an advantage. Communicate openly and honestly with stakeholders at all levels.

Excellent oral, written, and visual communication skills in English. Ability to present technical solutions clearly to management and global teams. Strong attention to detail with a process-driven, methodical approach.

Ability to work effectively under pressure and manage changing priorities. Self-starter with initiative and ownership mindset.

Positive, energetic, and collaborative team player. Strong commitment to delivering high-quality solutions within tight deadlines. Ability to support and drive continuous improvement across ETL engineering practices.

You’ll achieve more when you join HSBC.

www.hsbc.com/careers

HSBC is an equal opportunity employer 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. We encourage applications from all suitably qualified persons irrespective of, but not limited to, their gender or genetic information, sexual orientation, ethnicity, religion, social status, medical care leave requirements, political affiliation, people with disabilities, color, national origin, veteran status, etc., We consider all applications based on merit and suitability to the role.”

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