SUMMARY:

• Extensive experience in Information Technology with special emphasis on design and development of ETL Process, building Data Warehouse/EDW, performance on Data Integration Services, Database Testing.
• 6+ years of experience utilizing Informatica Power Center in all the phases of the Data Warehouse Life Cycle involving design, Development, Analysis.
• 4+ Over four years of experience in SQL, PL/SQL, T - SQL, Procedures/Functions, Stored Procedures, Triggers, Packages, Index Design and Tuning.
• 2+ years of experience as QA Analyst/Test Engineer on Manual and Automation Testing using ALM, JIRA, Bugzilla, Quality Center, QTP, Selenium.
• Mastery over the ETL process in extraction of the data from heterogeneous systems, transforming them using various kinds of transformations and loading the transformed data into the Data Warehouse followed by the analysis of the loaded data with the utilization of OLAP tools.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflakes Schema Modeling, Fact and Dimension tables, Pivot Tables.
• Expertise in Data Cleansing at staging level with utilization Informatica Power Center.
• Extensive experience in Data warehousing tools Informatica Power Center using different modules like Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Experience in integration of various data sources like Oracle, Teradata, Netezza, SQL server, SAP, Sybase, Informix, MQ series and XML, Flat files, Mainframes, XML files and Scheduling tools like Control-M, Autosys and Informatica Scheduler.
• Expertise in Performance Tuning, Indexing and Partitioning techniques on sources, targets, mappings and workflows
• Experience writing and modifying ETL Design Documentation, Test Results Documentation and Standard Operating Procedures (SOP) documentation.
• Experience in developing Shell Scripts on UNIX and experience with UNIX command line.
• Hands-on knowledge of Software Testing as Quality Assurance Analyst/Performance Test Engineer and related matters.
• Have good communications, management and problem solving skills with self-motivation, ability to working dependently or cooperatively in a team.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center (9.6/8.6/8.1), Informatica Power Exchange (9.6/8.6), SSIS

BI Tools: OBIEE, Cognos, SAP(Business Objects/Crystal Report), Pentaho, Tableau

Database: Oracle 11g/10g/9i/7i, MS SQL Server (2000, 2008), SYBASE, DB2-UDB, Teradata, Informix, Netezza

Data Modeling Tools: ER/Studio, ERWIN, Power Designer

Reporting Tools: Crystal Report, SSRS, Micro Strategy

Languages: SQL, PL/SQL, T-SQL, UNIX Shell Scripts, Java, VB ScriptsOperating Systems: UNIX/LINUX, AIX, Windows, MS Windows Server, MS DOS, Sun Solaris

Other Applications: Toad, SQL Developer, Visual Studio, MS Visio, Control M, Autosys, JIRA

Protocol: ODBC, JDBC, OLE DB, TCP/IP

Server: MS SQL Server, LINUX Server

PROFESSIONAL EXPERIENCE:

Confidential, Baltimore, MD

Informatica Developer

Responsibilities:

• Developed Data Flow diagrams to create Mappings and Test plans from OLTP systems staging to Data warehouse.
• Designed and developed Mappings from OLTP to Stage and Stage to DWH and effectively used Informatica Transformations like Source Qualifier, Joiner, Expression, Router, Aggregator, Connected and Unconnected Lookup, Normalizer, Update Strategy etc.
• Developed complex mappings, mapplets using Informatica workflow designer to integrate data from varied sources like Teradata, Oracle, SQL Server, Flat files and loaded into target.
• Worked on performance tuning by identifying the bottlenecks in Sources, Targets, and Mapping. Enhanced Performance on Informatica sessions using large data files by using partitions.
• Worked with Static cache, Persistent cache, Dynamic cache, Index cache, Data cache.
• Extensively performed Data Masking for preserving the referential integrity of the user data.
• Build number of Unix Shell scripts for PL/SQL programs to schedule them on Control M.
• Assisted the development team to design standards and codes for effective ETL procedure development and implementation.
• Worked with SQL Override in the Source Qualifier and Lookup transformation.
• Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Created Unix Shell Scripts for ETL jobs, session log cleanup, dynamic parameter and maintained shell scripts for data conversion.
• Prepared Unit Test plan and efficient unit test documentation was created along with Unit test cases for the developed code.
• Involved in the process design documentation of the DW Dimensional Upgrades.
• Validate the data in source and target systems using PL/SQL queries.
• Involved in migration of mappings and sessions from development repository to production repository

Environment: Informatica Power Center 9.6., Power Exchange 9.6, AS-400 (DB2), Oracle 11g, Teradata 14, SYBASE, OBIEE 10g, SQL/P SQL, IDQ, SQL Server 2005/2K, AIX, Windows XP, LINUX, UNIX, Sun Solaris, Putty, SCM, Rally, Control M.

Informatica Developer

Responsibilities:

• Developed ETL jobs to extract information from Enterprise Data Warehouse.
• Extensive use of ETL process to load data from different RDBMS, XML and flat files.
• Used Informatica Repository Manager to create repositories and users and set permissions.
• Experience in Performance tuning of SQL queries and mainframe applications.
• Involved in Data Extraction from Oracle, Flat files, Mainframe files using Informatica.
• Debugged the mappings extensively, hard coding the test data to test the logics going instance by instance.
• Handle the migration process from Development, Test and Production Environments.
• Implemented Type 2 slowly changing dimensions to maintain dimension history and tuned the mappings for Optimum Performance.
• Developed PL/SQL Procedures at the database level that were used in the mappings through Stored Procedure Transformation
• Used Informatica Designer to design mappings and coded it using reusable mapplets.
• Developed workflow sequences to control the execution sequence of various jobs and to email support personnel.
• Involved in unit testing and documenting the jobs and work flows.
• Set Standards for naming conventions and best practices for Informatica mapping development.
• Used database objects like Sequence generators and Stored Procedures for accomplishing the Complex logical situations.
• Created various UNIX shell scripts for Job automation of data loads
• Created mappings which include the Error Handling Logic being implemented to create an error, ok flags and an error message depending on the source data and the lookup outputs

Environment: Informatica Power Center 9.5.1/9.1, Informatica Power Exchange 9.5.1/9.1, Oracle 11g, Oracle Data Integrator, SQL, PL/SQL, SQL Developer, IDQ, ERwin, Oracle Designer, MS VISIO, Autosys, Quality Center 10, LINUX, UNIX.

Informatica / ETL Developer

Responsibilities:

• Extracted and transformed data from Flat Files and Oracle and then loaded into Oracle using Informatica Power Center.
• Created Source definitions, Target definitions, Mappings, Transformations, Reusable Transformations, Mapplets using Informatica Designer tool, which includes Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer and Mapplets Designer.
• Developed mappings for the Initial loads of the dimensions and incremental loads including Type1 and Type2.
• Utilized Slowly Changing Dimensions. Created corresponding workflows and sessions and various transformations like Source Qualifier, Expression, Filter, Joiner, Router, Lookup (Connected and Unconnected, Static and Dynamic cache) and Aggregator were used.
• Wrote SQL overrides in Source Qualifier and Lookups according to business requirements.
• Involved in capturing the incremental changes in the source systems for updating in the staging area and data warehouse respectively
• Worked on performance tuning forETL processes.
• Created mappings using Unconnected, Connected Lookup and Aggregate transformations for populating target table in efficient manner.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Extracted data from different sources like Oracle and Flat files and loaded the data into DWH.

Environment: Informatica Power Center 9.1, Informatica Power Exchange 9.1, Oracle 10g, Oracle Data Integrator, SQL, PL/SQL, SQL Developer, Erwin, Oracle Designer, MS VISIO, Autosys, Korn Shell, Quality Center 10, LINUX, UNIX.

ETL Developer

Responsibilities:

• Performed requirements gathering, developed Analysis & Design document (A&D), developed in project time lines.
• Designed and developed the ETL mappings for the source systems data extractions, data transformations, data loading.
• Extracted data from various sources using source analyzer.
• Developed standard mappings using various transformations like expression, aggregator, joiner, source qualifier, Router, lookup, and filter for weekly, quarterly process to loading heterogeneous data into the data warehouse.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy, Union, SQL, Java and Sequence generator.
• Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like Event wait, Event raise, email and command.
• Used Informatica for loading the historical data from various tables for different departments.
• Developed Informatica mappings for Slowly Changing Dimensions Type 1, 2 and Type3.
• Created Mapplets for implementing the incremental logic, in identifying the fiscal quarter of the transaction and in calculating various requirements of business processes.
• Involved in the Unit & Integration testing of the mappings and workflows developed for the enhancements in the application.
• Tuned the databases (stage, target) for better, faster and efficient loading and user query performance.
• Created Informatica mappings with PL/SQL stored procedures/functions to in corporate critical business functionality to load data.
• Extensively worked on performance tuning of mappings, sessions, Target, Source and various ETL processes.

Environment: Informatica Power Center 8.6/8.1, Oracle 10g, DB2, SQL Server 2000, Shell scripting, UNIX, LINUX, Windows, SQL Developer.