Informatica Developer Result oriented developer with experience in Design, Development, Implementation and support of Data Warehousing Applications for over 4 years. Experienced in complete Software Development Life Cycle (SDLC), software Testing Life Cycle (STLC), SDLC methodologies. Extensively worked on Informatica Designer Tools (Source Analyze, Warehouse Designer, Mapping Designer, Mapplet Designer, and Transformation Developer) and Workflow Manager Tools (Task Developer, Worklet and Workflow Designer), Workflow Monitor and informatica Power exchange. Experience in working with using Informatica in SAP HANA, Oracle, MS SQL, Teradata and DB2 environments. Working knowledge of integrating various ERP systems like SAP, Oracle APPs to RDBMS systems to like Oracle, MS SQL Server and SAP HANA. Experience on designing and developing mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, joiner, Update strategy, Transaction Control Transformation etc. Experience in integration of various data sources like Oracle, DB2, SQL Server, XML files and Flat Files into staging area. Also experience in Optimizing Database querying, data manipulation using SQL and PL/SQL in Oracle, flat files and SQL server database. Experienced in implementing Change Data Capture (CDC) using informatica Power Center for Oracle and SAP Systems. Experienced in debugging mapping by analyzing the data flow and evaluating transformations. Experienced in performance tuning of data flow through source, target, sessions and mappings, identifying and resolving performance bottlenecks at various stages using techniques like Database tuning and Session Partitioning. Experienced in test strategy, developing test plan, details test cases, and writing test scripts by decomposing business requirements, and developing test scenarios to support quality deliverables. Involved in test planning and execution for various Test Phases: Unit Test, System and User Acceptance Testing. Performed data profiling, data cleansing, data conversion, exception handling and data matching using informatica IDQ. Excellent communication skills, good organizational skills, self-motivated, hardworking, ability to grasp quickly and learn fast and open to new technologies.
Companies Worked For:
Job Titles Held: