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.