Informatica Exposure Details• Creating Sources, Targets, Mappings, Mapplets, Transformations in Power Centre Designer• Designing and developing complex and super complex mappings, tasks, worklets and workflows in Power Centre Workflow Manager• Troubleshooting invalid mappings and fixing the technical problems. Debugging sessions by utilizing the logs• Proficient in using various transformation logics by utilizing the expression, filter, joiner, aggregator, lookup, router &… Show more Informatica Exposure Details• Creating Sources, Targets, Mappings, Mapplets, Transformations in Power Centre Designer• Designing and developing complex and super complex mappings, tasks, worklets and workflows in Power Centre Workflow Manager• Troubleshooting invalid mappings and fixing the technical problems. Debugging sessions by utilizing the logs• Proficient in using various transformation logics by utilizing the expression, filter, joiner, aggregator, lookup, router & rank• INFA Admin Tasks to grant users permissions on objects and trouble shoot services (IS, RS etc.)Responsibilities & Duties• Review functional specifications for completeness & accuracy prior to accepting into the development stream• Attend business meetings to understand the business requirements• Responsible for all issues related to the design of the enhancements• Develop and Deploy the super complex and complex ETL INFA workflows• Designing Maestro jobs to schedule the ETL processes as per project requirement• Use Informatica code review tool to review of all ETL objects including mappings, sessions, tasks and workflows• Writing Functional Specifications for various change requests (for simple and medium level mappings)• Performing UAT/SIT testing before change deployment to production• Tuning the informatica code to reduce the run time of workflows• Providing all the possible solutions along with the best approach option in terms of business profitability / process optimization to the clients• Responsible for all Knowledge Transfer Activity for any new team members. Mentoring and guiding them for any application/process related queries. Also preparing KT documents and reusable knowledge solution for references. Show less

ICAS: This project basically deals with the Investment related data. We are responsible for doing enhancements for system improvement and automation of processes.Responsibilities: Technical• Designing interfaces using INFORMATICA for the existing Data Warehouse• Writing Stored Procedures, developing ETL mappings, creating jobs in ZEKE and Also hands on experience of Charm etc.• Preparing the Detailed Design doc from the Business Requirement Document• Using Serena… Show more ICAS: This project basically deals with the Investment related data. We are responsible for doing enhancements for system improvement and automation of processes.Responsibilities: Technical• Designing interfaces using INFORMATICA for the existing Data Warehouse• Writing Stored Procedures, developing ETL mappings, creating jobs in ZEKE and Also hands on experience of Charm etc.• Preparing the Detailed Design doc from the Business Requirement Document• Using Serena Dimensions for version control• The support and development teams are clubbed so in my current role I work on the Development Projects and support the existing system in parallel• Worked on enhancements needed to automate the existing system and add value to business• Development - Involved in designing new mappings and workflows for the existing Data warehouseResponsibilities: Functional• Responsible for holding the weekly status meetings for all the projects going under the Investment team as a whole and then sending out the consolidated status report to the Business Partners• From support perspective, involved in resolving production abends, including workflow failures and Report related issues• Worked on Understanding the Investment Business data and the Business processes Show less

Roles performed• ETL Developer• Deployment, Implementation member• Support Executive, Shift Lead• Issue analyst and functional mentorResponsibilities: Technical• Analyze, Design, Develop and Deploy the ETL INFA workflows• Designing Control-M jobs to schedule the ETL processes as per project requirement• Use Informatica code review tool to review all ETL objects including mappings, sessions, tasks and workflows• Prepared daily ETL status reports… Show more Roles performed• ETL Developer• Deployment, Implementation member• Support Executive, Shift Lead• Issue analyst and functional mentorResponsibilities: Technical• Analyze, Design, Develop and Deploy the ETL INFA workflows• Designing Control-M jobs to schedule the ETL processes as per project requirement• Use Informatica code review tool to review all ETL objects including mappings, sessions, tasks and workflows• Prepared daily ETL status reports using oracle queries and publish it to client community and leadership• Finding process bugs/bottlenecks, reproducing them (in non-PROD env.) and reporting it on incident tools (Helpzilla / SFDC CRM)• Perform/Assist in peer reviews for deliverables and other Technical SpecificationsResponsibilities: Functional• Review functional specifications for completeness & accuracy prior to accepting into the development stream• Attend business meeting to understand the business requirements and responsible for all issues related to the design of the enhancements• Analysing client requirements and translating them into project’s high level plan• Writing Functional Specifications for various change requests• Performing UAT/SIT testing before change deployment to production• Root Cause Identification of the critical production load and data issues• Responsible for all Knowledge Transfer Activity for any new team members. Mentoring and guiding them for any application/process related queries. Also preparing KT documents and reusable knowledge solution for references. Show less