KHUSHBU BANG (MALANI)
Ringwood,Australia
Summary
Dynamic and solutions-oriented Senior Data Engineer with over 11 years of experience in the banking and insurance sectors, poised to transition into a Data Lead role. Proficient in a diverse range of technologies, including Starburst (Trino), Teradata, Azure Data Factory, Databricks, Python, and SQL. A proven track record in developing analytics-ready datasets, data warehouses, and data lake solutions highlights a commitment to translating complex business requirements into effective data strategies that enhance performance and support advanced analytics initiatives. Recognized for leading geographically dispersed teams and fostering collaboration across cultures while implementing automation to deliver impactful data solutions that drive improved decision-making and business outcomes.
Overview
14
14
years of professional experience
2
2
Certification
Work History
Senior Data Engineer
ANZ Bank – Home Loans (Acquisition & Retention Team)
09.2022 - Current
- Partner with business stakeholders to design and deliver data solutions supporting customer acquisition and retention initiatives in the Home Loans Offers domain.
- Lead migration of Home Loan Offer assets from Teradata to Starburst (Trino), improving performance, scalability, and reducing reliance on legacy systems.
- Led a major upgrade to the cleanup auto-approval process, transitioning from manual Excel checks to automated rule-based validation, resulting in 95% match accuracy, significantly reducing manual effort, and improving scalability and speed.
- Design and optimize complex SQL queries for scalability, create reusable views.
- Automate freshness and integrity checks for critical datasets and collaborate with cross-functional teams to translate business requirements into production-ready pipelines.
- Provide fast-turnaround data extracts and analysis for urgent business needs and other time-sensitive requests.
- Coordinate with the team to provide regular data extracts for retention initiatives, including terminated broker TPMIs, Staff Offers, and new campaigns to support future revenue-generating programs.
- Mentor colleagues on Starburst SQL optimization, Python best practices, and pipeline design standards, improving team capability and adoption of best practices.
- Key Achievements:
- Contributed to Teradata workload decommissioning, supporting ANZ’s cloud migration journey.
- Fixed split payment issues in Payment History pipelines, improving reporting accuracy.
- Optimized queries to reduce runtimes by up to 40%, enabling faster insights and reporting.
- Automated Cleanup Enhancement Initiative to reduce manual checks and dependency.
Senior Data Engineer (EDS DataStage Developer)
AIA Australia Ltd – Enterprise Data Solutions
08.2016 - 08.2022
- Analysed and integrated data from multiple source systems into the data warehouse for BI reporting and analytics.
- Collaborated with business, internal teams, and third-party stakeholders to understand requirements and assess technical feasibility.
- Designed ETL workflows for initial and delta loads, ensuring efficient daily data refresh.
- Developed DataStage jobs handling XML files, format conversions, complex transformations, and fact/dimension tables with Type 1 and Type 2 slowly changing dimensions.
- Implemented real-time data replication to populate the data lake and enhanced data lake capabilities.
- Built and maintained ETL pipelines using Azure Data Factory, Spark SQL, T-SQL, and Azure Data Lake Analytics.
- Delivered multiple projects on strict timelines with minimal defects, ensuring reliable and timely insights.
- Key Achievements:
- Delivered multiple high-visibility projects with defect-free code.
- Introduced automated processes reducing manual effort and improving data quality.
- Performed data profiling, cleansing, and modelling to integrate new data and improve existing datasets.
ETL Developer (DataStage Specialist)
Tech Mahindra – Coles Supermarkets
03.2016 - 07.2016
- Designed and developed DataStage jobs for integration projects.
- Coordinated deployments across SIT/SVT using Control-M.
- Worked with secure file transfers (SFTP, GPG encryption/decryption).
ETL Developer / Teradata DBA
IBM India Pvt Ltd – ANZ Bank / Vodafone UK
04.2012 - 03.2016
- Built ETL jobs integrating Oracle, SQL Server, XML, and flat files into Teradata DW.
- Supported dimensional modelling and performance tuning.
- Managed database administration including user management, space allocation, and environment clean-up.
- Delivered multiple enhancements and production fixes within SLA.
- Improved Teradata environment performance via proactive clean-up.
Education
Bachelor of Technology - Electronics and Communication Engineering
JNTU Hyderabad
Skills
- Databases / Query Engines: Teradata, Starburst (Trino/Presto), DB2, MS SQL Server, Oracle, Amazon Redshift
- Programming & Data Processing: Python (Pandas, PySpark, NumPy), SQL, PL/SQL, Databricks
- Cloud & Big Data: Azure Data Factory, Delta Lake, Azure Synapse Analytics, Familiar with AWS Glue and GCP (BigQuery)
- ETL / Data Integration: DataStage, ADF, Python ETL, Unix Shell Scripting
- Workflow Orchestration: Airflow, Azure Data Factory (ADF) pipelines
- Tools: Control-M, GitHub, Jira, Confluence, SharePoint
- Reporting / BI: Cognos, Tableau (basic)
- Concepts: Data Warehousing, Data Modelling (Star & Snowflake), ETL, Data Migration, Performance Optimization, Git Version Control
Certification
- Microsoft Certified: Azure Data Engineer Associate
- IBM DataStage v8.5 Certified Developer
- Microsoft DP-900
Timeline
Senior Data Engineer
ANZ Bank – Home Loans (Acquisition & Retention Team)
09.2022 - Current
Senior Data Engineer (EDS DataStage Developer)
AIA Australia Ltd – Enterprise Data Solutions
08.2016 - 08.2022
ETL Developer (DataStage Specialist)
Tech Mahindra – Coles Supermarkets
03.2016 - 07.2016
ETL Developer / Teradata DBA
IBM India Pvt Ltd – ANZ Bank / Vodafone UK
04.2012 - 03.2016
Bachelor of Technology - Electronics and Communication Engineering
JNTU Hyderabad