DBS 2.0, Thai, AU Duck Creek, Chubb, Team Lead, 07/2021 - Present, IICS, Informatica 10.2.0, SQL, Responsibilities:
Working on IICS Code, writing SQL Queries.
Making a changes in informatica mappings or creating new mappings
Making a presentation for clients on weekly basis and presenting it infront of them.
Taking daily calls with team and clients.
Monitoring of all the informatica and IICS batches.
Working on ETL Process
Developed ETL Mappings, Sessions, and Workflows using various transformations like Expression, Update strategy, Lookups, Filters, Routers, and Joiner transformations etc. LeadIQ, Morgan Stanley, ETL Developer, 07/2018 - 07/2021, Informatica 10.2.0, Hadoop, Unix(Basic), LeadIQ is web based application for assigning the participants to specific FA(Financial Advisors) based on regions and wealth. There are different companies involved. Also automatic blocking and expiring of participants happens here.
Responsibilities:
Writing code in hadoop and promoting it in qa-qa1 environment
Making a changes in informatica mappings or creating new mappings
Monitoring of all the informatica and hadoop batches.
Working on ETL Process
Developed ETL Mappings, Sessions, and Workflows using various transformations like Expression, Update strategy, Lookups, Filters, Routers, and Joiner transformations etc. Informatica Cloud, Morgan Stanley, IT Developer, 07/2016 - 2018, Cloud, Responsibilities:
Creating Users and giving permissions
Creating and managing secure agents for all the environments
Working on ETL Process.
Working on putty for managing secure agent
Creating native and SAML users Morgan Stanley, Morgan, Application Support, 07/2014 - 06/2016, Windows 7, 10, In this project mainly work was on supporting the application related issues like installing of software, handling server, assigning virtual machine , scheduling server related , VM related activities
Responsibilities:
Worked with users to solve the application related issues or physical issues
Worked on Virtual Machine.
Worked on physical servers to get the issues sorted.
Involved in the discussion with Customer to understand the requirements