Experience

Tata MD

• India
• Hospitals and Health Care
• 100 - 200 Employee

• Sr. Software Developer

  • Jan 2021 - Present

   Have worked and developed sql scripts for data pulling from source system.  SQL scripts developing as well as reporting to customer every day.  Effectively worked on Mapping Designer, Workflow Manager, and Workflow Monitor.  Responsible for Unit test case writing and testing the data.  Creating and modification of dashboards in Metabase reporting tool.  Developed full run scripts into incremental scripts as one time activity.  Scheduling the jobs as per client requirement in crontab file.  Creating new tables and adding the data as source from excel formats then creating new dashboards for that.  Any new table added in the source system same to be deployed in the production as well. Show less



Axa Business Service Private Limited

• India
• Consumer Services
• 500 - 600 Employee

• Software Developer

  • Dec 2015 - Sep 2020

   Created mappings using Joiner, Sorter, Union, Filter, Router, Aggregator and Lookup. Implemented and Tested Slowly Changing Dimension - SCD Type 2.  Good command on Power center Designer, Workflow Manager and Workflow Monitor. Extensively worked on Informatica Power center Designer like Source Analyzer, Target Designer, Transformation Developer, Mapplet Designer and Mapping Designer. Good hands on in UNIX Environment. Worked on UNIX environment while reading the files and for archival process. Developed different mappings by using different Transformations like Aggregator, Lookup, Expression, update Strategy, Joiner, Router etc to load the data into staging tables and then to target. Scheduling, Monitoring and Debugging of Informatica Sessions and Workflows. Involved in preparing Unit test cases in source system then checking count in dev and prod environments. The Informatica mappings within those batches would then populate the staging tables. Show less

• Outlook Administrator

  • Dec 2013 - Nov 2015

  Worked as an outlook administrator, fixing issues and troubleshooting.Maintaining & managing of outlook errors.