Lalit Malik
Principal Data & AI Engineer
Gurugram
Summary
Experienced Data Engineering Leader with 9+ years in designing and managing scalable data solutions across service and product-based organizations. Proficient in Database Engineering, Data Modeling, AI Ops, and Cloud Data Optimization. AWS Certified Solution Architect-Professional with expertise in building real-time data pipelines, managing large-scale data migrations, and leveraging Generative AI for innovative solutions.
Overview
9
9
years of professional experience
Work History
Principal AI & Data Engineer
Globalization Partners
10.2023 - Current
- Designed and delivered scalable data pipelines for curated, value-added data assets, including data marts and real-time streaming solutions.
- Optimized cloud databases, enhancing performance and reducing costs.
- Implemented Generative AI solutions, scraping data from 1,500+ websites and integrating prompt engineering techniques.
- Streamlined ETL processes, ensuring efficient data loading cycles within specified windows.
- Led the migration of legacy data systems to modern solutions, ensuring minimal downtime and data integrity.
Senior Data Engineering Consultant
360 Digital Transformation
03.2023 - 10.2023
- Collaborated with clients to design tailored database solutions and develop conceptual and logical data models.
- Managed data migration projects using AWS DMS and advanced ETL frameworks.
- Mentored a team of engineers, guiding them in best practices for ETL development and data governance.
- Established scalable database architectures to support high-performance analytics and reporting.
Senior Data Engineer
Mindteck India Ltd.
05.2022 - 03.2023
- Executed end-to-end data migration activities, transitioning legacy systems to cloud data warehouses (e.g., Redshift).
- Developed Python and PySpark scripts for data transformation and modeling.
- Designed and deployed CI/CD pipelines using GitHub to automate workflows.
- Collaborated with cross-functional teams to optimize data models for real-time analytics.
Technical Consultant – Data (Contractual)
Nityo Infotech
07.2021 - 12.2021
- Built real-time data pipelines using AWS Kinesis, Python Boto3, and AWS RDS.
- Developed data reports and business logic using SQL queries.
- Utilized AWS data services (S3, RDS) AND Snowflake warehouse for data processing and analytics.
Senior Software Consultant - NoSQL
MongoDB ( Contractual)
01.2021 - 04.2021
- Provided NO-SQL(MongoDB) technical support using knowledge of complex technology to solve problems and support new projects.
- Evaluated multiple data solutions during early software architecture plotting and system migration planning stage.
Senior Data Architect
Flexsin Technologies
12.2019 - 12.2020
- Developed comprehensive database documentation, facilitating better collaboration among team members.
- Established efficient backup and recovery procedures, safeguarding valuable company assets during unforeseen events.
- Creation of Data consumption service (DCS) and Data Migration process end to end.
- Worked on Data Science POC to predict value of prices using Multi Regression Predictive model.
- Worked on process improvement, data extraction, data cleansing and data manipulation.
- Initiated Data Science NLP project for sentiment analysis
Data Consultant
NCS Pte Ltd
04.2019 - 12.2019
- Data mapping specifications to migrate Data from different source Systems using stored procedures.
- End to End Data Migration from Legacy system to Postgres SQL.
- Setup the whole infrastructure of the AWS cloud formation scratch.
- Migrating the data to the AWS Relational Databases like RDS DB.
- Gathered requirements for Singapore’s one licensing system project, which is one platform for all licenses for National Environment Agency of Singapore.
- Implemented new code management tools in the Project responsible for better handling of the Real Time data ingestion for Big Data.
Senior Software Engineer
Q3 Technologies
02.2018 - 02.2019
- Worked on Oracle stored procedures involving various SQL,PL/SQL
- Created PostgreSQL queries to implement Business logic.
- Utilized Oracle, MS SQL, AWS , Data warehousing, SSIS, and other ETL tools for Business Intelligence and analysis.
- Created LLD’s (Low level design documents for the project)
- Designed ETL packages using different transformations for data conversion using python.
Software Engineer
NIIT Technologies
01.2016 - 01.2018
- Successfully created and debugged Oracle PL/SQL procedures, function and packages to Implement business logic.
- Led development of database projects for customers- Banking system- Completed data migration project on time.
- Analyzed requirements with application developers, business analysts to Provide data related solutions.
- Developed reports and Dashboards using multiple data sources.
Education
Masters of Computer Applications. - Computer And Information Sciences
Guru Gobind Singh Indraprastha University.
New Delhi, India 04.2001 -
Bachelors of Computer Applications. -
Guru Gobind Singh Indraprastha University.
New Delhi, India 04.2001 -
Skills
ETL development
Data Governance
NoSQL Databases
Data Modeling
Python Programming
Data Warehousing
Natural Language Processing
SQL Database Management
Big Data Management
Database Design
SQL
Data Migration
Real-time Analytics
SQL Expertise
RDMS Design
AWS REdshift
Timeline
Principal AI & Data Engineer
Globalization Partners
10.2023 - Current
Senior Data Engineering Consultant
360 Digital Transformation
03.2023 - 10.2023
Senior Data Engineer
Mindteck India Ltd.
05.2022 - 03.2023
Technical Consultant – Data (Contractual)
Nityo Infotech
07.2021 - 12.2021
Senior Software Consultant - NoSQL
MongoDB ( Contractual)
01.2021 - 04.2021
Senior Data Architect
Flexsin Technologies
12.2019 - 12.2020
Data Consultant
NCS Pte Ltd
04.2019 - 12.2019
Senior Software Engineer
Q3 Technologies
02.2018 - 02.2019
Software Engineer
NIIT Technologies
01.2016 - 01.2018
Masters of Computer Applications. - Computer And Information Sciences
Guru Gobind Singh Indraprastha University.
04.2001 -
Bachelors of Computer Applications. -
Guru Gobind Singh Indraprastha University.
04.2001 -
Similar Profiles
Priya MahatoPriya Mahato
Sr. Human Resource Associate Shared Service at Globalization PartnersSr. Human Resource Associate Shared Service at Globalization Partners
Priya MahatoPriya Mahato
Sr. Human Resource Associate Shared Service at Globalization PartnersSr. Human Resource Associate Shared Service at Globalization Partners
Shivani PanwarShivani Panwar
Market Research Associate at Globalization PartnersMarket Research Associate at Globalization Partners