SUMMARY

• Over 7 years of IT experience with extensive Data Warehousing implementations across Healthcare, Financial, Pharmaceutical and Product based Industries usingInformatica Power Center 9.x/8.x and Oracle Database.
• 4+ years of ETL and data integration experience in developing ETL mappings and scripts using Informatica Power Center with client tools like Designer (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer and Mapping Designer), Repository Manager, Workflow Manager and Workflow Monitor.
• Implemented Cleansing flat files as per the business requirements.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements. Solid understanding of OLAP concepts and challenges, especially with large data sets.
• Designed complex ETL mappings like slowly changing dimensions, performed critical performance tweaking stages with partitioning, persistent cache and extensive use of mapplets.
• Developed high level and low level design documents and mapping specifications to build Informatica Mappings to load data into target tables adhering to the business rules
• Strong knowledge of Dimensional Data Modeling, Star Schema Modeling, Snow - Flake Schema Modeling, FACT and Dimensions Tables.
• Experience in integration of various relational and non-relational data sources like Oracle, SQL Server, and Flat Files into staging area.
• Experience in creating Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Event Wait, Event Raise, Timer etc).
• Expert knowledge in Performance Tuning, identifying and resolving performance bottlenecks in various levels such as source, mapping, target and sessions to provide maximum efficiency and performance.
• Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows.
• Experience in writing, testing and implementation of the PL/SQL packages, triggers, stored procedures and functions.
• Good understanding of Relational Database Management Systems (RDBMS) like Oracle 8i/9i/10g/11g.
• Involved in Unit testing, Integration testing to check whether the data loads into target are accurate.
• Experience in support and knowledge transfer to the production team.
• Proficient in interaction with the business users by attending meetings with the clients in Requirements gathering phase.
• Coordinated and provided technical oversight to onshore and offshore team to implement the project.
• Excellent analytical/ communication skills and good team player.
• Experience in all the phases of Data warehouse life cycle involving Requirement gathering, Implementation & Design, Development, Testing and Deployment.

TECHNICAL SKILLS

Data Warehousing Tools: Informatica Power Center 9.x/8.x, Cognos, SSIS

Languages: SQL, PL/SQL, JAVA, PHP,JAVASCRIPT, CSS,HTML, XML

Databases: Oracle11g/10g/9i/8i/7i, MS SQL Server 2008/2005/2000

Operating System: Windows 9x/NT/2000/XP, UNIX, Linux, MS-DOS

Tools: /Utilities: SQL*plus, SQL Developer, Toad 5.x/6.x/7.x/8.x/9.x

Scripting: UNIX Shell Script, PowerShell Script

OTHERS: JSON, JQUEARY, AJAX

PROFESSIONAL EXPERIENCE

Confidential, Salt Lake city, UT

Informatica Developer

Responsibilities:

• Lead the development of source-to-target mapping design specifications, data dictionaries, and review database schemas. Develop and test Extra, Transformation, and Loading (ETL) modules based on design specifications.
• Codes, tests, debug, implements, and documents moderately complex programs. Creates appropriate documents in work assignments such as program code, and technical documentation.
• Designs system and program to meet complex business need. Prepares detailed specifications from which programs are developed and coded. Ensures programs meet standers and technical specifications; performs technical analysis and component delivery.
• Designs programs for projects or enhancements to existing programs.
• Plan, test, and deploy ETL mappings, and database code as part of application build process across the enterprise.
• Conducts quality assurance activities such as reviews.
• Creates appropriate documentation in work assignments such as program code, and technical documentation.
• Remains abreast of industry technical trends and new development to maintain current sills and remain current with industry standers.
• Work as part of a team and provide 7X24 supports when required.
• Communicates with customers, team members, external data providers and management
• Anticipates problems and takes decisive action.
• Troubleshoots operational data issues and performs ad-hoc reporting as needed.

Environment: Informatica PowerCenter 8.6.1, Oracle 11g, PL/SQL, Unix Shell Script, SQL Developer

Confidential, Charlotte, NC

Informatica Developer

Responsibilities:

• Analyzed business process and gathered core business requirements. Interacted with business analysts and end users.
• Used Informatica designer for designing mappings and mapplets to extract data from SQL Server, DB2 and Oracle sources.
• Created different parameter files and changed Session parameters, mapping parameters, and variables at run time.
• Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level. Created different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator.
• Used Debugger to test the data flow and fix the mappings.
• Created and monitored workflows and task using Informatica PowerCenter Workflow Manager.
• Tuned the workflows and mappings.
• Involved in the development of PL/SQL Stored Procedures and Functions to process business data
• Involved in identifying the bottle necks and tuning to improve the Performance.
• Created workflows using Workflow manager for different tasks like sending email notifications, timer that triggers when an event occurs, and sessions to run a mapping.
• Executed Workflows and Sessions using Workflow Monitor.
• Dealt with data issues in the staging flat files and after it was cleaned up it is sent to the targets.
• Actively coordinated with testing team in the testing phase and helped the team to understand the dependency chain of the whole project.
• Executed the workflow using pmcmd command in UNIX.

Environment: Informatica PowerCenter 9.1, Oracle 11g, PL/SQL, SQL Developer

Confidential, Salt Lake City, UT

Informatica Developer

Responsibilities:

• My main responsibility was to resolve issues related to data warehouse, Stored procedures and analyzed, design and developed ETL strategies.
• Developed mappings, sessions and workflows in Informatica Power Center.
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Worked with heterogeneous source to Extracted data fromOracle database and flat files and loaded to a relational Oracle warehouse.
• Developed standard and reusable mappings and mapplets using various transformations like Expression, Aggregator, Joiner, Router, Lookup (Connected and Unconnected) and Filter.
• Trouble shooting of long running sessions and fixing the issues.
• Worked withVariables and Parametersin the mappings to pass the values between sessions.
• Worked with the testing team to resolve bugs related to ETL mappings that our team created.
• Creating the weekly project status reports, tracking the progress of tasks according to schedule and reporting any risks and contingency plan to management and business users.
• Involved in meetings with production team for issues related to Deployment, maintenance, future enhancements, backup and crisis management of DW.
• Involved in the preparation of design documents like High Level, Low Level.
• Involved in the development of PL/SQL stored procedures and functions to process business data.

Environment: Informatica PowerCenter 9.1, Oracle 11g, XML, PL/SQL, SQL Developer

Confidential

Software Developer

Responsibilities:

• Parsing high-level design specifications of legacy systems to understand dependencies and fetching selective information in target tables - helped the data modeler in designing relational schema
• Developed 60+ ETL mappings to Extract/Transform/Load OLTP data from Staging systems into Data Warehouse following ETL coding standards
• Developed 12 Aggregate mappings to capture Workforce Profile data at Monthly, Quarterly and Yearly level.
• Fine-tuned SQL queries to avoid excessive transformations in ETL, avoided using Joiners and Lookup transformations to improve ETL performance
• Fixed Invalid mappings, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
• Error Management - Debugged mappings by creating logic that assigns a severity level to each error, and sending the error rows to error table so that they can be corrected and re-loaded into a target system
• Removed bottlenecks at source level, transformation level, and target level for the optimum usage of sources, transformations and target loads.
• Developed complex mappings and SCD type-I and Type-II mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Lookup (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router and SQL transformations. Created complex Mapplets for reusable purposes.
• Efficient Documentation was done for all phases like Analysis, design, development, testing and maintenance.

Environment: Informatica Power Center8.1.1, Oracle 10g, Windows XP, WINSCP

Confidential

Software Developer

Responsibilities:

• Analyzed the functional specs provided by data architect and created technical specs documents for all the mappings
• Creation of Informatica mappings using transformations like Source Qualifier, Lookup, Joiner, Rank, Union, Router etc. in the Power Center Designer
• Created complex mappings using SC2 logic, Unconnected Lookup, Sorter, Aggregator, Dynamic Lookup transformations for populating target table in efficient manner
• Extracted data from Files supplied by legacy systems and feeding the database tables
• Created reusable Mapplets, Sequence generators, Lookup transformation in the ETL mappings when same business rules were to be applied
• Created E-mail tasks to notify business people about file generation, data availability
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Improved ETL support work by selectively choosing the parameter variables and loading Parameter files from ETL to avoid mishandling of files
• Developed Data Dictionary and Documented ETL design specifications to help support team

Environment: Informatica 8.1.1, Oracle 10g.