PROFESSIONAL SUMMARY:

• Over 8years of experience in Information Technology with a strong background in Data warehousing and Informatica for Banking, Pharmacy, Insurance and Utilities industries.
• Extensive experience in requirement gathering from business users to create Functional Specification Document (FSD) used by ETL/BI teams to build ETL/BI architecture.
• Expert in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, DB2, Teradata, Netezza, successfully worked on integrating data from flat files like fixed width and delimited.
• Extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Extensive experience with Informatica PowerCenter Client tools - Designer, Repository Manager, Workflow manager, Workflow Monitor, Transformation Developer, Mapp let and Mapping Designer.
• Expertise in different Informatica Performance Tuning issues like Source, Target, Mapping, Transformation and Session.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Unconnected/Connected Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and XML Source Qualifier.
• Extensive experience in implementing SCD Type 1 and SCD Type 2 as per the requirements.
• Strong Experience in Data Analysis, developing Sessions/tasks, Worklets, Workflows using Workflow Manager Tools - Task Developer, Workflow & Worklet Designer.
• Proficiency in data warehousing techniques for data cleansing, surrogate key assignment and Change data capture ( Confidential ).
• Excellent experience in Optimizing Queries using query optimization tool.
• Extensive experience in debugging mappings. Identified bugs in existing mappings/workflows by analyzing the data flow and evaluating transformations.
• Sound knowledge of UNIX Shell scripting & UNIX commands in Solaris, HP-UX, AIX environments.
• Sound knowledge of RDBMS concepts, SQL, PL/SQL (Oracle 10G, Oracle 9i, SQL Server 200X, DB2, Teradata).
• Worked with XML and Flat file sources coming from various legacy source systems and residing on Mainframe and UNIX.
• Strong experience in documenting the ETL process flow for better maintenance and analyzing the process flow.
• Extensive experience with all tasks in workflow manager to implement job control in Informatica to support dependencies in loading data in target systems including Pre-Post session commands/SQL.
• Excellent Informatica Administration skills like installing & configuring Informatica Power Center, administering user, privileges, deployment, starting & stopping server, resolving issues with Informatica Power Center Server.
• Sound knowledge of SDLC process and various deliverables in SDLC.
• Good Exposure in Business Intelligence tools like Business Objects, Cognizant OBIEE.
• Strong Knowledge in Data Exchange, MDM, IDQ, Data Transformation, SQL development, Data marts.
• Excellent working knowledge of UNIX shell scripts and scheduling of jobs by using tools like ControlM, Autosys and Tidal.
• Analyzed Business and Functional Specifications and assisted the QA team for writing a comprehensive test plan / writing test cases.
• Worked extensively with Stored Procedures, Triggers, Cursors, Indexes and Functions. Practical knowledge of Data warehouse concepts and principles (Kimball/Inman) - Star Schema, Snowflake, SCD, Surrogate keys, Normalization/De normalization.
• Strong Knowledge and understanding of Data Modeling. Unique ability to understand and address long-term project development issues at all levels, from interpersonal relationships to the details of coding scripts with strong analytical, organizational, presentation and problem solving skills

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter, Informatica Data Quality, and Informatica Power Connect.

Databases: Oracle MS-SQL Server Teradata Sybase, IBM DB2, MySQLTools: TOAD, MS VISUAL STUDIO, SQL *PLUS, ERWIN, Business Objects, AUTOSYS, Control-M, ViewPoint.

Programming Languages: UNIX, Shell Scripts, SQL, PL/SQL, T-SQL, XML.

PROFESSIONAL EXPERIENCE:

ETL Informatica Developer

Confidential, Hopkins, MN

Responsibilities:

• Prioritized Business requirements and translated those requirements into functional requirements.
• Worked with business analysts for requirement gathering, business analysis, and translated the business requirements into technical specifications to build the Enterprise data warehouse.
• Analyzed the system for the functionality required as per the requirements and created System Requirement Specification document (Functional Requirement Document).
• Involved in the development of the conceptual, logical and physical data model of the star schema using ERWIN.
• Extensively used ETL to load data from heterogeneous sources like flat files (Fixed Width and Delimited),Oracle tables, and DB2 tables
• Extensively used Informatica Client tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
• Developed various complex mappings using Mapping Designer and worked with Aggregator, Lookup(connected and unconnected), Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Optimized and Tuned SQL queries used in the source qualifier of certain mappings to eliminate Full Table scans.
• Created and Configured Workflows, Worklets and Sessions to transport the data to target warehouse tables using Informatica Workflow Manager.
• Designed and developed several Mapp let and worklets for reusability.
• Used Informatica Power center workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Developed PL/SQL procedures for processing business logic in the database and use them as a Stored Procedure Transformation. Developed Oracle PL/SQL Packages, Procedures, Functions and Data Base Triggers.
• Wrote functions and triggers using PL/SQL. Reviewed and documented existing scripts.
• Identified and fixed bottlenecks and tuned the complex Informatica mappings for optimized performance.
• Prepared, documented unit test plans and resolved issues escalated from system testing.
• Collaborated with Project Manager, Tech Lead, Developers, QA teams and Business SMEs to ensure delivered solutions optimally support the achievement of business outcomes. Coordinating with source system owners, performed data migration and monitored day-to-day ETL progress, Data warehouse target schema Design (Star Schema) and maintenance.
• Implemented various slowing changing mappings based on the related Star Schema data model
• Data Warehouse and Data modeling based on the client requirement using Erwin (Conceptual, Logical and Physical Data Modeling).
• Automated UNIX shell scripts to verify the count of records added everyday due to incremental data load for few of the base tables in order to check for the consistency.
• Expertise in UNIX shell scripting and automation of ETL processes using scheduling tool Autosys.
• Dimensional Modeling for creation of Star Schema and Snow Flake Schema Used Incremental aggregation for Confidential
• Created reports using BO and involved in developing report using BO and developed tabular matrix, parameterized chart reports.

Environment: Informatica Power Center 9.6.1/9.0.1, SAP Business Objects 3.4, Oracle 11g, BPM, Flat files, HP ALM, HP Quality Center 10.00, Erwin 7.2, Sql Developer & Toad, shell scripting, Autosys, Tidal Scheduler.

Informatica developer

Confidential, San Antonio, TX

Responsibilities:

• Collaborated with Business analysts for requirements gathering, business analysis and designing of the Enterprise Data warehouse.
• Involved in requirement analysis, ETL design and development for extracting data from the heterogeneous source systems like MS SQL Server, Oracle, flat files, XML files and loading into Staging and Data Warehouse Star Schema.
• Involved in massive data cleansing prior to data staging.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Designed and developed the logic for handling Slowly Changing Dimension Table Type 1/ Type 2.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Design and Development of ETL Mappings, Using Informatica Mapping Designer within the Informatic PowerCenter, Usage of Lookups, Joiner, Expression, Aggregator, XML, Rank, Mapp let, connected and unconnected stored procedures, Lookups, SQL Overrides usage in Lookups, Source filter and SQL Override usage in Source Qualifiers and data flow management into multiple targets using Routers were extensively done.
• Invoked and Executed Stored Procedures to transform the Data and worked extensively with PL/SQL for various needs of the transformations while loading the data into Oracle Database. Converted MS SQL Server DTS Packages logic into Informatica Mappings.
• Created Mappings with shared objects/Reusable Transformations/Mapp let using Mapping/Multiparameter/Variables.
• Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Workflow Manager.
• Configured workflows with Email Task, which would send mail with session log file for Failure of a sessions and for Target Failed Rows.
• Used pmcmd commands on command prompt and executed Unix Shell scripts to automate workflows and to populate parameter files. Worked with UNIX shell scripts for job execution and automation.
• Scheduled Informatica workflows using ControlM to run at regular intervals.
• Used SQL tools like Query Analyzer and TOAD to run SQL queries and validate the data. Tuning the Mappings for Optimum Performance, Dependencies and Batch Design.
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis.
• Involved in Unit testing, System testing, Integrated testing and User Acceptance Testing to check whether the data was loading into target, which was extracted from different source systems per the business requirements.
• Involved in jobs scheduling, monitoring and production support activities in a 24/7 environment.

Environment: Informatica Power Center 9.5, ControlM, Cognos, Oracle 10g/11g, MS Access, MS SQL Server, Sybase, IBM DB2, SQL PL/SQL, SQL*Plus, TOAD, Oracle Applications 11i, Erwin, Unix, Sun Solaris, WindowsXP

Informatica Developer

Confidential, PA

Responsibilities:

• Analyze business requirements to build a data mart design for various business processes conformed to the business rules.
• Developed the mapping specifications from the business requirements and the data model.
• Proficient in writing SQL queries and creating PL/SQL stored procedures.
• Involved in Developing OLAP models like facts, measures and dimensions.
• Implemented change data capture ( Confidential ) using Informatica Power Exchange to update tables in the oracle database.
• Created Reusable Transformations and Mappletto use in Multiple Mappings and worked with shortcuts.
• Implemented Type2 slowly changing dimensions (SCD).
• Worked on all aspects of Teradata loading and query tuning activities.
• Used Teradata utilities like Fast Load, Multiload, Fast Export and BTEQ.
• Extracted data from Teradata source systems to a flat file.
• Created parameter files and scheduled workflows.
• Optimized mappings by performing Performance Tuning and Informatica best practices.
• Involved in Unit testing and system integration testing (SIT).
• Created mapping documentation and user guides for ETL processes as part of end user training.

Environment: Informatica Power Center 9.1, Power Exchange, Oracle 10g, Teradata 12.0, SQL, PL/SQL, Erwin, Toad 9.6, WinSCP, UNIX (Solaris 10), Autosys.

ETL Developer

Confidential

Responsibilities:

• Implemented ETL Informatica designs and processes for the load of data from the sources to the target warehouse.
• Designed mappings from the scratch and also did performance tuning of the mappings that were previously implemented.
• Responsible for performance tuning at various levels like mapping level, session level, and database level Worked on Power Center Tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Extensively used various active and passive transformations like Filter Transformation, Router Transformation, Expression Transformation, Source Qualifier Transformation, Joiner Transformation, Look up Transformation, Update Strategy Transformation, Sequence Generator Transformation, Rank Transformation, and Aggregator Transformation.
• Developed several Re Usable Transformations and Re-Usable applet by using the Power Center Designer.
• Worked with Shortcuts across Shared and Non-Shared Folders.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD.
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files.
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.
• Worked with Index Cache and Data Cache in cache using transformation like Rank, Lookup, Joiner, and Aggregator Transformations.
• Extensive worked on debugging and troubleshooting the Sessions using the Debugger and Workflow Monitor.
• Worked with Session Logs and Workflow Logs for Error handling and troubleshooting.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy.
• Responsible for Unit Testing and creating unit test plans and preparing unit test cases

Environment: Informatica Power Center 9.0, Oracle 10g, SQL Server, Syb ase, FlatFiles, UNIX, ndows XP, CA Autosy, StarTea