Roopa B
Bengaluru
Summary
An 8-year experienced Data Engineer with balanced expertise: 4 years of IBM DataStage 11.5 parallel jobs (banking regulatory) and 4 years of modern cloud patterns in building and modernizing banking data platforms.
Currently at HSBC (Capgemini), driving Google Cloud (BigQuery + Airflow/Composer) pipelines for ADS and CDL layers. Proven in IBM DataStage, regulatory reporting, production support, and cloud migration. Google Cloud Associate Certified.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Senior Consultant
Capgemini ,Client -HSBC
Bengaluru
06.2023 - Current
GCP BigQuery, Airflow, SQL, Python Automation, GIT, CI/CD.
- Own end-to-end ADS and CDL layer pipelines on BigQuery using Airflow/Composer for MENAT and UK regulatory reporting.
- Develop parameterized Python scripts for log parsing, validation, and automation.
- Optimize BigQuery cost and performance via partitioning, clustering, and query refactoring.
- Raise change requests via service now and Drive CI/CD deployments to preproduction and prod environments ,and resolve production incidents within strict banking SLAs.
Consultant
Capgemini, Client : HSBC
Bengaluru
04.2021 - 06.2023
- Designed and supported parallel DataStage jobs using DataStage 11.5 for Oracle/DB2 targets.
- Delivered regulatory projects (Falcon, I-Score, Egypt CCR, Government Bank Reporting).
- Performance-tuned long-running jobs, and reduced recurring failures.
Software Developer Engineer
Tesco Bank (via Rlabs)
Bengaluru
12.2019 - 03.2021
DataStage 11.5 + Oracle
- Constructed DataStage extraction jobs from Tsys, Aperio, Fiserv, Experian, and Strata sources.
- Developed sequencers and Unix wrappers to enhance job execution efficiency.
- Implemented Autosys scheduling for streamlined job automation.
- Provided L3 production support to resolve technical issues effectively.
Associate IT Consultant
ITC infotech
Bengaluru
10.2017 - 12.2019
DataStage 8.1 + Oracle.
- Designed and supported DataStage jobs for the internal data warehouse.
Education
Bachelor of Engineering - Computer Science
PES College of Engineering
Mandya06-2017
Skills
Data Engineering: Google BigQuery, Airflow/Composer, IBM DataStage 115
Languages: SQL (expert), Python (parameterized scripting – daily self-learning and production use), Unix
Tools: TOAD, WinSCP, Putty, Control-M, Autosys, ServiceNow, JIRA, Jenkins, Git
Cloud and DevOps: GCP, CI/CD pipelines, databases: Oracle, DB2
Certification: Google Cloud Associate Cloud Engineer
Certification
Google Cloud Certified Associate Cloud Engineer.
Accomplishments
Woman of the Quarter
Affiliations
Singing.
Timeline
Senior Consultant
Capgemini ,Client -HSBC
06.2023 - Current
Consultant
Capgemini, Client : HSBC
04.2021 - 06.2023
Software Developer Engineer
Tesco Bank (via Rlabs)
12.2019 - 03.2021
Associate IT Consultant
ITC infotech
10.2017 - 12.2019
Bachelor of Engineering - Computer Science
PES College of Engineering