SUMMARY

• 7 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.
• Good knowledge on Informatica IDQ & Informatica Power Exchange. Proficient inRelational Database Management System(RDBMS).
• Having knowledge on Master Data Management MDM Data Integration concepts in large scale implementation environments.Proficiency in developing complex mappings using Informatica and Change data capture (CDC), Data Cleansing, slowly changing dimensions (SCD) types 1&2.
• Database experience using Oracle 11g/10g/9i, MS SQL Server 2000 and MS Access. 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 usingglobal variables,expressionsandfunctionsfor the reports with immense experience in handling sub reports inSSRS.
• 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.
• 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 modelingandDimensional 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, MDM

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++

Scheduling tools: 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 InformaticaPower Center 9.5/9.6 for retrieving data from Mainframe system.
• Involved in development of ETL loads and Business intelligence reports and analysis, providing mentoring, guidance and troubleshooting to analysis team members in solving complex reporting and analytical problems.
• Debugging invalid mappings using breakpoints, testing of stored procedures and functions, testing of Informatica sessions, batches and the target Data.
• Performing requirement gathering analysis design development testing implementation support and maintenance phases of both MDM and Data Integration Projects.
• 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.
• Developes SQL and PL/SQL scripts to validate and load data int interface tables using SQL Loader. Performed strategies for incremental data extraction as well data migration to load data into Teradata.
• Developed ETL programs using Informatica to implement the business requirements. Involved in data modeling and design of data warehouse in star schema methodology with confirmed granular dimensionsand Fact tables.
• Expertise in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDMsolutions
• Utilized Informatica Data Quality (IDQ) for data profiling and matching/removing duplicate data, fixing the bad data, fixing the null values.
• Implemented different Mappings with the collection of all Sources, Targets, and Transformations using Designer.
• Implemented Conceptual, Normalized/Denormalized Logical and Physical data models to design OTLP and Data warehouse environments.
• 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.
• Experience developing and supporting complex DW transformations. Creating Reusable Transformations and Mapplets in a mapping.
• Expertise in using both connected and unconnected Lookup Transformations. 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 10g) using InformaticaPower Center 9.5.1.Created Mappletsand 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 ShellScripts for various purposes in the project.

Environment: Informatica Power Center9.5/9.6, Oracle 10g, MS SQL SERVER 2000, Teradata, SQL, PL/SQL, SQL*Loader, UNIX Shell Script,InformaticaData Quality (IDQ), Workflow Manager, Power Center Designer, Oracle 11g.

Confidential - Chesterfield, MO

Sr. Informatica Developer

Responsibilities:

• Responsible for Internal Delivery of ETL code from Architecture/Design/Development/Testing and Implementation phases.
• Extensively developed various mappings incorporated business logic, which performed Extraction, Transformation and Loading of source data into OLAP schema.
• Created Several Informatica Mappings to populate the data into dimensions and fact tables. Worked on MDMHub configurations - Data modeling & Mappings, Data validation, Match and Merge rules, Hierarchy Manager, customizing/configuring Informatica Data Director (IDD).
• Involved in the development of Informaticamappings and Mapplets and tuned them for optimum performance, Dependencies and Batch Design.
• 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 and Sequence Generator transformations.
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• 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).
• Worked on PPM related requirements & providing solutions for issues related with same which covers activities like: requirement analysis, ETL designing, scheduling workflows and providing Maintenance, Enhancement & Support to the Client.
• Involved in implementing the Land Process of loading the customer data set into informatica MDM from various sourse system.
• 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, InformaticaRepository Manager and Workflow Manager.

Environment: InformaticaPower Centre 9.1, Work Flows, ETL, Oracle 11g, Teradata, XML, SSRS, MS SQL Server, Flat Files, ETL, PL/SQL, SSOracle, Excel source files, XML files, Unix Shell Scripts.

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. 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 anAd delivered all assignments/projects within specified time lines.

Environment: InformaticaPower Center 9.1/9.5, Oracle 11g, SQL, DB2, Teradata, Flat Files, Erwin, SQL Assistant, Toad, ETL, 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 and PL/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.