OnBenchMark Logo

Santhi Priya

Senior Data Engineer
placeholder
Location Hyderabad
view-icon
Total Views53
availability
Shortlist0
back in time
Member since30+ Days ago
 back in time
Contact Details
phone call {{contact.cdata.phone}}
phone call {{contact.cdata.email}}
Candidate Information
  • User Experience
    Experience 6.3 Year
  • Cost
    Hourly Rate$15
  • availability
    AvailabilityImmediate
  • work from
    Work FromOffsite
  • check list
    CategoryInformation Technology & Services
  • back in time
    Last Active OnJune 06, 2024
Key Skills
Data EngineerSnowflakeSQL
Summary

Project Title: RTB Role: Senior Data Engineer

Description : RTB project involves in Developing the new integrations and Enhancements to the existing integrations and as well optimizing the integrations in matilion and snowflake

 

Responsibilities:

• Designed and developed various Matillion jobs like flat file load, database loads, API based integrations, Big Query data load to Snowflake.

• Developed the SnowSQL scripts to find out the duplicates inthetable level.

• Implemented Audit mechanisms for Matillion jobs and created the common frame work jobs for Flat file loads and database loads

• Worked on various credit optimizations tasks on snowflake data warehouse.

• Enhanced the few of the BODS jobs and migrated them from BODS to Matillion.

• Replicated the some of the tables to snowflake using perspectium. Environment: Matillion, Snowflake, Python, SQL ,BODS ,Perspectium

 

Project Title: HCM (WasteManagement) Role: Snowflake/ Matillion Developer

Description : HCM involves Employee payroll related data for different regions. The main focus of the project is migrating the data from people soft data to HCM cloud

 

Responsibilities:

• Designed and developed Matillion jobs to load data into various Snowflake tables.

• Developed the SnowSQL scripts to Validate, Cleanse, and Standardize and summarize the data.

• Implemented Error handling for Matillion jobs and worked on different methods of logging mechanism.

• Created a shared jobs for reusability of error framework and HCM loads.

• Implemented the python script for triggering the HDL jobs to oracle cloud.

• Worked with different file formats like fixed width, Flat files, semi structured date.

• Used the various components like truncate, S3Load, S3Unload, SNS,DataTransfer, Detect Changes ,filter ,SQL ,Excel Query ,Python ,Bash Script, API Extract etc. Environment: Matillion, Snowflake, AWS. ………………………………………………………

Copyright© Cosette Network Private Limited All Rights Reserved
Submit Query
WhatsApp Icon