Role and Responsibilities: Informatica PC/BDM Developer• Analysing the requirements sent by the Data Architects Team to understand it from business perspective & provided the client with estimates to work in agile methodology.• Using Informatica PowerCenter 10.1.1 and Informatica BDM 10.2.1 to implement SCD2 logic with different business logics.• Preparing design document’s as per the requirements & designing mappings/sessions/workflows or any Unix Scripts/parameter file to process the data.• Load the data from Hadoop system to Teradata table tables.• Automated the entire batch jobs from landing tables to Data warehouse using Autosys.• Creating the hive, Teradata Sql queries to verify data accuracy in different layers.

Roles & Responsibilities: Informatica Developer• Experienced in Informatica 9.6/9.5.1 • Involved in Requirement Gathering and Business Analysis• Possess good knowledge on Informatica Designer. Have developed mappings with Transformations like – Rank, Aggregate, Update Strategy, Joiner, Connected Lookups, Unconnected Lookups, Expression, etc., in lower/prod environments• Automated the entire batch jobs from landing tables to Data warehouse using Autosys.• Performed unit testing at various levels of the ETL and actively involved in team code reviews.• Inducted the level 2 team and the new joiners to the team on Functional knowledge.• Preparing root cause analysis for the issues and taking necessary actions to prevent them in future• Supported the team with high flexibility during critical production implementations• In addition to the above, actively involved in release activities, preparation of Knowledge base, quality assurance

• Experienced in Informatica 9.5.1 • Involved in Requirement Gathering and Business Analysis• Possess good knowledge on Informatica Designer. Have developed mappings with Transformations like – Rank, Aggregate, Update Strategy, Joiner, Connected Lookups, Unconnected Lookups, Expression, etc., in lower/prod environments• Handled ETL issues in critical applications as part of my daily activities. This included fixing batch failure, data issues in the reporting tool (SAP BO X1 3.1 SP5), exploring the design and analyzing data flow as and when need arises.• Performed unit testing at various levels of the ETL and actively involved in team code reviews.• Extensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks• Trained and worked on Fusion HCM Applications including Fusion Person Management, Core HR, Goal and Performance Management, Absence Management, Talent Management for 1 year• Inducted the level 1 team and the new joiners to the team on Application knowledge.• Preparing root cause analysis for the issues and taking necessary actions to prevent them in future• Supported the team with high flexibility during critical production implementations• In addition to the above, actively involved in release activities, preparation of Knowledge base, quality assurance