Sreejith Malammal
Data Engineer
Bengaluru
Summary
Data Engineer with 12+ years in ETL development & RDBMS Systems, data warehousing, and cloud-based data integration. Skilled in Azure Data Factory, Synapse, Python, microsoft sql server, with a record of designing efficient pipelines and metadata architectures. Proven experience across healthcare, finance, and retail sectors, leveraging strong technical skills and adaptability to drive seamless data migration and reporting solutions.
Overview
13
13
years of professional experience
2010
2010
years of post-secondary education
4
4
Languages
Work History
ADF Developer
Hexaware Technologies Ltd.
02.2023 - Current
- Datalake Project is aimed at fetching source data from multiple environments like Oracle server, servicenow, SQL server etc and load to DataLake and synapse datawarehouse
- Done end to end development of multiple pipelines to source data to warehouse
- Created a robust metadata architecture which is used to drive the ETL
- Created multiple stored procedures for data sourcing and movement
- Worked on project technical documentations
ETL Developer
Hexaware Technologies Ltd.
12.2021 - 02.2023
- Column Leaching Project aimed at loading complex xlsm files having data scattered across multiple places in a sheet and having multiple sheets to snowflake tables
- Also to load data from azure cosmos db to snowflake as a part of new UI creation for column leaching
- Done the technical feasibility analysis initially between ADF & Python, to select the ETL tool
- Orchestrated 2 separate Python ETL process to load data from excel to snowflake and cosmos to snowflake
ADF Developer
WinWire Technologies
01.2020 - 11.2021
- Regulatory Datawarehouse project where data factory pipelines were created for scheduled data migration from multiple source systems like Oracle, VeevaRIM, Csv files, text files (SAP data) to azure data lake and then to Azure synapse and then to datamart
- The whole data ingestion, data quality checks and transformations is done via databricks notebooks
- Create multiple stored procedures for metadata manipulations
- Creating Databricks notebooks for transformations
ADF Developer
Winwire Technologies
04.2020 - 07.2020
- The project is aimed at migrating Oracle data/object schema from multiple servers to Azure Data lake using Azure data factory
- Involved in creating multiple data factory pipelines for data migration to data lake
Paginated Report Developer
WinWire Technologies
01.2020 - 04.2020
- The project is aimed at migrating 60+ SSRS Reports to Power BI premium workspace and creating standard/data driven subscription for reports
- The data driven subscription capability is currently not currently supported in Power BI workspaces and is implemented as a separated solution using Azure Function App
- Deployed and configured reports from report server to PBI premium workspace
- Created standard subscriptions for reports
- Created new reports as per business requirements
SSIS/SSRS/ADF Developer
Accenture Solutions Pvt Ltd
02.2018 - 01.2020
- The primary objective of the App Rationalization project is to rebuild the complex BOBJ Reports in SSRS and subsequently to decommission the BOBJ application to save the heavy Licensing cost of BOBJ
- Involved in understanding the existing Business logic and report expressions of BOBJ reports
- Involved in rebuilding the existing BOBJ complex reports in SSRS converting the complex BOBJ logic as SSRS expressions
- Developed SSIS package to load tables required for Reporting Services.
- Ensured that the reports/packages are in line with the requirements specified by clients by conducting Sanity tests and Unit tests
- Fixing defects raised at time of SIT,UAT and providing Warranty Support.
SSRS Developer
Mindtree Ltd.
10.2015 - 11.2017
- The goal of the Shared Reporting Services project is to addresses the limitations which meet the needs of various markets for back office users
- Involved in development of SSRS reports with backend as microsoft sql server.
- These reports are mainly used to decide the bonus for Sales Rep
- These Reports provides basic analysis of sales rep visits to outlets by day
- Involved in preparation of detailed design documents (DD) based on conceptual design (CD) produced by Client
SSIS developer
Mindtree Ltd.
10.2015 - 11.2017
- Data Integration Layer (DIL) is built to upload market or Cluster provided data to Salesforce
- A generic SSIS package is developed to capture and monitor the file information, validate the data on historical database and then upload to salesforce based on the successful validation
- Involved in creating multiple SSIS Packages to load data to Salesforce
SSIS Developer
Nuware Systems
04.2014 - 10.2015
- The project was aimed at loading data from csv files and excels files into respective raw tables after performing the necessary transformations and later loaded into the main table
- A variety of transformations are used in the packages to filter data as per the requirement
Production Support Analyst
Nuware Systems
01.2012 - 10.2015
- EIMT Production Support combines onsite communications with offsite execution
- Production Support involves handling the nightly batch production jobs and fixing up the Production job failures within the time frame in order to meet the SLA
- Debugging existing SQL codes and failed SSIS packages to fix critical time-based Production issues and failures and updating and creating of Stored Procedures, Triggers, Functions, etc
- SQL Server production support activities
Education
MCA -
DOEACC, Calicut University
BSc - Chemistry
St. Joseph's College, Calicut University
12th Std - undefined
Kendriya Vidyalaya No.2
10th Std - undefined
Veda Vyasa Vidyalayam
Skills
Data Warehousing
RDBMS
Python Programming
Business Intelligence
ETL processes
Microsoft SQL Server
Azure development
Areas Of Experience
MS SQL Server,Azure SQL,Oracle,Synapse DP, Snowflake, Azure Data Factory, Azure Repo, SSRS, Power BI Paginated, Python, Databricks
Personal Information
Passport Number: Yes
Timeline
ADF Developer
Hexaware Technologies Ltd.
02.2023 - Current
ETL Developer
Hexaware Technologies Ltd.
12.2021 - 02.2023
ADF Developer
Winwire Technologies
04.2020 - 07.2020
ADF Developer
WinWire Technologies
01.2020 - 11.2021
Paginated Report Developer
WinWire Technologies
01.2020 - 04.2020
SSIS/SSRS/ADF Developer
Accenture Solutions Pvt Ltd
02.2018 - 01.2020
SSRS Developer
Mindtree Ltd.
10.2015 - 11.2017
SSIS developer
Mindtree Ltd.
10.2015 - 11.2017
SSIS Developer
Nuware Systems
04.2014 - 10.2015
Production Support Analyst
Nuware Systems
01.2012 - 10.2015
BSc - Chemistry
St. Joseph's College, Calicut University
12th Std - undefined
Kendriya Vidyalaya No.2
10th Std - undefined
Veda Vyasa Vidyalayam
MCA -
DOEACC, Calicut University
Similar Profiles
BRAULINE G. DANIEL JR.BRAULINE G. DANIEL JR.
CENTRAL TRIAGE NURSE (CNT) at Hexaware Technologies Ltd.CENTRAL TRIAGE NURSE (CNT) at Hexaware Technologies Ltd.
Ramanji RaiRamanji Rai
Technical business analyst at Hexaware Technologies Ltd.Technical business analyst at Hexaware Technologies Ltd.
Ponni ParthibanPonni Parthiban
NA at Hexaware Technologies Ltd.NA at Hexaware Technologies Ltd.