Chaithanya Ravulu — Rocket Companies - Senior Data Engineer

Profile 

Served in varied domains like fintech, digital marketing and travel and hospitality. Over ten years of experience building, deploying, and managing cloud data engineering, data analytics, enterprise data warehouse, horizontal scalable data services.Experience with AWS cloud analytics stack for data transformation, data lake, object storage and data catalog. 

Experience 

Rocket Companies (Quicken Loans) August 2020 – Till Date 

Senior Data Engineer Detroit, MI 

  • Architected and developed cloud-based data applications to be consumed by 100+ applications across different verticals by Rocket family of companies.
  • Demonstrated Proof of Concepts (POCs) to leadership for novel data use cases such as connecting PowerBI gateway service installed in EC2 to Redshift instance in private subnets.
  • Created and maintained AWS Glue park, Streaming ETL, and Python shell jobs to process data in batches and near real time use cases such as app telemetry, Workday, Service Now integrations.
  • Developed high throughput, scalable & serverless data lake solutions involving hot and cold data from Microservices APIs both REST and GraphQL calls with Lambda functions to Glue Data Catalog.
  • Orchestrated and managed data pipelines with AWS Step functions with error handling and event bridge triggers and SNS for broadcasting mechanisms.
  • Designed and implemented cloud-based data warehouses in AWS Redshift and enabled parallel querying of dimensional modeled data and raw data in the data lake via Spectrum.
  • Instantiated, created, and maintained CI/CD (continuous integration & deployment) pipelines and apply automation to environments and applications.Worked on various automation tools like GIT, Terraform, CircleCI.
  • Leveraged Apache Flink (Kinesis Analytics) to process near real time data for customer analytics, fraud detection and operational efficiency.

Deloitte August 2015 – July 2020 

Lead Data Engineer Chicago, IL 

  • Worked in end-to-end technology platform that combines mobile data-collection, corporate and unit-level performance improvement tools, and mobile-optimized reporting and visual analytics dashboards in a powerful platform designed for insights and actions to drive performance.
  • Built SnowPipes and Snowflake streams to capture change data and Snowflake Tasks for ELT and data normalization while migrating from MS SQL Server to Snowflake (AWS).
  • Detecting and preempting adverse impacts to brand and reputation using augmented intelligence with thick data, beyond consumer sentiment analysis by using analytics tools.
  • Worked extensively with Dimensional modeling, Data migration, Data cleansing, ETL Processes for data warehouses.
  • Developed parallel jobs using different processing stages like Transformer, Aggregator, Lookup, Join, Sort, Copy, Merge,

Funnel, CDC, Change Apply and Filter. 

Citi Group December 2011 – June 2014 

Data Engineer Hyderabad, India 

  • Involved in ETL development operations that include building and maintaining Operational Data Store (ODS).
  • Contributed to support activities that include Preparing Schedules for Tivoli scheduler, Supporting Data Batch Process

from ODS into Teradata Enterprise Warehouse System. 

  • Delivered data transformation using InfoSphere tools like DataStage Designer, DataStage Director and DataStage

Administrator. 

  • Contributed to support activities that include preparing schedules for Tivoli scheduler, supporting data batch process

from ODS into Teradata Enterprise Warehouse System. 

Technical Skills 

Certifications: AWS Certified Data Analytics Specialist, Oracle Certified Associate 

Languages: Python, SQL 

Developer Tools: VS Code, VS Enterprise, AWS Cloud Platform, DataGrip, MS Integration Services, IBM DataStage Technologies/Frameworks: Terraform, CircleCI, GitHub, Copilot, Apache Flink, Apache Spark, AWS Glue, AWS Lambda, AWS Step Functions, AWS Kinesis 

Databases/Datawarehouses: AWS Redshift, Snowflake, MS SQL Server, Teradata 

Education 

University of Cincinnati 

Master of Science, Information Systems 

Karunya University 

Bachelor of Engineering, Computer Science 

July 2014 – August 2015 July 2007 – August 2011