SUMMARY

• 6 years of experience in Information Technology having involved in in analysis and design, implementation, maintenance and support using Informatica Power Center 9.x/8.x.
• Knowledge of Data warehouse concepts and principles (Kimball/Inman) - Star Schema, Snowflake, SCD, Surrogate keys, Normalization/De normalization.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server and DB2, COBOL files, XML files and Worked on integrating data from flat files like fixed width and delimited.
• Have extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators.
• Strong experience in developing Sessions/tasks, Worklets, Workflows using Workflow Manager Tools - Task Developer, Workflow & Worklet Designer.
• Experience inSlowly Changing Dimensions Type 1, Type 2andType 3for tables for maintaining the history.
• Worked with Informatica Data Quality toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ.
• Experience with slowly changing dimension and slowly growing targets methodologies.
• Experience in using the Informatica command line utilities like pmcmd to execute workflows in non-windows environments.
• Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Hands on experience in Performance tuning of sources, targets, transformations and sessions.
• Good experience in documenting the ETL process flow for better maintenance and analyzing the process flow.
• Solid experience in writing SQL queries,Stored Procedures, Cursors, Indexes, and views.
• Experience onDebuggerto validate the mappings and gain troubleshooting information about data and error conditions.
• Experience on advance SQL query techniques and using utilities for import.
• Experience in Version control Code check in and check out, delivering code to the integration stream and moved to the production.
• Experience with OLAP, ROLAP and other BI tools.
• Experience with Cognos Decision Stream ETL tool, and Erwin Data Modeling tools and knowledge about Informatica Big Data Editor.
• Experience in UNIX shell scripting, CRON, FTP and file management in various UNIX environments.
• Experience onpost-session and pre-session shell scriptsfor tasks like merging flat files deleting temporary files, changing the file name to reflect the file generated date etc.
• Good team player with strong communication skills and willing to learn and adapt to new challenges.

TECHNICAL SKILLS

Operating Systems: Windows 2003/2008/XP/7, UNIX, Linux.

RDMS: Oracle 10g/9i/8i, MS SQL Server 2012/2008/2005 , DB2, OLAP Tools, Cognos 7.0/6.0, Unix Shell Script, Visual Basic, TOAD, SQL* Loader.

ETL TOOLS: Informatica 9.1/8.6/8.5.1/7.1 (Power Center/Power Mart) (Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Connect), Cognos Decision Stream 7.2, IDQ

Data Modeling Tools: Erwin 4.0/3.5, Visio 2007, Star Schema Modeling, Snow Flake Modeling

Programming Languages: T-SQL, PL/SQL C/C++,Visual Studio2005/2003, ASP.NET, VB.Net

PROFESSIONAL EXPERIENCE

Confidential, Richardson, TX

ETL Informatica Developer

Responsibilities:

• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer.
• Implemented various Transformations likeJoiner, Aggregate, Expression, Lookup, Filter, Update Strategy, Stored Procedures, and Routeretc.
• Also have good knowledge inPerformance Tuning at both Database Level and Informatica.
• Extracted data from multiple operational sources for loading staging area, Data warehouse, Data Marts using SCD's (Type 1/Type 2) loads.
• Using Informatica Server Manager for Creating, running the Batches, Sessions and scheduled to run at specified time.
• Design and development of Informatica Data Quality plans
• Involved in uploading Dictionaries using IDQ Content installer.
• Developed reusable Mapplet called as Plans in IDQ and imported into Power center.
• Worked on test plans and executed it atUNITtesting and also supported forsystem testing, volume testing and User Acceptance Testing.
• Extracted, transformed data from various sources such asFlat files, COBOL filesand transferred data to the target data warehouse.
• Developed complexStored Procedures, Packages, Triggers, Cursors and ShellScriptingwhich were in turn used in Informatica for mapping purposes based on certain conditions.
• Extensively used ETL and Informatica to load data from SQL database, Excel spreadsheet, into the targetOracle database.
• End-to-End ETL development of theData Mart. Data Quality Analysisto determine cleansing requirements. Designed and developed Informatica mappings for data loads.
• Extensively used various tasks like Session task, Event Wait task, Decision task, Email task, Command task.
• Checked Sessions and error logs to troubleshoot problems and also useddebuggerfor trouble shooting.
• Designed ETL Flow diagram in Visio to arrive at the schedule forAutosys Jobs.

Environment: InformaticaPowerCenter9.1/8.6.1, IDQ, SQL Server 2014/20122008 R2, Oracle 11g/10g, ERWIN, Autosys, UNIX, Windows XP.

Confidential, PA

BI/ETL Developer

Responsibilities:

• Interacted with Business Analysts and SMEs while creating General Specification, Detailed Specification and Source to Target Mapping Documents.
• Created Entity Relationship Diagrams using Erwin Tool.
• Created Informatica mappings using SQL/PL SQL queries, and Cogons Decision Stream Builds.
• Created re-usable Transformations/Mapplets and used across various mappings.
• Wrote complex PLSQL functions/procedures.
• Developed and executed several optimized queries in SQL.
• Enhancing and deploying the SSIS packages from development server to production server.
• Involved in creation of dimensions using star and snow flake schemas.
• Designed and created report models based on users’ requirements, explain and train users to use report builder to generate their own personalized reports.
• Created Informatica Metadata Manager/Business Glossary, standardize and map business terms, metrics, related terms, synonyms, data quality rules, constituencies and data stewards/owners in metadata repository with end-to-end lineage diagrams.
• Performed metadata validation, reconciliation and appropriate error handling inETLprocesses.
• Created complex Informatica mappings using Unconnected Lookup, Joiner, Rank, Source Qualifier, XML, Sorter, Aggregator, Lookup and Router transformations to extract, transform and load to data warehouse area.
• Designed restart recovery logic and also defined point of commit activities for highly volume loads.
• Involved in activities like database archiving, test data management, data masking, and security of data as part of ILM.
• Good Knowledge onapplying rules and policies using ILM (Information Life Cycle Management) workbench for Data Masking Transformationand loading into targets.
• Involved in performance tuning of Informatica code using standard Informatica tuning steps.
• Developed Informatica workflows/Worklets/sessions associated with the mappings using Workflow Manager.
• Responsible for error handling using Session Logs, Reject Files, and Session Logs in the Workflow Monitor.
• Informatica dataflow partition was used for loading large files of data.
• Wrote test cases and executed test scripts in Data warehouse.

Environment: Informatica Power Center 9.1, Metadata Manager, ILM, Oracle 11g, Flat files, XML filesSQL server 2012/2008/2005 , SQL Developer, Cognos Decision Stream 7.2, AppWorks.

Confidential, OK

ETL Migration Consultant

Responsibilities:

• Interacted with business analysts for Need Analysis and to define Business and Functional Specifications. Participated in the Design team meetings and prepared technical, mapping and run documentations.
• Extensively used SSIS import/Export wizard for performing the ETL operation.
• Involved in Analyzing the System requirements, implementation of star schema & involved in designing and development of data warehouse environment.
• Created/modified various Informatica Mappings and workflows for the successful migration of the data from various source systems to Oracle Data Warehouse which meets the business requirements for reporting and analysis.
• Optimized the performance of the mappings by various tests on sources, targets and transformations. Identified the Bottlenecks, Removed the Bottlenecks and implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Created and managed the databases in development environment.
• Involved in creating, maintaining different SQL server objects such as tables, procedures, functions, views, triggers etc. according to the requirements.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Deployed SSIS packages across various environments using configuration files and variables.
• Involved in knowledge transfer to the peers documenting of all the business logic, insuring maintenance is easy for the peers.
• Performed logging, error handling by using event handler, custom logging for SSIS packages.
• Performed Unit Testing of the mappings developed and ETL process to check if the transformations are executing as expected.
• Analyzed Session Log files, used debugger wizard in case the session fails in order to resolve errors in mapping or session configurations.
• Assisted in setting up jobs in the correct sequential load order in the scheduling tool AppWorks.
• Actively coordinated with testing team in the testing phase and helped the team to understand the dependency chain of the whole project.

Environment: Informatica Power Center 9.1, Oracle 10g, SQL server 2012/2008R2/2008/2005, SSIS, SSRS,Flat files, TOAD, VisiPrise, Main Frames, LINUX, Windows XP.

Confidential, IA

ETL Informatica Developer

Responsibilities:

• Interacted with the Business Personnel to analyze the business requirements and transform the business requirements into the technical requirements.
• Prepared technical specifications for the development of Informatica (ETL) process to load data into various target tables.
• 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, SQL, Stored Procedure, Sequence Generator transformations and Normalizer.
• Extensively used XML Source, XML target and XML Parser transformations.
• Extensively used Stored Procedures, Functions and Sequences using PL/SQL.
• Improved the Informatica Mappings and Sessions Performance by eliminating extensive Cache usage transformations, tuning source queries, dropping Indexes on the target table, modifying session properties.
• Worked on email, command and assignment tasks.
• Developed the pre session scripts, which will create the parameter file dynamically.
• Implemented slowly changing dimensions methodology and developed mappings to keep track of historical data.
• MigratedETL code from development to QA and then QA to production.
• Responsible for Unit testing, User Acceptance testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Maintaining jobs for data messaging from development server to test server for generating daily reports for financial and marketing team.
• Worked with Session logs and Workflow logs for Error handling and troubleshooting in Development environment.
• Involved in the production support and also transferred knowledge to the other team members.

Environment: Informatica Power Center 9.1/8.6, Oracle 11g, MS SQL Server 2008 R2, Mainframe Files (COBOL files), XML files, Flat Files, MS Access 2007, Benthic Software (Golden32), Cognos.

Confidential, Detroit, MI

Informatica Developer

Responsibilities:

• Involved in ETL process from development to testing and production environments.
• Involved in Data Analysis, requirement gathering, setting standards and warehouse maintenance.
• Created standard templates or patterns to standardize the process. Established standard code migration process.
• Extensively worked with Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Designed and developed complex mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner and Update Strategy.
• Worked extensively with Variables and Parameters.
• Implemented Type II Slowly Changing Dimensions.
• Involved in creating Informatica mapping to populate staging tables and data warehouse tables from various sources like flat files db2, Netezza and oracle sources.
• Created reusable transformations and mapplets and used them in complex mappings.
• Setting up sessions to schedule the loads at required frequency using Power Center Workflow manager, PMCMD and also using scheduling tools. Generated completion messages and status reports using Workflow manager.
• Created workflows and worklets for designed mappings.
• Worked on Dimension as well as Fact tables, developed mappings and loaded data on to the EDW.
• Wrote session commands to configure pre-session and post-session tasks.
• Developed SQL stored procedures, and triggers for data load and transformation, and data extraction.
• Created, Tested and debugged the Stored Procedures, Functions, Cursors and triggers using SQL developer.
• Loaded data from the files got in different formats into the development and production systems.
• Created External Tables to access data for interfaces from a data file instead of loading the data into the database as per storage consideration.
• Involved in writing complex stored procedures to facilitate functionality. Wrote complex queries using SQL.
• Maintain all documentation and spreadsheets for SQL Database operations. Prepared documentation for database operations standards.
• Handled large volume of data, some tables having records of 100 million and some tables having an average of 50 million records.
• Troubleshooting development problems.
• Subsequent alterations of design based on user requirement changes.
• Implementation of coding and documentation standards to be followed.

Environment: SQL Server, Windows XP, Informatica Power Center 8.6, Oracle 11g, MS SQL Server 2008 R2, Mainframe Files (COBOL files), XML files, Flat Files, MS Access 2007, Benthic Software (Golden32), Cognos.