Deptesh S. — CTO

● Currently working as Lead Data Engineer (Azure) in TCS MBU since Oct 2021. ● Possess 10+ years of professional multifaceted experience and Microsoft Certified Azure Data Engineer, which includes expertise in Design, Development and Implementation of Data Warehousing applications using Azure Data Factory, Azure Databricks, Snowflake, Azure Data Lake, Azure Devops, Azure Batch, Azure Function, , SQL Server , Oracle, IBM Db2, Informatica Power center, SAP Business Object Data Services 4.2 , Azure Synapse Developer in which worked directly with customers throughout the full software life cycle experiencing in all aspects of SDLC (Software Development Life Cycle), including analysis, design, Implementation, testing, build and deployment, configuration, and production support. ● Well versed in Development, Maintenance in Financial, Insurance, Banking Domain projects. ● Strong ability in identifying problems, developing new ideas, and finding the best solutions and Innovation. ● Strong ability to analyze source systems/business requirements, identify & document business rules, design data architecture for cohesive decision support. ● Experience in Performance/Query tuning, patching, server upgrade, migrations. ● Skilled in Unix Shell Scripting and scheduling of ETL jobs via Tivoli Workload Scheduling tool. ● Has ability to effectively process semi-structured files (CSV, Parquet, JSON) in cloud ENV. ● Has ability to work independently and as part of a team, handle multiple tasks simultaneously, react to problems quickly, understand complex issues and provide high quality solutions. ● Exceptional analytical skills and problem-solving technique. ● Always open to new roles/challenges (Recently took additional role). Shared resource working in 2 projects (RS reporting and ETL AM) simultaneously.

Stackforce AI infers this person is a Data Engineering expert specializing in cloud solutions for the SaaS industry.

Location: Delhi, India

Experience: 12 yrs

Skills

Data Engineering
Cloud Solutions
Etl Development

Career Highlights

10+ years of experience in data engineering.
Microsoft Certified Azure Data Engineer.
Expertise in developing cloud-based data solutions.

Work Experience

Voya India

Technical Leader (1 yr 9 mos)

Tata Consultancy Services

Lead Data Engineer (2 yrs 10 mos)

Cognizant

Data Engineer (7 yrs 5 mos)

Education

Bachelor of Technology - BTech at Inderprastha Engineering College

12th at Saint Thomas School Shahganj

10th at Saint Thomas School Shahganj

Deptesh S.

CTO

Delhi, India12 yrs experience

Highly Stable

Key Highlights

10+ years of experience in data engineering.
Microsoft Certified Azure Data Engineer.
Expertise in developing cloud-based data solutions.

Stackforce AI infers this person is a Data Engineering expert specializing in cloud solutions for the SaaS industry.

Contact

Skills

Core Skills

Data EngineeringCloud SolutionsEtl Development

Other Skills

Azure Data FactoryAzure DatabricksAzure FunctionsSQL ServerSnowflakeIBM Tivoli Workload Scheduler (TWS)Microsoft SQL ServerAzure DevOps ServicesPowershellAzure Data LakeInformatica PowerCenterShell ScriptingAzure BatchALMAsset Management

About

Experience

12 yrs

Total Experience

5 yrs 1 mo

Average Tenure

1 yr 9 mos

Current Experience

Voya india

Technical Leader

Aug 2024 – Present · 1 yr 9 mos · Noida · Hybrid

Azure Data FactoryAzure DatabricksData EngineeringCloud Solutions

Tata consultancy services

Lead Data Engineer

Oct 2021 – Aug 2024 · 2 yrs 10 mos · Noida, Uttar Pradesh, India · Hybrid

● Analysis of the requirement and developing the ELT pipeline & maintaining Azure development standards
● Took role of consultant and derive design approach for end-to-end development project (cloud feed framework) with customers and implement the same within stipulated timeline.
● Developed ADF pipelines and mapping data flows for various business scenarios.
● Worked on Azure tech ADLS gen 2, ADF, Snowflake, Azure functions, Logic apps, Azure Batch, Azure databricks, SQL Server ,Synapse analytics, Azure Key vault, Azure AD, Azure Dev-OPS, SQL Server as part of project.
● Implemented Gpg encryption and decryption process through PowerShell with azure batch for Inbound and outbound files.
● Implemented file polling for single file, multi file, wild card files. Perform multiple POC’s and implemented the best cost effective, highly performance tuned solution.
● Implemented parameter-based file delimitation changes, zip/unzip operation in Feed Framework.
● Implemented fixed width file loading to Prem SQL server / snowflake in generic pipeline.
● Implemented generic ADF components as well as custom logic for Cloud feed framework.
● Used most of data movement activities, data transformation activities and control flows for delivering the framework.
● SharePoint online connector is not available in ADF so Azure functions implemented the inbound, outbound, transformation.
● Designed CI/CD process to migrate the ADF code , DB objects , Azure functions web app codes , Power shell code to higher environment (UAT & PROD).
● Effectively managed request for quotation [Estimation], Client handling, Design proposal, Development of code with performance tuning, Quality assurance testing support, Deployment, and postproduction support.

IBM Tivoli Workload Scheduler (TWS)Microsoft SQL ServerData EngineeringETL Development

Cognizant

Data Engineer

May 2014 – Oct 2021 · 7 yrs 5 mos · Kolkata, West Bengal, India · Remote

● Took SME role in 5 major modules which comprised around 70% of the total ETL applications.
● Solved critical challenges and issues encountered in one of complex ETL applications within least stipulated time. Many times, customers greatly appreciated and acknowledge the efficiency of work.
● Took initiative to derive best approaches, prevention mechanism and solutions for the issues encountered in critical RS applications along with business. So that we could avoid such scenarios in future.
● Created Innovative Automation Scripts, which can reduce manual effort. Viz. – Automated File arrival gateway, Error analyzer and fixer, WH Mart sync check.
● Automation of daily reports through Informatica, UNIX scripting. Email alerts upon failures etc.
● Developed UNIX scripts to ftp files, archive, trigger workflow, creating parameter files and table to table load.
● Designed mappings in Informatica for the loading of the data in the Data warehouse from the system.
● Development and testing of ETL processes and components using Informatica.
● Handling team size of 5 Members