OnBenchMark Logo

Sateesh

Lead Data Engineer
placeholder
Location Bengaluru
view-icon
Total Views32
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 7 Year
  • Cost
    Hourly Rate$9
  • availability
    AvailabilityImmediate
  • work from
    Work FromOffsite
  • check list
    CategoryInformation Technology & Services
  • back in time
    Last Active OnMay 08, 2024
Key Skills
SDLCSQL Server Postgress SQL
Summary

Work Experience

 

✔       Working as a Lead data engineer  in Sonata Software Ltd. From Dec 2019 to till date.

✔       Worked as an Engineer – IT in SLK software services Pvt. Ltd. From Nov 2017 to Dec 2019

✔       Worked as an ETL Developerfor IBM India Pvt Ltd Bangalore from Dec 2014 to Jul 2017.

 

Project Details:

 

1.     Title: PennyMac- Kanan-BI-Reporting: Kanan-Hub-Extracts                    Duration: Dec’19 to till Date

Team Size: 20                                                                                Role: Consultant and Lead Data                                                                                                             Engineer

Client: PennyMac Bank, US

Environment: Informatica Intelligent cloud services, Snowflake, SQL server, Postgress SQL, SFMC, Python,AWS-S3 and LAMBDA , Sumo Logic, Tableau, New relic and Kirby

 

Description:

 

PennyMac is a leading national home loan lender and servicer in the USA committed to providing a superior mortgage experience from start to finish. As an online lender, PennyMac specializes only in home loans: conventional, FHA, VA and investment property loans to focus on your needs as a homeowner instead of cross-selling other financial products.

           Kanan-Hub-Extracts project is about extracting the data from Ellie-Mae Source systems and Load them on to the PostgreSQL database and type was SCD type1 and SCD type 2 eventually called as single state and multistate.

           Kanan-BI-Reporting LoanLogics is using mail-room integration which uses LAMBDA that triggers when AWS SQS receives a message, processes them and calls Informatica cloud application integration service REST API Call with the required payload. These payloads are used by the IICS application integration process to download the loan XML files. Further python script parses the XML, Loads the hub tables and stored proc is used to refresh the views for business reporting.


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