Gen AI Learner
Gnana Prakash T
Senior Data Engineer
Chennai,TN
Summary
Detail-oriented and performance-driven Data Engineer with 10+ years of experience in end-to-end data pipeline development, cloud data warehousing, and large-scale data processing.
Expertise in designing and optimizing ETL/ELT workflows using AWS Glue, AWS Redshift, S3 and automation frameworks. Strong hands-on proficiency in SQL across multiple database systems including MSSQL, MySQL, Redshift and PostgreSQL.
Expertise at building data marts, data models, and scalable architectures for datasets exceeding 1TB. Recognized for strong analytical and problem-solving skills, data design knowledge, and ability to deliver high-quality, reliable solutions across complex and multi-tool environments. I am thrilled to apply my expertise in any Data-driven domain associated with ETL tools maintaining multi-dimensional modelling of databases as per the requirements.
Overview
11
11
years of professional experience
2
2
Languages
Work History
Senior Datawarehouse Engineer
Learnship Technologies
03.2024 - Current
- Played a major role in building the complete Datawarehouse in the redshift as a migration process from the Azure SQL based Datawarehouse with relevant ETL tools like AWS glue, Redshift SQL, S3.
- Implemented the performance improved, durable, reliable Datawarehouse model in redshift SQL which helps the Power-BI reporting in an effective way in terms of Performance, accuracy, accessibility with the deep insights.
- Utilized the AWS services like AWS Glue, AWS Step functions to build the automated ETL flow and the alerting emails configuration for the daily data load monitoring and to support during the failures.
- Building up the strong data team in terms of providing valuable analysis for the decision-making process for dimensional model table architecture designing, development and providing strong technical guidance for the better data model creation with clean mapping with facts and dimensions.
- Different types of source data mapping like MySQL, SQL server, AWS dynamo, Azure SQL, Salesforce, Streamnative and from APIs into Redshift Datawarehouse using AWS Glue Pyspark jobs and adding necessary loggings, transformation and from excel files and normalizing the data using dimensional modelling.
- Involved in Power-BI reporting by supporting the report creation for complex data model creation consists of reports like trinity – Sales, Booking & Revenue which generates the key insights of company’s performance in all areas and maintaining the data quality as it is served for the stake holders.
- Associated with the best market practice of Sprint-wise working methodology using Jira by Planning the tickets effectively, refining the backlog, reviewing the sprint outcome with BI head and doing monthly retrospective.
Tech Lead
Mobius Knowledge Services
06.2023 - 02.2024
- Built a star-mesh Datawarehouse in Redshift right from the architecture design, data model creation, Source-Target mapping, business transformation and finally building the resilient automated structure in addition with tracking mechanisms.
- Created a star-mesh Datawarehouse in the redshift as a migration process from the Azure SQL based Datawarehouse with relevant ETL tools like AWS glue, Redshift SQL, S3.
- Built the complete data warehouse from the different type of ERP system which stores the data in the different types.
- All types of data have been brought into the Azure SQL suing ADF, APIs, etc and changing the un-normalized data into the normalized model and creating the global data lake structure which includes sales, finance, etc.
- Finally, we are aggregating the facts and dimensions into the source data for the power BI where the user’s dashboards are being created which gives them the real-time data in different kinds of analysis, reports, predictions, forecasting, open-orders, invoice information.
Senior Software Developer
Mobius Knowledge Services
06.2017 - 12.2022
- Developed my career as a senior software developer by owning the various projects right from the design, development, testing, integration, automation and maintenance.
- Created a unified Tool for the platform for multiple data marts of existing projects. The Tool provides the user-interface to configure the platform as per the roles & permission granted user-wise. Various complex functionalities have been integrated in the tool as per the needs & concepts in the process requirement.
- Built a data warehouse in SQL Server 2012 which stores inverter power information & complete inverter details & day-by-day fluctuations, energy savings, etc of the Tamilnadu’s largest network of companies. This information has been launched as product environment tool (UI) to alert as per the fluctuations & publishing daily report summary EOD for the end user.
- Live ticket details of concerts, sports, arts & theatre, family entertainment & it also provides the information of different sections which has been incorporated the Data flow starts from Python scripts, then into MSSQL Database, manipulation & post processing of data & manual correction of unfilled sections & finally delivers to customer via FTP which has been fully automated high time efficient process which requires very less manual intervention .
Software Developer
Mobius Knowledge Services
01.2015 - 05.2017
- Started my career as a database developer by learning SQL server, MySQL and excel functionalities and involved in the end-end development of various projects.
- Individually contributed to a project consists different chain stores information of American Restaurants, Coffee shops, shopping malls, etc which has been stored in MSSQL Database. Parsing the street information to identify the Addition, Modification, Deletion & Verification of refresh data comparing the client input describes the key factor of this project.
- Worked in a vast project which has the commercial information about the authorized & certified companies of Indian government as well as the private sector. It has the various classifications like information of the employees, company’s information, and the contact information of telephone service provider all over India. Each section of this project will be comprised as separate models right from the scraping & data manipulation in Database & we are delivering the Add, Delete & Modify outputs for all sections quarterly comparing the last delivered batch.
Education
B. Tech - Electronics and Communication Engineering
Anna University
01.2014
Skills
Accomplishments
- Won Employee of the Month in March 2025 at Learnship Technologies Pvt Ltd for contributing to the Team for great milestones in Migration, Development and introducing AWS cloud services into the System.
- Achieved Long-time migration completion through effectively helping with Design, Planning and Analyzing the key tables and prioritizing with the report needs.
- Actively contributing in the Data team during the blockers, technical guidance for Big Data architecture of Data engineering model
Interests
Fun Committee Contributor
Gym Fitness
Timeline
Senior Datawarehouse Engineer
Learnship Technologies
03.2024 - Current
Tech Lead
Mobius Knowledge Services
06.2023 - 02.2024
Senior Software Developer
Mobius Knowledge Services
06.2017 - 12.2022
Software Developer
Mobius Knowledge Services
01.2015 - 05.2017
B. Tech - Electronics and Communication Engineering
Anna University