PROFESSIONAL SUMMARY:

• Informatica developer with about 7 years of IT experience in all aspects of software development and systems management including project analysis, development, implementation and documentation.
• Good understanding of relational database management systems like Oracle, Teradata, DB2, and SQL Server and extensively worked on Data Integration using Informatica for the Extraction transformation and loading of data from various database source systems and mainframe Cobol and VSAM files.
• Over 6+ years of strong experience in development and design of ETL (Extract, Transform and Loading data ) methodology for supporting data transformations and processing ETL Solutions using Informatica Power Center (8.x/7.x).
• Knowledge on latest version of Informatica tool - --Informatica 9.1
• Proficient in all phases of software development life cycle (SDLC) including requirements definition, development, system implementation, maintenance and acceptance testing.
• Excellent data warehousing experience using Informatica Power Center 8.6.18.1/7.1.2/7.1.1/6.2/5.1 (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Workflow Monitor, Repository Manager), and Informatica Power Mart.
• Programming experience using SQL, PL/SQL (Stored Procedures, Functions and Triggers), Oracle, VBScript and UNIX Shell Programming
• Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL Loader.
• Strong working experience in Informatica Power center 8.6.1 with understanding of new concepts.
• Experienced in developing Data marts & Data warehouse.
• Skilled in requirements gathering & creating documentation for the whole ETL process & mapping templates.
• Good understanding of Dimensional Data Modeling (Star Schema Modeling, Snow-flake Schema FACT and Dimension Tables), Conceptual, Logical & Physical Data Model.
• Good understanding of Ralf Kimball & Inmon Methodologies in Data Warehousing.
• Hands on experience in fixing mapping errors, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions. Have Understanding with Lab Ware LIMS v6 Core Functionality and Architecture
• Extensive experience using Debugger, Workflow Recovery in Workflow Manager.
• Extensive experience working with Slowly Changing Dimensions, Slowly Growing Targets.
• Experience in UNIX Shell Scripting for updating parameter files, scheduling Jobs in Autosys
• Experienced in Unit testing and Integration Testing of mappings in Informatica Power Center.
• Knowledge in ETL reporting tools - Business Objects, Cognos.
• Experience on programming with LIMS Basic
• Experience in Oracle backend operations for creating PL/SQL stored procedures, functions, packages, triggers, tables, indexes, views, aliases and sequences.
• Able to manage changing responsibilities and deliver time critical projects on schedule.
• Team and Independent Player with excellent Organizational and Interpersonal skills.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 8.6.1/8.1.1/7. x/6.x

Databases: Oracle 10g/9i/8i, SQL Server 2000, Teradata.

Languages: SQL, T-SQL, PL/SQL, C, UNIX Shell Scripting.

Operating Systems: UNIX, Windows 2000/2003/NT, Linux, Sun Solaris, HP-UNIX.

Business Intelligence Tools: Business Objects

Scheduling Tools: Autosys, Crontab.

DB Tools: TOAD, SQL *Plus, PL/SQL Developer, SQL * Loader

Web Technologies: HTML, XML

Other Tools: Dream Weaver, Fireworks, Photoshop, Ms-Office

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

ETL Developer

Responsibilities:

• Involved in study of HCA (Health Care Accounts) and HCP (Health Care Professional) requirements and design of data movement processes.
• Created and developed Functional Specification Document, Detailed Level Design Document and Unit Test Plan.
• Attended meetings with business analysts and architects to estimate amount and duration of work.
• Followed ETL SDS to understand Confidential mappings standards and process flows.
• Extracted data from various sources and loaded into Oracle Data warehouse.
• Developed ETL procedures to transform the data according to the business rules.
• Incorporated reusable transformations, mapplets, mappings, sessions and worklets that were frequently used by different interfaces.
• Used debugger to test the data flow and fix the data issues.
• Involved in Performance tuning for sources, targets, mappings, sessions and workflows.
• Used stored procedure transformation to invoke PL/SQL procedures.
• Created mappings using Transformations such as Source qualifier, Aggregator, Expression, Connected and Unconnected Lookup, Filter, Router, Sorter, Stored Procedure, Normalizer, etc
• Managed sessions, worklets and workflows, and scheduled them to run every week.
• Worked on Data masking, HTTP and web services transformations in Informatica to mask the customer data and receive the data from URL.
• Used extensively the connected lookup Transformations using dynamic cache.
• Usage of Joiner, SQL overrides usages in lookup and source filter usage in Source Qualifier and data flow management into multiple targets using routers was extensive.
• Optimized the load performance and query performance for Informatica Mappings by tuning the SQL used in Transformations and various session settings to reduce any source or target bottlenecks
• Created different tasks in Workflow Designer such as sessions, event raise, event wait, decision, e-mail, command, and Timer tasks according to the requirements.
• Created scheduler and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager.
• Wrote test scripts to validate the data and performed unit testing, system integrated testing.
• Identified and fixed bottlenecks and tuned the complex Informatica mappings for better performance
• Developed PL/SQL Packages, Functions, Procedures & Triggers to implement the Business Logic.

Environment: Informatica Power Center 8.6.0, Oracle 11g, SQL, PL/SQL, UNIX SunOS 5.8, Windows XP, Toad, Tivoli, Visual SourceSafe

Confidential, Columbus OH

DW Informatica Developer

Responsibilities:

• Member of warehouse design team, which interacted with the business community and database administrators to identify the business requirements and data realities.
• Involved in dimensional modeling data warehouse to design the business process.
• Created Source definitions from Flat Files, XML files, Oracle DB, Imported/Created Target definitions and created Reusable Transformations and mapplets in Shared folder.
• Used various Transformations like Source Qualifier, Lookup, Update Strategy, Router, Filter, Sequence Generator and Joiner on the extracted source data according to the business rules and technical specifications.
• Optimized the mappings using various optimization techniques and also debugged some existing mappings using the Debugger to test and fix the mappings.
• Developed Teradata Macros and Views.
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Used different types of transformations like Source qualifier, expression, Router, filter, update strategy, Connected and Un-connected lookup, Normalizer, joiner, Aggregator, Update strategy.
• Used Type 1 and Type 2 mappings to update Slowly Changing Dimension Tables.
• Migrated mappings from Development to Testing and to Production.
• Implemented Slowly Changing dimensions to update the dimensional schema.
• Implemented pipeline Partitioning (hash key, key range, round robin and pass through) to improve session performance.
• Monitored workflows and collected performance data to maximize the session performance.
• Used SQL Loader to minimize data load time into Oracle Database.
• Documented the mapping process and methodology used to facilitate future development.

Environment: Informatica Power Center 8.1.1, Oracle 10g, Teradata, Erwin 4x

Confidential, San Jose, CA

Informatica Developer

Responsibilities:

• Parsing high-level design specs to simple ETL coding and mapping standards.Designed Mapping Document, Detail Design Documents, Install and Release documents which is a guideline to ETL Coding.
• Implemented star schema to represent data in the data ware house
• Designed and developed Informatica Mappings and Sessions based on user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Analyzed the business requirements and framing the business logic for the ETL process and interacted with the technical staff to develop Entity Relationship/data models, requirements document and ETL specifications.
• Documented user requirements, translated requirements into system solutions and developed implementation plan and schedule.
• Worked in Oracle SQL, PL/SQL, Query Tuning, created DDL scripts, created database objects like Tables, Indexes, Synonyms, and Sequences etc., closely worked with DBAs to create Physical Databases.
• Fine tuned Transformations and mappings for better performance.
• Developed and scheduled Workflows using task developer, worklet designer and workflow designer in Workflow manager and monitored the results in Workflow monitor.
• Used workflow Manager for Creating, Validating, Testing and Running the sequential and concurrent Batches and Sessions, and scheduled them to run at a specified time.
• Extensively used ERWIN model for data modeling and Dimensional Data Modeling.
• Used Pipeline partitioning to enhance session performance.
• Performed versioning i.e. checking in and checking out of objects to commit changes to the repository.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Actively took part in creating Performance summary and Reporting Hierarchy tables for customer reports.

Environment: Informatica Power Center 7.1/8.1.1, Business Objects 5.x, DB2, Oracle 9i, PL/SQL, PL/SQL Developer, TOAD, Windows 2003, UNIX.

Confidential, NY

Informatica Developer

Responsibilities:

• Parsing high-level design specs to simple ETL coding and mapping standards. Designed Mapping Document, Detail Design Documents, Install and Release documents which is a guideline to ETL Coding.
• Implemented star schema to represent data in the data ware house
• Designed and developed Informatica Mappings and Sessions based on user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Created Source definitions from Flat Files, Oracle DB, Imported Target definitions and created Reusable Transformations
• Developed Transformation Logic to cleanse the source data of inconsistencies before loading the data into staging area, which is the source for stage loading.
• Worked on Connected & Unconnected Lookups, Router, Expressions, Source Qualifier, Aggregator, Filter and Sequence Generator etc.
• Used PMCMD commands for automating Batches and Sessions.
• Identified and fixed bottlenecks and tuned the Informatica mappings for better performance.
• Used Informatica Power Connect to extract information from the ERP systems.
• Created Informatica mappings with PL/SQL procedures/functions to build business rules to load data.

Environment: Informatica Power Center 6.2, Informatica Power Exchange, Power Connect for Mainframes, Oracle 9i, Teradata, TOAD, ERWIN, SQL Navigator, PL/SQL