Summary
Overview
Work History
Education
Skills
Timeline
Generic

Thamizharasan Babu

CHICAGO,IL

Summary

Results-driven Big Data Engineer with expertise at Rocket Mortgage in automating ETL pipelines and enhancing data analytics. Proficient in SQL and Python, I excel in collaborative environments, delivering impactful solutions that improve lead allocation efficiency and client engagement. Committed to leveraging data for strategic decision-making and operational excellence.

Overview

7
7
years of professional experience

Work History

Big Data Engineer

Rocket Mortgage
Detroit, MI
07.2018 - Current
  • Engineered and automated robust ETL pipeline to match newly closed loans with existing servicing loans using multiple matching keys. Handled monthly snapshot ingestion, enriched records with borrower data, implemented deduplication logic, and optimized output delivery to Amazon S3 and Athena for scalable downstream analytics and reporting.
  • Developed and orchestrated AWS Glue ETL pipeline to generate daily service monitoring and suppression files for third-party vendors based on the latest serviced data population. Implemented change data tracking for client base variations, automated data export to Amazon S3, and integrated email notifications to deliver pipeline metrics to stakeholders.
  • Built Python-based simulation pipeline to model and analyze optimal marketing lead mixes for mortgage products. Leveraged historical lead data and conversion metrics using Pandas and SQL, applied business rules to test multiple lead mix scenarios, and exported results to Amazon S3 for downstream analytics. Enabled data-driven decision-making, improving lead allocation efficiency and conversion forecasting accuracy.
  • Designed and implemented a Python-based data pipeline using AWS Glue to monitor client online activity signals and identify behavioral patterns indicating potential cash needs or home buying/selling intent. Enabled early, targeted engagement with clients by processing event data, applying business logic, and triggering downstream workflows—supporting proactive product outreach and improving client retention.
  • Supported the integration of diverse data sources into central systems.
  • Collaborated with teams to gather data requirements for analytics projects and transform data from raw format to raw processed format to have them ready for the pipelines usage.
  • Optimized complex SQL stored procedures in the data warehouse to significantly reduce execution time and improve overall query performance. Analyzed query plans, refactored inefficient logic, and implemented indexing strategies—resulting in faster data processing and enhanced system scalability.
  • Developed and maintained SSIS packages to support ETL processes within the enterprise data warehouse, enabling efficient data integration, transformation, and loading from multiple source systems into structured reporting layers.
  • Executed SQL queries to test back end data validation of DB2 database tables based on business requirement.
  • Worked with SSIS creating packages in data access for the Business Intelligence dashboards.

Education

Master of Science - Information Technology And Management

Illinois Institute of Technology
Chicago, IL
12-2017

Skills

  • Programming languages: SQL, Python, Pyspark
  • Database: MySQL, SQL database server, MS Access, SSMS
  • Methodologies: Agile (Scrum and Kanban)
  • Tools: ServiceNow, Remedy, Jira, Azure DevOps, Pycharm, Github, AWS

Timeline

Big Data Engineer

Rocket Mortgage
07.2018 - Current

Master of Science - Information Technology And Management

Illinois Institute of Technology

Similar Profiles

CREATE PROFILE
Thamizharasan Babu