Sunil Kumar Dash
Technology Analyst
Hong Kong
Summary
Leveraging extensive experience in ETL development and Data Warehousing to design robust, scalable, and high-performance data solutions that empower organizations to make smarter, data-driven decisions. Seeking a challenging role where I can contribute to advanced analytics initiatives, streamline data workflows, and drive innovation in data engineering within a dynamic, growth-oriented environment.
Overview
10
10
years of professional experience
Work History
Information Technology Analyst
TCS Ltd
08.2022 - Current
- Optimized ETL processes
- Data Warehousing Excellence
- Designed and implemented scalable ETL processes resulting in a 20% increase in data processing efficiency.
- Collaborated with Data Integration Analyst teams to troubleshoot ETL failures and resolve complex data issues, reducing occurrence of failures by 30%.
- Worked closely with Aviation data, including longitudinal claims and high risk conditions, improving processing speed by 25%.
- Working alongside different types of source and target partners which includes both internal and external partner as well
- Shell scripting mechanism and it's usage through informatica power center
Developer
TCS Ltd
05.2021 - 07.2022
- This assignment is all about using ADF framework along with Apache Nifi to ingest and load on premises source system records into target hive & HBase tables in HDInsight cluster hosted in Azure cloud
ETL Informatica Developer
Infosys Ltd
01.2020 - 05.2021
- Company Overview: L'Oreal is a French Personal Care company headquartered in Clichy, France
- This project is the operation all-head of the informatica tool and ETL
- The Overall aspects providing a business solution including end to end implementation of the designated road-map which involves data consolidation from heterogeneous data sources and Dumping them into various layers inside both the core and local system prolifically broken as into staging, Data warehouse and Data Mart
- Data is taken to analytical cubes from Mart layer in order to analyze and preview the implemented solution by using Microsoft SSAS and publish the solution to end-user in terms of visualization which is carried out by Microsoft power-BI as a reporting BI tool
- L'Oreal is a French Personal Care company headquartered in Clichy, France
Informatica Administrator
Infosys Ltd
04.2019 - 12.2019
- Company Overview: L'Oreal is a French Personal Care company headquartered in Clichy, France
- Providing 24
- 7 supports for operational issues and helping users and monitoring teams to build their codes the best way possible
- Resolved maximum number of tickets and resolved several Incidents
- Along with Administering Informatica developed mappings, session and work-flows for L'Oreal according to their business requirement
- Handled all sorts of outages like UNIX patching, Database upgrading, Installing EBF, CDC activity
- Automated the migration process of Informatica objects like mappings, sessions and work-flows from different repositories in different environment (Development, QA and Production)
- Worked with vendor to resolve severe issues related to Informatica 9.6 and Informatica 10.1
- Developed Shell Scripts to automate various processes in Informatica Administration to reduce manual efforts
- L'Oreal is a French Personal Care company headquartered in Clichy, France
SQL Developer
Tech Mahindra Ltd
06.2018 - 08.2018
- Company Overview: General Electric is an American multinational conglomerate corporation incorporated in New York and headquartered in Boston
- Back-office associate's job is to do data migration activities from given source to Target, Data quality checks and functional user interaction about the requirements
- General Electric is an American multinational conglomerate corporation incorporated in New York and headquartered in Boston
Informatica Administrator
Tech Mahindra Ltd
06.2016 - 05.2018
- Company Overview: General Electrical is the Giant in the electrical industry based in USA
- It is an operational project where we provide service as well as support to development teams
- We resolve issues on informatica tool faced by users
- This project is the operational head of the informatica tool and ETL used by developers
- Developers require our help for any kind of code migration or any access to informatica system
- This project also provides production support, at the same time side by side works with developers to develop their codes in the best way possible, so as to make the performance of the codes better
- General Electrical is the Giant in the electrical industry based in USA
Informatica Developer
Tech Mahindra Ltd
06.2016 - 05.2018
- Company Overview: General Electric is an American multinational conglomerate corporation incorporated in New York and headquartered in Boston
- This project is a Data Integration part of GE Power and Water
- Development of codes is basically from miscellaneous clients
- Extensively developed various mappings to perform ETL of source data into the OLAP/data warehouse
- General Electric is an American multinational conglomerate corporation incorporated in New York and headquartered in Boston
Education
BTECH - EEE
GIET
CHSE - Science
J.K.B.K GOVT JUNIOR College
HSE - Matriculation
Municipal high School
Skills
Informatica Power Center 96&101
IICS
Microsoft SSIS
AWS S3, Lambda, Glue, IAM, Cloudwatch
IBM Sterling Gateway
Unix, Shell Scripting
SQL, PLSQL, PostgreSQL
Disclaimer
I do, hereby, state that the above information is true to my knowledge., 11/01/2026, Hongkong SARC
Alternate Contact
+852 59806570
+91 6370917566
Timeline
Information Technology Analyst
TCS Ltd
08.2022 - Current
Developer
TCS Ltd
05.2021 - 07.2022
ETL Informatica Developer
Infosys Ltd
01.2020 - 05.2021
Informatica Administrator
Infosys Ltd
04.2019 - 12.2019
SQL Developer
Tech Mahindra Ltd
06.2018 - 08.2018
Informatica Administrator
Tech Mahindra Ltd
06.2016 - 05.2018
Informatica Developer
Tech Mahindra Ltd
06.2016 - 05.2018
CHSE - Science
J.K.B.K GOVT JUNIOR College
HSE - Matriculation
Municipal high School
BTECH - EEE
GIET