Not Available
User

Oracle Developer

BMT Score
84
84%
  • Remote

Available for

About Manoj

A performance driven ambitious software developer with an extraordinary blend of and technical knowledge. Ability to communicate and motivate team members to enhance strategic goals and bottom line objectives. Creative problem solving and troubleshooting skills complemented by meticulous attention to details that will result in the success of an organization by developing new applications or improving existing ones. 

Tech Stack Expertise

  • Tech Stack Expertise

    Oracle

    Oracle 10G

    0 Years
  • Tech Stack Expertise

    AWS

    Amazon AWS

    0 Years

Work Experience

Images

Snowflake Developer

  • January 2020 - January 2023 - 3 Year
  • India

Projects

Images

BPS Advantage (Retail Domain)

  • November 2022 - January 2023 - 3 Months
Technologies
Role & Responsibility
    Advantage is complex tool in BPS where all the upstream data can be classified into client centric and restore all the data into client data base. This migration projects help clients to take the necessary data from snowflake data base. Earlier data will be sent to several databases like SQL server and oracle.

    Responsibilities:

    Designed and implemented data pipelines in Snowflake.
    We have different source, SQL, SHARE POINT files, so by using snap-logic we are extracting data into snowflake stage.
    We will receive the CSV files as well, So by using COPY INTO command we load the data into snowflake stage.
    Good experience in integrations between AWS S3 and Snowflake and
    Applied optimization techniques on each query wherever possible.
    In-depth understanding of different kinds on caching in Snowflake.
    Good knowledge of Data Sharing in Snowflake.
    Strong Understanding of Snowflake Architecture and experience in Snowflake features like Clone, Time Travel, Stages, Fail safe Multi-Clustered Warehouse, CDC (Streams and Tasks), Role based Access Management, UDF.
    Involved in Daily Standup calls for continue development and integration Agile Methodologies.
    Involved in development of Prod/QA and QA/Dev data sync process ETL jobs for UAT.
    Involved in development of Audit ETL jobs for different modules.
     
...see less
Images

Sahara MDM (Retail Domain)

  • December 2019 - August 2020 - 9 Months
Technologies
Role & Responsibility
     The Implementation plan for Sahara involves migrating the data set Sybase to Oracle. During this transition period, there will be a delta feed from ODS into oracle on a periodic basis. The data from oracle will be synced back into a different copy of the ODS.


    Responsibilities:

    Understand the requirements for designing the BI Architecture and ETL Architecture.
    Good Experience in Talend Administration & Configuration in Windows and Linux Environments.
    Good Experience in Extraction, Transformation and Loading from Homogeneous and Heterogeneous Sources.
    Understanding the Business Data Mapping requirements and preparing the Tech. Design documents.
    Creation of Fact and dimension tables and bridge tables as per the requirements and source systems.
    Involved in developing ETL to extract data from multiple sources like files, Oracle database and Mssql server database.
    Designed ETL that contain business rules for extract, transform and load process using for staging and fact and dimension tables population.

    Responsible for migrating DDL and GIT code from Development to test, UAT & Production (deployments).
    Involved    in    Daily    Standup    calls    for    continue    development and integration Agile Methodologies.
    Involved in development of Prod/QA and QA/Dev data sync process ETL jobs for UAT.
    Involved in development of Audit ETL jobs for different modules.
     
...see less

Industry Expertise

Education

Education

in Bachelor of Engineering

Karnataka Unversity
  • June 2015 - June 2017

Our Suggestions