SUMMARY

• 7+ years of IT experience in Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing and the past 4+ years spent primarily on Data warehouse projects using Informatica Power Center, IDQ, Cognos, SQL Server and Oracle on UNIX and Windows platforms.
• Knowledge in Full Life Cycle development of Data Warehousing.
• Expertise in full life cycle of ETL (Extraction, Transformation and Loading) using Informatica Power Center (Repository Manager, Mapping Designer, Workflow Manager, Workflow monitor).
• Solid understanding of Relational (ROLAP) and Multidimensional (MOLAP) modeling using Facts and Dimension tables, broad understanding of data warehousing concepts, star and snowflake schema database design methodologies.
• Extensively used Informatica Workflow manager and Workflow monitor for creating and monitoring workflows, Worklets and sessions.
• Experience in maintenance and enhancement of existing data extraction, cleansing, transformation, and loading processes to improve efficiency.
• Proficiency in developing SQL with various relational databases like Oracle, SQL Server and MySQL.
• Worked with Oracle Stored Procedures and experienced in loading data into Data Warehouse/Data Marts using Informatica, SQL*Loader, Export/Import utilities.
• Proficient in server side programming like stored procedures, stored functions, database triggers, packages using PL/SQL and SQL.
• Understanding the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• Extensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks.
• Knowledge in UNIX shell programming.
• Knowledge in DataStage implementations, Development and support.
• Experience in file transfer thru SFTP and B2B.
• Knowledge in Java, C, C++, ASP.NET.
• Good exposure to development, testing, debugging, implementation, documentation, user training & production support.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.

TECHNICAL SKILLS

Operating Systems: Microsoft Windows, UNIX

ETL Tools: Informatica(Integration Service/Power Center/PowerMart) 9.5.1/8.6.1 , DataStage 8.1/8.0.1

Databases: MYSQL, SQL Server, Oracle

Languages: C, C++, Java, SQL, PLSQL,C# .NET,XML

Web Technologies: HTML, CSS, ASP.NET

IDE's: Visual Studio, Eclipse, Net Beans, TOAD

BI Tools: Cognos 8 Series

Packages: MS Office

PROFESSIONAL EXPERIENCE

Confidential, Eden Prairie, MN

Sr. ETL Developer

Responsibilities:

• Interacted with Subject Matter Experts (SME) to gather Business Requirements for the application, through one - on-one interviews, and worked on developing the business rules for cleansing.
• Applied business rules using Informatica Data Quality (IDQ) tool to cleanse data.
• Created and analyzed Process Work Flows, Scope & Functional Specifications, and was responsible for preparing Software Requirement Specifications (SRS) and Functional Specification Documents (FSD).
• Exclusively worked on Autosys (Scheduling tool) to create Informatica jobs scheduled as demanded.
• Extracted data from wide variety of data Sources like Flat files and Relational Databases (Oracle& SQL Server).
• Extensively used Informatica Power Center 9.5.1/9.1 to create and manipulate source definitions, target definitions, mappings, mapplets, transformations, re-usable transformations, etc.
• Used Informatica Power Connect for SAP to pull data from SAP R/3.
• Designed Data transformation from Transient to Staging, Fact and Dimension Tables in the Warehouse.
• Used transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure and update strategy to meet business logic in the mappings.
• Created and tested Informatica mappings and workflows to automate Job scheduling.
• Created Workflow, Worklet, Assignment, Decision, Event Wait and Raise and Email Task, scheduled Task and Workflow based on Client requirement
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Created sessions, batches for incremental load into staging tables, and schedule them to run daily/weekly/monthly.
• Developed various Mappings with the collection of Sources, Transformations, and Targets, using designer.
• Traced the flow of data in PowerCenter from the sources to targets using Metadata Manager.
• Perform analysis profiling on existing data and identify root causes for data inaccuracies Table Lineage and Impact Analysis and recommendation of Data Quality Internal and External Audits.
• Extensively worked on Performance tuning to increase the throughput of the data load (like read the data from flat file & write the data into target flat files to identify the bottlenecks).
• Extensively used Informatica debugger to figure out the problems in mappings. Also involved in troubleshooting existing ETL bugs.
• Created UNIX Scripts to run Workflows.
• Used Control M scheduling tool to schedule the Jobs
• Extensively worked on SQL tuning process to increase the source qualifier throughput by analyzing the queries with explain plan, creating new indexes, partitions and Materialized views.
• Developed, executed Test Plans and Test Cases to validate and check Referential integrity of data extracts before loading it to Data Warehouse.
• Work closely with the development team during the development phase of the project to ensure Standards and processes are followed.
• Unit/Integrated test plans are written and tested
• Migration checklist is prepared
• Responsible for migration of code from Dev to QA, UAT and PROD for ETL environments
• Provided expertise in design changes and strategy, Resolved the issues raised by testing team.

Environment: Informatica Power center 9.1.0/8.6.1 , Oracle 11g, SQL Server 2005/2008, Autosys, UNIX, Erwin, TOAD, SQL Server

Confidential, Dallas

Jr. ETL Developer

Responsibilities:

• Worked on complete SDLC (Software Development Life Cycle) from Extraction, Transformation and Loading of data using Informatica.
• Extensively used Informatica Designer to create and manipulate source and target definitions, mappings, Mapplets, transformations, re-usable transformations.
• Worked on the Installation and configuration of Informatica Power center 8.6 (Server Manager, Designer and Repository manager).
• Mentored team members in using new features of Informatica power center 8.6.1 and power exchange.
• Worked with Informatica power exchange tools to give on demand access to the business users.
• Transferred the mainframe data using Direct connect.
• Worked on Source Analyzer, Warehouse Designer, Mapping & Mapplets Designer and Transformations, Informatica Repository Manager, Workflow Manager and Workflow Monitor.
• Used most of the transformations such as the Source Qualifiers, Routers, SQL, Transaction control, Sequence Generators and Expression as per the Business requirement.
• Created Workflows with Worklets, event wait, decision box, email and command tasks using Workflow Manager and monitored them in Workflow Monitor.
• Used Workflow Manager for creating and maintaining the Sessions. Also used Workflow Monitor to Monitor, edit, schedule, copy, aborts and delete sessions.
• Provided detailed technical, process and support documentation like daily process rollback and detailed specifications and very detailed document of all the projects with the workflows and their dependencies.
• Monitored and improved the performance of Sources, Targets and Mappings Documented the Sources, Targets and Mappings.
• Involved in writing shell scripts for file transfers, file renaming and several other database scripts to be executed from UNIX.
• Created and Documented ETL Test Plans, Test Cases, Test Scripts, Expected Results, Assumptions and Validations.
• Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre/post SQL.

Environment: Informatica Power Center 8.6, Oracle 10g, PL/SQL, UNIX, Erwin, TOAD,SQL Server, Mainframes (Cobol, VSAM, DB2, File Aid, Flat files).

Confidential

Jr. ETL Developer

Responsibilities:

• Developed Conceptual and logical ETL applications to populate data from source to target database by Informatica tool.
• Worked on Informatica Power Center tool - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplets, and Reusable Transformations.
• Using Informatica Designer designed Mappings, which populated the Data into the Target Star Schema on Oracle Instance.
• Implemented slowly changing dimensions Type2.
• Extensively used Router, Lookup (Connected/Unconnected), Aggregator, Expression and Update Strategy Transformations.
• Tuning the Mappings for Optimum Performance, Dependencies and Batch design.
• Schedule and Run Extraction and Load process and monitor sessions using Informatica Workflow Manager.
• Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs.
• Design and develop application to solve business functional requirements.
• Used Agile Methodology throughout the project and participated in daily Scrum meetings and worked with Business
• Involved in writing UNIX shell scripts for Informatica ETL tool to run the sessions.
• Performed testing the application.

Environment: Informatica Power Center 8.X, Oracle 10g, PL/SQL, UNIX, Erwin, TOAD, SQL server, Cognos, Agile.

Confidential

Database Developer

Responsibilities:

• Involved in analysis and development of the Data Warehouse.
• Translation of Business Processes into Informatica mappings for building Data Marts.
• Involved in the development of Informatica mappings and also tuning for better performance.
• Involved in design of procedures to load data from all systems to Data Warehouse.
• Created mappings with Stored Procedures to build business rules.
• Extensively used ETL to load data from different databases and flat files to Oracle.
• Developed and executed sessions and batches using Server Manager to load the data into the Target Database.
• Performed tests for Data Integrity and Consistency.

Environment: Oracle 8i, PL-SQL, Informatica 7.1.