PROFESSIONAL SUMMARY:

• 6+ years of work experience in designing and developing Data warehouse applications with special emphasis on Design and Development of Data Warehousing using Informatica Power Center 9.6/9.5/9.1/8.6/8.1 .
• Expert in all phases of Software development life cycle(SDLC) - Project Analysis, Requirements, Design Documentation, Development, Unit Testing, User Acceptance Testing, Implementation, Post Implementation Support and Maintenance
• Extensively worked in ETL process consisting of data transformation, data sourcing, mapping, conversion and loading.
• Strong experience with Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformations Developer, Workflow Manager/Monitor and Server tools - Informatic Server, Repository Server manager.
• Strong expertise in Relational data base systems like Oracle, SQL Server, MS Access. Strong knowledge of writing simple and Complex Queries in various databases like Oracle, Teradata, My SQL, DB2 and SQL Server.
• Good experience in creating and using Stored Procedures, Functions, Triggers, Views and packages in Different databases.
• Extensive experience in data profiling, data migration from various legacy sources and relational systems to OLAP and decision support target systems.
• Having good Knowledge of Informatica administration in windows and Linux environment.
• Practical knowledge of Data warehouse concepts, Data modeling principles - Star Schema, Snowflake, Normalization/De-normalization
• Expertise in configuration, performance tuning, installation of Informatica, & in integration of various data sources like Oracle, DB2, flat files into the staging area and Design ETL processes that span multiple projects
• Worked with PMCMD to interact with Informatica Server from command mode and execute the Shell scripts.
• Proficiency in developing complex mappings using Informatica and Change data capture (CDC), Data Cleansing, slowly changing dimensions (SCD) types 1&2.
• Experience in working in a Multi-Dimensional Warehouse projects. Experience in reading and loading high-volume Type 2 dimensions by implementing SCD (Slowly Changing Dimensions).
• Expertise in OLTP/OLAP System Study, Understanding E-R modeling and Dimensional Models using Star schema and Snowflake schema techniques.
• Highly proficient in processing tasks, scheduling sessions, import/export repositories, manage users, groups, associated privileges and folders.
• Proficient in creating UNIX Shell Scripts. Excellent communication skills and co-ordination with project managers, business analysts, architects, DBA’s and Developers.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.6/9.5/9.1/8.6/8.1, Informatica Power Exchange 9.1/8.6, IDQ

Databases: Oracle 11g/10g/9i, DB2, MS SQL Server (2012, 2008, 2005)

Other Tools: Oracle Report Writer, TOAD, MLOAD, TPUMP, Erwin 4.x/3.5/3.x, SQL, XML, XSL, PL/SQL, SQL*Plus, SQL*Loader and Developer

Languages: SQL, PL/SQL, UNIX Shell Scripting, Unix Commands, C, C++

Autosys, Control: M

Operating Systems: Windows Server 2008/2003, UNIX, OS.

PROFESSIONAL EXPERIENCE:

Confidential -Omaha, NE

Sr. Informatica Developer

Responsibilities:

• Interacted with functional/end users to gather requirements of core reporting system to understand exceptional features users expecting with ETL and Reporting system and to successfully implement business logic.
• Understood the Business point of view to implement coding using Informatica power center designer. Used Informatica Power Center for retrieving data from Mainframe system.
• Debugging invalid mappings using breakpoints, testing of stored procedures and functions, testing of Informatica sessions, batches and the target Data.
• Identified sources, targets, mappings and sessions and tuned them to improve performance.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager.
• Implemented different Mappings with the collection of all Sources, Targets, and Transformations using Designer.
• Performed extraction, transformation and loading of data from RDBMS tables and Flat File sources into Oracle 11g RDBMS in accordance with requirements and specifications.
• Designed and developed mapplets and re-usable transformations, and used them in different mappings.
• Exported the IDQ Mappings and Mapplet's to power center and automated the scheduling process. Knowledge of data profiling using Informatica Data Quality (IDQ)
• Developed Conceptual, normalized Logical and Physical data models to design OTLP and Data warehouse environments.
• Used ETL process to load data from multiple sources to staging area (Oracle) using Informatica Power Center 9.5.1. Created Mapplets and used them in different Mappings.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Performance tuning using Informatica partitioning. Involved in Data Base Tuning. Written UNIX Shell Scripts for various purposes in the project.

Environment: Informatica Power Center 8.1.1, Oracle 10g, MS SQL SERVER 2000, SQL, PL/SQL, SQL*Loader, UNIX Shell Script.

Confidential -Chesterfield, MO

Sr. Informatica Developer

Responsibilities:

• Responsible for Internal Delivery of ETL code from Architecture /Design/ Development/ Testing and Implementation phases.
• Created Several Informatica Mappings to populate the data into dimensions and fact tables.
• Involved in the development of Informatica mappings and Mapplets and tuned them for optimum performance, Dependencies and Batch Design.
• Knowledge of Identifying Facts and Dimensions tables. Involved in understanding of Business Processes, identification of dimensions and measures for OLAP applications.
• Experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions and packages.
• Extensively worked on developing and debugging Informatica mappings, Mapplets, sessions and workflows. Experienced with creating Unit Test Cases for mapping and code reviews.
• Loading data from different sources like relational Tables and Flat Files to Target Data warehouse.
• Used Slowly Changing Dimensions (SCD 1 and SCD 2) techniques to load the conformed dimensions.
• Worked with various Informatica client tools like Source Analyzer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager.

Environment: Informatica Power Centre 9.1, Windows-XP (Client), Informatica Data Quality (IDQ), Power Designer, Power Exchange, Work Flows, ETL, Oracle 11g, Teradata, XML, SSRS, Web-Services, MS SQL Server, TOAD 9.6.1, Unix Shell Scripts, Autosys.

Confidential, Herdon, VA

Informatica Developer

Responsibilities:

• Analyzed the Business Requirement Documents (BRD) and laid out the steps for the data extraction, business logic implementation & loading into targets.
• Responsible for Impact Analysis, upstream/downstream impacts. Created detailed Technical specifications for Data Warehouse and ETL processes.
• Used Informatica as ETL tool, and stored procedures to pull data from source systems/ files, cleanse, transform and load data into the Teradata using Teradata Utilities.
• Worked on Informatica- Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformation Developer.
• Used most of the transformations such as the Source Qualifier, Expression, Aggregator, Filter, Connected and Unconnected Lookups, Joiner, update strategy and stored procedure.
• Extensively used Pre-SQL and Post-SQL scripts for loading the data into the targets. Developed mappings to load Fact and Dimension tables, SCD Type 1 and SCD Type 2 dimensions and Incremental loading and unit tested the mappings.
• Successfully upgraded Informatica 9.1 and to 9.5 and responsible for validating objects in new version of Informatica.
• Involved in Initial loads, Incremental loads and Daily loads to ensure that the data is loaded in the tables in a timely and appropriate manner.
• Extensively worked in the performance tuning of Teradata SQL, ETL and other processes to optimize session performance.
• Loaded data in to the Teradata tables using Teradata Utilities, Fast Load, Multi Load, and Fast Export, TPT.
• Worked extensively with different Caches such as Index cache, Data cache and Lookup cache (Static, Dynamic and Persistence) while developing the Mappings.
• Created Reusable transformations, Mapplets, Worklets using Transformation Developer, Mapplet Designer and Worklet Designer.
• Integrated the data into centralized location. Used migration, redesign and Evaluation approaches.
• Responsible for Unit Testing, Integration Testing and helped with User Acceptance Testing.
• Tuned the performance of mappings by following Informatica best practices and applied several methods to get best performance by decreasing the run time of workflows.
• Worked extensively on Informatica Partitioning when dealing with huge volumes of data and partitioned the tables in Teradata for optimal performance.
• Scheduling Informatica jobs and implementing dependencies if necessary using Autosys.
• Managed post production issues and delivered all assignments/projects within specified time lines.

ENVIRONMENT: Informatica Power Center 9.1.1/9.5.1, Oracle 11g, DB2, Teradata, Flat Files, Erwin 4.1.2, SQL Assistant, Toad, WinSCP, Putty, Autosys, UNIX.

Confidential

SQL Developer

Responsibilities:

• Created/ modified SQL Queries better performance tuning on analyzed existing code for better outcome.
• Performed End-to-End Testing, troubleshooting, debugging, integration testing and performance testing and analyzed the results to justify the validation.
• Works with business analysts to gather and interpret business requirements for multiple financial and healthcare systems including large data warehouses.
• Designs and develops database applications using SQL Server Integration Services, TSQL and Stored Procedures. Developed User Defined Functions and created Views.
• Created Triggers to maintain the Referential Integrity. Implemented Exceptional Handling.
• Worked on client requirement and wrote Complex SQL Queries to generate Reports.
• Collaborates with business analysts, source system experts, and other team members to determine data extraction and transformation requirements.
• Involved in performing database Backup and Recovery. Collaborate with IT operations for support in problem resolution and root cause analysis.
• Supports IT staff and business users in the development, usage and troubleshooting of database-driven applications. Participates in special projects as needed and performs other duties as assigned.

Environment: Oracle 9i, Reports 6i, Forms 6i, SQL* loader, Oracle SQL Developer PL/SQL, SQL*Plus.