Prabhakara Rao Ch
Hyderabad
Summary
Data engineer with extensive experience in developing and optimizing data pipelines using Snowflake, Matillion, and MS SQL Server. Proven ability to transform raw data into actionable insights, enhancing reporting efficiency and reducing warehouse costs. Skilled in creating efficient ETL processes, developing modular data models with DBT, and implementing automated data quality tests to ensure integrity. Successfully managed complex projects across various industries, including healthcare, education, payments, and manufacturing.
Overview
15
15
years of professional experience
1
1
Certification
Work History
Data Engineer
Honeywell
08.2025 - Current
- Loading the data from different business source tables to snowflake target tables
- Creating the required snowflake scripts as per business
- Creating the snowflake script for data validation from source and target
- Deployed the Snowflake scripts from Dev to Prod using Git
- Technology & Tools: Snowflake
Data Engineer
Scania
02.2023 - 07.2025
- Loading the data from different sources to snowflake using matillion and once loading the data into snowflake then we are transforming the data into target tales using matillion.
- Loading the different file formats from matillion to snowflake.
- Developed the matillion jobs as per requirement to load the data into snowflake.
- Migrating the Other ETL job to matillion jobs to load the different files.
- Creating the required scripts and stored procedure as per business logic in snowflake.
- Design, build, and maintain efficient, reliable, and scalable data pipelines using Matillion + DBT
- Developed modular data models in dbt to transform raw source data into clean, business-ready analytics tables for reporting efficiency.
- Optimized dbt project performance by implementing incremental models and materializations on large Snowflake datasets, reducing warehouse costs.
- Implemented automated data quality tests (generic tests, schema tests) in dbt to ensure data integrity, reducing data quality issues.
- Technology & Tools: DBT, Snowflake, Matillion
Data Engineer
Service Now
10.2021 - 02.2023
- Loading the data from different sources to snowflake using matillion and once load the data into snowflake then we are transforming the data into target tales using matillion.
- Loading the different file formats from matillion to snowflake.
- Developed the matillion jobs as per requirement to load the data into snowflake.
- Migrating the Other ETL job to matillion jobs to load the different files.
- Creating the required scripts and stored procedure as per business logic in snowflake.
- Technology & Tools: Matillion, Snowflake
Data Engineer
FINVI
11.2021 - 10.2022
- The scope of this project was to load the RDS MS SQL Server database into snowflake using matillion and writing the queries for tableau reporting.
- Involved in requirement gathering, analysis, design, development, testing and deployment phases.
- Creating the different environments to creating the jobs in Matillion.
- Technology & Tools: Matillion, Snowflake
Data Engineer
FINVI
01.2020 - 10.2021
- In the Payments, transform the account journey from the moment of creation through to resolution across several industries.
- Created internal and external stage and transformed data during load.
- Developed data warehouse model in snowflake and developed user defined functions.
- Creating Orchestration jobs and Transformations jobs.
- Done unit testing on the code developed.
- Technology & Tools: Matillion, Snowflake
Data Engineer
eLearning
07.2018 - 12.2019
- In the eLearning project, developed on MS SQL Server stored procedures and function and required scripts.
- Scheduling the jobs and trouble shouting jobs, analyzing long running slow queries.
- Detecting and fixing blocking and locking related issues and performing index analysis.
- Responding to trouble tickets and resolving database issues.
- Analyzing and checking the Stored Procedures.
- Technology & Tools: MS SQL Server Development and DBA
Data Engineer
Carrier Service
08.2016 - 07.2018
- Developed the MS SQL Server stored procedures and functions and SQL scripts. Loaded data using SSIS.
- Analyzing and checking the Stored Procedures, supporting on SSIS to Load the Data into Database.
- Used SSIS to develop jobs for extracting, cleaning, transforming and loading data into tables.
- AFS is the US carrier service
- Technology & Tools: MS SQL Server Development and DBA
Data Engineer
edFusion
05.2014 - 06.2016
- Developed MS SQL Server stored procedures and functions and view.
- Created database objects like Tables, Views, Synonyms, Stored procedures, function, Triggers.
- Understood the complex Queries, conducted design, coding and Testing.
- Altered various existing procedures, functions, and triggers according to the new business needs.
- Retrieved data from the database through complex SQL queries using joins, sub queries.
- EdFusion is a comprehensive data management and application integration platform connecting people.
- Technology & Tools: MS SQL Server Development And DBA
Data Engineer
Doctor Desk
03.2011 - 04.2014
- Wrote procedures function & triggers, synonyms, dynamic procedures, cursors, indexes constraints.
- Identified and fixed Blocking & Locking related issues.
- Created all constraint and maintains, indexes and statistics and maintains.
- This is a module in HIMS application that consists of the Sub modules like OP Patients, IP Patients.
- Technology & Tools: MS SQL Server Development
Education
MCA - master’s in computer applications
Andhra University
07-2009
Skills
- Health
- Education
- Payments
- Manufacturing
- MS SQL Server Development
- DBA
- Windows 7
- Windows 8
- Windows 10
- Matillion
- Snowflake
- Matillion Data Productivity Cloud
- MS SQL SERVER DEVELOPMENT 2017
Certification
- [Area of certification] certified
Timeline
Data Engineer
Honeywell
08.2025 - Current
Data Engineer
Scania
02.2023 - 07.2025
Data Engineer
FINVI
11.2021 - 10.2022
Data Engineer
Service Now
10.2021 - 02.2023
Data Engineer
FINVI
01.2020 - 10.2021
Data Engineer
eLearning
07.2018 - 12.2019
Data Engineer
Carrier Service
08.2016 - 07.2018
Data Engineer
edFusion
05.2014 - 06.2016
Data Engineer
Doctor Desk
03.2011 - 04.2014
MCA - master’s in computer applications
Andhra University