DEVELOPMENT ENGINEERING

HSBC; Ciudad de México; Presencial; MXN 800,000 - 1,100,000; Jornada completa

Descripción de la vacante

A leading global bank seeks an experienced Senior ETL Developer to design robust ETL processes utilizing IBM DataStage and Oracle technologies. This role demands strong experience in data integration and ensures compliance with regulatory standards while collaborating with multidisciplinary teams. Ideal candidates will have over 5 years in ETL development and a focus on data quality assurance. The role offers competitive pay and leave packages according to industry standards.

Servicios

Flexible working hours

Generous leave policy

Professional development opportunities

Formación

• Minimum 5 years experience in ETL process development.
• Robust knowledge of Oracle and ETL tools.
• Ability to document and manage processes.

Responsabilidades

• Design, develop and maintain robust ETL processes.
• Ensure compliance with internal and external regulations.
• Collaborate with multidisciplinary teams to align goals.

Conocimientos

ETL process development

Oracle databases

Data integration

Data quality assurance

Documentation skill

Team collaboration

Educación

Certifications in DataStage, Oracle

Herramientas

IBM DataStage

Oracle

Descripción del empleo

If you’re looking for a career where you can make a real impression, join Global Service Center (GSC) HSBC and discover how valued you’ll be. 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 DEVELOPMENT ENGINEERING.

Role Purpose

This role is responsible for design, develop, and optimize robust ETL processes using IBM DataStage and Oracle technologies to support the organization’s data integration, transformation, and reporting needs. The Senior Developer will ensure the reliability, performance, and scalability of data pipelines, contribute to solution architecture, and provide technical leadership and best practices to the team. This role is critical for enabling accurate, timely, and secure data flows across core business and regulatory processes.

Main Activities

This role will carry out some or all the following activities:

• ETL Solution Delivery: Target: Meet 100% of ETL solution deliveries according to project schedule. Measure: Percentage of deliverables completed on time and in compliance with requirements.
• Technical Decision-Making: Target: Propose and document at least 2 technical improvements per semester. Measure: Number of proposals implemented and their impact on operational efficiency.
• Stakeholder Satisfaction: Target: ≥ 90% satisfaction in user surveys and related areas. Measure: Satisfaction survey results and feedback received.
• Knowledge Sharing: Target: Perform at least 1 knowledge transfer session per month. Measure: Number of sessions performed and team participation.
• Data Quality & Compliance: Target: ≤ 0.5% of data quality errors in ETL processes. Measure: Number of quality incidents and compliance with internal controls.
• Incident Response: Target: Resolve 95% of critical incidents in less than 24 hours. Measure: Average resolution time and number of incidents outside SLA.
• Process Documentation: Target: 100% of critical ETL processes documented and updated quarterly. Measure: Percentage of documentation reviewed and audited.

Qualifications Required

• Minimum experience of 5 years in ETL process development, preferably using IBM DataStage.
• Robust knowledge of Oracle databases, including modeling, query optimisation, and basic management.
• Proven experience in data integration, handling large volumes of information and data quality assurance.
• Knowledge of security policies, regulatory compliance and best practices in data management.
• Ability to document technical and functional processes.
• Experience working in multidisciplinary teams and collaborating with business and technology areas.
• Desirable: Certifications in DataStage, Oracle or data management; experience in regulated environments (financial, banking, etc.).

Mandatory

• Performance Optimization: Ensure ETL processes are efficient and scalable, minimising load times and resource use.
• Incident and error management: Quickly solve problems in ETL processes to avoid impacts on the operation and financial report.
• Regulatory and security compliance: Ensure that processes comply with internal and external regulations, maintaining the confidentiality and integrity of data.
• Technology update: Adapt to new versions of DataStage, Oracle and other tools, managing migration and training.
• Collaboration with multidisciplinary teams: Effectively coordinate with business areas, infrastructure and support to align goals and priorities.

Responsibilities

• The Senior ETL DataStage & Oracle Developer operates in a highly regulated, data‑driven environment where the accuracy, integrity, and availability of financial and regulatory information is critical to the business. This role is responsible for designing, developing and maintaining robust ETL processes that support the organization’s core systems, working with large volumes of data and multiple sources.
• The position requires constant interaction with business teams, analysts, data architects and infrastructure areas, ensuring that the implemented solutions meet quality, security and regulatory compliance standards. In addition, the role demands the ability to adapt to technological and regulatory changes, as well as to lead continuous improvement and process optimisation initiatives in a dynamic and high-demand environment.
• The role is responsible for ensuring that all ETL development and data management activities strictly adhere to the organization’s internal controls, compliance policies, and Financial Information Management (FIM) requirements. This includes maintaining accurate and up-to-date documentation, following established change management procedures, and ensuring data privacy and security standards are met. The role must proactively identify and report any control weaknesses or compliance breaches.
• Data Volume: Responsible for ETL processes that handle large volumes of financial and regulatory data, processing millions of records daily.
• Critical Systems: Support and development for applications that directly impact the organization’s financial and regulatory reporting.
• Budget Responsibility: Participation in the estimation and control of budgets for data integration projects and technological improvements, with influence on investment decisions in infrastructure and licensing.
• Transaction Size: Processing of transactions and data movements that may affect key balance sheet figures and regulatory reports.
• Compliance Impact: Ensures compliance with internal and external regulations, directly impacting the integrity and reliability of information reported to regulatory entities.
• Stakeholder Reach: Interaction with multiple business, IT and audit areas, influencing critical processes and strategic decision making related to data management.

Language Level

• English level – Advanced English Proficiency C1.

Due to the urgent hiring need, candidates with immediate right to work locally and no relocation need will be prioritised.

At HSBC we offer our colleagues a greater number of leave days so that they can fully enjoy their wedding, take care of the new member of the family, or grieve the loss of a family member. Our paid leave package is at the forefront in Mexico, now you have one more reason to be HSBC and proudly live a culture of well‑being, balance, and care.

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 Electronic Data Process Mexico Private LTD***