SUMMARY

• More than 7 years of Experience in all the phases of the Data warehouse life cycle involving analysing, developing, designing, testing, maintaining Software applications and implementing Data Mart, Data Warehouse applications and Data integration using ETL
• Experience in the Development, Implementation of Database/Data Warehousing /Client/Server /Legacy applications for using Data Extraction, Data Transformation, Data Loading and Data Analysis
• Extensive experience in Data Warehousing with Informatica, OLTP and OLAP
• Experience in developing Linux, Unix Shell Scripting.
• Experience in creating entity relational and dimensional relational data models with Kimball Methodology (Star schema and Snow flake schema architectures, Fact/dimension tables)
• Also experienced SSRS, Data Modeling using Erwin and MS Visio
• Extensive experience in using Informatica 9.x/8.x/7.x (Designer, Repository Manager, Workflow Manager and Work Flow Monitor, Power connect)
• Experienced in creating the Workflows, Worklets, Mappings, Mapplets, Reusable transformations and scheduling the Workflows and sessions using Informatica Power Center.
• Excellent skills in retrieving/manipulating data by writing simple/ complex SQL Queries and optimizing SQL and PL/SQL
• Skilled in developing Test Plans, Creating and Executing Test Cases
• Performed Testing at various levels including Unit Testing, SIT, UAT
• Active participation in Knowledge Transfer and Documentation. Experience in mentoring team members in an understandable user friendly manner

TECHNICAL SKILLS:

Operating Systems: UNIX, MS Win NT 4.0, Windows 7/95/98/XP

ETL’s: Informatica Power Center 7.x/8.6.1/9.1.0/9.3.1/9.5x

Data Modeling Tools: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, and MS Visio.

Databases: Netezza, Oracle 10g/11g, MS SQL 200x, MS Access 97/2000, TOAD for Oracle/SQL Server (Front end tools)

Languages: SQL, PL/SQL, Visual Basic 6.0, VBScript, C, C++, XML, UNIX Shell Scripting, PERL Scripting

Application Tools: MS Office (Word, Excel, PowerPoint), MS Visio, Business Objects 6.1, Views

Scheduling Tools: Control - M, Autosys.

PROFESSIONAL EXPERIENCE:

Confidential

Informatica Developer

Responsibilities:

• Designs, analyzes, develop, code, test, debug and document programming to satisfy business requirements.
• Created Relational Connections, Migrated the Mappings from Dev to QA, QA to Prod.
• Participated in every phase of software delivery life cycle including Requirement, Analysis & Design, Build Code, Unit Test, Support system and Integration testing, Implementation phase and post implementation support
• Created re-usable objects and maintain the shared folder.
• Data profiling on Oracle using Toad for Oracle.
• Automate the loads to minimize load run times and performances tune some of the long running processes.
• Thoroughly perform unit testing ensuring minimal code defects out of build phase into system test phase.
• Worked with various Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager
• Created job schedules and make sure the dependency is defined and jobs run in sequence using Control-M.

Environment: Informatica Power Center 9.5x, SQL, Oracle 11g, Toad for Oracle, UNIX AIX, Putty, WinSCP, BMC Remedy User, Control-M etc.

Confidential IN

Informatica Developer

Responsibilities:

• Configured Informatica Power Center 9.1, also installed and configured Informatica Power Center and Informatica Client tools
• Worked in Migration of the Metadata changes to the Informatica repository
• Develop several Complex Informatica Mappings, Mapplets, Reusable Transformations, and Workflows for cleansing and loading of data into the Staging area and Data Warehouse
• Worked on the implementation of both Type I and Type II (SCD) for data mart
• Extensively used Transformations for heterogeneous data joins, complex aggregations and external procedure calls
• Created Informatica jobs using Designer and extracted data from various sources, transformed data according to the requirement and loaded into GDW data warehouse

Environment: Informatica Power Center 9.1, Sql, Terradata, Oracle 11g, Unix AIX, SAP, Autosys, Quality center etc.

Confidential WI

ETL Developer

Responsibilities:

• Reviewed System Design Documents for the Data Acquisition Requirements for moving data from external systems to Staging Area and Source-to-Target Mapping
• Interacted with the Business Personnel to analyze the business requirements and transformed the business requirements into the technical requirements
• Created Informatica jobs using Designer and extracted data from various sources, transformed data according to the requirement and loaded into GDW data warehouse
• Extensively used ETL to load data from source as Oracle and as well as Delimited Flat files to the Relational database which was Oracle
• Creating Relational Connections, Migrating the Mappings from Dev to QA, QA to Prod
• Worked with various Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager
• Developed complex mappings using various transformations like Source Qualifier, Expression, Filter, Aggregator, Lookup, Update Strategy, Stored Procedure, Sequence generator, Joiner Transformations and Router Transformation.

Environment: Informatica PowerCenter 9.3/8.6.1, Sql, XML, Netezza, Aginity work bench, Terradata, SSRS, DVO tool.

Confidential

Informatica Developer

Responsibilities:

• Created different transformations for loading the data into target database using Aggregator, Upgrade strategy, Router, Rank, Sorter, Source Qualifier, Filter, Expression, Look-up, Sequence Generator, Normalizer, Joiner, etc
• Developed joiner transformation for extracting data from multiple sources
• Design and Developed pre-session, post-session routines and batch execution routines using Informatica Server to run Informatica sessions
• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions and scheduling them to run at specified time
• Tested the Informatica mappings with manual testing and assisted QA team
• Informatica Designer tools were used to design the source definition, target definition and transformations to build mappings
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, testing of Informatica Sessions, and the Target Data.

Environment: Informatica PowerCenter 8.6.0/8.6.1, Informatica PowerExchange 8.1, Informatica Data Quality, UNIX (Solaris), HP Quality Center, Autosys.

Confidential PA

ETL Developer

Responsibilities:

• Studied the existing environment and accumulating the requirements by querying the Clients on various aspects
• Identification of various Data Sources and Development Environment
• Data modeling and design of for data warehouse and data marts in star schema methodology with confirmed and granular dimensions and FACT tables
• Created PL/SQL packages, Stored Procedures, Sql Loader and Triggers for data transformation on the data warehouse
• Design and Development of data validation, load processes, test cases, error control routines, audit and log controls using PL/SQL, SQL
• Used Update strategy and Target load plans to load data into Type-2/Type1 Dimensions
• Created and used reusable Mapplets and transformations using Informatica PowerCenter
• Improved performance by identifying the bottlenecks in Source, Target, Mapping and Session levels

Environment: Informatica PowerCenter 8.6.1 Oracle 11g, MSSQL Server 2005/2008.

Confidential WI

Informatica Developer

Responsibilities:

• Involved in designing, developing, testing, implementing and supporting application software in line with business objectives
• Interacted with Client Business Users for Requirements Gathering and Analysis
• Designed the Functional Requirements and Mapping Technical Specifications on the basis of Functional Requirements
• Created ETL mappings using Informatica Power Center to move Data from multiple sources like Flat files,XML Files,SQL Server, DB2, Oracle into a common target area such as Staging, Data Warehouse and Data Marts
• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions and scheduling them to run at specified time
• Tested the Informatica mappings with manual testing and assisted QA team

Environment: Informatica PowerCenter 8.6.0/8.6.1, Oracle 9i, Quality Centre.

Confidential, IL

Informatica, ETL Developer

Responsibilities:

• Helped in generating solutions for business and IT strategies as per the organization's architectural standards
• Created mapping specifications on Excel sheets based on information acquired from analysis of source data, User Requirements and some Business Rules
• Extracted and transformed data from Fixed-Width Flat Files, Delimited Flat Files, and loaded staging tables using Informatica
• Extensively used Informatica Designer to create and manipulate source definitions, target definitions, mappings, Mapplets, transformations, re-usable transformations, etc

Environment: Informatica Power Center 7x, TOAD for Oracle, PL/SQL, Quality center.