SUMMARY

• Extensive Information Technology experience in Data Warehouse using Tools like Informatica Power Center, Business Objects, Cognos, Oracle and Teradata.
• Extensive experience in Insurance, Retail, Telecom, and Financial domains.
• Experienced in full Software Development Life Cycle (SDLC) process.
• Expertise in OLTP/OLAP System Study, Analysis and E - R modeling, developing Database Schemas like Star/Snowflake schema, used in relational, dimensional and multidimensional modeling(Dimensions and Fact Table) using Erwin Modeling like Physical & logical data modeling.
• Developed ETL mappings and ETL workflows and also monitoring the Production Environment.
• Developed Complex ETL mappings from varied transformation logics like Unconnected /Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Union, Update Strategy and more.
• Well versed in Extracting, Transforming and Loading from different Source systems to Warehouse system.
• Performed Data Analysis to summarize data with the intent to extract useful information and develop conclusion using the IDE and IDQ tools.
• Well versed with Informatica Power center and its Architecture to Extract, Transform and Loading the data from different Source systems to a Warehouse.
• Good Knowledge in INFORMATICA Power Exchange.
• Experience in Teradata with Fast Export, Fast Load, Multi Load and BTEQ.
• Experience in Trouble shooting and implementing Performance tuning at various levels such as Source, Target, Mapping, Session and System in ETL Process.
• Proficient in warehouse designs based on Ralph Kimball and Bill Inman methodologies.
• Used T-SQL for creating Triggers and stored Procedures using SQL Server 2000/05/08 to create reports from the database.
• Conducted System, UAT and Functionality testing and investigated software bugs.
• Worked on Unix shell scripts used in INFORMATICA pre/post session operations, Increasing Cache size, database administrations and database connections.
• Expertise in working with the UNIX/Windows systems
• Worked with various scheduling tools like Informatica, Appworks,Autosys to schedule the jobs and automate the workload.
• Worked with wide variety of sources like Oracle, MSSQL, Excel sheets, Flat Files, Teradata and DB2.
• Worked with Oracle and SQL Server Stored Procedures, Triggers, Cursors and Indexes and experienced in loading data into Data Warehouse/Data Marts.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center (9.x,8.x,7.x),Power Exchange, Power Connect

BI Tools: Business Objects XI R3/R2/6.5/5.1, Cognos Impromptu 7.0/6.x, OBIEE

Databases: Teradata, Oracle 11.x/10.x/9.x, MS SQL Server, DB2 7.x/6.x

Languages/Others: SQL, PL/SQL, UNIX Shell Scripting, C, C++, TOAD

Packages: MS Office (MS Access, MS Excel, MS Visio, MS PowerPoint, MS Word)

OS / Internet tools: MS DOS, Windows 95/98/2000/XP/7/8 Professional/NT, UNIX (HP-UX, IBM AIX) IBM AIX 5.1.2/4.3.2 , Sun Solaris 9.x/8.x, HTML, XML, ODBC

PROFESSIONAL EXPERIENCE

Confidential, Muscatine, IA

Sr.Informatica Developer

Responsibilities:

• Involved in Analyzing the System requirements, implementation of star schema & Involved in designing and development of data warehouse environment.
• Created SSIS packages to clean and load data to data warehouse.
• PreparedTechnical Specification Documents(TSD) and ETL Specifications based on Business Specification Documents (BSD) and Mapping document.
• Developed ETL code and executed Unit Test Cases.
• Extensively worked on INFORMATICA tools like Source Analyzer, Mapping Designer, Warehouse Designer, Workflow Manager, and Workflow Monitor.
• Used various Transformations like Joiner, Aggregate, Java, Expression, Lookup, Filter, Union, Update Strategy, Stored Procedures, and Router etc. to implement complex logics while coding a Mapping.
• Involved in Data Profiling &Analysis on heterogeneous Databases like Teradata, Oracle and DB2 using INFORMATICA Data Explorer (IDE).
• Used the Integration service in Power Center to start multiple instances of the same workflow.
• Summarize data with the intent to extract useful information and develop conclusion using the IDE and IDQ tools
• Implemented different Tasks in workflows which included Session, Command, E-mail, Event-Wait etc.
• Involved in importing data into SQL server through SSIS.
• Created Data Breakpoints and Error Breakpoints for debugging the mappings using Debugger Wizard.
• Worked with complex queries for data validation and reporting using SQL and PL/SQL.
• Developed BTEQ scripts to transform bulk amount of data in Teradata database.
• Worked with Teradata utilities like BTEQ, Fast Export and Fast Load.
• Involved in Performance Tuning of SQL Queries, Sources, Targets and sessions by identifying and rectifying performance bottlenecks.
• Extensively worked in UNIX environment to crate/modify Kornshell scripts, BTEQ scripts and Fast Load scripts.
• Worked on Autosys Scheduler to automate the Workflows.
• Worked with File-watcher to recognize if any new files were detected using Autosys Job Scheduler.
• Tested all the mappings and sessions in development environment and involved in code migration to higher environments after everything is successful

Environment: Informatica Power Center 9.5/9.0.1, Oracle 11g, Teradata, MDM, DB2, UNIX, SSIS,SSRS, PL/SQL, Appworks.

Confidential, Oaks, PA

Sr. Informatica Developer

Responsibilities:

• Interacted actively with Business Analysts and Data Modelers on Mapping documentsand design process for various Sources and Targets
• Created complex mappings using various transformations like Lookup, Aggregate update Strategy, Normalizer, Stored Procedure and Router transformations to extract data from various sources like Oracle, SQL Server, flat files and Excel files into the Data warehouse.
• Extraction of pipe delimited flat files into Data Warehouse using INFORMATICA mappings and Unix Scripts.
• Running the SQL scripts from TOAD and creating Oracle Objects like tables, views, Indexes, sequences, synonyms and other Oracle Objects.
• Created Informatica mappings with PL/SQL Procedures/Functions to build business rules to load data
• Extensive use of UNIX Scripts to build Interfaces between various Data Warehouse systems across the company.
• Developed (or edited existing) Informatica mappings and sessions to accomplish Data Migrations.
• Involved in Performance Tuning of the Informatica mappings using various components like Parameter files and Variables
• Managed Change control implementation and coordinating daily, monthly releases and reruns.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Developed various Mapplets, Transformations and was responsible for Validating and Fine-Tuning the ETL logic coded into mappings to improve Data Quality.
• Performed extensive Unit Testing on the developed Mappings and was also involved in the documentation of Test Plans and testing with the users (UAT).

Environment: Informatica Power Center 8.6.1, INFORMATICA Power Connect / Power Exchange, Oracle 10g/9i, OBIEE,SSIS, Business Objects, SQL Server, UNIX AIX.

Confidential, Owensboro, KY

Informatica Developer

Responsibilities:

• Worked with architect and business managers to understand the requirement. Communicated with the DBA group to understand the source systems as well.
• Worked with DBA team to formulate the incremental loads, change data capture process to INFORMATICA interface.
• Worked on E/R studio 7.6 and interacted with data architect to design source to target mapping document.
• Created mappings for initial load in PowerCenter Designer using the Expression, Aggregator, Joiner, and Sorter transformations.
• Created complex mappings for full load into target using the transformations like Sorter, Connected / Unconnected Lookup, Aggregate, Update Strategy, Router, Stored Procedures, etc.
• Used mainframes from where data is extracted and and after trasnforming it they are loaded into thetarget tables.
• Created Mapplets to reuse all the set of transformations in other mappings.
• Created work flows and sessions for each mapping that we are extracting from source systems to staging area and from staging area to target.
• Implemented Type 1 and Type 2 Slowly Changing Dimensions.
• Worked on Cumulative Fact (Aggregate fact tables), Atomic Fact loading from all Dimensions in the Target. (Star Schema)
• Participated in the enterprise performance tuning of INFORMATICA for sources, targets, mappings and sessions and Created reusable sessions for different workflows.
• Performed Unit testing on the INFORMATICA code by running in the debugger and writing simple test scripts in the database thereby tuning it by identifying and eliminating the bottlenecks for the optimum performance.
• Created / Modified UNIX scripts.
• Responsible for validating the Informatica mappings against the pre-defined ETL design standards.
• Used INFORMATICA Scheduler to schedule the work flows.

Environment: Informatica Power Center 8.6.1, Oracle 9i, Oracle 10g, PL/SQL, SQL, UNIX

Confidential, Bellevue, WA

Informatica Developer

Responsibilities:

• Developed several INFORMATICA load maps using PowerCenter for extraction, loading and transformation (ETL) of data into Oracle database.
• Developed several INFORMATICA error maps to perform Error handling by capturing errors and error messages and inserting them into the Error tables.
• Used Star schema and Snowflake schema in relational, dimensional and multidimensional modeling
• Extracted data from flat files and oracle database, applied business logic using several transformations and loaded them in the central oracle database.
• Used INFORMATICA Workflow Manager to create, Schedule, execute and Monitor Sessions, Batches/Worklets and Workflows.
• Wrote SQL, PL/SQL, stored procedures & triggers, cursors for implementing business rules and transformations.
• Used TOAD to import data from different schemas and to export the query results into XLS sheets, text files and several other formats.
• Created complex mappings in using Aggregate, Expression, Router, Sequence Generator, Update Strategy, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Developed UNIX scripts to automate load process and email the status to specific distribution lists.

Environment: Informatica 7.1.3, Oracle 9i, MS SQL Server 2005, PL/SQL, TOAD, DB2, Microsoft Excel, OBIEE, Windows NT, Rational Rose.

Confidential

ETL Developer

Responsibilities:

• Extensively involved to implement customer data mart and also data ware house.
• Extensively used INFORMATICA Power center for extracting, transforming and loading into different databases.
• Designed, developed and tested the different Mappings according to Requirements.
• Analyzed the load dependencies and scheduled the workflows accordingly to avoid the loading conflict issues.
• Analyzed Session Log files in case the session fails in order to resolve errors in mapping or session configurations.
• Developed UNIX shell scripts as part of the ETL process for scheduling.
• Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL*Loader, Created database objects like Tables, Indexes
• Performed unit testing, knowledge transfer and mentored other team members.

Environment: Informatica Power Center 5.1.1, Oracle 9i, MS SQL SERVER 2000, SQL, PL/SQL, SQL*Loader, UNIX Shell Script.