DEVELOPMENT ENGINEERING ETL

HSBC; Ciudad de México; Presencial; MXN 200,000 - 400,000; Jornada completa

Descripción de la vacante

A major international bank in Mexico is seeking a Senior ETL Developer to design and optimize ETL processes using IBM DataStage and Oracle technologies. The role involves ensuring the reliability and performance of data pipelines, with a focus on compliance and security. Candidates should have extensive experience in ETL development, data integration, and strong knowledge of Oracle. This position offers opportunities for continuous professional development and a supportive work environment.

Servicios

Greater number of leave days

Inclusive workplace culture

Opportunities for professional development

Formación

• Minimum 5 years of ETL process development experience using IBM DataStage.
• Strong knowledge of Oracle databases including query optimization.
• Ability to document technical processes effectively.

Responsabilidades

• Design and develop robust ETL processes for data integration.
• Ensure compliance with internal and external regulations.
• Act as a technical leader, proposing improvements.

Conocimientos

ETL process development

IBM DataStage

Oracle databases

data integration

data quality assurance

regulatory compliance

technical documentation

Educación

Certifications in DataStage, Oracle, or data management

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 designing, developing, and optimizing 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:

• 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. 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 5 years of ETL process development experience, preferably using IBM DataStage.
• Robust knowledge of Oracle databases, including modeling, query optimization, 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, minimizing load times and resource use.
• Incident and Error Management – Quickly solve problems in ETL processes to avoid impacts on operation and financial reporting.
• Regulatory and Security Compliance – Ensure that processes comply with internal and external regulations, maintaining 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.

Additional Responsibilities:

• The Senior ETL DataStage & Oracle Developer operates in a highly regulated, data‑driven environment where accuracy, integrity, and availability of financial and regulatory information are critical.
• Designing, developing and maintaining robust ETL processes that support the organization’s core systems, handling large volumes of data and multiple sources.
• Constant interaction with business teams, analysts, data architects and infrastructure areas to ensure implemented solutions meet quality, security and regulatory compliance standards.
• Adapting to technological and regulatory changes, and leading continuous improvement and process optimization initiatives.
• Managing compliance with internal controls, regulation policies, and Financial Information Management requirements; maintaining documentation, change‑management procedures, and data privacy and security standards.
• Processing large volumes of financial and regulatory data, supporting applications that directly impact financial and regulatory reporting.
• Participating in budgeting for data integration projects and technology improvements, influencing infrastructure and licensing investment decisions.

Language Level: Advanced English Proficiency C1.

Due to the urgent hiring need, candidates with immediate right to work locally and no relocation requirement 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, colour, 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***