SUMMARY:

• Over 8+ years of Solid understanding and expertise in data warehouse Development, Testing, Deployment, Maintenance and Production Support of Data Integration using Informatica Power Center 10.1(9.x/8.x/7.x), DWBI ETL
• Extensively used Informatica PowerCenter (10.1/9.x/8.x/7.x) for ETL (Extraction, Transformation and Loading) of data from multiple source database systems to Data Warehouses in UNIX/Windows environment.
• Hands - on experience with JIRA UC4, Autosys, Tidal.
• Expertise in Extraction, Transformation and Loading (ETL) process, Dimensional Data Modeling experience using Data modeling, Star schema/ Snowflake modeling, Fact and Dimensions tables, dimensional, multidimensional modeling and De-normalization techniques. Thorough understanding of Kimball and Inmon methodologies.
• Extensive experience using tools and technologies such as Oracle 11g/10g/9i/8i, SQL Server, DB2 UDB, Sybase, TERADATA, MS Access, Flat files, SQL Developer, SQL Navigator, SQL Loader, PL/SQL, TOAD, Stored procedures, triggers.
• Hands-on experience in Developing/Optimizing/Tuning mappings using Informatica.
• Worked on various types of transformations like Lookup, Update Strategy, Stored Procedure, Joiner, Filter, Aggregator, Rank, Router, Normalizer, Sorter, External Procedure, Sequence Generator, and Source qualifier etc.
• Expertise using Debugger, Mapping wizards, Workflow Manager and Workflow Monitor.
• Sound knowledge in creating Tasks, Sessions, Worklets and Workflows in Work let/workflow designer.
• Worked with heterogeneous data sources like Oracle, SQL Server 2008/2005, flat files, XML files, DB2 UDB, Main Frames and COBOL files.
• Experienced in the development, modification and automation of the ETL processes using UNIX shell scripting.
• Created Reusable Transformation, Mapplets, Sessions and Work lets and made use of the shared folder concept using shortcuts wherever possible to avoid redundancy.
• Expertise in design and implementation of Slowly Changing Dimensions (SCD) type1, type2.
• Experience in Informatica mapping specification documentation, tuning mappings to increase performance, proficient in creating and scheduling workflows and expertise in Automation of ETL processes with scheduling tools such as Autosys and Control-M.
• Strong data modeling experience using Star/Snowflake schema, Re-engineering, Dimensional Data modeling, Fact & Dimension tables, Physical & logical data modeling.
• Experience in writing complex sub queries, PL/SQL programs (functions, procedures, packages), stored procedures, and shell scripting to run pre-session and post session commands.
• Perform error handling as part of production support on Informatica as well as Unix.
• Experience in Installation, Configuration, and Administration of Informatica Power Center 10.1/9.x/8.x/7.x
• Extensive experience in writing SQL scripts to validate the database systems and backend database testing.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center (10.1/9.x/8.x/7.x)

Data Modeling Tools: Erwin Data Modeler, TOAD Data Modeler, Microsoft Visio

RDBMS: Oracle 11i/10g/9i/8i, TERADATA, SQL Server

Operating System: UNIX, Windows

Scheduling Tools: Control - M, Autosys, Tivoli, Active Batch, BMC

OLAP Tools: Cognos 8.x/7.0, Micro Strategy, OBIEE

PROFESSIONAL WORK EXPERIENCE

Confidential, Cincinnati, OH

Senior ETL Informatica Developer

Responsibilities:

• Involved in Data Modeling using different techniques.
• Interacts with business users to understand the requirements.
• Created technical specification documents, STM documents, detailed ETL designs, Unit test plans, Deployment plans, Turn over documents etc.
• Implemented Type 2 Dimensions (SCD Type 2) to maintain history in the Dimensions.
• Involved in requirement specification meetings to add/change requirement as per the changing ETL Scenarios.
• Involved in ETL architecture meetings and any new tool implementations.
• Used complex Informatica mappings to extract data from the source system to the Staging DB.
• Converted complex Oracle PL/SQL Packages to Informatica Mapping/Mapplets.
• Converted complex Transformation requirements to Informatica Transformations to transform the Source data to match the Confidential data.
• Involved in change control meetings every week.
• Created test plans and scenarios for development unit testing and data validation.
• Performance tuned slow running mappings by using best practices like Partitioning, SQL Overrides, etc.
• Generated fixed and variable length flat files and read XML files.
• Gained knowledge on experience using Teradata utilities (SQL, B-TEQ, Fast Load, MultiLoad, FastExport, Tpump, Visual Explain, Query man).
• Worked on the Teradata stored procedures and functions to confirm the data and have load it on the table.
• Worked on FTP commands for file transfer.
• Worked on tools like SQL developer, TOAD and DB Visualizer to write complex SQL queries.

Environment: Informatica Power Center (PWC) 10.1.0/9.6.1, Oracle 11g, PL/SQL Developer, Toad, Flat Files, MS Excel 2010, MS Visual Studio 2010, UNIX, WinSCP, MS Access, Jira.

Confidential, PA

Senior Informatica Analyst

Responsibilities:

• Used various informatica transformations in the development of complex mappings.
• Extracted data from different heterogeneous source systems applied business logic using transformations and loaded to the Confidential systems using Informatica power center.
• Used Informatica Data Quality (IDQ) to profile the data and apply rules to Membership & Provider subject areas to get Master Data Management (MDM).
• Worked on multiple projects using Informatica developer tool IDQ
• Involved in migration of the maps from IDQ to power center.
• Design reference data and data quality rules using IDQ and involved in cleaning the data using IDQ.
• Used IDQ to profile the project source data, define or confirm the definition of the metadata, cleanse and accuracy check the project data, check for duplicate or redundant records, and provide information on how to proceed with ETL processes
• Analyzed and thoroughly studied various data sources and different development environments within the organization.
• Extensively worked on extracting the data from various flat files (fixed width, delimited), applying the business logic and then loading them to the oracle databases.
• Extensively worked with Source qualifier, Filter, Joiner, Expression, Lookups, Aggregator, Router, Sequence Generator, and Update Strategy.
• Worked closely with business for requirement gathering and to understand the project needs.
• Interacted with environmental team and data architects in design and implementation data models.
• Designed and developed complex mappings to load the Historical, Weekly and Daily files to Oracle database.
• Extensively worked on data conversion and data cleansing.
• Created different move-it jobs to have inbound/outbound transition of files between WellCare and different vendors. written UNIX shell scripts created command task, and email task for providing the pre-session post-session requirements for various informatica jobs.
• Provide database coding to support business applications using T-SQL
• Worked on automation of informatica job flow using autosys boxes/jobs.
• Extensively worked on basic SQL queries such as creating altering Tables, Indexes, Views also worked with PL/SQL stored procedures. Queried various tables to get resultant datasets as per the business requirements.
• Prepared ETL mapping documents explaining complete mapping logic.
• Prepared unit test document and performed unit testing, regression testing.
• Provided QA/UAT support while code promotion and worked with QA's to resolve any defects if found.
• Worked with the Release Management Team, the DBA Team, and the UNIX team for smooth code productions.

Environment: Informatica PowerCenter 9.6.1/9.5, Informatica Data Quality (IDQ), Oracle 11g, PLSQL Developer, Flat Files, MS Excel 2010, MS Visual Studio 2010, UNIX, WinSCP, MS Access, Autosys.

Confidential, Minneapolis, MN

Senior ETL Developer

Responsibilities:

• Used Informatica Power Center to extract/transform and load data from different operational data sources like Oracle, Flat files like CSV files, XML files, Cobol files, SQL server from which customers data is coming and is loaded into Teradata warehouse,
• Configured JMS message Queue and message triggers with SIF API,
• Configured Web services using SIF API Interface,
• Implemented Type 2 Slowly Changing Dimension (SCD) to access the full history of accounts and transaction information,
• Implemented Change Data Capture (CDC) using the MD5 function,
• Worked on Informatica command line utilities like PMCMD, PMREP,
• Responsible for the performance tuning of the ETL process at source, Confidential, mapping and session levels,
• Responsible for troubleshooting bottleneck problems by creating the indexes at database level,
• Created and configured workflows, worklets, and sessions using Informatica Workflow Manager,
• Made use of session log files and workflow log files to debug errors in mappings and sessions,
• Used Mapping Parameters and Variables for reusability of code snippets,
• Worked with version control tools like SVN and scheduler tools like autosys,
• Worked with Teradata utilities like Multiload, FastExport, and BTEQ scripts,
• Coded shell scrips in UNIX and used UNIX tools like WinSCP,
• Supported the testing team, UAT team and production support teams.
• Worked on complex mappings using transformations like Aggregator, Expression, Joiner, Filter, Sequence Generator, Connected and Unconnected Lookup, Dynamic Lookup, Filter, Router, Union, and Update Strategy using Informatica Power Center Designer,

Environment: Informatica Power Center 9.1.1, IDD, SIF, Oracle11g, Teradata V2R12, SQL Server 2008/R2, UNIX, Teradata utilities.

Confidential

Informatica Developer

Responsibilities:

• Performed requirements gathering, developed Analysis & Design document (A&D), developed Project time line,
• Designed and developed the ETL Mappings for the source systems data extractions, data transformations, data staging, movement and aggregation,
• Developed standard mappings using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter for weekly, quarterly process to loading heterogeneous data into the data warehouse. Source files include delimited flat files, and SQL server tables,
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy, Union, SQL, Java and Sequence generator,
• Executed sessions, both sequential and concurrent, for efficient execution of mappings and used other tasks like event wait, event raise, email and command,
• Used Informatica for loading the historical data from various tables for different departments
• Developed Informatica mappings for Slowly Changing Dimensions Type 1 and 2,
• Created Mapplets for implementing the incremental logic, in identifying the fiscal quarter of the transaction and in calculating various requirements of business processes,
• Involved in the Unit & Integration testing of the mappings and workflows developed for the enhancements in the application,
• Code migration of Informatica jobs from Development to Test to Production. Performed Unit testing, Integration Testing, Job & Environment Parameters Testing along the way,
• Scheduled and ran Extraction and Load processes and monitored tasks and workflows,
• Tuned the MMW databases (stage, Confidential ) for better, faster and efficient loading and user query performance,
• Created Informatica mappings with PL/SQL stored procedures/functions to in corporate critical business functionality to load data,
• Extensively worked on performance tuning of mappings, sessions, Confidential, Source and various ETL processes.

Environment: Informatica 9.0.1, Oracle, DB2, Erwin, Oracle, SQL server, Shell scripting, TOAD.

Confidential

ETL Developer

Responsibilities:

• Involved in all phases of SDLC from requirement, design, development, testing, training and rollout to the field user and support for production environment,
• Involved in Analysis of the current system and Design solutions to create a centralized data warehouse as well as planning migration solutions from the current system to the new system,
• Used Informatica to extract data from different Source systems DB2 and Flat files then into Oracle Confidential system,
• Designed and developed mapping, transformation logic and processes in Informatica for implementing business rules and standardization of source data from multiple systems into the data warehouse,
• Actively involved in the scripting team for shell script to automate and migrate data from ODS to Data warehouse,
• Involved in different team review meetings,
• Involved in Development and Data Integration of the main components using Informatica Power Center,
• Used different Transformations like Expression, Router, Filter, Sequence Generator, Stored Procedure, Connected and Un-connected Look ups etc.,
• Created the mapping and Functional Specifications,
• Managed software releases after each stage of the testing and defect removal. As well as resolving issues from UAT and System testing.

Environment: Informatica Power Center 8.6, Oracle 9i, UNIX Flat files, SQL, PL/SQL and UC4 Scheduling tool.