Sachin Shetty

Data Engineer

Bengaluru, Karnataka, India13 yrs 1 mo experience

Most Likely To SwitchHighly Stable

Key Highlights

Over 9 years of IT experience in data engineering.
Expertise in building ELT pipelines and data models.
Strong background in Agile methodologies and team coaching.

Stackforce AI infers this person is a Data Engineer with expertise in Fintech and SaaS industries.

Contact

Skills

Core Skills

Data EngineeringAgile MethodologiesData Analysis

Other Skills

AirflowAmazon S3BAMBOOBIT BUCKETBig DataCONTROL-MCloud AdministrationCloud DevelopmentData Build Tool (DBT)Data ModelingEndeavorGCFRGIT HUBIBM MainframeIBM Tivoli Workload Scheduler (TWS)

About

Over 9 experiences of IT experience, with proficiency as Teradata Developer/Database developer, expertise in SQL queries, Analysis, Design, Development, Documentation, Deployment and Integration. Technical Skills : 1. Language : Sql, Unix, Python 2. Database : Teradata, Oracle, MS-sql 3. Cloud Platform : Azure Fundamentals 4. ETL Platform : Gcfr, Informatica, TTF 5. Big Data Technologies : PySpark 6. Tracking Tools : Github, Mainframe - Endevor, Jira, Bitbucket, Service now 7. Scheduling Tools : Control -M, IBM tws, Mainframe -Zeeke 8. CICD Tool : Bamboo 9. Reporting Tool : Qlik Sense 10. Other tool and Utilities : Knime, Datamover, Confluence, Sharepoint, Sql, Fload, Mload, BTEQ, Viewpoint, JCL (JOB CONTROL LANGUAGE)

Experience

13 yrs 1 mo

Total Experience

4 yrs 4 mos

Average Tenure

4 yrs 11 mos

Current Experience

Anz

Lead Data Engineer

Jul 2021 – Present · 4 yrs 11 mos · Bengaluru, Karnataka, India

PROJECT :Digital and Marketing Data Insights
ROLES AND RESPONSIBILITIES:
LEAD ENGINEER AND SCRUM MASTER
1. Working on building ELT pipelines and dashboards for campaign data to analyse, revenue, performance and other vital KPI’s, hence impacting business decisions .
2. Creating data models for data collected from internal, digital and vendor platforms.
3. Building customised data assets which are used as inputs for machine learning models.
4. Analysing customer feedback data , sharing reporting and insights using Net promoter system(NPS) with senior stakeholder engagement and presentations, quantitative research design ,program management.
5. Building voice of customer platform(VOC) high volume campaign, survey, data management and dashboard solution that provides customer feedback reporting and analytics to frontline bankers ,head office cross-functional team and senior executives.
6. Specific highlights of this role was my focus on uplifting the data engineering capabilities within my team and our stakeholders by leading the project to integrate Voice of Customer data with the organisation’s primary data warehouse .
7. Coaching team about sense of their project ownership ,that processes are followed and that team are self managed under Agile processes.
8. Hosting daily stand up meeting to estimate the tasks , to track team progress , and notes that any obstacles that may keep the team from completing the tasks .
9. Assisting Product Owner to maintain product backlog using the information gathered from daily stand up meetings , writing user stories.
10. To help the team stay focused on the tasks that need to be done during each iteration.

Microsoft SQL ServerGCFRPython (Programming Language)JiraAgile MethodologiesKnime+13

Teradata

Sr Data Engineer

Apr 2017 – Jul 2021 · 4 yrs 3 mos · Mumbai, Maharashtra, India

PROJECT: Sales and Service Executive (SSE) - RBC[ROYAL BANK OF CANADA]
ROLES AND RESPONSIBILITIES :
DATA ENGINEER
1. Understanding requirements from business users and source system & doing effort estimation.
2. Strong Analytical, collaboration, communication, business process modeling technique and problem solving skills on project leveraging both traditional waterfall and Agile project management methodology with local and onshore teams.
3. Data Sourcing from different source systems including Teradata/Oracle/Hadoop/File.
4. Create, enhance and maintain metric to support Regional Banking Initiatives.
5. Ability to create and Interpret high level Business requirements into the detailed functional and technical specification.
6. Responsible for Requirement/ Impact Analysis, Development, Unit Testing and Implementation. Successfully projected the concept of using generic program for multiple modules.
7. Creating python scripts for EDA and pre-processing of csv files.
8. Responsible for maintaining and performance tuning of Teradata SQL.

IBM MainframeJob Control Language (JCL)Python (Programming Language)JiraEndeavorTERADATA - DATA MOVER+4

Accenture

Software Engineer

Feb 2013 – Jan 2017 · 3 yrs 11 mos · Mumbai, Maharashtra, India

PROJECT : RASC[REPORTING AND ANALYTICS SERVICE CAPABILITIES , BESTBUY INC
ROLES AND RESPONSIBILITIES :
SOFTWARE DEVELOPER
1. RASC - Reporting and Analytics Service Capabilities, a centralised group responsible for maintaining the consistency of Best Buy’s analytical capability by providing critical information about performance to business operators from store level to the corporate level.
2. It ensures the availability of the highest quality data in the BI-DW environment that enables business value generation to BI-DW stakeholders.
3. Purpose of the block is to have established processes in place where all BI-DW data is objectively measured for accuracy, enabling proactive and continuous improvement.
4. Data Architect for Design and development of data quality Tools. Coordinate with cross-functional teams in different locations for quality data and analysis.
5. Architecture and design support to provide quality controls on critical business data sets. Create ER diagrams and conceptual, logical, physical data models. Design and implement a data model for Data Quality Audits. Develop data strategies and roadmaps for Data Governance.
6. Analyse the current data movement process and procedures. Interact with technical and business analyst, operation analyst to resolve data issues.
7. Creation of BTEQ, Fast export, Multi Load, Fast load scripts for extracting data from various production systems.
8. Analysed massive and highly complex data sets, performing ad-hoc analysis and data manipulation. Define and maintain metadata, data sources and set up Validation rules.
9. Develop a scalable architecture for staging and loading data using Teradata database. Provide data quality process improvement strategy. Analyse and recommend enterprise data warehouse data quality controls. Design and development of data controls.