Thiruloga Chandar Jayabalan
Oak Park,Australia
Summary
Experienced Senior Data Engineer with extensive expertise in cloud-based data solutions, specializing in Snowflake, DBT, Azure Data Factory, Databricks and Fivetran. Proven track record of designing, building, and optimizing data pipelines and ETL processes across Azure Cloud and Oracle/MS SQL Server environments to support data warehousing and analytics initiatives. Skilled in leveraging Snowflake’s architecture for scalable, high-performance data warehousing, and implementing robust data transformation workflows with DBT to ensure data accuracy and consistency. Known for a results-oriented approach to data engineering that balances performance, security, and scalability, and thrives in cross-functional teams to drive impactful data solutions that enhance strategic decision-making.
Results-driven data engineering professional with solid foundation in designing and maintaining scalable data systems. Expertise in developing efficient ETL processes and ensuring data accuracy, contributing to impactful business insights. Known for strong collaborative skills and ability to adapt to dynamic project requirements, delivering reliable and timely solutions.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Data Engineer
The Good Guys
08.2018 - Current
- Developed and maintained data warehousing pipelines for JB Group and The Good Guys, enabling analytics and machine learning capabilities to drive data-driven business initiatives
- Engaged closely with internal and external stakeholders to gather data requirements, delivering scalable data solutions to support core business objectives
- Created and maintained ETL pipelines to bridge multiple data sources with the datalake and enterprise data warehouse, ensuring accurate, timely, and secure data delivery
- Led data acquisition, ingestion, transformation, and deployment of data models to support both functional and analytical business needs, ensuring data quality and relevance
- Monitored data pipelines across tools including Azure Data Factory (ADF), Matillion, DBT, Fivetran, and Snowflake, proactively responding to key alerts and ensuring timely issue resolution
- Took initiative to identify and implement improvements in pipeline design and processes, focusing on opportunities for continuous integration and deployment (CI/CD)
- Supported cost management efforts across data platforms, applying best practices to optimize data management processes and reduce platform-associated expenses
- Successfully led the migration of The Good Guys’ data warehouse from Oracle to Snowflake, including the transition of ELT mappings from Oracle Warehouse Builder to Matillion, resulting in a modernized and scalable data infrastructure
- Migrated data replication from Oracle GoldenGate to Matillion, improving data integration and ETL efficiency across systems
- Led the migration of JB Group’s data warehouse from Databricks to Snowflake, converting PySpark code to Snowpark and establishing automated pipelines to seamlessly ingest data from the datalake to Snowflake
- Spearheaded a DBT project from Proof of Concept (POC) through to full implementation, setting up environments, CI/CD pipelines, testing, and code migration, enabling robust data transformation practices and enhanced data model quality
- Directed the migration of customer master data from IBM MDM to an in-house Snowflake solution, implementing rigorous data quality checks and testing protocols to ensure data accuracy and reliability
- Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
- .Fine-tuned query performance and optimized database structures for faster, more accurate data retrieval and reporting.
- Enhanced data quality by performing thorough cleaning, validation, and transformation tasks.
- Streamlined complex workflows by breaking them down into manageable components for easier implementation and maintenance.
- Provided technical guidance and mentorship to junior team members, fostering a collaborative learning environment within the organization.
Application Systems Support E-Commerce
The Good Guys
07.2014 - Current
- Joined this role to provide technical support to The Good Guys web channels (B2C, B2B, and eBay Store) and allocation system (IBM Sterling)
- Main responsibilities include helping business in setting up organizations (IBM WebSphere), promotions on the website and troubleshoot integration and website issues
- Ensuring application systems are highly available, reliable and accurate by responding to critical application alerts
- Maintain accurate control of issues, record/respond to issues and troubleshoot accurately in a timely manner
- Ensure that regular data uploads and operational procedures are performed as scheduled by coordinating outages and special activities on the systems
- Review application systems operational performance, analyze and escalate issues, and provide suggestions for improvement
- Assist with the development of new functionality, perform testing activities and deploy into production
- Generate reports as requested by the business
- Respond to customer care team inquiries
- Provide assistance as required by Application Systems Manager e-commerce
- The Good Guys has been awarded the NORA Multichannel Retailer of the Year Award at the 2015 Australian Retail Awards
Application Service Desk Level 1
The Good Guys
07.2013 - 06.2014
- To deliver efficient and effective operational support to all The Good Guys stores and Support Centre staff
- This involves providing support to POS, Oracle RMS, in-house applications and troubleshooting hardware and networking issues
- Provide help desk support to retail stores and Support Centre staff
- Escalate support problems to the responsible IT Technical Team member when necessary
- Resolve support problems and queries in an effective and timely manner to minimize or avoid downtime
- Ensure all users know the current status of their individual problems
- Process hardware requests, configure and test hardware before dispatching to the store
- Receive faulty hardware, assess repair requirements and organize dispatch as required
- Set up workstations
- Create user accounts on the retail system
- Participate in staff training and after-hours support roster
Systems Support Officer
Fusion Retail Brands
08.2012 - 06.2013
- To deliver efficient and effective operational support to Fusion retail brand stores across Australia
- Provide POS support to retail stores
- Receive faulty hardware, assess repair requirements and organize dispatch as required
- Resolve support problems and queries escalated by service desk in an effective and timely manner
- Troubleshooting network related problems
- Configure and test hardware before dispatching to the store
- Troubleshooting and maintenance of PC
- Ghost and configure hard drives for stores
- Asset management
- Provided technical support and issue resolution to users via remote assistance platforms.
Education
Master of Computing Technology -
University of Southern Queensland
01.2010
Bachelor of Engineering - Electronics and Communication Engineering
Anna University
01.2008
Skills
- Data Warehousing
- ETL Processes
- Dimensional Modeling
- #NF Data Modeling
- SQL Tuning
- Star Schema
- Snowflake Schema
- Azure
- Snowflake
- DBT
- Matillion
- Fivetran
- Databricks
- Azure Data Factory
- Hex
- Oracle Data Integrator
- Oracle Warehouse Builder
- Oracle
- SQL Server
- SQL
- PL/SQL
- Python
Certification
- Azure Data Engineer Associate
- Azure Fundamentals
References
Happily available upon request.
Accomplishments
- Collaborated with team of 5 in the development of DBT project.
Timeline
Data Engineer
The Good Guys
08.2018 - Current
Application Systems Support E-Commerce
The Good Guys
07.2014 - Current
Application Service Desk Level 1
The Good Guys
07.2013 - 06.2014
Systems Support Officer
Fusion Retail Brands
08.2012 - 06.2013
Bachelor of Engineering - Electronics and Communication Engineering
Anna University
Master of Computing Technology -
University of Southern Queensland
Similar Profiles
Declan EdenDeclan Eden
Salesperson at The Good GuysSalesperson at The Good Guys
Angus CollinsAngus Collins
Administrative Clerk at The Good GuysAdministrative Clerk at The Good Guys
Jacob WatmoreJacob Watmore
Store Executive Manager at The Good GuysStore Executive Manager at The Good Guys
UNISHA MAHARJANUNISHA MAHARJAN
Operations assistant at The Good GuysOperations assistant at The Good Guys
Mervyn Michael DMervyn Michael D
Truck Driver at MR Truck DrivingTruck Driver at MR Truck Driving