PROFESSIONAL SUMMARY:

• Around 12 years of IT Experience in Analysis, Design and Development in various business applications as an ETL developer with major contribution in Informatica Power Center 9.x/8.x/7.x,PowerExchange and DT studio.
• Proficient in all phases of the System Development Lifecycle (SDLC) - Analysis, Design and Modeling, System Implementation, System Testing, Acceptance and Maintenance.
• Strong experience in the field of Data Warehousing with good understanding of the concepts of data modeling(relational and dimensional) and experience with data extraction, transformation and loading (ETL) using Informatica 9.x/8.x/7.x, DT Studio
• Experienced in Inmon and Kimball Methodology - Dimensional Modeling, SCD (Slowly Changing Dimension) Types- 1, 2, 3 and 6, Data Marts and data warehouses.
• Extensively worked on Informatica Designer Components- Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designers.
• Extensive usage of transformations-Expression, Aggregator, Filter, Router, Normalizer, Sorter, Lookup-Unconnected and Connected, XML transformations, Update strategy, Sequence generator, Stored Procedure, Joiner.
• Extensively used Informatica Power Center Workflow manager to create workflows and worklets, to run with the logic embedded in the mappings.
• Extraction of data from Source to Targets-Staging Area, Data Marts or Data Warehouse.
• Extensive use of Informatica Debugging in mapping and used Session Log File to trace the errors while loading into targets.
• Good in understanding Business process/requirements and translating them into technical requirements.
• Good Knowledge on OLTP and OLAP Systems, developing database schema (Dimension and Facts), E-R Modeling-Logical and Physical Modeling Concepts.
• Experience in different project methodologies such as Agile/Scrum and Waterfall.
• Experience in coding using SQL, PL/SQL Procedures/Functions, Triggers and Packages in Oracle.
• Hands on Experience in working with tools like Win SQL,SQL Developer and TOAD.
• Experience with diverse source and target systems like SQL Server, Oracle, DB2, Netezza, XML Files and CSV/Flat Files etc.
• Extensive experience in all aspects of Business Objects XI R2 using Designer, WebI, DeskI, Infoview and Crystal Reports.
• Worked closely with Architects while designing the Data Marts and Data Warehouses, With Business Analyst in understanding the business needs and interacting with other team members in completing the task as scheduled.
• Experienced in Scheduling Meetings with Business Users and Coordinating with offshore team.
• Enthusiastic and goal-oriented team player possessing excellent communication, interpersonal skills and leadership capabilities with high level of adaptability. A fast learner with an open mind to learning new technologies.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.x/8.x/7.x, DT-Studio

Data Modeling: Erwin 4.0/3.5, Star Schema ModelingSnow Flake Schema Modeling,: Fact and Dimensions TablesPhysical and Logical Data Modeling,: Oracle Designer

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005/2000, DB2, Netezza, COBOL, MS Access.

SQL Utilities: TOAD, SQL Developer, SQL Plus, Query Analyzer.

Languages: C, C++, SQL, PL-SQL, Unix Shell Scripting.

Operating Systems: Windows 2000/NT/XP/7, UNIX

Reporting Tools: Crystal Reports, Business Objects XI R2.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Informatica Developer

Responsibilities:

• Worked with business analysts and data modelers to understand the ETL requirements.
• Designed parameter driven Informatica mappings and sessions for extracting, transforming and loading data from various sources like Oracle, DB2, SQL Server, flat files into the targets.
• Designed and Developed complex mappings by using lookup, expression, update strategy, sequence Generator, Aggregator, Router, Stored procedure transformations.
• Created re- usable mapplets, worklets and used them in different mappings to streamline the process.
• Experience in using debugger to debug the mapping and check the data flow in the mapping.
• Implemented Slowly Changing Dimensions - Type I & II,junk,cross- and Fact tables in different mappings as per the requirements.
• Worked with the off shore team to gather the business requirements and also to communicate about the daily developments.
• Working with XML and XML Schema Definitions (XSD)
• Designed the ETL processes using Informatica to load data from Flat Files, XML Files and Excel files to Oracle Staging area.
• Used Informatica to create and organize various Metadata types, including legacy Source and Data warehouse Target data definitions and ETL jobs.
• Worked extensively on UNIX to create workflow schedules and to create mapping parameters.
• Extensively used PL/SQL for creating stored procedures, views and indexes on the tables.
• Worked extensively in identifying the Bottle Necks and fixing them and also fine tuned the mappings and sessions for better performance.
• Worked on SAP Business Objects XI R2 to create dashboard reports as per the requirements.
• Worked on Control-M Scheduler to schedule various Informatica jobs.
• Provided documentation which explained the various mappings that were developed and designed.
• Worked with Offshore team and involved in meetings with them to complete the task on weekly basis.

Environment: Informatica Power Center 9.1.0, SAP Business Objects XI R2, Informatica Data Analyzer 8.6, Oracle 11g, DB2, SQL/PLSQL, Windows XP,UNIX, Erwin 6.0, TOAD, Control-M agent

Confidential, NC

Informatica Developer

Responsibilities:

• Worked as a ETL Developer and Designed complex mappings by using lookup, expression, update strategy, sequence Generator, Aggregator, Router, Stored procedure transformations to implement complex logics while coding a Mapping.
• Closely worked with Business Analysis team and technical Analysis in gathering the requirements and created Functional and ETL specification documents. Authored LLD documents and Mapping documents for every Interface developed.
• Extracted data from flat files according to the requirement.
• Created re- usable mapplets, worklets and used them in different mappings to streamline the process.
• Generated queries for duplicate check and mandatory check using SQL, PL/SQL to check for consistency of the data in the tables and to update the tables as per the requirements.
• Performed tuning of Informatica sessions by implementing database partitioning, increasing block size, data cache size, target based commit interval and SQL overrides.
• Expertise in using debugger to debug the mapping and check the data flow in the mapping.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Used pmcmd commands to communicate with the Informatica server
• Created UNIX shell scripts automation of ETL processes.
• Tuned the Sources, Targets, Transformations and Mapping to remove bottlenecks for better performance.
• Involved in fixing Invalid Mappings, testing of Stored Procedures and Functions, Performance and Unit Testing of Informatica Sessions, Batches and Target Data.
• Performed code reviews with peers and created unit test plans document.
• Performed troubleshooting, debugging, root cause analysis and resolved application and environment issues.
• Deployed and monitored UAT and Production workflows to ensure completeness.
• Worked on Autosys Batch Job scheduling. Developed several .jil files to schedule informatica workflows on Autosys server.
• Provide performance tuning to system components as required to ensure optimum function of Informatica environments.
• Migrated repository objects and scripts from development environment to pre-production and production environment. Extensive experience in troubleshooting and solving migration issues and production issues.
• Created and managed daily, weekly and monthly data operations, workflows and scheduling processes.
• Assisted ETL developers on the ETL errors and resolve problems to reconcile extracted data to the source system.
• Coordinated with an offshore team to meet project deadlines and to provide ongoing operational support.
• Worked as the main point of contact for the QA team, analyzed all the defects if any, and fixed QA issues with priority.

Environment: Informatica Power Center 8.6, Oracle, Netezza, UNIX, AIX, OBIEE, Autosys, WinSCP, Filezilla, TOAD, SQL Developer, Oracle BI, Microsoft Visio, Windows Server 2003, Mercury Quality Center.

Confidential

Informatica Developer

Responsibilities:

• Worked on Informatica Power Center 7.3.2 - Used Source Analyzer and Warehouse designer to import the source and target database schemas and the Mapping Designer, Mapplets and Transformation Developer to map the sources to the target.
• Developed complex mappings to implement the business rules and logic using Expression, Lookup, Filter, Joiner, Rank, Router, Sequence Generator, Normalizer and Update Strategy transformations and tuned for better performance.
• Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level.
• Involved in Data Loading Sequence and Populated Data into Staging Area and Warehouse with Business Rules.
• Identified all the conformed dimensions to be included in the target warehouse design and confirmed the granularity of the facts in the fact tables.
• Extensively used ETL to load data from Flat Files to Staging area using Informatica Power Center.
• Worked with pre and post sessions, and extracted data from Transaction System into Staging Area.
• Developed complex mappings to implement slowly changing dimensions to maintain history
• Uploaded the data in incremental fashion by using batches & sessions on Informatica Server Manager.
• Created and modified UNIX shell scripts to automate the loading and execution of workflows and tasks.
• Extensively used the pmcmd command to schedule workflows and tasks.
• Performed unit testing on the mappings, sessions and workflows developed.
• Carried out performance tuning at various levels to improve the efficiency of the ETL process.
• Tuned the SQL Queries by Analyzing the Tables and enforced hints to improve the Query Execution Time.
• Used debugger and breakpoints to view transformations output and debug mappings.
• Migrated mappings, sessions from development environment to production environment.
• Lead discussions and decision-making groups in determining needs for subject areas.

Environment: Informatica Power Center 7.3.2, Oracle 10g/9i, SQL Server 2005, SQL*Plus, TOAD, PL/SQL, Erwin, Rational Clear case, Rational Clear Quest, UNIX, Business Objects