Sandip Dey

Engineering Manager

Hyderabad, Telangana, India20 yrs 5 mos experience

Most Likely To SwitchHighly Stable

Key Highlights

14 years of experience in Data Warehousing solutions.
Expert in Teradata and Big Data technologies.
Proven track record in technical leadership and problem-solving.

Stackforce AI infers this person is a Data Warehousing and Big Data specialist with strong architectural skills.

Contact

Skills

Core Skills

Data WarehousingEtl

Other Skills

TeradataApache HadoopSqoopHiveHBaseInformaticaBusiness IntelligenceData ModelingSoftware Development Life Cycle (SDLC)Requirements GatheringData IntegrationExtract, Transform, Load (ETL)Requirements AnalysisShell ScriptingPL/SQL

About

A Datawarehouse specialist with overall 14 years of experience in DWH solution development using technologies like Teradata, Oracle and Unix and ETL framework across three business verticals Telecom , Banking and Manufacturing Domain . Have worked as an architect to develop technical solutions from business requirements. A proven track record for delivery and technical leadership with excellent problem solving skills. Technologies worked on : Teradata,Oracle,Unix, BigData,HDFS,Hive,Pig,Sqoop,spark,MapR Administration Specialties: Data Warehousing, Business Intelligence, Teradata, Oracle, BigData

Experience

Apple

2 roles

Engineering Manager

Promoted

May 2020 – Present · 5 yrs 10 mos

Lead Engineer

Mar 2019 – Apr 2020 · 1 yr 1 mo

Maersk global service centres

Lead Engineer

Apr 2018 – Feb 2019 · 10 mos · Bangalore, India

Ericsson

2 roles

Solutions Architect

Promoted

Sep 2012 – Mar 2018 · 5 yrs 6 mos

Worked as a Solution Architect of the project and provided end to end design and solution for multiple
requirements to integrate data from heterogeneous source systems and make them presentable using
Teradata and ETL framework.
Led the dev team and also worked as a contact point to end users .
Redesign and redevelopment of datawarehouse architecture that resulted in successful delivery and stable
solution.
Worked on a POC to perform Data Warehouse Tool Optimization by implementing a new solution through
Apache Hadoop 2.7 Ecosystem tools like Sqoop,Hive,Pig and HBase. Data got inducted from source systems
using Sqoop ,transformed in Hive and History data stored in HBase. Aggregated Summary data then sent to
Teradata for reporting. This approach brought in huge performance boost in one of the Analytical
platforms and got highly appreciated by Business Users. Plan is to induct real time Log Streams through
Flume and store data in No-SQL DB (HBase) and perform real time predictive analytics on that (May be
through Apache Spark).

TeradataETLApache HadoopSqoopHiveHBase+1

Senior Solution Integrator

Jan 2012 – Jan 2014 · 2 yrs

Worked as a Senior Solution Integrator of the project and provided end to end design and solution for multiple
requirements to integrate data from heterogeneous source systems and make them presentable using
Teradata and ETL framework.
Led the dev team and also worked as a contact point to end users .

Barclays technology centre india

Tech lead

Oct 2011 – Sep 2012 · 11 mos

Worked as a Techlead /Offshore Team lead and provided solution for data integration and adhoc reporting
requirements from the retail sector (Credit Card, Loan, etc) of the bank.
Worked closely with the data mining team to understand the requirements and provide the optimum
solution.

Infosys technologies ltd

Technology Lead

Jul 2005 – Sep 2011 · 6 yrs 2 mos · Cupertino California

Worked as onshore team lead for marketing data segment of Apple's biggest data warehouse (Customer
Base).
Worked closely with iTunes and Campaign Users to identify new data requirement and then provided end to
end delivery of the identified enhancement/development using Teradata .Oracle, Informatica and Unix.
Coordinated with offshore teams across multiple location to cater to complex business requirements that
needed handshaking across multiple segments.