SUMMARY

• Having 8 years of experience working in all the phases of the Data warehousing life cycle including Architecture, Administration, Analysis, design, development, testing and Implementation.
• Over 8 years of strong Data Warehousing experience using Informatica Power Center (Workflow Manager,IBM workflow Monitor, Source Analyser, Repository Manager, Mapping Designer, Mapplet Designer, Transformation developer).
• Experience on SQL Server 2005 Integration Services (SSIS) introduces the concepts of control flow and data flow in packages.
• Poficient in Integration Services architecture and object models.
• Good working knowledge in Data Modeling using Dimensional Data modeling, IBM netezza, Oracle Golden Gate, AWS redshift, Star Schema/Snow flake schema, FACT & Dimensions tables, Physical & logical data modeling.
• Extensive experience in handling ETL using Informatica Power Center 9.x/8.x/7.x
• Extensively worked on Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
• Strong Experience in using Workflow Manager Tools - Task Developer, Workflow & Worklet Designer.
• Extensively used Informatica Repository Manager and Workflow Monitor.
• Strong experience in developing complex mappings using various transformations like Unconnected and Connected lookups, Router, Aggregator, Sorter, Ranker Joiner, Stored Procedure, Update Strategy etc and Re-usable transformations.
• Strong experience in developing Workflows, Worklets, sessions and tasks to effectively manage the Load.
• Experience working with various source systems/files like RDBMS (DB2, Oracle, SQL Server, Teradata) Flat Files, XML Files etc.
• Proficient in databases including DB2, Oracle 11g/10g/9i /8i, Teradata, MS SQL Server, MS Access.
• Proficient in using tools like Microsoft Visio, Microsoft Project, Microsoft Office (Excel, Access, Word, PowerPoint).
• Excellent knowledge in Creating database objects like Stored Procedure, Views, packages, functions and Triggers using PL/SQL.
• Good knowledge of UNIX Shell Scripting.
• Ability to prioritize multiple tasks.
• Good experience in performing Integration testing, System testing, Unit testing and User Acceptance testing.
• Excellent knowledge in identifying performance bottlenecks and tuning the Informatica Load for better performance and efficiency.
• Extensively involved in performance tuning of Informatica mapping and sessions by reducing Data Flow, Eliminating I/O & bottlenecks, optimize resources, optimize common ETL processes and data parallelism.
• Extensive experience in error handling and problem fixing in Informatica.
• Excellent communication and inter personnel skills, Proactive, Dedicated, and Enjoy learning new Technologies and Tools.
• Strong commitment towards quality, experience in ensuring compliance to coding standards and review process.

TECHNICAL SKILLS

Data warehousing: Informatica Power Center 9.5/9.1/8.x/7.x/6.x (Workflow Manager, Workflow Monitor, Warehouse Designer, Source Analyzer, IBM netezza, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Repository Manager), Informatica Web Services, Informatica power mart 6.2/5.1/4.7, Informatica Power Connect for SAP/PeopleSoft/DB2, Power Plug, Power Analyzer, Power Exchange, ETL, Oracle Golden Gate, Metadata, Data Mining, DataMart, OLAP, OLTP, SQL*Plus, SQL*Loader.

Dimensional Data Modeling: Dimensional Data Modeling, Erwin Modeling (Erwin, Oracle Designer), Star Join Schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling, Star & Snowflake schema Relational, dimensional and multidimensional modeling and De-normalization techniques, Kimball & Inmon Methodologies.

Databases: Oracle 11g/10g/9i/8i, SQL, PL/SQL, SQL * Plus, SQL*Loader, SQL Server, DB2 UDB, Teradata, MS Access, SSIS (Integrating Services).

Environment: Windows 8/7/NT/XP/2000/2003, UNIX.

Programming Languages: SQL, PL/SQL, Unix Shell Scripting, AIX Scripting, C, C++, HTML, DHTML.

Web Technologies: HTML, DHTML, XML, Front page, Dreamweaver, AWS Redshift

Tools: SQL *Plus, TOAD, MS Office, Microsoft Visio

PROFESSIONAL EXPERIENCE

Confidential - Norfolk, VA

Informatica Developer

Responsibilities:

• Ensure accuracy and integrity of archived data through analysis, coding and validation.
• Created clear documentation of the process to be followed during the retirement of legacy applications and archiving of Health System data.
• Development and deployment of integrated solutions to enhance, consolidate, and coordinate independently designed applications enterprise-wide; assist in scheduling and coordinating project deliverables with the use of SSIS.
• Possess expertise in process and data modeling, architecture development and IT planning methodologies, as well as extensive knowledge of enterprise business and decision-making processes.
• Strong leadership skills to gain credibility with business leaders and stakeholders, and must possess the ability to work with other IT teams to ensure solid cross-functional decisions are made by the team.
• Build SSIS Packages for data integration.
• Modify Existing SSIS Packages.
• Involved in the requirement definition and analysis in support of Data Warehouse efforts.
• Describes the Capabilities of DTS and summarizes the business problem it addresses.
• Developed ETL mappings, transformations using Informatica Power Developer.
• Extensively used Informatica Client tools - Source Analyzer, Warehouse Designer, Oracle golden gate, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Developed data Mappings between source systems and warehouse components using Mapping Designer.
• Describes specifics data conversion and data transformation issues that can arise when using DTS
• Experienced in data profiling & data quality rules development using Informatica Data Quality tools
• Worked in extensively testing and performance tuning of the mapping and logic.
• Worked on Performance tuning of Oracle queries using SQLtrace, SQLplan, various indexes and join types.
• Worked on Power Exchange for change data capture (CDC).
• Develop test, and implement program logic.
• Utilize ETL tools such as Informatica product suit.
• Worked on building UNIX Shell Scripts to check and update the Teradata/Oracle tables and appending multiple CSV'S to a single CSV and used them in Data stage jobs.
• Used IDQ transformation like labels, standardizing, proofing, parser, address doctor, Match, Exception transformations for standardizing, profiling and scoring the data.
• Used IDQ analyst tool to correct the bad table records, reprocessed the records in Analyst.
• Created custom reports using various tools including Crystal Reports.
• Created, launched & scheduled Workflows/sessions. Involved in the Performance Tuning of Mappings and Sessions.
• Experienced in several facets of MDM implementations including Data Profiling, metadata acquisition, and data migration.
• Documented to describe program development, logic, coding, testing, changes and corrections.
• Implemented extreme programming by using fact paced agile methodology, involving in task completion, user stories, and iterations.
• Provided support in the administration of the Informatica repository Manager and assisted in the design and architecture of multiple repositories to support multiple application developments and QA environments.
• Provided Production support.

Environment: Informatica Power Developer 9.6, SSIS, Informatica Analyst Tool, Power Connect, Oracle Golden Gate, Teradata, Oracle Data Integrator, Flat file, TOAD, UNIX scripting, Windows, Hyperion, Microsoft DTS packages.

Confidential, Memphis, TN

Informatica Developer

Responsibilities:

• Analyzed Business/ functional Specifications and worked with Business Analyst team and identified the source data and transformation logic needs and review of final mapping documents.
• Interacted with business users to gather requirements and understand business logic/other features expected from ETL and Reporting system.
• Involved in enhancing the data model for new additions of dimension and reference tables.
• Extensively used Erwin tool in Forward and reverse engineering, following the Corporate Standards in Naming Conventions, using Conformed dimensions whenever possible.
• Created mappings and Mapplets using the transformations such as Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Sequence Generator and Update Strategy.
• Used Error Handling to capture error data in tables for handling nulls, analysis, and error remediation Process.
• Create the DDL scripts using ER Studio and source to target mappings (S2T- for ETL) to bring the data from NS to the warehouse.
• Identified source systems, their connectivity, related tables and fields and ensure that data is suitable for mapping.
• Extensively used Informatica Functions LTRIM, RTRIM, DECODE, ISNULL, IIF, INSTR and date functions in Transformations.
• Developed Sessions and Workflows for the project.
• Extensively used Informatica XML transformations like XML Source Qualifier, XML Parser and XML Generator to load data from XML files to DWH
• Created Informatica data load where source files have XML applications
• Effectively worked on Mapping Designer, Workflow Manager, and Workflow Monitor.
• Extensively used Sequence Generator in all mappings and fixed bugs / tickets raised in production for existing mappings in a common folder for new files through versioning (Check in and Check out) on an urgency through support for QA in component unit testing and validation.
• Used shortcuts for sources, targets, transformations, Mapplets, and sessions to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Created Tidal jobs to schedule Informatica Workflows. Executed workflows using Tidal schedule.
• Involved in checking Data accuracy standards for NULLS, Comparison, key generator and labeler using reference table manager in PWH and rolled based on statistics through Threshold value and Score Cards applied the Data cleansing process in Model Repository on the same domain and merged to Power center.
• Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time.
• Performed the data profiling and analysis making use of Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ).
• Used Informatica Power Exchange to handle the change data capture (CDC) data from the source and load into Data Mart by following slowly changing dimensions (SCD) type II process.
• Used Power Center Workflow Manager to create workflows, sessions, and also used various tasks like a command, event wait, event raise, email to run with the logic embedded in the mappings.
• Developed Error/Exception handling mechanism to enhance the data quality loaded to EDW.
• Created BTEQ scripts to in corporate the transformation rules.
• Used TOAD to write queries and interact with Oracle database.
• Developed several PL/SQL procedures, functions to provide data consistency.
• Developed UNIX scripts to automate different tasks involved as part of the loading process.
• Performed Unit Testing and Integration Testing on the mappings.
• Involved in Performance Tuning of Sessions and Mappings.
• Did Informatica mapping specification documents for the mappings developed and documented them according to Business standards.

Environment: Informatica Power Center 9.5/9.1, Teradata 14.0, Oracle 11g, SQL LOADER, Flat Files, SQL Server 2012, AWS redshift, Mercury Quality Center 9, SSIS,UNIX Shell Scripting, TOAD, Crontab, SQL, PL/SQL, VSS, IDE, IDQ, Erwin, TOAD, Outlook, putty, WinSCP.

Confidential, Pittsburgh, PA

Informatica Developer

Responsibilities:

• Involved in ETL designing and coding. Extensively used ETL (Informatica tool) to load data from Oracle database, SQL server, and Flat files to Teradata Data Warehouse.
• Modified the existing mappings and workflows as per requirement changes and migrated them back to the production environment.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target (in Informatica 9.1/9.5 versions).
• Used Informatica Designer to create complex mappings using different transformations like Source Qualifier, Expression, Lookup, Aggregator, and Update Strategy, Joiner, Filter and Router transformations to pipeline data to Data Warehouse/Data Marts.
• Created robust and complex workflow and Worklets using Informatica Workflow Manager and troubleshot data load problems.
• Created Workflows, re-usable Sessions using Workflow Monitor.
• Handled slowly changing dimensions of Type I, Type II to populate current and historical data to Dimensions tables in the data warehouse.
• Developed PL/SQL stored procedures/functions and Unix Shell Scripts as a part of the project.
• Widely used Parameter file to override mapping Variables, Workflow Variables, Session Parameters, FTP Session Parameters and Source-Target Application Connection parameters.
• Performed Developer testing, Functional testing, and Unit testing for the Informatica mappings.
• Performed Performance tuning and also have used the debugger to troubleshoot errors.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.

Environment: Informatica Power Center 9.5/9.1/8.6, Workflow Manager, Windows 2003, Erwin4.0, Oracle 11g/10g, SQL server, XML, SQL, PL/SQL, Teradata, Unix Shell Scripts, Flat Files, Windows NT.

Confidential, Austin, TX

Informatica Developer

Responsibilities:

• Responsible for converting Functional Requirements into Technical Specifications.
• Worked with the team to Integrate data from multiple source systems like Health Answers, Power system, Health Plex into Single Data Warehouse system.
• Worked on Designer tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer and Mapping Designer.
• Creating mappings with different transformations like Parser transformation, Standardizer transformation, Address Validator in Informatica developer (IDQ) tool.
• Used Address validator transformation in IDQ and passed the partial address and populated the full address in the target table.
• Designed and developed complex ETL mappings making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator.
• Extracted data from Flat files and Oracle and loaded them into Teradata.
• Designed the ETL processes using Informatica to load data from Oracle to target Teradata Database.
• Loaded the data into the Teradata database using Load utilities like FastExport, FastLoad, MultiLoad, and Tpump.
• Developed complex mappings, mapplets using Informatica workflow designer to integrate data from varied sources like Teradata, Oracle, Flat files and loaded into the target.
• Worked with Shortcuts across Shared and Non Shared Folders.
• Created Pre-Sql and Post-Sql scripts which need to be run at Informatica level.
• Developed Oracle views to identify incremental changes for full extract data sources.
• Developed Stored Procedures which truncates the Tables and reinserts all/partial records depending on the "Load Flag" Parameter passed to the procedure.
• All messages/errors/load times are logged into the log table.
• Developed the automated and scheduled load processes using Fact scheduler.
• Involved in the migration of mappings and sessions from development repository to production repository.
• Responsible for Unit testing and Integration testing of mappings and workflows.
• Worked on production tickets to resolve the issues in a timely manner.
• Populated and updated data dictionary, standardized naming convention.

Environment: Informatica PowerCenter 8.6, Informatica Data Quality (IDQ), Data Quality, Teradata, Oracle 10g, DB2- Surveyor 400, Solaris UNIX, TOAD, Fact.

Confidential, Heathrow, FL

Informatica Developer

Responsibilities:

• Analyzed the source systems data and the current reports at the client side to gather the requirements for the Data Warehouse Data Model.
• Managing Team, Timelines and Coordinating with the Business Partners.
• Involved in creating new table structures and modifying existing tables and fit into the existing Data Model.
• Extracted data from different databases like Oracle and external source systems like flat files using ETL tool.
• Created mappings using transformations like Source Qualifier, Aggregator, Expression, lookup, Router, Filter, Update Strategy, Joiner, Union, and Stored procedure, and XML transformations.
• Worked on Informatica Power Center tools - Source Analyzer, Warehouse Designer, Mapping & Mapplet Designer, and Transformation Developer.
• Schedule and Run Extraction and Load process, monitor task and workflow using the Workflow Manager and Workflow monitor.
• Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data.
• Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica.
• Involved in Performance Tuning at various levels including Target, Source, Mapping, and Session for large data files.
• Worked on Migration Strategies between Development, Test, and Production Repositories.
• Supported the Quality Assurance team in testing and validating the Informatica workflows.

Environment: Informatica PowerCenter 7.1/8.6, Oracle 9i, PL/SQL, SQL*Plus, SQL* Loader, Erwin 3.5, DB2, Sybase, SQL Server 2000, MS-Excel, XML, Flat files, Shell Scripting.

Confidential

Informatica Developer

Responsibilities:

• Prepared technical design/specifications for data Extraction, Transformation, and Loading.
• Worked on Informatica Utilities Source Analyzer, warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Analyzing the sources, transforming data, mapping the data and loading the data into targets using Informatica Power Center Designer.
• Created reusable transformations to load data from operational data source to Data Warehouse and involved in capacity planning and storage of data.
• Used various transformations like Stored Procedure, Connected and Unconnected lookups, Update Strategy, Filter transformation, Joiner transformations to implement complex business logic.
• Used Informatica Workflow Manager to create workflows, database connections, sessions and batches to run the mappings.
• Defined the Source databases and Target databases in Informatica.
• Created PL/SQL packages and procedures to build business rules to load data.
• Designed strategy and coded procedures to extract daily incremental data.
• Created UNIX shell scripting for file handing and archival and also to run the workflows for Informatica mappings.
• Developed materialized views for aggregate data information.
• Involved in Performance Tuning of Informatica mappings, SQL Query, views etc.
• Involved in performance tuning of SQL statements on Oracle database.

Environment: Informatica PowerCenter 8.6, Oracle 8i, SQL, PL/SQL, Erwin, SQL*Plus, SQL*Loader Tool, Windows, UNIX.

Confidential

Informatica Developer

Responsibilities:

• Extensively involved in writing ETL Specifications for Development and conversion projects.
• Created shortcuts for reusable source/target definitions, Reusable Transformations, mapplets in Shared folder.
• Involved in requirement definition and analysis in support of Data Warehouse.
• Worked with XSD and XML files generation through ETL process.
• Defined and worked with mapping parameters and variables.
• Designed and developed transformation rules (business rules) to generate consolidated (fact/summary) data using InformaticaETL tool.
• Developed workflow tasks like reusable Email, Event wait, Timer, Command, Decision.
• Used various debugging techniques to debug the mappings.
• Developed packages, procedures, functions, and PL/SQL blocks for data validation.
• Created database links to access data from remote databases.
• Coordinated with testing team to make testing team understand Business and transformation rules being used throughout ETL process.

Environment: Oracle8i, SQL, PL/SQL, Developer 2000, Reporter 4.5, UNIX, Windows, Informatica Power center 8.1, Teradata.