SUMMARY:

• More than thirteen (13) years of proven experience in data warehousing, database and decision support systems
• Over ten (10) years of ETL (Extract Transform Load ) experience with Informatica Power Center
• Proficient in all phases of System Development and Project Management Life Cycles from analysis of business requirements, design of implementation strategies, data analysis, relational database design and architecture, business/technical liaising, workflow and quality assurance
• Key strengths include OLAP, ETL and business intelligence
• Worked with Relational (ER), Normalized, ODS/Staging, Star and Snowflake Dimensional Data Models
• Wrote database ETL/API programs using Oracle (9i/10g/11g/12c) SQL, and PL/SQL (Procedures, Functions, Triggers, Packages, Views and Materialized logs and Views)
• Expertise in defining and implementing ETL data load strategies including Type 1/2/3 Dimensions and facts (SCD), ETL Exception handling and restart recovery logic for relational and flat files
• Worked with Informatica Power Center transformations such as Joiner, Lookup (Static, Dynamic, Persistent Cache), Aggregate, Rank, Update Strategy, Transformation Control, Source Qualifier, Sorter, Normalizer, Filter, Stored procedure, Expression, and Router
• Experience in SQL tuning, analyzing data access paths including explain plans and using database hints, Indexes and Partitions
• Employed Informatica Power Center best practices including session partitioning and caching techniques
• Experience with entire Software Development Life Cycle (SDLC)
• Experience with date warehouse methodologies for both Kimball and Inmon
• Proficient in UNIX shell scripting and scheduling tools like Crontab, BMC Control - M and Autosys

SKILL:

ETL Tools: Informatica Power Center 7.1.1/8.1.1/8.6.1/9.1/9.5/10.1.1 (Repository, Designer, Workflow Monitor and Manager)

Oracle Technologies: 9i/10g/11g/12c databases SQL, PL/SQL (Procedures, Functions, Triggers, Packages, Utilities, import/export, SQL Loader, Packages

Data Modeling: Erwin 9.5, Toad Modeler

Operating Systems: Windows, Linux, Unix

Other ETL tools: Snap Logic

Databases: SQL Server 2005/2008, DB2 UDB, Teradata, Netezza

Tools: /Applications: Informatica Data Quality, OBIEE, Salesforce

EXPERIENCE:

Sr. Informatica Developer

Confidential, Columbia, MD

Responsibilities:

• Analyzed the business requirements and the existing systems
• Analyzed the OLTP database data mode and the OLAP database Dimensional Models
• Validated customer address using Informatica Data Quality tool
• Extracted the data from source to staging, with the staging loaded into data warehouse
• Developed Informatica mappings, sessions and workflows
• Developed the mappings to load the data into fact tables
• Optimized Oracle performance by using Oracle hints and created indexes
• Created ETL mappings including various transformations such as Source Qualifier, Lookup, Update
• Developed the PL/SQL procedures for data correction purposes
• Optimized Oracle PL/SQL procedures
• Used cursors, triggers and bulk load in PL/SQL
• Employed Strategy, Expression, Filter, Router, and Sequence Generator and Aggregator
• Developed common Slowly Changing Dimension ETL codes SCD type 1 and SCD type 2
• Maintained the customer address history by developing SCD type 2
• Performed unit testing and performance tuning testing
• Efficiently created migration packages for migrating the codes from DEV to TST and PROD environments

Environment: Informatica Power Center 9.6.1, Erwin 9.5, Oracle 12c, Autosys, Windows, UNIX, Salesforce, Netezza, IDQ

Sr. Informatica and PL/SQL Developer

Confidential, Columbus, Ohio

Responsibilities:

• Performed in-depth analysis of the current system landscape including Asset Management and Asset Suite Work applications, and the new Maximo system in order to identify and document business rules
• Provided architectural design for the data model and created an ETL transformation for converting and ingesting new data marts - TPC Mart for transmission data, and Value Mart for inventory data
• ETL Transformation involved complex mappings across 4 systems to execute one time and facilitate incremental data load. High throughput was achieved by implementing workflow partitioning
• Owned and managed all changes to the data models. Effectively articulated reasoning for data model design decisions and incorporated team member feedback to continue to refine data models
• Promoted reusability of the code by created mapplets, parameters and variables
• Optimized end to end ETL pipeline by removing performance bottlenecks

Environment: Informatica Power Center 9.6.1, Erwin 9.5, Oracle 11g, Tivoli, Windows, UNIX, Flat Files, Erwin

Sr. Informatica/PL/SQL Developer

Confidential, Richmond, VA

Responsibilities:

• Solicited business requirements, analyzed existing system
• Extracted the claims data from Source (flat files, database) to the Staging to load into data warehouse
• Developed Informatica Mappings, Sessions and Workflows to load the claims data into Oracle database tables and Amazon Aurora (PostgreSQL, MySQL), Amazon Red Shift Database
• Developed SnapLogic Pipeline’s to load the claims data from source Oracle tables to target Amazon Red Shift Database
• Developed the PL/SQL procedures for data correction purpose
• Automated the Informatica workflows using Unix scripting
• Optimized the Oracle performance by using Oracle Hints and Creating Indexes
• Developed the Mapping to Load the data into Flat files from fact tables, Dimension tables and send it to oust side vendors
• Created ETL mappings including various transformations such as Source Qualifier, Lookup, Update Strategy, Expression, Filter, Router, and Sequence Generator, Aggregator
• Developed common slowly changing dimension ETL code SCD type 1 and SCD type 2
• Maintained the Customer Address History by Developing SCD type 2
• Performed Unit testing and Performance Tuning testing
• Efficiently created migration packages for migrating the code from DEV to TST and PROD environments

Environment: Informatica Power Center 10.1.1, Erwin 9.5, Oracle 12c, Windows, UNIX, Flat Files, Amazon Aurora (PostgreSQL, MySQL), Amazon Red Shift, SnapLogic

Sr. Informatica Developer

Confidential, Auburn Hills, MI

Environment: Informatica Power Center 9.6.1, Erwin 9.5, Oracle 11g, Tivoli, Windows, UNIX, Flat Files, Erwin