Work History
Overview
Education
Skills
Summary
Certification
Generic

Vineetha Jacob

Bengaluru,KA

Work History

Data Engineer

Tata Consultancy Services
Bengaluru, KA
05.2023 - Current

The LEAP D&A Legacy Migration project is to re-platform and modernize WBA data systems, leveraging Microsoft Azure capabilities, for the business to focus on core functions, leveraging cloud capabilities.
The project objective is to ingest and curate retail data domains from the existing Hadoop/DB2 environment to the Azure environment and build a Global Data Hub.
Design and implement migration strategies for traditional systems onto the Azure platform.
Develop an Azure Data Factory pipeline for on-cloud ETL processing.
Build complex stored procedures to facilitate efficient data manipulation and consistent data storage according to the business rules.
Improved database performance and loading speed by 80% through SQL query optimization.
Hide Description

Data Engineer

Tata Consultancy Services
Bengaluru, KA
07.2019 - 08.2022
  • Worked as a Data Engineer Major Commercial client based out of NZ, Involved in development activities for various use cases
    Build a metadata driven ADF ingestion framework which extracts data from different source systems namely SAP, network drive, manual files, Teams Folders and API etc
    And orchestration of databricks notebooks using ADF and performed advanced transformations with Azure Databricks
    Loaded transformed data into Azure SQL Server databases, ensuring optimal performance and adherence to data governance standard

ETL Developer

Tata Consultancy Services
Bengaluru, KA
05.2015 - 02.2017

1)To develop DMX-h ETL codes for Hadoop control checks to validate various Hadoop files.

2) To develop DMX-h Map Reduce Jobs to run on a Hadoop cluster using various functions like copy, sort, merge, aggregate,lookup

3) Worked on Hive tables to load data, applied extraction logic on data and storing data into Hive target table for analysis.

4)Used Change Data Capture (CDC) to simplify ETL in data warehouse applications.

5)Involved in design and creation of Hive table and View schema.

6) To develop Autosys scripts for Job execution, controlling, scheduling and monitoring.

7) To develop Unix scripts to run DMX jobs to load Teradata Target Tables

SQL Developer

Tata Consultancy Services
Kochi, KL
08.2012 - 02.2015
  • 2)Created Tables, Users,Views, Constraints, Index, Programmed packages, Stored Procedures, Functions.

    3)Successfully handled the needs of access grants,resolving deadlock issues.

    3)Unit and System testing, Performance tuning.

    4)Worked extensively on Ref Cursor, Collections, Dynamic SQL

    5)Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

    6)Understanding the requirements and carrying out impact analysis.

    7)Involved in integration testing, Issue Resolution and bug fixing

    8)Designed and coded application components in an Agile environment.

    9)Applied DB scripts as patches using Maven – SQL plugin and DB deploy(Continuous Integration Tool).

Overview

14
14
years of professional experience
6
6

Certifications

Education

B.Tech -

TKM College of Engineering
Kerala
06.2007 - 05.2011

Skills

  • SQL
  • PL/SQL
  • Microsoft SQL Server
  • Microsoft Azure
  • Azure Data Factory
  • Azure Synapse Datawarehouse
  • Azure Data Lake
  • Microsoft Fabric
  • Linux Shell Scripting
  • Git

Summary

  • Accomplished IT professional with over 10 years of experience in application development and enhancement across high-impact domains such as Retail, EIS, and Life Sciences.
  • Expertise in SQL and PL/SQL programming, including the creation of complex queries to drive business insights, and optimize data management.
  • Proven ability in developing and optimizing T-SQL and PL/SQL queries by efficiently joining multiple tables, and designing stored procedures, views, triggers, and functions to ensure high-quality data manipulation and storage, aligned with business rules.
  • 3.5 years of experience working with cutting-edge Microsoft Azure technologies, including ADF, Azure Synapse Data warehouse, and ADLS, to build scalable, cloud-based solutions.
  • Skilled in developing Azure Data Factory pipelines for ETL processes, implementing automated job scheduling, and facilitating seamless data transfers between diverse sources and destinations.
  • Extensive experience with Microsoft Fabric, driving the development of data pipelines, and working with lakehouse architecture to enable data transformations using PySpark.
  • Expertise in architecting and implementing cloud migration strategies for seamlessly transitioning traditional on-premise systems to Azure Cloud, improving scalability and performance.
  • Adept in agile methodologies, ensuring iterative development and quick adaptation to changing business requirements.
  • Demonstrated leadership and collaboration skills, with a strong ability to guide cross-functional teams and cultivate a high-performance team environment.
  • Involved in all stages of the SDLC, from analysis and design to development, testing, implementation, and ongoing maintenance, delivering projects on time and within budget, despite aggressive deadlines.

Certification

• Microsoft Certified: Azure Data Fundamentals(DP-900)

• Microsoft Certified: Azure Solution Architect(AZ-303)

• Microsoft Certified: Azure Fundamentals(AZ-900)

• Microsoft Certified: Azure Administrator(AZ-104)

• Oracle Certified:PL/SQL developer

Similar Profiles

CREATE PROFILE
Vineetha Jacob