SUMMARY

• Over 7 years of experience in Data Warehousing/Integration using ETL Tool Informatica PowerCenter 9.x/8.x across the business areas such as Pharmaceutical, Healthcare, Insurance and Finance.
• Extensive experience in using Informatica PowerCenter 9.x/8.x to carry out the Extraction, Transformation and Loading process as well as Administering and creating domains, repositories and folder.
• Knowledge of complete software development life cycle including Requirement Gathering, Requirement Analysis, Cost Estimation, Project Management, Design, Development, Implementation and Testing.
• Knowledge on various phases of data warehouse development lifecycle, from gathering requirements to design, development, testing & UAT.
• Experience in integration of various data sources like Oracle, DB2, SQL Server, Flat Files, XML files, COBOL Mainframe files.
• Knowledge of Informatica Power Exchange while reading data in Real Time and Creation of Data maps for reading the Source files into Informatica.
• Strong experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected, Static and Dynamic lookups, SQL, Stored Procedure, Router, Filter, Expression, Aggregator, Joiner, Update Strategy.
• Experience in Creating the Data Mart using the Flat file sources and implementing complex business rules by creating re - usable transformations and Mappings/Mapplets.
• Implemented Slowly Changing dimensions Type 1, Type 2, and Type 3 methodology for accessing the full history of accounts and transaction information.
• Expertise in Data Warehousing concepts like Star schema, Snowflake schema, Fact table and Dimension Table.
• Expert in Oracle 11g/10g, IBM DB2 8.1, Sybase, SQL Server 2008/2005/2008 , SQL, PL/SQL Stored procedures using Toad.
• Excellent communication, interpersonal skills, enthusiastic, knowledge-hungry self-starter, eager to meet challenges and quickly assimilate latest technologies concepts and ideas.

TECHNICAL SKILLS

Primary Tools: Informatica Power Center 9.0/8.5/8.1.2/8.1.1/7.1.1 Repository Admin: console,MDM,B2B DT,Data Exchange, Repository Manager, DesignerWorkflow manager, Work flow Monitor, Source Analyzer, Powe AnalyzaerInformatica PowerMart, Warehouse Designer, Transformation Developer.

Databases: Oracle 11g/10g/9i, MS SQL Server 2008/2005,MS Access, MySQL, SQL,PLSQL.

Operating Systems: Windows 95/98/NT/2000/XP/7/8, UNIX, Linux, NCR MP-RAS UNIX

Data Modeling: Erwin, ER Studio

Scheduling tools: Control M, Autosys

PROFESSIONAL EXPERIENCE

Senior Informatica Developer

Responsibilities:

• Participated in the Design Team and user requirement gathering meetings.
• Performed business analysis and requirements per high end users and managers and performed requirement gathering.
• Extensively used Informatica Designer to create and manipulate source and target definitions, mappings, mapplets, transformations, re-usable transformations.
• Created different source definitions to extract data from flat files and relational tables for Informatica Power Centre.
• Used Star Schema approach for designing of database for the data warehouse
• Developed a standard ETL, T-Sql framework to enable the reusability of similar logic across the board.
• Created different target definitions using warehouse designer of Informatica Power Center.
• Used mapping designer to generate different mappings for different loads.
• Created different transformations such as Joiner Transformations, Look-up Transformations, Rank Transformations, Expressions, Aggregators and Sequence Generator.
• Created stored procedures, packages, triggers, tables, views, synonyms, and test data in Oracle.
• Extracted source data from Oracle, Flat files, XML files using Informatica, and loaded into target Database.
• Created medium to complex PL/SQL stored procedure for Integration with Informatica using Oracle 11g.
• Developed complex mapping also involving SCD Type-I, Type-II,Type-III mapping in Informatica to load the data from various sources
• Extensively transformed the existing PL/SQL scripts into stored procedures to be used by Informatica Mappings with the help of Stored Procedure Transformations.
• Involved in extensive Performance Tuning by determining bottlenecks in sources, mappings and sessions.
• Created Models based on the dimensions, levels and measures required for the analysis.
• Validate the data in warehouse and data marts after loading process balancing with source data.
• Worked closely with the business analyst’s team in order to solve the Problem Tickets, Service Requests.

Environment: Informatica Power Center 9.5, T-SQL, Oracle 11g/10g, MS SQL Server, TWS, UNIX, SSRS Reporting

Confidential, San Diego, CA

Sr.ETL Informatica Developer

Responsibilities:

• Worked with the Business analysts for requirements gathering, business needs and analysis.
• Analyzed the business requirement document and created functional requirement document for mapping all the business requirements.
• Extracted data from various heterogeneous sources like Oracle, SQL Server, Sybase, MS Access and Flat files.
• Designed and Developed ETL mappings using T/R logic for extracting the data from various source systems.
• Extensively used different source definitions and Target definitions to extract data from flat files and relational tables.
• Extensively worked with various Lookup caches like Static cache, Dynamic cache and Persistent cache.
• Solid Expertise in using both connected and unconnected Lookup Transformations.
• Worked with Informatica Data Quality 8.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 8.6.1.
• Developed Reusable Transformations and Reusable Mapplets.
• Responsible for implementing Incremental Loading using Mapping Variables and Parameter Files.
• Implemented slowly changing dimensions methodology and developed mappings to keep track of historical data.
• Involved in Extraction, Transformation, and Loading (ETL) solutions using SQL Server Integration Services (SSIS).
• Integrated instructed data in B2B and integrated industry standards in consolidate the data transformation. Improved business partners in boarding.
• Worked on multiple input and output ports to improve the streamer in transformation B2B.
• Eliminated programmatic effort to handling various translations formats in data exchange.
• Improved partner network efficiency in integration hubs with data exchange.
• Extensively used SQL override function in Source qualifier Transformations.
• Used parallel processing capabilities, Session-partitioning and Target table partitioning techniques.
• Improved XML functionality in improving on B2B.
• Used various SSIS tasks such as Conditional Split, Derived Column on the data retrieved, performed Data Validation Checks during Staging, and then loaded the data.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Created effective Test Cases and did Unit and Integration Testing to ensure the successful execution of data loading process.
• Developed critical reports like drill down, Slice and Dice, master/detail for analysis of parts benefits and headcount.
• Experienced in the use of agile approaches, including Extreme Programming, Test-Driven Development and Scrum
• Tested the data and data integrity among various sources and targets.
• Worked with Session logs and Workflow logs for Error handling and troubleshooting in Development environment.
• Involved in writing the Korn shell programming.
• Developed UNIX Shell Scripts, AIX and PL/SQL procedures and LINUX VM functions as well as coding.
• Responsible for testing ETL jobs before test to production migration.
• Supported migration of ETL code from development to QA and then QA to production.

Environment: Informatica Power Center 9.5, IDQ,(Repository Manger, Designer, Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task developer, Worklet Designer), CDC, Oracle11g, SQL server, Access, DB2, Flat files Teradata, XML, SQL/PLSQL, T-SQL, ERWIN, LINUX,UNIX shell scripting, Sun Solaris, Windows XP, TOAD, SQL, Agile approach with unit tests and weekly releases and Scrum Gathering, Mercury Quality Center (for issue tracking)B2B DT and data exchange.

ETL/Informatica Developer

Responsibilities:

• Gathered business requirements from business users and prepared functional specifications for various interfaces and Data Migrations.
• Developed ETL jobs to load data into XML files from Oracle database.
• Developed various mapping to migrate the data from ADMIN/LIMS to Darwin.
• Developed various interfaces like Darwin to Smart lab bi-directional interface, ADMIN/LIMS to Smart Lab bi-directional interface, MDI interface etc.
• Used Integration Manager to load data from XML files into Darwin system.
• Extensively worked on developing and modification of ETL Mappings using various Transformations like Source Qqualifier, Expression, Lookup, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, and Router transformations in Informatica Designer
• Extensively worked on creating Workflows for various Interfaces and Data Migrations
• Developed UNIX shell scripts to execute interfaces and data migration mappings.
• Scheduled workflows using UNIX command tasks to automate the entire process of fetching the source file from a different path and ftp it onto the server.
• Involved in creation of target tables in Oracle and Informatica mappings and workflows and executing them through UNIX Shell Scripts.
• Worked with heterogeneous sources from various channels like Sybase, Oracle, Flat files.
• Developed FTP scripts to move files across different servers.
• Files, XML Files and Excel files to target Oracle Data Warehouse.
• Loading the OLTP data into the Warehouse OLAP and built the Re-usable
• Created various UNIX Shell Scripts for scheduling, data cleansing and loading process
• Used pm cmd command in the UNIX shell scripts.
• Involved in Testing of Interfaces and Data Migrations.

Environment: Informatica PowerCenter 9.1,Integration Manager,Oracle11g, SQL,PL/SQL,Unix Shell Scripts(Korn),Windows XP, TOAD 8.5,MQ series,ClearCase Explorer, Documentum.

Confidential, Santa Clara, CA

Informatica ETL Developer

Responsibilities:

• Business Requirements gathering and analysis provided by the client, preparation of functional specifications and design documents.
• Performed extensive data analysis along with subject matter experts and identified source data and implemented data cleansing strategy.
• Prepared technical specifications for the development of Informatica (ETL) mappings to load data into various target tables and defining ETL standards.
• Worked with various Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager.
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup Connected/Unconnected, and filter.
• Created Mapplets, reusable transformations and used them in different mappings.
• Created Workflows and used various tasks like Email, Timer, Scheduler, Control, Decision, and Session in the workflow manager.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Created, Tested and debugged the Stored Procedures, Functions, Packages, Cursors and triggers using PL/SQL developer.
• Used the feature EXPLAIN PLAN to find out the bottlenecks in a given Query, thus improving the performance of the job.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Migrated repository objects, services and scripts from development environment to production environment
• Actively involved in production support. Implemented fixes/solutions to issues/tickets raised by user community.

Environment: Informatica Power Center 9.0, SQL server, Oracle 10g, Teradata Utilities, Flat Files, Windows, UNIX, TOAD.

Informatica Developer

Responsibilities:

• DUNS Scoring performance Improvement
• Testing of the entire application in various stages of the project
• Release 1 Recovery Analytics for Personal and Commercial Auto
• Release 2 Recovery Analytics for Workers compensation
• Interaction with business users in discussing the approach and doing gap analysis for the varying functionality. Have walkthrough meetings with client in making sure that expectations are met.
• Extensively did testing for the application developed. It includes Unit Testing, Regression Testing, Integration Testing and User Testing.
• Used capture issues using Issue Tracker and did log error Quality Center Testing tool.
• Did involve in both Development and testing phases of the project following Agile methodologies
• Involved in Informatica Baseline Testing 9.0 version. Did Baseline Testing and as well as regression Testing.
• Analyzed the functional specs provided by the client and created technical specs documents for all the mappings.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
• Used windows Scripting and Scheduled pmcmd to interact with Informatica Server from command mode.
• Used Scheduling tool Zena and arranged jobs in parallel run to complete the sheet on time.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Project management activities such as status tracking and coordinating client calls.
• 24 X 7 production support for all the security master central applications and provide solutions to the production failure jobs
• Responsibility of project role outs and implementations within the specified SLAs.
• Get hold of security master central architecture and propose new solutions to improvise the existing system.

Environment: INFORMATICA 9.0, SQL, Statistical, Agile, Oracle 10g

Confidential, Houston, TX

Informatica/ETL Developer

Responsibilities:

• Analyzing, designing and developing ETL strategies and processes, writing ETL specifications, Informatica development, and administration and mentoring other team members.
• Developed mapping parameters and variables to support SQL override.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, and SQL, Lookup (File and Database) to develop robust mappings in the Informatica Designer.
• Worked and Implemented Pushdown Optimization (PDO) to optimize performance issues of complex mappings involving numerous transformations and hence degrading the performance of the session.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Exhaustive testing of developed components.
• Worked on the various enhancements activities, involved in process improvement.
• Used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer, Workflow Manager, Workflow Monitor.
• Worked on Change data Capture (CDC) using CHKSUM to handle any change in the data if there is no flag or date column present to represent the changed row.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.
• Created shell scripts to fine tune the ETL flow of the Informatica workflows.
• Migrated the code into QA (Testing) and supported QA team and UAT (User).
• Played a major role in coordinating Admin and DBA Team for data exports, imports and migration between different environments.
• Created various UNIX Scripts for Job automation of Data loads.
• Created Test cases for Unit testing, System Integration Test and UAT to check the data.

Environment: Informatica 8.5, Oracle 10G, UNIX, PL/SQL Developer, Advanced Query Tool, UNIX AIX 5.1.

Informatica Developer

Responsibilities:

• Extensively used Power Center to design multiple mappings with embedded business logic.
• Extensively worked with Informatica Transformations like Sequence generator, Expression, Lookup, Aggregate, Update Strategy, Joiner and Source qualifier transformations in Informatica Designer.
• Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.
• Developed PL/SQL scripts for the data cleaning and loading the data from source system to the staging area
• Created complex mappings and mapplets and Worked on different tasks like sessions, events raise, event wait, decision, e-mail, and command.

Environment: Informatica Power Center 8.1, PL/SQL, Oracle 9i/8i, DB2, HP-UX 10.20, Windows NT 4.0.