NITHIN THAPPALI SANKARLAL

• Managing E2E tool migration projects - Informatica PowerCenter to Informatica Cloud Data Integration
• Proactively identified potential bottlenecks in processes and implemented appropriate optimizations to mitigate performance impacts efficiently.
• Contributed to ongoing process improvement initiatives by suggesting and implementing innovative solutions that enhanced overall team productivity.
• Spearheaded migration of existing ETL processes to Informatica Cloud, ensuring seamless transition.

• Reported on updates to project specifications and progress
• Requirement analysis, ETL code implementation, Unit test, SIT, UAT, Code deployment and post production support
• Minimized resource and time losses by addressing employee or production issue directly and implementing timely solutions
• Coached team members in techniques necessary to complete job tasks

Project 1 (IICS - Data Integration) - Development role: Sep 2019 - Present

• Tool migration project - Metasuite to IICS
• Understood Metasuite code and implemented code in IICS to achieve same business logic
• Worked on end-to-end process including requirement analysis, designed ETL code, performed unit testing, designed jobs in UAC scheduler, created parameter values in Oracle DB, End-to-End job runs in scheduler, code comparison of Metasuite and Informatica, promoted code to higher environment, pre and post production support
• Involved in Business users meetings to understand requirements
• Actively performed code peer review
• Ability to meet deadlines and handled multiple tasks, decisive with strong leadership qualities, flexible in work schedules and posses good communication skills
• Involved in load testing and resolution of various bottlenecks came across in ST phase

Project 2 (Informatica PowerCenter - 10.2.0, 10.4.1) - Maintenance role : Aug 2020 - Feb 2022

• Provided L3 maintenance and support for around 24 systems
• Monitored daily, weekly & monthly batch jobs and triggered status notification e-mails to Stake holders and keep them updated
• Automated jobs in UAC scheduler to trigger monthly load files to Stake holders in order to avoid manual efforts
• Worked on change request for various systems and well versed to updated details both in Jira and ServiceNow
• Monitored ServiceNow for open incidents and provided resolutions with root cause and permanent solutions wherever needed
• Involved in Business users meetings to understand requirements for change request and to negotiate man-days for each ticket
• Collaborated with business intelligence staff to produce customized ETL solutions for specific goals
• Collaborated with multi-functional roles to communicate and align maintenance efforts

• Developed ETL programs using Informatica PowerCenter (9.6, 10.2.0 versions) to implement business requirements.
• Designed complex mappings that involved implementation of business logics to load data into staging database.
• Performed data manipulations using various Informatica transformations like Expression, Lookup, Aggregate, Joiner, Router, Source Qualifier etc,.
• Understood existing ETL code and worked on enhancement projects.
• Optimizing performance tuning at source, target, mapping and session level.
• Performed unit testing at various levels of ETL and actively involved in team code reviews.
• Effectively used Informatica parameter files for defining mapping variables and relational connections.
• Effectively worked in version based environment (GitHub) to migrate objects.
• Worked on Onsite and Offshore work model.
• Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.

• Applied honed problem-solving skills to analyze and resolve issues impacting business operations and goal achievement.
• Found and executed new ways to utilize analytics to drive business performance.
• Derived conceptual designs from business objectives to deliver software and applications according to specifications for usability, performance and functionality.
• Engaged client to gather software requirements/ Business rules, and ensured alignment with development teams.
• Innovated and implemented online platform to train clients on software which saved company on average of Rs.6,00,000+ per year.
• Identified and reconciled errors in client data to ensure accurate business requirements
• Drafted and maintained business requirements and aligned them with functional and technical requirements