GCP, Big query, ETL – Data Warehouse – Production support Engineer/Consultant Specialist

Responsible for overseeing the day-to-day operations and troubleshooting of Extract, Transform, and Load (ETL) processes within a production environment, ensuring data integrity and timely delivery by monitoring jobs. Identifying issues, performing root cause analysis, and coordinating with development teams to resolve critical data pipeline problems. Able to understand \troubleshoot shell scripts , sql (Teradata) for regular maintenance jobs to improve performance and knowledge on Big query and Postgres. Develop and maintain automated scripts to streamline repetitive tasks like data validation, error handling, and job resubmission Analyze ETL job performance metrics to identify bottlenecks and implement optimizations to improve data processing speed and efficiency. Review and refactor existing ETL code for better performance and maintainability. Design and Implement scalable, secure and highly available solutions using GCP services Familiar with GCP services like GCP Bigquery Datawarehouse, GCP Cloud Storage Experience with monitoring tools and performance optimization Assisting team to Monitor system health and performance using metrics and alerts to identify potential issues before they impact users. Collaborate internally with and external sources to maintain SLA and provide escalations. Maintenance of the ETL platform infrastructure (upgrades, patches, health monitoring). Worked on Service Management Tools to track all the incidents, problems and changes and to plan the production changes as per the change management policies. Troubleshooting ETL jobs and follow escalation procedures to resolve the issue. Collaborate and work with development team on L3 issues and follow the task to completion. Ensures adherence to bank and information systems policies and procedures, security measures and audit standards. Team player and mentor junior support engineers

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.