SUMMARY

• Over 8+ years of extensive Data Warehousing experience in designing and creating mappings using Informatica Power Center 9.5.1/9.5.0/8.6/7.1.3/6.1.2 ) including Designer, Workflow Manager, Workflow Monitor, Repository Manager.
• Strong experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Designer, Workflow Manager, Workflow Monitor, Metadata Manger).
• Expertise in Dimensional data modeling, Star schema modeling, Snowflake modeling, Data Normalization.
• Solid experience in all phases of Data warehouse life cycle involving design, development, analysis & testing of Data warehouses using ETL and Data Modeling.
• Worked wif Full Software Development Life Cycle (SDLC) involving Application Development and ETL/OLAP Processes.
• Experience in performance tuning of Informatica Sources, Targets, Mappings and Sessions. Highly proficient in processing tasks, scheduling sessions, import/export repositories, manage users, groups, associated privileges and folders.
• Developed mappings in Informatica to load the data from various sources into the Data warehouse different transformations like Source Qualifier, JAVA, Expression, Lookup, Aggregate, Update Strategy and Joiner.
• Worked exclusively on implementing the types of slowly changing dimensions (SCDs) - Type 1 and Type 2 in different mappings as per the requirements.
• Experience in UNIX Shell Scripting.
• Experience in using the Informatica command line utilities like PMCMD to control workflows in non-windows environments.
• Strong Expertise in using Tools like Tableau Server, Tableau Desktop and Qlikview.
• Expert in Data Visualization development using Tableau to create complex, intuitive, and innovative dashboards.
• Experience in defining and configuring Landing Tables, Staging Tables, Base Objects, Hierarchies, Foreign key relationships, Queries, and Packages in MDM.
• Defined Entity objects, Hierarchies, Entity and Relationship Type, Relationship Object using Hierarchy Tool.
• Hands on experience wif data steward tools like data, merge and hierarchy manager in MDM.
• TEMPHas a strong ability to articulate and present complex technical concepts so that business users can realize the value of these technologies.
• Experience inOracle supplied packages, Dynamic SQL, RecordsandPL/SQL Tables.
• Strong skills in SQL, PL/SQL packages, functions, stored procedures, triggers and materialized views to implement business logic in oracle database.
• Worked wif various SQL Editors such as TOAD and SQL Plus. Solid background in data modeling and database design,
• In depth experience in Oracle database architecture, Oracle database development, Oracle database administration, database/SQL performance tuning, Data Warehouse.
• Performed the data profiling and analysis making use ofInformatica Data Explorer (IDE) and Informatica Data Quality (IDQ)
• Excellent analytical and problem-solving skills, ability to isolate and resolve problems in timely manner
• Knowledge on implementing hierarchies, relationships types, packages and profiles for hierarchy management in MDM Hub implementation.
• Experience in data analysis and business intelligence using Talend Open Studio.
• Experience working on Informatica Scheduler for job scheduling.
• Experience in usingSSIStools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Experience inimporting/exportingdata between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility.
• Worked wif cross functional teams such as QA, DBA to deploy the code from development to QA and QA to Production.
• Excellent communication and interpersonal skills. Committed and Motivated team player wif good Analytical skills.
• Ability to achieve project goals wifin project constraints such as scope, timing and budget.
• TEMPHas a strong ability to articulate and present complex technical concepts so that business users can realize the value of these technologies.

TECHNICAL SKILLS

ETL Tools: Informatica Power center 9.x/8.x/7.x/6.x, Informatica Power Exchange 8.x/9.x, Data Stage 7.5, SSIS, Talend Open Studio, Abnitio, IDE, IDQ

Reporting Tools: Tableau Desktop 7.0/8.0/8.1, Cognos, SSRS, Crystal Reports.

Operating Systems: UNIX, Windows 98/ NT/2000/XP, Solaris

Database: TERADATA 14.x, Oracle 10g/9i, SQL Server,DB2

Database GUI Tools: TOAD, SQL Assistant

Web Development: HTML,XML

Programming Languages: Oracle SQL, PL/SQL, UNIX, Shell Script, C, C++

Scheduling Tool: Autosys, ZENA, IBM WLM, Control M, UC4, JAMS.

Data Modelling: Erwin

PROFESSIONAL EXPERIENCE

Confidential, Portland, ME

Informatica Developer

Responsibilities:

• Involved in designing, developing and documenting of the ETL process (Extract, Transformation and Load) to populate the Data from various source system feeds using Informatica.
• Involved in sourcing the xml rows from source database
• Parsed the xml filtering the key/value combinations which are not needed. Created the target file which is pipe delimited txt file wif each containing policy id, key, value.
• Created data files which are ready to be loaded into the target db tables.
• Loading the data files into the final target database.
• Partitioned sessions for concurrent loading of data into the target tables.
• Designed and developed mappings, defined workflows and tasks, monitored sessions, exported and imported mappings and workflows.
• Created and configured workflows and sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Created Mapping Parameters and Variables.
• Profiled the data usingInformatica Data Explorer(IDE) and performed Proof of Concept forInformatica Data Quality(IDQ).
• Knowledge of IDQ 9.1 standards, guidelines and best practices.
• Knowledge of Data Profiling guidelines and best practices.
• Knowledge of best practices on Process Sequence, Dictionaries, Data Quality Lifecycles, Naming Convention, Version Control.
• Actively participated in code reviewing and assists to ensure developers follow theIHA standards. Providequality reviewsfor the work of other team members when required.
• As part of the INBOUND Interface project, have run the (PERL and UNIX) scripts to decrypt files from Insurity and as part of OUTBOUND Interface project, have run (PERL and UNIX) scripts to encrypt and send files to Insurity Server.
• Connected to Insurity FTP site from UNIX server to download the files and used SmartFTP for transferring the files.
• Used SQL tools like SQL server management studio to run SQL queries and validate the data pulled in reports.
• Complete understanding of data warehouse architecture, star schemas and snowflakes.
• Experienced in data profiling, data analysis, data quality checking.
• Experienced wif documenting data models.
• Supporting day-to-day issues as well as new pieces of work
• Identified recurring issues/alerts and conduct root cause analysis

Environment: s: Informatica Power Center 9.1.0, (Repository Manager, Mapping Designer, Workflow Manager and Workflow Monitor), MS SQL server 2008, Putty, SmartFTP, FileZilla 3.5.3, UNIX, IDE, IDQ 9.1

Confidential, charlotte, NC

Informatica Developer

Responsibilities:

• Involved in the design, development and implementation of the Enterprise Data Warehousing (EDW) process and Data Mart.
• Used Informatica Power Center 9.0.3 for migrating data from various OLTP servers/databases to the data mart.
• Created complex Informatica mappings to load the data mart and monitored them. The mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner, Sequence generator.
• Used Lookup Transformation to access data from tables, which are not the source for mapping and also used Unconnected Lookup to improve performance.
• Expertise in developing SQL and Oracle PL/SQL code as procedures to implement the business logic.
• Worked on ETL design, development, source to target mappings, data warehouse transformations, on call support, troubleshooting, testing, and documentation.
• Used Informatica Power Center/Power Exchange to extract/transform and load data from different operational data sources like Oracle, Flat files into staging area (Oracle) and load into Oracle data warehouse.
• Involved in implementing the Land Process of loading the customer/product Data Set into Informatica MDM from various source systems.
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Configured match rule set property by enabling search by rules in MDM according to Business Rules.
• Performed match/merge and ran match rules to check the TEMPeffectiveness of MDM process on data.
• Performed data analysis for Advanced Commercial Banking System (ACBS) data.
• Implemented Slowly Changing Dimensions for accessing the full history of accounts and transaction information.
• Extensively worked wif performance tuning Confidential mapping levels. For example, implementing active transformation like filter as early as possible in the mapping.
• Created and configured workflows, and sessions using Informatica Workflow Manager.
• Performed unit test for Informatica mappings and workflows in both development and test environments.

Environment: Informatica Power Center 9.X, Toad Data Modeler, Oracle 10g/11g, Visio, Excel, Flat Files, MDM.

Confidential, Atlanta, GA

Informatica Developer

Responsibilities:

• Installed Informatica Power Mart Server and Client.
• Extensively used Informatica for loading the historical data from various tables for different departments.
• Designed and developed transformation rules (business rules) to generate consolidated (fact and summary) data using Informatica Power Mart 4.7.
• Created reusable transformations and mapplets and used them in mappings.
• Used Informatica Power Center Server manager to create sessions, batches to run wif the logic embedded in the mappings.
• Tuned the Transformations and mappings for better performance.
• Involved in the development of Informatica mappings and also tuned them for better performance.
• Created mappings wif PL/SQL procedures/functions to build business rules to load data.
• Created transformations like Stored Procedure, Aggregate, Joiner, Filter, and Expression.
• Worked on Talend RTX ETL tool, devalop jobs and scheduled jobs in Talend integration suite.
• Extensively used the concepts of ETL to load data from AS400, flat files to Saleforce.
• Modified reports and Talend ETL jobs based on the feedback from QA testers and Users in development and staging environments.
• Implementation of MS SQL Server 2008/2005 Management studio to create Complex Stored Procedures, User Defined Functions (UDFs) Views using Confidential -SQL to evaluate result for the reports.
• Responsible for installation and Configuration of SQL Server 2005 and 2008database and configuration of Report manager.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.
• Developed, deployed, and monitored SSIS Packages.

Environment: Informatica PowerCenter 8.6, Oracle 8i, PL/SQL, TOAD, EWIN 3.0, UNIX Shell Script, Talend Open Studio, MSSQLServer2005/2008,SQLReporting Services (SSRS),SQLIntegration Services (SSIS), MSSQLServer2008

Confidential, Colombus, OH

Informatica Developer

Responsibilities:

• Translated business requirements into data mart design.
• Worked wif SQL, PL/SQL commands and command line program pmcmd to start/schedule/stop workflows.
• Improved integrity by identifying and creating relationships between tables.
• Involved in Dimensional modeling to design and develop STAR Schema, using Erwin to design Fact and Dimension Tables.
• Involved in import/export of repositories, backing up the repository.
• Worked on different data sources such as Oracle, XML, and Flat Files.
• Extensively worked wif Mapping Designer to create mappings based on the business logic.
• Extensively worked wif various transformations including Source Qualifier, Lookup, aggregator, Expression, Joiner, Filter, Router, Java and Update Strategy Transformations.
• Tuned the mappings Confidential session level by setting the buffer size, cache size, increasing commit intervals etc.
• Worked extensively on fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions and Target Data.
• Worked on configuring the Java classpath in the session properties while using third-party Java packages, built-in Java packages, and custom Java packages in a Java transformation and also in Java SDK Custom transformation.
• Created Reusable Transformations and Mapplets to use in multiple Mappings
• Created various UNIX Shell Scripts for pre/post session commands.
• Extensively worked wif Workflow Manager to create workflows, worklets wif different tasks (Session, Decision, E-mail, Event-Raise and Event-Wait).
• Extensively worked wif the Informatica server that runs on UNIX platform.

Environment: Informatica Power Center 7.1, Oracle 9i, SQL server 2000, SQL, XML, UNIX and Windows, Java.

Confidential

Data Warehouse Developer

Responsibilities:

• Create new tables, views, indexes and user defined functions.
• Assisted in designing the database wif an emphasis on improving performance if daily jobs and stored procedures
• Implemented indexes to improve query performance
• Implemented performance tuning in Confidential -SQL queries and Stored Procedures
• Create joins and sub-queries for complex queries involving multiple tables.
• Developed complex stored procedures to create various reports.
• Data migration from Text to SQL Server.
• Developed Stored Procedures and Views to be used to supply the Data to the Reports.
• Complex formulas were used to show derived fields and to format the data based on specific conditions.

Environment: Oracle 9i, SQL, PL/SQL, Windows XP, UNIX, MS Office.