PROFESSIONAL SUMMARY:

• Over 10 yrs of IT experience which includes strong data warehousing, ETL and OLAP experience using Informatica Power mart and Power Center 10.1/9.6.0/ 8.6/ 8.1/ 7 x/ 6.2/6.1/ 5.1,(Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet, Transformations), Business Objects, Oracle 11g/10g/9i/8i/7.x, MS SQL Server 2014/2008/2005/2000/7.0/6.5, MS Access 2007/2005.
• Experience in all aspects of the System Development Life Cycle.
• Designed and developed complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Sorter, Normalizer, Sequence Generator, Router, Filter, Expression, Aggregator, Joiner and Update Worked with Power Center Repository Manager, Designer, Workflow Manager and Workflow Monitor tools.
• Extensive UNIX Shell Scripting knowledge.
• Thorough Knowledge in creating DDL, DML and Transaction queries in SQL for Oracle database.
• Experience in Performance Tuning of ETL to get quicker execution time.
• Working Experience in E - R modeling-FACT & Dimensions tables, Physical & logical data modeling.
• Involved in Extraction Transformation and Loading (ETL) Process in various projects using Informatica Power Center.
• Extensive experience working in a health care payer environments.
• Worked Extensively with Slowly Changing Dimensions Type1, Type2 and Type3.
• Knowledge of ETL command line utilities to execute workflows in Unix environment.
• Experience in Capturing Incremental data (CDC) from source systems.
• Strong technical skills with Unix/Linux systems.
• Worked on error handling and problem solving in Informatica.
• Experienced in integration and transforming of various data sources from Databases like Oracle, DB2, SQL Server and formats like flat-files, COBOL files, XML, etc.
• Extensive Knowledge of Dimensional Data Modeling of Star Schema/Snowflake and Relational database concepts.
• Expertise in developing SQL,PL/SQL codes through various Procedures/Functions, Packages, Cursors and Triggers to implement the business logics of database.
• Sound knowledge of views, Synonyms, Indexes, Partitioned Tables, Joins and Sub-Queries.
• Experienced in data modeling and data normalization.
• Strong understanding of OLAP/OLTP and relational database design Concepts.
• Experience in Repository Configuration and processing tasks using Workflow Manager & Workflow Monitor to move data from multiple sources into targets.
• Experience with managing ODBC connections.
• Excellent communication skills and ability to learn new things and be highly motivated.
• Involved in Test Planning and execution for various Test Phases: Unit Test, System and User Acceptance Testing.
• Ability to work under stringent deadlines with team as well as independently.

TECHNICAL SKILLS:

DWH Tools: Informatica Power Center10.1/9.6.0, 9.1/8.6/ 8.1/ 7 x, Business Objects 5.1/5.0,Netezza, TOAD, MS Access

EIM: Informatica Data Quality 9.x/Informatica Data Explorer, Informatica MDM 9.x

BI Reporting Tools: Cognos Analysis, Query Studio (Workspace Advanced)

Languages: Visual Basic, Clear Basic, ASP, PL/SQL, T-SQL.

Data Modeling Tools: Erwin, ER Studio

Databases tools: Oracle 11g/10g/9i/8i, MS SQL Server 2014/2012/ 2008/ 2005/2000, SQL*Loader,Quest TOAD, UDB DB2 8.0, Sybase.

Environment: Windows Server 2012/2008/2003, Windows 7 & XP/2000, UNIX,LINUX

CRM Tools: Clarify 8.0/7.0

Scheduling tools: Informatica Scheduler, DAC, Autosys, Tidal Scheduler 2.5/5.3,Crontab, Control-M

PROFESSIONAL EXPERIENCE:

Confidential, Parsippany, NJ

Sr Informatica Developer

Environment: Informatica Power Center 10.2, MDM 10.2,Oracle 11g, UnixShellScripting, Red hat Linux, HP Service Manager, Bit Bucket, Autosys.

Responsibilities:

• Involved in the full SDLC of the project including Design, Development and Testing.
• Gathered requirements from Business Analysts, End Users analyze it and developed Technical design documents (TDD) using Business requirement documents (BRD).
• Created Sessions and Workflows to carry out the ETL process, configured sessions and connection parameters using Power Center tool.
• Involved in extensive performance tuning by determining bottlenecks at various points like sources, targets, mappings and sessions.
• Designed and developed Mappings and Maplets with various transformations such as Connected and Unconnected Lookup, XML Source Qualifier, Filter, Joiner, Router, Stored Procedure, Sorter, Expression, Aggregator in Power Center.
• Worked with to run Oracle SQL statements for storing, retrieving, and manipulating data in a relational database.
• Used the Explain Plan to fine tune the Source query to improve performance.
• Maplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability in Power Center.
• Created and Configured Workflows, Worklets, and Sessions to load the data to target tables using Informatica Workflow Manager.
• Involved in extracting data (CSV Files) from Mainframes and loaded into Oracle target tables using Power center workflows.
• Added new worklets with different sessions and partitioned the sessions of the workflows for loading quarterly data to improve the session performance.
• Exported and imported workflow xml files to standardize the session properties for large number of sessions in the workflow.
• Performed ETL configuration and troubleshooting.
• Extracted data from flat files and Oracle tables sources and loaded into the target database.
• Created missing indexes and dropped unused indexes on the source tables for faster retrieval of data.
• Migrated workflows from UAT to PROD repositories and validate them.
• Used SCD Type 1, Type 2 and Type 3 mappings to update slowly Changing Dimension Tables.
• Worked with DBA to create the derived tables required for ETL development.
• Performed incremental loads post history data loads across all the Business Units.
• Modified the existing stored procedures and replaced Pre SQL query in the session properties to improve performance.
• Created jil files with command and box jobs to schedule the incremental catch up workflows.
• Worked with QA team for defect fixes across UAT and PROD environments.
• Performed ETL testing to validate the data after loading.

Confidential, Milwaukee, WI

Sr Informatica Developer

Environment: Informatica Power Center 9.6, 10.1, SQL Server 2014, UnixShellScripting, Redhat Linux, HP Service Manager, Subversion, Tivoli, Autosys.

Responsibilities:

• Involved in the full SDLC of the project including Design, Development and Testing.
• Gathered requirements from Business Analysts, End Users analyze it and developed Technical design documents (TDD) using Business requirement documents (BRD).
• Performing one time history loads in different layers for all Business Units.
• Involved in extensive performance tuning by determining bottlenecks at various points like sources, targets, mappings and sessions using Informatica Power Center 9.6.
• Analyzing the session logs for troubleshooting the workflows/sessions failures and for the long running sessions.
• Worked with SQL Server 2014 to run SQL statements for storing, retrieving, and manipulating data in a relational database.
• Used the SQL Server Database tuning Advisor to fine tune the Source query to improve performance.
• Copying the workflows in different layers and updating the parameter files for all Business Units.
• Created and Configured Workflows, Worklets, and Sessions to load the data to target tables using Informatica 9.6 Workflow Manager.
• Modifying the commit interval, buffer block size and DTM buffer settings in the session properties for improving performance for long running sessions.
• Added new worklets with different sessions and partitioned the sessions of the workflows for loading quarterly data to improve the session performance.
• Exported and imported workflow xml files to standardize the session properties for large number of sessions in the workflow.
• Enhanced the existing mappings and created sessions and worklets to apply the business logic as per the requirements.
• Extracted data from flat files and SQL Server tables sources and loaded into the target database.
• Created missing indexes and dropped unused indexes on the source tables for faster retrieval of data.
• Migrated workflows from UAT to PROD repositories and validate them.
• Scheduled workflows using Autosys and Tivoli Scheduler.
• Performed incremental loads post history data loads across all the Business Units.
• Modified the existing stored procedures and replaced Pre SQL query in the session properties to improve performance.
• Created jil files with command and box jobs to schedule the incremental catch up workflows.
• Worked with QA team for defect fixes across UAT and PROD environments.
• Performed ETL testing to validate the data after loading.

Confidential, Bloomington, IL.

Sr Informatica Developer

Environment: Informatica Power Center 9.6.0, 10.1, IBM-AIX, Teradata, Oracle, UnixShellScripting, Red hat Linux, HP Service Manager, Power Exchange .Net, Oracle 12c, Subversion, Control-M.

Responsibilities:

• Developed Technical design documents (TDD) from user requirements and functional requirements documents (FRD).
• Worked on the build phase for the new data center migration of TAC project.
• Involved in implementing change management process while fixing the existing code to enhance the code or bug fixing.
• Modified existing mappings to accommodate new business requirements due to single instance impact at the source.
• Worked on Data Conversion and Data Analysis.
• Troubleshooting the issues in Informatica.
• Supported AS400/iSeries applications, starting/stopping hub jobs, clearing queues and logjams.
• Created and Configured Workflows, Worklets, and Sessions to transport the data to target using Informatica Workflow Manager.
• Worked with Oracle SQL for storing, retrieving, and managing document-oriented, or semi structured data.
• Supported .Net based applications such as configuring, clean restarting and managing.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions. This led to better session performance.
• Worked on Agile methodology for quick responses to change and continuous development.
• Improve availability and timeliness of test environments.
• Involved in extracting data (CSV Files) from Mainframes and loaded into Oracle target tables using Power center workflows.
• Performed ETL configuration and troubleshooting.
• Worked with Teradata SQL statements for storing, retrieving, and manipulating data in a relational database.
• Worked with Power Exchange for mainframe to simplifies mergers, acquisitions, and reorganizations to integrate, migrate the mainframe data rapidly.
• Strong Knowledge of Oracle EBS/ERP
• Worked with Security Analyst to upload the Unix script into Dynamic Password Lookup tool to securely access the application credentials.
• Used ODS for integrating disparate data from multiple sources for business operations, analysis and reporting.
• Used Informatica Power Exchange for Mainframes to access, integrate and mainframe-based enterprise data to Oracle target database using Power Center.
• Worked with Oracle ERP application for managing accounting, procurement, and projects throughout the organization.
• Involved in Agile process for continuous attention to technical excellence and good design.
• Worked with different transformations in Informatica Power Center 9.6 to apply business logic.
• Created mappings in Power center 9.6 to migrate data from Flat files, Sybase to data warehouse.
• Strong technical skills with Unix/Linux systems.
• Used DB2 Load utility to load the data from FDW table into the file.
• Managed ETL Domain/Repository/Integrations services and workflows (Stop/Start) whenever the database servers are bounced.
• Used Oracle ERP software with integrated cloud applications to deliver the functionality, analytics, security, and collaboration tools for the business needs.
• Worked with ODS can for data scrubbing, resolve for redundancy and checked for compliance with the business rules.
• Worked with DBA to create the derived tables required for ETL development.
• Used UNIX Shell Scripting on Linux platforms to automate the loading process and to generate restart tokens for cold starting the workflows.
• Created Sessions and Workflows to carry out the ETL process, configured sessions and connection parameters using Informatica Power Center 9.6 tool.
• Extensively used unix commands to check the processes, view logs and troubleshoot the issues.
• Used unix scripts to load the initial/incremental SQL into the file and then load into FDW table.
• Worked closely with Unix SAs for troubleshooting OS related issues with applications and servers maintenance activities.
• Involved in Data migration, extraction, Data cleansing and Data Staging of operational sources using ETL processes.
• Used control-M tool for automating and scheduling the ETL workflows using Power center 9.6
• Worked with different teams to trouble shoot the workflows/control-M jobs failures due to db and network issues.
• Developed Unit test cases and Unit test plans to check data is correctly loading.

Confidential, Dallas, TX

Sr Informatica Developer

Environment: Informatica Power Center 9.1.0, Oracle 11g/12c,SQL, PL/SQL, IBM-AIX, Sybase, UnixShellScripting, Red hat Linux, PVCS, TOAD,SQL Developer, Business Objects, UC4,Autosys, Erwin.

Responsibilities:

• Involved in implementing change management process while fixing the existing code to enhance the code or bug fixing.
• Coordinated with the DBA Teams, Source systems and offshore for different data loads (System test Load, Integration System Test Load, UAT Load and Pre production deployment load) and identified the bugs, new requirement changes and Data Quality Issue.
• Prepared Technical Specification documents (TSD) for Mappings.
• Troubleshooting the issues in Informatica.
• Worked with Teradata SQL statements for storing, retrieving, and manipulating data in a relational database.
• Good understanding of relational database management systems like Oracle,PLSQL,and SQL and extensively worked on Data Integration using Informatica for the Extraction transformation and loading of data from various database source systems.
• Created and Configured Workflows, Worklets, and Sessions to transport the data to target using Informatica Workflow Manager.
• Worked with Power Exchange for mainframe to simplifies mergers, acquisitions, and reorganizations to integrate, migrate the mainframe data rapidly.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions. This led to better session performance.
• Designed and developed Mappings and mapplets with various transformations such as Connected and Unconnected Lookup, XML Source Qualifier, Filter, Joiner, Router, Stored Procedure, Sorter, Expression, Aggregator in Power Center.
• Supported .Net based applications such as configuring, clean restarting and managing.
• Developed the code for data extraction, data processing and data warehousing.
• Built-in mapping variable / parameters and created parameter files for imparting flexible runs of sessions / mappings based on changing variable values.
• Used Informatica Power Exchange for Mainframes to access, integrate and mainframe-based enterprise data to Oracle target database using Power Center.
• Planned and executed deployments across all environments.
• Developed Slowly Changing Dimension Mappings for Type 1, Type 2 and Type 3 .
• Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability in Power Center.
• Worked on Agile methodology for quick responses to change and continuous development.
• Performed ETL configuration and troubleshooting.
• Loaded operational data from Oracle, Sql server, flat files, Excel sheets into various data marts.
• Redesigned some of the existing mappings in the system to meet new functionality.
• Used Power Center Debugger tool to fix the defects/ errors and data issues.
• Reviewed ETL code for standards adherence before the migration and tuned mappings and workflows for better performance.
• Migrated the repository objects (workflows) between the folders of different repositories.
• Developed workflow tasks like reusable Email, Event wait, Timer, Command and Decision task.
• Used UNIX Shell Scripting to automate the loading process and to generate restart tokens for cold starting the workflows.
• Involved in Agile process for continuous attention to technical excellence and good design.
• Created and scheduled sessions, jobs based on demand, run on time and run only once using Workflow Manager.
• Fine-tuned large/complex queries to improve batch load performances.
• Move components across various environments like test, UAT, and production environment.
• Prepared Test preparation and execution plans for different entities and executed the testing with team and Involved in Integration testing.

Confidential, St. Louis, MO

Sr.Informatica Developer

Environment: Informatica Power Center 8.6.1,9.1,Power mart, Oracle 11g,SQL, PL/SQL, IBM-AIX, UnixShellScripting, MS SQL Server 2008, TOAD,SQL Developer,.Net, Business Objects, Autosys, Erwin.

Responsibilities:

• Involved in gathering business user requirements, understanding the business model (E-R Diagrams) and database tables.
• Developed Technical design documents (TDD) from user requirements and functional requirements documents (FRD).
• Design, implement and documenting ETL processes data warehousing practices and standards.
• Extensively used Informatica Power center 9.1, Designer to create and manipulate source and target definitions, mappings, mapplets, transformations, re-usable transformations etc.
• Used Surrogate keys in the Data Ware house tables to manage the Slowly Changing Dimensions (SCD) properly and easily.
• Developed mappings in Informatica to load the data from various sources into the Data Warehouse using different transformations like Joiner, Aggregator, Update Strategy, Router, Lookup, Sequence Generator, Filter, Sorter, and Source Qualifier.
• Designed ETL strategy to load data from source systems such as UDB DB2,Oracle, XML, Flat Files to Target Data Base.
• Worked extensively on Mapping Designer to design and create mappings, transformations to implement transformation logic.
• Extensively used the features of Informatica Version 8.6 including Designer, Workflow manager and Workflow monitor.
• Worked on Agile methodology for quick responses to change and continuous development.
• Altered mappings to accommodate new business requirements due to single instance impact at the source.
• Created FTP connections to read data from the flat files from different server.
• Worked with SQL statements for storing, retrieving, and manipulating data in a relational database.
• Created partitions on the sources to improve the performance.
• Hands on Stored Procedures, Functions, Packages and Triggers using PL/SQL.
• Created Sessions and Workflows to carryout the ETL process, configured sessions and connection parameters.
• Used SCD Type 1, Type 2 and Type 3 mappings to update slowly Changing Dimension Tables.
• Worked on Informatica developments and enhancements by creating new mappings and making changes to the existing mappings as per the business requirements.
• Developed reusable transformations and mapplets, which were used in other operations.
• Used SQL developer and TOAD to run SQL queries and validate the data in warehouse and data mart.
• Worked with Variables and Parameters in the mappings to pass the values between sessions.
• Used Debugger to test the mappings and fixed the bugs.
• Migrated mappings to various environments like development, testing and production etc.
• Scheduled workflows using Autosys and Informatica Scheduler.
• Involved in Agile process for continuous attention to technical excellence and good design.
• Worked with the DBAs for the performance and database tuning.
• Created debugging sessions before the session to validate the transformations and also used existing mappings in debug mode extensively for error identification by creating break points and monitoring the debug monitor.
• Created workflows using Session, Command, and Email tasks.
• Developed Unit test cases and Unit test plans to check data is correctly loading.
• Conducted Informatica performance tuning on sessions by optimizing block size, data cache size, sequence buffer length and commit interval.
• Used UNIX Shell Scripting to automate the loading process.
• Provided reliable, timely support of integration, performance and user acceptance testing processes.

Confidential, Palo Alto, CA.

Sr.Informatica Developer

Environment: Informatica Power Center 8.6.1, Oracle 11g,SQL, PL/SQL, IBM-AIX,MS SQL Server 2008, UnixShellScripting, TOAD, Business Objects, Autosys, Erwin, MS Access.

Responsibilities:

• Involved in the full life cycle development of the project including: design, development, and testing.
• Involved in gathering business user requirements, understanding the business model (E-R Diagrams), database table and query design, extracts and use of report query tools and Identify technical risks, assumptions, and dependencies.
• Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule it.
• Extensively used Informatica Designer to create and manipulate source and target definitions, mappings, mapplets, transformations, re-usable transformations etc.
• Used Surrogate keys in the Data Ware house tables to manage the Slowly Changing Dimensions (SCD) properly and easily.
• Extracted data from multiple sources such as DB2, Oracle, XML, Cobol, Flat Files & MS Access and loaded the transformed data into targets in Oracle, Flat Files.
• Worked extensively on Mapping Designer to design and create mappings, transformations to implement transformation logic.
• Extensively used the features of Informatica Version 8.6 including Designer, Workflow manager and Workflow monitor.
• Experience in dimensional modeling (star schemas, snowflake schemas /ROLAP, OLAP, MOLAP) .
• Worked with SQL Server SQL statements for storing, retrieving, and manipulating data in a relational database.
• Involved in Data migration, extraction, Data cleansing and Data Staging of operational sources using ETL processes.
• Worked on Agile methodology for quick responses to change and continuous development.
• Created partitions on the sources to improve the performance.
• Extensively used Change Data Capture (CDC) approach efficiently to capture only the changed data.
• Used stored procedures for truncating the tables and deleting the rows from error logs.
• Created Sessions and Workflows to carryout the ETL process, configured sessions and connection parameters.
• Worked with the scheduling tool UC4 to schedule the workflow jobs.
• Developed reusable transformations and mapplets, which were used in other operations.
• Worked with Variables and Parameters in the mappings to pass the values between sessions.
• Created debugging sessions before the session to validate the transformations and also used existing mappings in debug mode extensively for error identification by creating break points and monitoring the debug monitor.
• Worked on software engineering/SDLC tools, particularly Microsoft Team Foundation Server (TFS), to document and track work items from initial request through production deployment.
• Conducted Informatica performance tuning on sessions by optimizing block size, data cache size, sequence buffer length and commit interval.
• Used UNIX Korn Shell Scripting to automate the loading process.
• Developed Unit test cases and Unit test plans to check data is correctly loading.

Confidential, Indianapolis, IN

Sr. Informatica Developer

Environment: Informatica Power Center 8.1.1, Oracle 10g,SQL,PL/SQL,UDB DB2, ODI,Toad, Mercury Test Director8.0,HP-UNIX, Citrix.

Responsibilities:

• Worked on Informatica - Source Analyzer, Data warehousing designer, Mapping Designer, Mapplet designer and Transformations.
• Implemented Joiner, Expression, Aggregator, Sorter, Rank, Lookup, Update Strategy, Filter, stored procedures, Normalizer Transformation and Router Transformations.
• Responsible for managing scope, planning, tracking, change control, aspects of the Informatica Objects.
• Used the Power Center 8.1.1, Designer’s debugger to test and fix bugs in the mappings.
• Generated Reusable Transformations, Mapplets and used them extensively in many mappings.
• Worked with Variables and Parameters in the mappings to pass the values between sessions.
• Created and Monitored Sessions using Informatica Power Center Server to load data in to the Target Database.
• Involved in Informatica GRID configuration & Data Modeling (ERD process).
• Implemented the enhanced ETL mapping to Staging Database and from Staging to Data warehouse star schema.
• Worked on Informatica developments and enhancements by creating new mappings and making changes to the existing mappings as per the business requirements.
• Extensively used ETL to load data from flat files to Oracle and flat files.
• Worked on converting PL/SQL loads to Informatica loads.
• Responsible to tune ETL procedures, processes, and STAR schemas to optimize load and query performance.
• Conducted performance tuning on sessions by optimizing block size, data cache size, sequence buffer length and commit interval.
• Mercury Test Director is used for assigning and tracking the Change Requests (CR’s) and Test Problem reports (TPR’s).