SUMMARY

• Over 7 years of extensive professional experience in Information Technology with strong background in Data Warehousing in all facets of architecture, ETL design and ETL development.
• Technical proficiency includes installation, configuration, administration, maintenance, monitoring, troubleshooting and on - going technical support for Informatica PowerCenter 9.x/8.x/7.x and client components in different environment.
• Extensive experience in analyzing, designing and developing Extraction, Transformation and Load (ETL) processes for Data Warehousing/ Decision Support System(DSS) using ETL tool, Informatica PowerCenter 9.x/8.x/7.x which includes Designer, Repository Manager, Workflow Manager and Workflow Monitor.
• Extensively expertise in developing data mapping using various transformation of Informatica PowerCenter like Source Qualifier, Joiner, Filter, Router, Expression, Aggregator, Lookup (Connected and Unconnected), Rank, Normalizer, Sequence Generator, Transaction Control, Union, Update Strategy, Java, XML, Normalizer etc.
• Expertise in planning, designing and developing Enterprise Data Warehouses with the sound knowledge of logical and physical Dimensional Modeling concept Star/ Snowflake Schema, fact and dimension table, OLAP tools and proficient in indentifying facts, measures and dimensions.
• Proficient in data warehousing technique for Data Analysis, Data Profiling, Data Cleansing, Transformation, Consolidation, Integration, Data Import, Data Export using various source ( Flat files, Oracle, MS SQL Server, IBM DB2, Teradata and XML) and target.
• Extensively worked with PL/SQL procedures, functions, packages, trigger, cursor and exception handling with hands-on experience in performance tuning of Oracle using SQL trace, SQL plan, SQL hints, creating appropriate indexes, Query optimization, utilizing table spaces, Oracle partitioning schemes and join types.
• Expertise in handling simple to complex mappings and SQL queries performance and optimization issues identifying and eliminating different types of processing bottlenecks (I/Os, CPUs) involved with mappings, sessions and workflows.
• Expert in UNIX shell scripts, pmcmd command and third party tool Autosys for scheduling workflows, collecting the session statistics and task detail and to interact with Informatica server.
• Strong knowledge in ETL tool SQL Server Integration Services (SSIS).
• Expertise in production support with strong troubleshooting, problem determination and resolution skill for development, testing, pre-production and production environment.
• Highly motivated with a strong analytical problem solving skills, ability to work in a team environment interacting with business users, business analysts, IT leads and developers in analyzing business requirements, translating requirement into functional and technical design specifications.
• A good team player with excellent communication, presentation and interpersonal skills and ability to prioritize and coordinate work across different geographic locations

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x/7.x/6.x (Designer, Workflow Manager, Workflow Monitor, Repository Manager)

Methodologies: Data Modeling Logical/ Physical, Star/ Snowflake Schema, Fact & Dimension Tables, ETL, OLAP, Agile, RUP, SDLC, ERWIN 7.x/4/x, De-normalization techniques, Kimball & Inmon Methodologies.

Operating System: UNIX(AIX 5.x/5.0, Solaris, HP-UP), Linux( Red Hat Enterprise Server 5.x/4.x, Suse 9.x), Windows NT/2K/XP

Web Servers: IBM HTTP Server, Apache 2.x/1.3.x, IIS 6.0/5.x/4.0, Sun ONE (iPlanet) Web Server, Tomcat Apache

Databases: Oracle 10g/9i/8i/8.0, Teradata, IBM DB2M, Sybase, SQL, PL/SQL, SQL*Plus, SQL*Loader, MS SQL Server, MS Access

Web Designing and Programming: HTML, Java Script, VBScript, LAMP (Linux, Apache, MySQL, PHP), ASP, JSP, ASP.NET, Photoshop, Image Ready, Dreamweaver, XML, CSS

Programming: C, C++, Java, Visual Basic, UNIX Shell Script(Bash, Korn)

PROFESSIONAL EXPERIENCE

Confidential, Franklin Lakes, NJ

Informatica ETL Developer

Responsibilities:

• Analyze the source systems data and the current reports at the client side to gather the requirements for the Data Warehouse Data Model.
• Developed mappings using Source qualifier, Aggregators, Connected & unconnected Lookups, Stored Procedures, Filters, Sorter & Update strategy Transformations using Power Center.
• Used Lookup Transformation to access data from tables, which are not the source for mapping and also used Unconnected Lookup to improve performance.
• Responsible for testing the mappings and ensure that the mappings do the transformations as proposed.
• Involved in Creating tasks, Worklets, workflows to load the data
• Scheduled, Run and Monitored sessions using workflow manager and workflow monitor.
• Troubleshoot problems by checking Sessions and Error Logs. Also used Debugger for complex problem troubleshooting.
• Used PMCMD commands for stopping and starting workflows and tasks.
• Worked closely in preparation of technical documentation of transformation components.
• Participates in design and development reviews
• Developed UNIX to automate different tasks involved as part of loading process and scheduling.
• Performed Unit Testing and Integration Testing on the mappings.
• Involved in maintaining effective relations with co-workers and business People.

Environment: Informatica PowerCenter 9.5/9.1/8.6.1/8.1.1 SP3, Oracle 10g/9i, Teradata, IBM DB2, Flat Files Teradata SQL Assistant 7.1, ERWIN Data Modeler 7.3, PL/SQL, UNIX Shell Programming, SQL*Loader.

Confidential, Hartford, CT

Informatica Developer

Responsibilities:

• Gathered business scope and technical requirements from users and translated business logic into ETL Specifications.
• Extensively worked on Business Analysis. Designed, Developed, Tested and Implemented Informatica transformations and Workflows for extracting data from multiple legacy systems.
• Actively involved in interaction with Management to identify key Dimensions and Measures for business performance.
• Responsible for Data Modeling and developing procedures to populate business rules using mappings.
• Developed extraction mapping to load data from various source system like Flat Files, ODBC sources into target using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Update Strategy Rank and Router transformations.
• Designed and developed reusable transformations and mapplets to use in multiple mappings.
• Generated different types of reports, such as Chart, Master/Detail and Cross Tab.
• Implemented performance tuning logic on targets, sources, mappings, sessions to achieve maximum efficiency and performance.
• Developed Data loading stored procedures, functions using PL/SQL from Source systems into operational data storage.
• Implemented Variables and Parameters in the mappings.
• Involved in designing ER diagrams, logical model (relationship, cardinality, attributes and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) as per business requirements.
• Implemented session partitions, dynamic cache memory, and index cache to gain optimal performance of Informatica server.
• Optimized SQL queries for better performance.
• Extensively used Informatica debugger to validate mappings and to gain troubleshooting information about data and error conditions.
• Worked with different Informatica tuning issues and fine-tuned the transformations to make them more efficient in terms of performance.
• UNIX shell scripts are used for scheduling to automate the load process.
• Developed Reports for the clients using business objects.
• Provided 24/7 production support and mentored duty staff in problem determination.

Environment: Informatica Power Center 9.1/8.5 (Repository Manager, Designer, Workflow Manager and Workflow Monitor), Oracle 10g, MS SQL Server 2005, DB2, Mainframe, PL/SQL, SQL, UNIX Shell Scripting, SISS, ERWIN.

Confidential, Wilmington, DE

Informatica Consultant

Responsibilities:

• Interacted with client's business process team to gather business requirements, formulate and implement a flexible system design that fulfils the functional requirements.
• Explored and analyzed the system use case documents and specification documents and developed detailed design of the interfaces.
• Designed and developed reusable common framework code which was used across all interfaces and across other development teams.
• Coordinated with the offshore team to help them understand business and technical requirements.
• Involved in designing and creating mapplets to promote reusability, elimination of redundancy and ease maintenance for version control.
• Extensively worked on Informatica Designer, Workflow Manager, Workflow Monitor and Repository Manager to design and develop complex ETL processes to extract, transform and load data from multiple sources into data warehouse.
• Successfully implemented various scenarios related to slowly growing target and slowly changing dimensions (Type1, Type2 and Type3).
• Created various mapping and mapplets for data transformation using different Informatica transformation like Normalizer, Source Qualifier, Update Strategy, Look Up ( connected, unconnected, static and dynamic cache), Sequence Generator, Expression, Aggregator etc.
• Responsible for designing target load order plan and constraint based loading for loading data correctly into different target tables.
• Used pmcmd commands and UNIX Shell Scripts for scheduling workflows, collecting the session statistics and task detail and to interact with Informatica server in command mode.
• Developed PL/SQL stored procedures and functions for database updates, to generate sequence and create necessary indexes in the target tables.
• Documented the project documents such as mappings specifications, test cases and process flow diagrams.
• Worked with session log files and bad files to trace errors occurred while loading. Used Informatica debugging techniques to find the performance bottlenecks and debug the mappings

Environment: Informatica Power Center 8.1/7.1(Designer, Repository Manager, Workflow Monitor, Workflow Manager), Windows XP, UNIX, Solaris, SQL Developer, Oracle 9i, PL/SQL, Flat Files, Putty, DB2, ERWIN 4.0.

Confidential, Jersey City, NJ

ETL Developer

Responsibilities:

• Gathered business requirements interacting with Project Coordinators, Business Analysts and End-users and mapped business requirement to source systems to decide what data elements will be extracted.
• Prepared the ETL Spread Sheet and created Logical and Physical Modeling of Star Schema after indentifying the Facts and Dimensions based on the business rules.
• Used Informatica PowerCenter Designer tool in developing mappings and mapplets to extract, transform and loading data from various source systems like Flat Files, oracle based on the ETL spreadsheet using various transformation like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Update Strategy Rank and Router transformations.
• Created various tasks like sessions, worklets and workflows in PowerCenter Workflow Manager to test the mapping during development.
• Used workflow monitor to watch the status of workflows and to get the session properties and session log for diagnostic.
• Analyzed the session logs, bad files and error tables for troubleshooting mappings and sessions.
• Extensively involved in performance tuning of various mappings and sessions identifying bottlenecks and correcting the mappings and sessions to improve the performance.
• Involved in Performance tuning of various mappings and sessions to increase the performance.
• Created PL/SQL stored procedures and functions for integration with Informatica using Oracle.
• Actively participated in performance tuning of Oracle using SQL Optimizers.
• Performed unit testing of mappings before including the developed sessions into already existing batch, documented the unit test plan and its results.
• Designed and developed the OBIEE/ MetadataRepository (.rpd) using Siebel Analytics Server Admin tool by importing the required objects.
• Worked on Siebel Answers to build OBIEE Interactive Dashboards with drill-down capabilities.
• Documented all the mappings and the transformations involved inETL process.
• Provided 24*7 production support and worked in root cause analysis, bug fixing and promptly updating the business users on day-to-day production issues.
• Developed UNIS Shell Scripts to control process flow for workflows to handle high volume data.
• Co-ordinate with off-shore teams and mentor junior developers.

Environment: Informatica Power Center 7.1, OBIEE10.1.3, Oracle 8, MS SQL Server 2005, Flat files and UNIX, Windows XP, Microsoft Word, Microsoft Excel, PowerPoint, PL/SQL, SQL*Plus, DB2, Erwin.

Confidential, New York, NY

Informatica/ETL Developer

Responsibilities:

• Interacted with Business personnel to analyze the business requirements and transform the business requirements into technical requirements.
• Developed and supported the extraction, transformation and load process (ETL) for Data Warehouse from the source systems using Informatica.
• Created Reusable Transformation and Mapplets in the designer using transformation developer and Mapplet designer according to the business requirements.
• Wrote SQL overrides in source qualifiers for extracting only the required rows for optimal performance.
• Created complex transformations using Source Qualifier, Joiner, Aggregator, Lookup, Router, Expression, Update Strategy, Sequence Generator etc.
• Debugging code, testing and validated data after processes are run in development/testing according to business rules.
• Prepared unit test plans and maintained defect logs to resolve issues.
• Communicated with the Team to prepare unit test plans, to find solutions for the defects/issues and to share business knowledge.
• Optimized the performance of the mappings by various tests on sources, targets and transformations.
• Identified the Bottlenecks, removed them and implemented performance tuning logic on targets, sources, mapping, sessions to provide maximum efficiency and performance.
• Used Workflow manager and Workflow monitor to create, run and monitor the sessions.
• Extensively used TOAD to check if data is properly loaded into target systems by writing SQL Queries.
• Tuned performance of Informatica sessions for large data files by implementing pipeline Partitioning and increasing block size, data cache size, sequence buffer length, and target based commit interval and resolved bottlenecks.

Environment: Informatica Power Center 7.1.2, Oracle 8i, SQL, TOAD, PL/SQL, Flat files, Sybase, Erwin Designer, Windows NT, Solaris 9.