Nihar Ranjan Routa

Currently working as an Informatica Developer in a Finance project, focusing in designing and building complex ETL mappings, tasks, and workflows using Informatica PowerCenter and BDM. Responsible for comprehensive documentation, including unit test document, detailed specifications, facilitating approval processes from client chief architecture. Utilized Jenkins pipeline for automated deployment of ETL solutions developed with Informatica PowerCenter, Linux and BDM, ensuring efficient and reliable deployment processes. Adapted Agile methodology to collaborate closely with clients and data modelers, ensuring alignment with project requirements and delivering high-quality code within project timelines. Spearheaded comprehensive unit testing procedures within TWS framework, overseeing the execution of job streams to guarantee the precision and dependability of ETL processes. Solely responsible for conducting rigorous testing of developed solutions, including diverse test case scenarios, to preemptively identify and rectify potential issues prior to deployment in production environments ensuring seamless integration and functionality of ETL.

Supported around 720 SAP BODS interfaces, 3500+ batch jobs & about 1200 Informatica Interfaces which are scheduled using Autosys. Incident reduction and stabilizing the existing production environment. Anchor for the Problem management process which involved analysis of the critical defects/issues for the problem investigation and proposing permanent solution. Incident resolution of all the modules of project within the agreed SLA and target KPIs using Service Now. Efficiently handled the change management process by approving/Rejecting CRQs as per the business impact. Data Investigations, job fine tuning, performance tuning, working with development team for documentation and knowledge transfer are part of day-to-day tasks.