Gurpreet S.

Gurpreet S.

Data Engineer

Gurugram , India

Experience: 10 Years

Gurpreet

Gurugram , India

Data Engineer

25356.6 USD / Year

  • Start Date / Notice Period end date: 2022-02-21

10 Years

Now you can Instantly Chat with Gurpreet!

About Me

Data Analysis, Data cleansing, Data transformation, Data Integration.

Informatica Powercenter, Talend Data Integration, PL/SQL, Unix Scripting, Power BI, Neo4j, VBA

...

Show More

Portfolio Projects

Account recon

Company

Account recon

Description

Banking reconciliation – Data store created for American multinational conglomerate company by integrating banks and third parties for reconciling financial transactions.

 

Project roles/responsibilities:

 

  • Coordination with client for requirements specifications.
  • Enhancing and developing Talend interfaces, PLSQL code for data movement.
  • Providing L2 support for the project by resolving talend issue and reported data issues.
  • Ensuring the daily data ingestion is completed without any issues.
  • Managing team of 4 members.
  • Technologies used is Talend Studio for Big Data , MS-SQL server, VBA, TAC, Unix.

Show More Show Less

Marketing Warehouse – Datawarehouse used by insurance company to sell its products

Company

Marketing Warehouse – Datawarehouse used by insurance company to sell its products

Description

Project roles/responsibilities:

    • Coordinating with client for requirement gathering.
    • Development of ETL interfaces, SQL blocks and unix scripts for data movement.
    • Enhancement of existing ETL jobs.
    • Creating test case for ETL scripts and SQL queries.
    • Deploying the code in production and scheduling as per requirements.
    • Creating SQL queries for data validation and tuning SQL performance.
    • Code migration from environment to other following best practices.
    • Providing L2 support for the datawarehouse and fixing issue passed by L1 support team.
    • Following Etl best practices, methodologies and other recommendations.
    • Creating Design document, Test case document as per standard followed in the project.
    • Technologies used is Talend, Informatica, Unix, Oracle 12c, TAC.

       

Show More Show Less

Medical Staging Area Database – Medical Staging Area is the hub of clinical data

Company

Medical Staging Area Database – Medical Staging Area is the hub of clinical data

Description

 

    • Meeting with client to understand the requirements.
    • Creating project plan, roadmaps, performing feasibility analysis for new interface, providing the estimates to client.
    • Leading team of 10 associates.
    • Responsible for project progress tracking and involved in migration tasks for proper delivery.
    • Coordinating with onshore team business team for requirement gathering.
    • Development of informatica interfaces, SQL code blocks and unix scripts for data movement.
    • Modified existing ETL scripts to fix defects at root cause as enhancement part of project.
    • Performing unit testing, end to end integration testing for ETL scripts.
    • Analyzing the existing workflow and tuning their performance.
    • Providing suggestions for existing bugs and fixing them.

Technology used is Informatica, Oracle 12c, Unix, HP-ALM

Show More Show Less