SUMMARY

• Over 8 years of SDLC Experience in Analysis, Design, Development, Testing and Implementation of Data Warehouse and Data Integration Application using ETL tool Informatica Power center 9.6.1/9.5.1 /9.1/8.6/8.1/7. x, Oracle 11g/10g/9i, SQL Server 2012/08/03.
• Expertise in Data Modeling techniques like Dimensional and Fact tables, Star Schema, Snowflake Schema.
• Implemented Data Warehousing Methodologies for ETL using Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor, and Repository Server Administration Console.
• Strong experience in installation of Informatica on Windows and UNIX, Migration of repositories, up gradation of repositories.
• Experience in Data modeling activities of the attributes integrating from data sources like Excel, Oracle, Teradata, XML, COBOL, DB2, Netezza and SQL Server into staging Area.
• Experience in Designing and Developing of Business Intelligence solutions in Data Warehousing for Decision Support Systems using Informatica Power Center.
• Extensively Worked on ETLInformatica transformations including - Source Qualifier, Connected - Unconnected Lookup, Filter, Expression, Router, Union, Normalizer, Joiner, Update, Rank, Aggregator, Stored Procedure, Sorter and Sequence Generator and created complex mappings.
• Implemented slowly changing dimensions, Type 1 and Type 2 Methodology for accessing the full history of accounts and transaction information.
• Experience in while creating database concepts, logical and physical design, and development Of the Mappings.
• Expertise in Implementing Complex Business Rules by creating Re-usable Tasks(Mapplets, Mappings, Session, Command, Email and Workflow Variables) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control).
• Proficient in using Informatica Workflow manager, Workflow monitors to create Schedule, Control Workflows, Tasks, and Sessions.
• Experience in Debugging of mappings using Informatica Power center for data Error Handling, Scheduling jobs using Control-M, Autosys and Informatica Scheduler.
• Good Knowledge of reporting tools such as Cognos, Tableau and SAP Business objects.
• Worked on Performance Tuning for Identifying and Resolving various performance Bottlenecks at Various Levels like Source, Mapping and Session.
• Experience in Documenting High Level and Low level Design, Source to Target Mapping (STM), Macro and Micro Documents, Unit test plan, Unit test cases and Code Migration Report.
• Hands-on experience in developing and supporting Metadata Manager Application, Data Analyzer application, IDQ, IDE, RTM, Informatica Web services, Power Exchange etc.
• Experience in writing PL/SQL and T-SQL Stored Procedures, Indexes, Functions, Procedures, and Triggers and Cursors using Oracle and SQL Server.
• Experience in using the Informatica command line utilities like PMCMD to control Workflows in UNIX environments.
• Experience in performing Informatica Code Migrations/Deployments across Development, Test, and Production environments.
• Excellent skills in retrieving the data by writing Simple and Complex SQL Queries.
• Created UNIX shell scripts to access data and move data from Production to Development.
• Good knowledge on Windows power shell scripting and UNIX Shell. Developed windows scripts and scheduled ETL Loads.
• Experience in working in an Onsite-Offshore structure and effectively coordinated tasks between onsite and offshore teams.
• Strong communication, interpersonal, learning and organizing skills matched with the ability to manage stress, time and people effectively.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.6.1/9.5.1 /9.1//8.6/8.1/7. x Power Exchange, MDM Power Hub, B2B DT, Developer (IDQ) and Analyst (IDE), Informatica Cloud, SSIS.

BI & Reporting: Business Objects Xi R3, Tableau, OBIEE, Cognos, SSRS.

Data Modeling: Relational and Dimensional Modelings, Star Schema, Snow- Flake, Fact and Dimensions tables, Entities, Attributes, MS Visio.

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2012/2008, Teradata, MS access.

Other tools: Autosys, Control-M, Toad, SQL *PLUS, MS Office

Environment: s Windows Family, UNIX (Sun Solaris, AIX)

Languages: PL/SQL, T-SQL, SQL, XML, Java, Data Structures, UNIX Shell Script

PROFESSIONAL EXPERIENCE

Confidential, Tempe AZ

Sr. Informatica Developer

Responsibilities:

• Worked with the Business Analysts team for requirements gathering, business analysis, testing, and project coordination.
• Developed the Data Modeling concepts like Star-Schema, Snowflake Schema and Fact and Dimension tables.
• Extracted data from various heterogeneous sources like Oracle, SQL Server, Teradata, XML, and Flat Files.
• Designed and Developed ETL mappings using Transformations (Source qualifier, Aggregator, Rank, Router, Filter, Sorter, Expression, B2B, Joiner and Stored Procedure) logic for extracting the data from various source systems).
• Worked on Informatica Data Quality (IDQ) toolkit, Analysis, Data cleansing, Data Matching, Data Conversion, Exception handling, Reporting and monitoring capabilities of IDQ.
• Used Informatica Data Quality (IDQ) to complete initial data profiling and matching/removing duplicate data.
• Implemented Slowly Changing Dimension Type-1 and Type-2 Methodology’s for developing mappings to keep track the historical data.
• Used parallel processing capabilities, Session-partitioning and Target table partitioning techniques.
• Created effective Test Cases Unit and Integration Testing to ensure the successful execution of data loading process.
• Responsible for implementing Incremental Loading using Mapping Variables and Parameter Files.
• Creating Jobs and Job streams using with Control-M scheduling tool to schedule Informatica workflows.
• Involved in various performance tuning activities which includes identifying the potential bottle necks and thereby tuning ETL code for best performance.
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• Experienced in the use of agile approaches, including Extreme Programming, Test-Driven Development and Scrum.
• Tested the data and Data Integrity among various sources and targets.
• Worked with Session logs and Workflow logs for Error handling and troubleshooting in Development environment.
• Migrated Mappings, Sessions, Workflows from Development to Test and then to Production environment and development.
• Created mappings using pushdown optimization to achieve good performance in loading data into Netezza. And Used Indexes and Views for query optimization.
• Extensive written UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Developed windows power Shell Scripts and PL/SQL procedure functions as well as coding.

Environment: Informatica Power Center 9.6.1/9.5.1 , Informatica Data Quality(IDQ), Oracle 11g/10g, Teradata, XML, SQL Server 2008, PL/SQL and Control-M.

Confidential, Baltimore, MD

Sr. Informatica Developer

Responsibilities:

• Worked with Business Analyst and business users to clarify requirements and translate the requirement into technical specifications.
• Involved in the entire SDLC process that includes Testing, Implementation, Deployment and Maintenance.
• Responsible for working with DBA and Data Modelers for Project Coordination and Detail design of each interface.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Develop and Maintain Logical data and Physical data models for Data Warehouse applications using tools like Erwin.
• Designed Sources to Targets mappings from SQL Server, Oracle, DB2, Teradata, Mainframe, XML and Flat files using Informatica Power Center.
• Determined the data sources, and imported the source tables into the physical layer using connection pool object and populated themetadata into schema object.
• Built jobs as required on InformaticaCloud to pull data from Salesforce.
• Experience in while creating database concepts, logical and physical design, and development Of the Mappings.
• Created Data Synchronization, Data Replication andInformatica Cloud Mapping for Salesforce.
• Performed data integration fromInformatica Cloud into SalesforceCloud.
• Responsible for developing Complex Mappings using different types of Transformations like UNION Transformation, Connected and Unconnected LOOKUP transformations, Router, Filter, Aggregator, B2B, Expression and Update strategy transformation for Large volumes of Data.
• Developed SDE Mappings to load large amount of data from different sources to staging area, SID Mappings for load the data from staging area to target system
• Implemented Slowly Changing Dimension (SCD) Type 1 and Type 2 for Change data capture using Version control.
• Responsible for Creating Workflows and Sessions using Informatica workflow manager and Monitor the workflow run and statistic properties on Informatica Workflow Monitor.
• Responsible for Defining Mapping Parameters, Variables and Session Parameters according to the requirements and performance related issues.
• Created various Tasks like Event wait, Event Raise and E-mail etc
• Worked with the Business Intelligence tools like Business Objects and Crystal Reports.
• Wrote Shell scripts for Automating of Worklets, Batch processes and Session schedule using PMCMD
• Prepared UNIX Shell Scripts for automatic execution of Informatica workflows at specific timings, using Autosys scheduling tool.
• Created various Oracle database SQL, PL/SQL objects like Indexes, Stored Procedures, Views and Functions for Data Import/Export.
• Tuning the Informatica mappings to increase the performance of workflows.
• Optimized the mappings using various optimization techniques and debugged some existing mappings using the Debugger to test and fix the mappings.
• Wrote test plans and executed it at UNIT testing and also supported for System Testing, Volume Testing and User Testing. Also provided production support by monitoring the processes running daily.
• Worked on code Migration Strategies between Development, Test and Production repositories.
• Involved in jobs scheduling, monitoring and production support in a 24/7 environment.
• Extracted Data from FACETS Database and created HIPAA files from SQL Server DB.
• Created Materialized view for summary data to improve the query performance.

Environment: Informatica Power Center 9.5.1/9.1, Informatica Cloud, Oracle 10g, SQL Server, FACETS, PL/SQL, XML, MS Access, UNIX Shell Scripting, Teradata, Erwin and Autosys.

Confidential, Charlotte, NC

Informatica Developer

Responsibilities:

• Interacted with business analysts to analyze the business requirements and created informative requirement document.
• Developed data conversion, quality, cleansing rules and executed Data Cleansing activities such as data.
• Consolidation, standardization, matching Trillium for the unstructured Flat file data.
• Responsible for Design, Developing, Support and Maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center.
• Experience in integration of Heterogeneous Data sources like Oracle, DB2, Teradata SQL Server, XML and Flat Files (Fixed & delimited) into Staging Area.
• Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, joiner and Rank transformations.
• Wrote SQL-Overrides and used Filter conditions in source qualifier thereby improving the performance of the mapping.
• Experience in while creating database concepts, logical and physical design, and development Of the Mappings.
• Managed the Meta data associated with the ETL processes used to populate the Data Warehouse.
• Implemented Complex Business Rules in Informatica Power Center by creating Re-usable transformations and Robust Mapplets.
• Implemented Performance Tuning of Source to Target Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Improved session Performance by enabling property incremental aggregation to load incremental data into target table.
• Used scheduling toolAutoSysto automate running of Informatica Workflows on a daily Batch Jobs.
• Generated Complex reports in Cognos report studio including Drill Down reports from DMR modeled Frame work.
• PerformedInformatica cloud deployment as a part of my responsibilities.
• Involved in a data migration process between different versions of Cognos.
• Worked with Functional team to make sure required data has been extracted and loaded and performed the Unit Testing and fixed the errors to meet the requirements.
• Created Test cases for Integration testing and User Acceptance Testing (UAT). Reviewed UAT with business users.
• Imported and Exported the Mappings, Sessions, Worklets and Workflows from development to Test Repository and promoted to Production.
• Used Session parameters, Mapping variable and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Used PMCMD command to automate the Power Center sessions and workflows through UNIX.

Environment: Informatica Power Center 9.1/8.6, IDQ, Informatica Cloud, Oracle 10g, Cognos, SQL Server 2008, DB2, Teradata, Flat files, MS Access, PL/SQL, Autosys.

Confidential, Portland, OR

Informatica Developer

Responsibilities:

• Interacted with business users and business analyst to understand requirements and system requirement specification document.
• Implemented Dimension model (logical and physical modeling) in the existing architecture.
• Worked with active Transformations in Informatica power center like Filter, Aggregator, Joiner, Rank, Router, Sorter, Source qualifier, and Update Strategy transformations.
• Designed and developed Complex Mappings from various transformations like Unconnected and Connected lookup’s, Expression, Sequence generator and more.
• Implemented Slowly Changing Dimensions According to the requirements.
• Used Workflow manager for creating, testing and running sessions and batches.
• Extracted data from DB2, Oracle, Teradata, and XML source systems and loaded into Flat files using Informatica.
• Designed incremental loading process to load data into staging tables.
• Optimized existing applications at the Mapping level, Session level and Target level for better performance.
• Implemented reports like Drill down, Slice and Dice, master/detail for analysis of parts benefits and headcount.
• Experience in while creating database concepts, logical and physical design, and development Of the Mappings.
• Generated the Business Object reports involving complex queries, sub queries, Unions and Intersection.
• Used TOAD to run SQL queries and validate the data in warehouse and mart.
• Implemented Security Features of Business Objects like Row level, Object level and Report level to make the data secure.
• Developed PL/SQL and T-SQL procedures, functions to facilitate specific requirement.
• Configured the sessions using Workflow manager to have multiple partitions on source data and to improve performance.
• As part of implementation of Enterprise data warehouse (EDW) involved in Data Standardization.
• Written UNIX shell scripts to run automate workflows on specific timings using with Informatica scheduler tool.
• Identified and removed bottlenecks in order to improve performance of mappings and workflows.
• Developed Shell Scripts for Informatica Pre-session and Post-session scripts.
• Developed test plans and Test Scripts to test the data based on the business requirements.
• Responsible for regression testing ETL jobs before test to production migration.

Environment: Informatica Power Center 9.1/8.6, Business Objects, Oracle 10g/9i, TOAD, XML, SQL Server, PL/SQL, T-SQL, DB2, Teradata, Flat files, Excel files, Toad.

Confidential, Chicago, IL

Informatica Developer

Responsibilities:

• Understood the Business requirements based on Functional specification to design the ETL methodology in technical specifications.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Designed and customized Data Models for Data warehouse supporting data from multiple sources.
• Installed and configuredInformatica Server and Power Center. Migrated the Metadata changes to theInformatica repository.
• Created mapping documents to outline data flow from sources to targets.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Used TOAD to FTP file moving processes to and from source systems.
• Extracted the data from the Flat files and other RDBMS (Oracle, SQL Server, DB2, Teradata) databases into staging area and populated into Data warehouse.
• Experience in while creating database concepts, logical and physical design, and development Of the Mappings.
• Used various Transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop Robust Mappings in the Informatica Designer.
• Used Type-1 and Type-2 mappings to update Slowly Changing Dimension Tables.
• Developed mappings to load into Staging Tables and then to Dimensions and Facts.
• Worked on different Tasks in Workflows like Sessions, Events Raise, Event Wait, Decision, E-mail, Command, Worklets, Assignment, Timer and scheduling of the workflow.
• Created sessions and configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Developed mapping parameters and variables to support SQL override.
• Used Debugger to test the mappings and fixed the bugs.
• Used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• Extensively used SQL* loader to load data from Flat files to the database tables in Oracle.
• Modified existing mappings for enhancements of new business requirements.
• Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document to move the mappings from development to testing and then to production repositories.

Environment: Informatica Power Center 8.6/8.1, Oracle 10g, TOAD, PL/SQL, Business Objects, Teradata, SQL Server, Erwin, UNIX, Windows NT.

Confidential

Oracle SQL Developer

Responsibilities:

• Involved in complete understanding of business requirement and involved in analyzing the Database Design, Developing, and Implementation.
• Loaded data into multiple tables using SQL Loader.
• Designed logical and physical data models for star and snowflake schemas usingErwin.
• Used extensivelyPL/SQL,to developpackages, stored procedure, functions and database triggers.
• Designed & developed major input screen using Oracle Forms.
• Developed master-detail, drill down, matrix, nested summary detail reports, using Oracle reports, which pulled the thousands of records in different formats.
• Used different joins, sub-query and nested query inSQL queryfor reports.
• Extensively used PL/SQL in reports to perform calculation and to get desired output.
• Implemented the technical and functional aspects of the project.
• Interacted with user for problems faced and providing necessary technical support by fixing the bugs.
• Worked on Designing, Developing, Testing and production Environment Operational Data Store (ODS) and Data Marts inOracle during the implementation of application.
• Attended the Training sessions in Work environment for integrating the Data into Data Warehouse using ETL Tool Informatica Power center.
• Understood the ETL tool such as Informatica Power center, for Design and develop the mappings from Source systems to Target systems, Using Informatica Designer, workflow manager and workflow monitor.

Environment: Oracle 10g/9i, MS SQL Server 2003, PL/SQL, Erwin, Informatica Power Center 8.1/7.x, MS Access, Excel Files, UNIX Shell Script.