SUMMARY:

• Over 7 years of total IT experience in the Business Requirements Analysis, Application Design, Development and Implementations of Data warehousing Applications.
• Extensive experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center Tools (Repository Manager, Designer, Workflow manager, Workflow Monitor and Informatica Administrator Console).
• Extensively worked on Informatica Designer Tools (Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, and Transformation Developer) and Workflow Manager Tools (Task Developer, Work let and Workflow Designer).
• Strong knowledge in OLAP Systems, Kimball and Inmon methodology and models, Dimensional modeling using Star schema and Snowflake schema.
• Strong skills in Informatica Power Center (versions 8.6.1/ 8.5/7.1/6.2/5.0 ), SQL, PL/SQL, Stored Procedures and Triggers, Performed Debugging, Troubleshooting and Performance Tuning.
• Extensive experience with Data Extraction, Transformation, and Loading(ETL) from disparate Data sources like Multiple Relational Databases like Oracle, SQL Server, MS Access, Teradata, and Worked on integrating data from flat files, CSV files, and XML files into a common reporting and analytical Data Model using Informatica.
• Experience in Designing, Developing, Documenting and Testing of ETL Jobs and mappings to populate tables in Data warehouse and Data marts.
• Experienced and trained in developing Data Warehousing / Business Intelligence applications using Informatica (versions 8.6.1/8.5/7.1/6.2/5.0 ) and different Databases.
• Experience in creating star schema for OBIEE project.
• Extensively worked on various stages like ODBC, Transformer, Sequential file, Hashed file, Join, Lookup, Lookup file set, Filter, Router, Rank, Sort, Aggregator, Copy, Dataset, Merge and Remove duplicates.
• Experienced in all stages of the software lifecycle Architecture(Waterfall model) for building a Data warehouse, Star schema and Snow flake Schema by using data modeling tool Erwin 7.0/4.1
• Expertise in working with various operational sources like Oracle, Teradata, DB2, SQL Server 2005/2008, Flat files into a staging area.
• Extensive experience in loading Functions, Requirements gathering, Analysis, Design, Development, Test and Implementation.
• Experience in Data analysis, Data modeling concepts, Database design and Data migration.
• Expert in Unit testing, System Integration testing, Implementation, Maintenance and Performance Tuning.
• Good experience in writing, testing and implementation of the Triggers, Procedures, Functions at Database level using SQL and PL/SQL.
• Experience in Database programming for Data Warehouse (Schemas), proficient in dimensional modeling, Star Schema modeling, and Snowflake modeling.
• Proficiency in data warehousing techniques for data cleaning, Slowly Changing Dimension phenomenon, surrogate key assignment and CDC (Change Data Capture).
• Extensive ETL experience, designing and developing jobs using Informatica.

TECHNICAL SKILLS:

ETL TOOLS: Informatica 9X//8x7x/6x, Informatica Power Exchange, Power Connect, Metadata Manager.

DATA MODELING: Star - Schema Modeling, Snowflake Modeling, FACT and Dimension tables, ERWIN 4.0

REPORTING TOOLS: OBIEE, Cognos Report Net, Cognos 8 and Business Objects XI R1/R2/6.x.

LANGUAGES: SQL, PL/SQL, Visual Basic, XML, C/C++

OPERATING SYSTEMS: UNIX, Windows NT/ 2000/2003/2008, XP

RDBMS: Oracle9i/10g/11g, DB2, MS-SQLServer 2000/2005/2008

PROFESSIONAL EXPERIENCE:

Confidential, Springfield, IL

Sr. ETL Informatica Developer

Responsibilities:

• Business Analysis and Requirements Gathering.
• Designing and customizing data models for Data warehouse supporting data from multiple sources on real time.
• Developed and designed Datamarts extensively using Star Schema.
• Project life cycle - from analysis to production implementation, with emphasis on identifying the source and source data validation, developing particular logic and transformation as per the requirement and creating mappings and loading the data into different targets.
• Designed, developed Informatica mappings, enabling the extract, transport and loading of the data into target tables.
• Used Simple Pass Through, Key Range, Round Robin Pipeline along the data transformation pipeline to increase the performance.
• Created and Configured Workflows, Work lets, and Sessions to transport the data to target using Informatica Workflow Manager. Also created various tasks such as command task, email task, timer tasks, Event wait and Event Raise tasks in the workflow manager.
• Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
• Involved in Performance testing the mappings and workflows in production staging before installing in the Production environment.
• Developed UNIX scripts to compare the Production sequence generators with Production staging sequence generators and to update the sequence values in staging environment and automated the script.
• Involved in coding UNIX scripts to automate multiple ETL Jobs.
• Involved in Tuning the Informatica objects to increase the Performance of the Informatica loads.
• Performed Tuning by identifying and eliminating the bottlenecks occurred for increasing the performance.
• Designed and developed Informatica mappings for data loads and data cleansing. Extensively worked on Informatica Designer and Workflow Manager.
• Extensively used almost all of the transformations of Informatica including lookups, Stored Procedures, Update Strategy and others.
• Developed sessions using Informatica Workflow Manager.
• Solely responsible for the daily loads and handling the reject data.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
• Used SQL tools like TOAD to run SQL queries and validate the data in warehouse and mart.
• Involved in fixing invalid mappings, testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Designed and developed table structures, stored procedures, and functions to implement business rules.
• Tested the data and data integrity among various sources and targets. Associated with Production support team in various performances related issues.

Confidential, Cincinnati, OH

ETL Informatica Developer

Responsibilities:

• Gathered the system requirements and created mapping document which gives detail information about source to target mapping and business rules implementation.
• Designed, developed and debugged ETL Mappings using Informatica designer tool.
• Created complex mappings using Aggregator, Expression, Joiner, Filter, Sequencer, Procedure, connected & unconnected Lookup, Filter and Update Strategy transformations using Informatica PowerCenter Designer.
• Implemented Slowly Changing Dimension for accessing the full history of accounts and transaction information.
• Tuned and monitored in Informatica workflows using Informatica workflow Manager and workflow monitor tools.
• Created and configured workflows, worklets, and sessions using Informatica Workflow Manager.
• Used Mapping Parameters and Variables to implement Object Orientation techniques and facilitate the reusability of code.
• Worked on database connections, SQL joins loops, aliases, views, aggregate conditions and also wrote various PL/SQL procedures, Functions and Triggers for processing business logic in the database. Tuning of SQL queries for better performance.
• Implemented the standard data population method loading the data into new set of tables after successful completion of the data loading, rolled over to original tables. This concept used to high availability of the data to users at the time of the data loading instead of users to wait to run their reports.
• Used Debugger to test the mappings and fixed the bugs.
• Created sessions, configured Workflow to extract data from various sources, transformed data and loading into data warehouse.
• Developed UNIX shell scripts to move Staging files to DB2 database using DB2 bulk loads.
• Created, launched & scheduled Workflows/sessions by developing the Autosys Jobs by generating the JIL files in UNIX Environment.
• Involved in migrating the mappings and workflows from Development to Testing and then to Production environments.
• Improved ETL Performance by using the Informatica Pipeline Partitioning.
• Created Partitions through the session wizard in the Workflow Manager to increase the performance.
• Involved in designing and developing universes for reporting generation from warehouse database using Business Objects.
• Performed unit testing on the Informatica code using the Informatica Debugger and by manually checking through Sql Queries.

Environment: Informatica PowerCenter 8.6.0/8.1.1, Metadata Manager, Power Exchange 8.6, Data Analyzer, UNIX, Oracle 10g, DB2 Flat Files, XML Files, SQL and PL/SQL, Business Objects XIR2, ERWIN 4.0

Confidential, Bloomington, IL

Informatica Developer

Responsibilities:

• Collaborated with Business analysts and the DBA for requirements gathering, business analysis and designing of the data marts. Worked on dimensional modeling to Design and develop STAR Schemas, identifying Fact and Dimension Tables for providing a unified view to ensure consistent decision making.
• Identified all the confirmed dimensions to be included in the target warehouse design and confirmed the granularity of the facts in the fact tables.
• Worked with heterogeneous sources from various channels like Oracle, SQL Server, flat files, and web logs.
• Created User, Groups, assigning users to groups and grant privileges and permissions to groups and folders.
• Worked on Informatica tool Source Analyzer, Warehouse Designer, Mapping Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Extensively used Transformations like, Aggregator, Router, Joiner, Expression, Lookup, Update Strategy, and Sequence Generator.
• Used Informatica Repository Manager to create Repositories and Users and to give permissions to users.
• Developed Interfaces using UNIX Shell Scripts to automate the bulk load, update Processes and Batch processes Scheduled Sessions and Batches using Server Manager.
• Extensively worked in the performance tuning of ETL mappings and sessions.
• Written PL/SQL stored Procedures and Functions for Stored Procedure Transformation.
• Created data - model for supporting this table driven design in ERWIN.
• Created effective Test Cases and did Unit and Integration Testing to ensure the successful execution of data loading process.
• Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.
• Provided technical assistance by responding to inquiries regarding errors, problems, or questions with programs/interfaces.
• Tested the data and data integrity among various sources and targets. Associated with Production support team in various performances related issues.

Environment: Informatica PowerCenter 8.x/7.x, Power Exchange 8.6, Metadata Manager, Data Analyzer, UNIX, Oracle 10g,SQL Server 2008, Flat Files, XML Files, SQL and PL/SQL, Business Objects XIR2,, Toad for oracle 10G, Informatica B2B studio Tool set

Confidential, Grand Rapids, MI

Informatica Developer

Responsibilities:

• Worked with the Customers and Business Analysts for requirements gathering, rules and metadata, understanding the business and designing the solution.
• Worked with Architects and DBA in designing the rules engine and implementing the logical and physical model based on the rules and metadata provided by the Business Analysts.
• Worked with the Third party Interface team like Priority Health to understand the layout and specifications of claims files and handled the automated process of placing the files onto the development server.
• Worked with eSHare application development team to create and populate the presentation tables.
• Worked with application team in designing the SQL Server point of care application tables and complex mappings are written to populate these tables.
• Transformed the HL - 7 feed patient appointments and scheduling information into an automated Informatica process to populate them into oracle scheduling tables.
• Worked with different types of flat files from Priority health and created processes in Informatica to populate the data into Oracle tables.
• Transformed the given source data into different transformed tables based on the patient demographic data, patient visit Information and claims data from providers like Priority Health, BCN and Misys using complex match/merge Informatica logic.
• Wrote UNIX shell scripts to automate the process of compressing and moving the files into archive folder on the development server after they are processed into Oracle stage tables.
• Complex mappings were designed and developed which process the source data through rules engine to populate the registry data mart tables.
• Extensively used transformations like lookup, update strategy, expression, aggregator, normalizer, filter, router, stored procedure, sequence generator, union and rank.
• Worked with mapping parameters and variables, created multiple mapplets and reusable transformations and used them appropriately in different mappings.
• Followed Best practices Informatica and Confidential standards for EDW at various levels of SDLC.
• Created Workflows with worklets, event wait, decision box, e-mail and command tasks using Workflow Manager and monitored them in Workflow Monitor.
• Performed Unit test and Integration test for the process created in Informatica and all the test cases were well documented for process improvements.
• Implemented Informatica best tuning techniques to increase the performance of the process.
• Complex SQL queries are written in TOAD for validating the registry data.
• Assisted the Business Intelligence team in understanding the registry data mart and also involved in Registry Universe design.

Environment: Informatica, Power Center 8.x/7.x, Metadata Manager, Data Analyzer, UNIX, Oracle 10g, Flat Files, XML Files, SQL and PL/SQL, Business Objects XIR2,, Toad for oracle 10G, Informatica B2B studio Tool set

Confidential

Informatica Developer

Responsibilities:

• Involved in the complete life cycle of the data warehouse development and designed and maintained data marts.
• Designed star and minimal snowflake schemas.
• Extraction, transformation and loading were performed using Informatica PowerCenter to build the data warehouse.
• Extensively used Informatica Designer to create and manipulate source and target definitions, mappings, mapplets, transformations, re - usable transformations.
• Worked on various transformations such as Aggregator, Normalizer, Upgrade strategy, Router, Sorter, Source Qualifier, Filter, Expression, Look-up, Sequence Generator, Joiner, etc.
• Developed Informatica mappings for TYPE 2 Slowly Changing Dimensions.
• Created Mapplets for reusable business rules.
• Used Pipeline partitioning and External Loader to improve Session performance.
• Used the Debugger to run Debug sessions setting Breakpoints across instances to verify the accuracy of data.
• Developed UNIX Shell scripts for data extraction, running the pre/post processes and PL/SQL procedures for performing different database tasks.
• Designed a data model for the reporting needs of marketing team at Disney using ERWIN.
• Made extensive use of UNIX Shell scripting, setting UNIX cron jobs, maintaining user profiles, archiving log files etc.
• Extracted data from different Relational sources like oracle, transformed the data based on user requirement and loaded around 1TB of data into target, by scheduling the sessions.
• Sessions and batches were created using Server Manager to load the data into the target tables.
• Performed Repository Administration tasks (Creating Repositories, Users, Assigning privileges, creating backups and recovery).
• Performed Unit Testing and validated the data.
• Created partitions through the session wizard in the server manager to increase the performance.
• Responsible to tune ETL procedures and STAR schemas to optimize load and query Performance.
• Used universe, Stored Procedures and Personal Data Files as source for the Business Objects querying, analysis and reporting. Designed adhoc and canned reports using Business Objects.

Environment: Informatica Power Center 7.1.4, Business Objects 6.5, PowerMart5.0, Oracle 10g, SQL Server 2005, SQL * Loader, Teradata V2R5, Embracedo, DBArtician, PL/SQL, XML, UNIX 5.8.