SUMMARY

• Around 8 years of Data Warehousing experience using Informatica Power center 9.x,8.x (Source Analyzer, Data Warehousing Designer, Mapping Designer - data transformation and mapping issues, Mapplet, Transformations), Informatica Power Center 9.x/8.x.
• Experience in working with business requirements and various application teams and business teams to develop ETL procedures that are consistent across all applications and systems in Informatica 9.x/8.0, Oracle 9i/10g.
• Strong experience in Data Warehousing, Data Architecture, Data Modeling, Data Analysis.
• Experience in Application Design, Data Extraction, Development, Implementations and Testing of Data warehousing and Database business systems.
• Used the Ralph Kimball’s DW methodologies in creating Data Marts using Power Center.
• Experience in Relational and Dimensional Data Modeling using Star Schema/Snow flake schema, FACT & Dimensions tables, Physical & logical data modeling.
• Excellent command over UNIX shell scripts used in scheduling Informatica pre/post session operations.
• Expertise in configuration, performance tuning & integration of various data sources like Oracle, MS SQL Server, fixed width and Delimited flat files, DB2, COBOL files XML, Flat files into the staging area and Design ETL processes that span multiple projects
• Extensive experience in writing (DML, DDL), stored procedures in Oracle PL/SQL, SQL Server 2008/2005.
• Experience in RDBMS concepts, database Management Systems, Database Physical and Logical design, Data Mapping, Normalization and De-normalization.
• Created shell scripts to run daily jobs and extract the files from remote location for data loads.
• Good understanding of Project Life Cycle and gathering requirements for ETL Development..
• Worked with various Error Handling Strategies and having experience in Production Support and User Training.
• Flexible, adaptive and project oriented team player with good communication and leadership skills to develop creative solution for challenging client needs.
• Able to work independently and collaborate proactively & cross functionally within a team.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center 9.x/8.x (Source Analyzer, Data warehousing designer, Mapping Designer, Mapplet, Transformations).

Data Modeling: Erwin 4.1/3.5,Star-Schema Modeling, Snowflakes Modeling, FACT and Dimension Tables

Programming: UNIX Shell Scripting (Bourne Shell, Korn), SQL.

Platforms: Microsoft Windows 98/NT/2000/XP, Sun Solaris, Linux Red Hat.

Etl tool: Informatica Power Center 9.x/8.x,Informatica Power Exchange, Informatica Data Quality 9.x/8.x

PROFESSIONAL EXPERIENCE

Confidential, Downers Grove, IL

Senior Informatica Developer

Responsibilities:

• Worked with architect, business managers, to understand the requirement and source system in order to prepare design documents specifying the various ETL approaches, with suggestion of the best approach.
• Extensively used mapping parameter/variable for Incremental Loading.
• Worked extensively on Informatica designer to design a robust end-to-end ETL process involving complex transformation like Lookup, Update strategy, XML, SQL, Stored procedures, External procedures, Transactional control for the efficient extraction, transformation and loading of the data to the staging and then to the Data Mart (Data Warehouse) checking the complex logics for computing the facts.
• Involved in Data migration from one environment to another environment using ETL Informatica tool.
• Understand the components of a Data quality plan. Make informed choices between sources data cleansing and target data cleansing.
• Performed Data Analysis using Informatica Data Explorer.
• Worked with various transformations like Aggregator, Joiner, Sequence generator, Lookup, Expression, Router, Filter, Sorter etc to develop Mappings/Mapplets using Informatica PowerCenter Designer.
• Implemented SCD for assessing the full history of customer and transactions of customer. Implement SCD Type1, SCD Type2 and SCD Type3 methodologies in SCD tables.
• Involved in analyzing different modules of facets system and EDI interfaces to understand the source system and source data
• Written UNIX shell Scripts for getting the data from all systems to Data Warehousing system.
• Created and scheduled jobs based sessions, on demand, run on time and run only once using work flow manager.
• Reviewed the business logic and documented the ETL development process.
• Development including Production support. Analyze, design, build, test and implement change requests for certain areas in the production data warehouse.
• Implemented Error handling Mechanisms in Informatica mapping.
• Good experience in creating SQL Server database objects like tables, views, procedures, functions and triggers for a project
• Involved in data analysis, design, and development and Production stages of data warehouse environment.
• Design the architecture for production support in order to scheduling the tasks (without any manual intervention) using UNIX shell scripting.
• Developed scripts for inbound and outbound of the data on servers.
• Wrote complex SQL queries PL/SQL function, procedure, Packages, Cursor and triggers to retrieve the data from sources system and to count and validate the data and dataset.
• Involved in Performance tuning in Informatica for source, transformation, targets, mapping and session.
• Created parameter files and using the mapping parameters in mappings.
• Used Update Strategy to effectively migrate data from source system to target Database.
• Used the Debugger to validate the transformations by creating BreakPoints and analyzing the Debug Monitor. Fixing invalid Mappings, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
• Developed number of Complex Informatica Mappings and Reusable Transformations to facilitate Daily, Weekly & Monthly Data Loads.

Environment: Informatica PowerCenter 9.1/8.6, Power Exchange, Oracle 11/10g, PL/SQL, Business Objects XI R2, Erwin 7.0, Autosys, DB2, UNIX.

Confidential, Mo

Informatica Developer

Responsibilities:

• Participated in requirement gathering, Business analysis, User meetings, discussing the issues to be resolved and translating user input into ETL design documents.
• Analysis, design, and development, testing and implementation of Informatica transformations and workflows for extracting data from multiple sources.
• Created unit test plans, test cases and reports on various Bugs while testing the Informatica processes.
• Successfully supported production System as post production activity.
• Reviewed the business logic and documented the ETL development process.
• Implemented Error handling Mechanisms in Informatica mapping.
• Extensively worked on SCD type 2 using Look up transformation.
• Extensively used Transformations like Source Qualifier, Expression, Filter, Aggregator, Joiner, Lookup, Sequence generator, Router, Sorter and stored Procedures, java transformations and used debugger to test the mappings and fixed the bugs.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Involved in project cycle plan for the data warehouse, source data analysis, data extraction process, and transformation and loading strategies.
• Used Informatica for migrating data from various OLTP servers/databases. The data migration included identifying various databases where the information/data lay scattered, understanding the complex business rules that need to be implemented and planning the data transformation methodology.
• Extensively worked with SCD Type-I, Type-II and Type-III dimensions.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Extensively used SQL* loader to load data from flat files to the database tables in Oracle.
• Good experience in writing Unix shell scripts.
• Created shell scripts and updated the scripts as per the requirement.
• Written and modify SQL override in many mappings according to business requirements.
• Involved in resolving the issues related with the migration of design from Dev server to prod server and also helped in resolving issue related with the production support of the Data Warehouse.
• Involved in creating logical and physical data models using CA ERwin data modeler. Generating the DDL scripts for the physical data model.
• Performed Performance Tuning of sources, targets, transformations, mappings, and sessions.
• Worked with T-SQL and Extracted data originating from Sybase.
• Joined Tables originating from Oracle and Sybase.
• Checked session and error logs to troubleshoot problems, and also debugger for complex problem troubleshooting.
• Worked with Variables and Parameters in the mappings to pass the values between sessions.
• Analyzed data flow requirements and developed a saleable architecture/plan for staging data/loading data.

Environment: Informatica Power Center 8.6, Oracle 11g, Erwin - 4.0, TOAD 9.x, Oracle Financials, Shell Scripting, Oracle SQL *Loader,and Sun Solaris UNIX, Windows-XP.

Confidential, Atlanta, GA

ETL Informatica Developer

Responsibilities:

• Worked with business requirements analyst to identify and understand source systems.
• Involved in system study, analyze the requirements by meeting the client and designing the system.
• Extracted data from different sources like DB2, Oracle, Flat Files and loaded into ODS.
• Designed and developed complex aggregate, join, lookup transformation rules(business rules) to generate consolidated(fact summary) data identified by dimensions using Informatica ETL tool.
• Used Informatica Data Quality as a tool for data quality measurement.
• Cleansed the source data, extracted and transformed data with business rules, and built reusable transformation logic, known as ‘Mapplets’ using Informatica Designer.
• Modified several of the existing mappings and created several new mappings based on the user requirement.
• Used the Debugger in debugging some critical mappings to check the data flow from instance to instance.
• Involved in Performance tuning of various mappings and sessions to increase the performance.
• Used SQL tools like TOAD to run SQL queries and validate the sata in warehouse and mart.
• Used PL/SQL and UNIX shell scripts for scheduling the sessions in Informatica.
• Involved in error checking and testing of ETL procedures and programs using Informatica session log.
• Extensively worked on tuning and thereby improving the load time.
• Performed unit testing and documented the unit test plan and its results.
• Created parameter files and using the mapping parameters in mappings.

Environment: Informatica Power Center (Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor), Oracle 10g, Windows XP professional, Toad 8.5, UNIX AIX.

Confidential, Flint, MI

ETL Developer

Responsibilities:

• Analyzed business requirements and worked closely with the team to develop ETL procedures that are consistent across all applications and systems.
• Responsible for gathering suit of business requirements, prepare Source to Target Mapping specifications and Transformation rules.
• Developed data transformation and extract design and strategy.
• Creation of Transformations like Sequence generator, Lookup, Joiner, Update strategy and Source qualifier transformations in Informatica Designer.
• Created Complex mappings using Unconnected Lookup, and Aggregate and Router transformations for populating target table in efficient manner
• Created Mapplets and used them in different Mappings for maintaining the standards.
• Created UNIX shell scripting to run the sessions workflow for Informatics mappings.
• Involved in Performance Tuning of Informatics mappings, SQL Query, views etc.
• Used post session commands for sending email to get the status of the session.
• Involved in Unit Testing and write unit test cases for mappings
• Scheduled and monitored the sessions.

Environment: Informatica Power center 8.6/8.1, Oracle10g, SQL Server 2008, Erwin 4.0, UNIX scripting, Business Objects, Toad 8.6.

Confidential

Informatica consultant

Responsibilities:

• Involved in data analysis, design, and development and Production stages of data warehouse environment.
• Involved in designing documents, technical specifications for mappings and sessions based on user requirements.
• Extensive experience in creation of ETL mappings and transformations to reflect business rules using Informatica Power Center to move data from multiple sources into target area, source systems are mainly flat files, and relational tables.
• Designed and developed ETL routines, using Informatica Power Center. Within the Informatica Mappings, usage of Lookups, Aggregator, Ranking, connected and unconnected Lookups, Source qualifiers and data flow management into multiple targets using Routers was extensively done.
• Experience in using Mapplets, Mapping variables in Informatica mappings.
• Migrated mappings from Development to Production folders.
• Scheduling the session tasks comprising of different mappings for data conversion and extraction in order to load data into target database.

Environment: Informatica power center 8.6, 8.1, Windows XP and UNIX, Oracle 9i, DB2, SQL Server.