SUMMARY:

• Sr. Informatica developer with over nine (9) years of experience in analysis, design, development and maintenance of data warehouse and related applications using ETL and BI tools.
• Experience working in banking, financials, healthcare, insurance and pharmaceutical industries
• Expert level experience in implementing advanced ETL methodologies for corporate - wide ETL solutions using Informatica Power Center 9.6.1/9.5.1 /9.1/8. x/7.x
• Hands on data modeling knowledge of Ralph Kimball’s dimensional data modeling using star schema and snow-flake schema
• Hands on experience with user interaction for the sake of gathering and analyzing project requirements
• Strong expertise in design, development and integration of complex ETL processes
• Extensive experience with PL/SQL in designing, developing functions, procedures, triggers and packages
• Solid experience performance tuning ETL mappings including ETL sources, targets, transformations and at systems level
• Excellent analytical, problem solving, and communication skills

SKILL:

ETL Tools: Informatica Power Center 9.x/8.x/7.x, IDQ 9.6.1, Informatica Power Exchange.

Reporting tools: Data Modelling

Oracle BI Apps, OBIEE, Cognos.: Erwin, UML.

Data Modeling Methodologies: Logical/Physical/Dimensional, Star/Snowflake, ETL, OLAP, Complete Software Development Life Cycle.

Operating Systems: Unix, Linux, Windows.

Databases: Oracle 11g/10g/9i, MS SQL Server 2008/2005, DB2 8.x, Teradata 14.0

Tools: Toad, Visio, SQL developer.

EXPERIENCE:

Sr. Informatica Developer

Confidential, Kansas City, MO

Responsibilities:

• Worked with business users, business analysts and architects to analyze requirements: created ETL design and technical specs
• Involved in building ETL architecture and source to target mapping for loading in to data warehouse
• Employed agile methodology to deliver the codes
• Implemented complex SCD-1 methodology by reading the data from SQL Server staging tables and loaded the data into dimensions and facts in Oracle warehouse.
• Modified existing mappings and sessions for new enhancements requests
• Responsible for migrating jobs from dev to test environment using deployment groups in repository manager
• Involved in unit testing, system testing and functional testing of the ETL jobs
• Facilitated performance tuning of slow running ETL jobs
• Worked with DBAs in identifying and eliminating the bottlenecks of slow running SQL queries and stored procs
• Actively participated in code reviews and mentored the developers

Environment: Informatica Power Center 9.6.1, OBIEE 11g, Oracle 11g, SQL Server 2012, PL/SQL, Linux, Quality Center and JIRA

Sr. Informatica Developer

Confidential, Overland Park, KS

Responsibilities:

• Worked with business analysts, business users and architects to analyze the data model: updated the design and technical specs
• Parsed high-level design specifications to simple ETL coding and mapping standards
• Designed the ETL flow and developed mappings for SilkRoad vendor by reading XML files as sources and loaded the data into SQL Server target tables
• Implemented complex SCD-1 methodology by loading the data into SQL Server tables: produced the feeds for DST vendors
• Developed mapping parameters, variables to support SQL override and created mapplets for reusability across mappings
• Responsible for migrating the jobs from dev to test and to the load environment using deployment groups in repository manager
• Involved in unit testing and system testing the ETL jobs. Worked with QA team to resolve the defects
• Worked with DBA for partitioning and creating indexes on tables used in Source Qualifier queries
• Tuned performance of mapping and sessions by optimizing source and target bottlenecks and implemented pipeline partitioning

Environment: Informatica Power Center 9.6.1/9.1,SQL Server 2012, Oracle 11g, PL/SQL and Tidal

Sr. Informatica Developer

Confidential, Portland, ME

Responsibilities:

• Contributed to creation of the BRD/functional and technical design documents after multiple sessions with the business user team
• Responsible for designing the ETL framework for the proof of concepts from different data sources to Teradata 14.0 and DB2 8.x database/sandbox
• Worked with the data analysts to build common business rules in IDQ pertaining to subject area for reusability across all of the sources
• Profiled the data using IDQ and worked with analysts and business users with data quality issues
• Developed Change Data Capture (CDC) mappings using Informatica Power Exchange 9.6.1
• Loaded data into Teradata tables for I3 application based upon SCD Type 2 by doing full and delta loads for each feed
• Worked in real time environment by creating CDC mappings and loaded the topics (queues) by using them as staging area. Built the secondary ETL process to read data from the topics and loaded the Teradata database for thirteen applications as per the business needs
• Involved in performance tuning of multiple Informatica jobs to improve performance

Environment: Informatica Power Center 9.6.1/9.5.1 , Teradata14.0, DB2 8.x, SQL Server 2008, Teradata, shell scripting, PL/SQL, Cognos, Control-M, IDQ 9.6.1/9.5.1 , Informatica Analyst (IA)

Sr. Informatica Developer

Confidential, Buffalo, NY

Responsibilities:

• Involved in all phases of SDLC including requirements, design, development, testing, training and rollout to field user and production support
• Created technical specs and mapping documents to outline data flow from sources to targets
• Developed mappings to load data into staging tables and then in to dimensions and facts
• Implemented various error handling strategies
• Responsible for writing shell scripts to automate jobs
• Involved in unit testing of the mappings and mentored the developers and the QA team to give them an understanding of the business logic
• Developed various reports, interactive dashboards with drill-down capabilities, and with various charts, views and tables using global and local filters

Environment: Informatica Power Center 8.6/9.1, SQL Server 2008, Oracle 11g, Toad 9.x, shell scripting, OBIEE 11g, PL/SQL, Windows, Opcon, IDQ 8.6.1

Sr. Informatica Developer

Confidential, Boston, MA

Responsibilities:

• Worked with business analysts to identify the appropriate sources for data warehouse, prepared the functional and technical designs, test cases and user guides
• Helped in developing star schema by following referential integrities among facts and dimensions
• Implemented slowly changing dimension methodologies and created aggregated fact tables for creating ad-hoc reports
• Created and maintained surrogate keys on the master tables to handle SCD type 2 changes effectively
• Developed Informatica jobs and automated data loads using UNIX shell scripts
• Involved in debugging mappings, recovering sessions and developing error-handling methods

Environment: Informatica Power Center 8.6, DB2, Oracle 10g, Toad, Shell Scripting, OBIEE, PL/SQL, UNIX, Visio and Autosys

Informatica Developer

Confidential, Fairfield, CT

Responsibilities:

• Involved in business analysis and technical design sessions with business and technical staff to develop requirements document and ETL design specifications
• Extracted data from source system and loaded the Dimensions and Fact tables
• Co-ordinated with the off shore teams and provided training in understanding the business requirements and performed code reviews
• Created Stored Procedures to extract data from the various data sources like Oracle and SAP

Environment: Informatica Power Center 8.1, OBIEE,Oracle 10g, SQL Server 2005, UNIX, SQL Developer, SQL, PL/SQL, Erwin

Informatica Developer

Confidential, Dublin, OH

Responsibilities:

• Created the ETL process to generate claim extract XML files for vendors from the base tables using Informatica
• Designed mapping templates and developed several Informatica mappings to populate the data into dimensions and fact tables
• Tuned sources, targets, mappings and sessions to improve the performance of data load
• Optimized the mappings using various optimization techniques and also debugged existing mappings

Environment: Informatica Power Center 8.1, Oracle 9i, Business Objects, PL/SQL, Toad, Erwin, UNIX, Control M.