About Me
Currently working as software Engineer at Tech Mahindra with 5.2years of experience in Data warehousing, Reporting and Informatica ETL development.
... Show MoreSkills
Operating System
Database
Development Tools
Data & Analytics
Others
Software Engineering
Positions
Portfolio Projects
Company
Total One Stop Reporting for Healthcare
Role
Backend Developer
Description
TORCH is a critical application used by GE Corporate, for reporting and decision making on Insurance Domain. Basically Healthcare Project that deals with Claims ,Contributions, JEs and Invoices details of GE employees under various businesses under Dental, Vision and Medical. We replicate the data from OLTP to data warehouse through Informatica and support the users to create the reports through BO.
- Responsible for development of ETL code like mappings, sessions and workflows and performing unit testing, code reviews.
- Responsible for Developing UNIX Shell Scripts for file validations, executing jobs using pmcmd command and archival of files.
- Understand Technical specification, mapping document.
- Used Informatica Power Center V9.1, 10.1.0, 10.1.1 for extraction, transformation and load (ETL) of data in the data warehouse.
- Extensively worked on Transformations like Router, Aggregator, Joiner, Lookup, Update strategy, Sequence generator, Filter, Expression etc.
- Worked on Informatica Mappings, sessions and other tasks like Command tasks, Event Wait, Event Raise, Timer and workflows on business requirements.
- Worked on mapplets, worklets and also parameterized the mappings for increasing the re-usability.
- Involved in ETL job automation and scheduling using UNIX scripts/pmcmd.
- Report and resolve critical bugs analytically.
- Worked on Documentation , reporting in confluence
Show More Show Less
Skills
Business IntelligenceCompany
Accounts & Payable Data ware House (Buy to Pay)
Role
Backend Developer
Description
The Project loads data from different source systems and populates data into the B2P data warehouse for B2P metrics calculation. As per the requirement from the user, the ETL logic is developed to load data to B2P DWH for to cater data for different B2P metrics calculation.
- Responsible for development of ETL code like mappings, sessions and workflows and performing unit testing, code reviews.
- Responsible for Developing UNIX Shell Scripts for file validations, executing jobs using pmcmd command and archival of files.
- Understand Technical specification, mapping document.
- Used Informatica Power Center V9.1, 10.1.0, 10.1.1 for extraction, transformation and load (ETL) of data in the data warehouse.
- Extensively worked on Transformations like Router, Aggregator, Joiner, Lookup, Update strategy, Sequence generator, Filter, Expression etc.
- Worked on Informatica Mappings, sessions and other tasks like Command tasks, Event Wait, Event Raise, Timer and workflows on business requirements.
- Worked on mapplets, worklets and also parameterized the mappings for increasing the re-usability
- Involved in ETL job automation and scheduling using UNIX scripts/pmcmd.
- Report and resolve critical bugs analytically.
- Worked on Documentation , reporting in confluence
Skills
Business IntelligenceTools
Informatica SQL DeveloperCompany
Business Objects
Role
Backend Developer
Description
Business Objects deals with Creating Universes, Reports based on the requirements provided by the user with less complexity, which contains 23 applications.
Show More Show LessSkills
Business IntelligenceTools
SQL Developer