SUMMARY

• Over 8 years of experience in the IT industry with a strong background in software development and 6+ years of experience in Development, Architecture and Testing Business Intelligence solutions in data warehouse and decision support systems using ETL tool Informatica PowerCenter 8.6/8.0/7.3.1/7.1/6. x and Power Exchange(PWX) and also some knowledge on DT Studio.
• Knowledge of IDQ and IDE.
• Certified in Informatica PowerCenter Mapping designer 8.x.
• Excellent understanding on full software development life cycle (SLDC) of ETL process including requirement analysis, design, development, support of testing and migration to production.
• Experience in Data migration and integration with various domains like HealthCare, Finance, Retails Insurance and Manufacturing.
• Extensively worked with large Databases in Development, Testing and Production environments.
• Experience with advanced ETL techniques including staging, reusability, data validation, change data Capture (CDC), Real time.
• Experience in working with Extraction/Transformation/ Loading using Informatica Power Center and Power Exchange with Oracle, Sql Server, Teradata, DB2/UDB, XML, Flat files, SAP and Cobol on UNIX, Linux, Windows NT/2000/9x.
• Strong in Data warehousing methodologies of Star /Snow Flake schemas of Ralph Kimball, Bill Inman.
• Experience in developing Informatica Mappings, Sessions, Worklets and Tasks.
• Experience in working with Deploying groups.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and XML Source Qualifier.
• Expertise in implementing complex business rules using different transformation, mapplets and worklets.
• Experience with code migration from between repositories and folders.
• Hands on experience in identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Expertise in developing SQL and PL/SQL Scripts through various procedures, functions, and packages to implement the business logic.
• Well versed with different SQL Development Tools like TOAD & PL/SQL Developer.
• Good experience in shell scripts for Informatica pre & post session operations.
• Experience in logical/physical data models and Forward/Reverse Engineering using ERwin.
• Experience in team management and a good team player.
• Good experience in ETL technical documentation.

TECHNICAL SKILLS:

ETL: Informatica PowerCenter 8.6/8.1/7.3/7. x/6.x, Power Exchange(PWX) 8.x, Informatica Data Quality and Data Explorer, DataStage, DT Studio.

RDBMS: Oracle 11g/10g/9i/8.0/7.x, SQL Server 2008/05/00, DB2/ UDB, SAP, XML, Teradata v12/v13, Sybase.

Methodologies: Star schema and Snowflake schema

Languages: SQL, PL/SQL,T - SQLMY SQL, C,C++, COBOL, JAVA SDK, VB script, XML, HTML, DHTML, UNIX Shell Scripting, PERL scripting.

Operating system: Windows NT, Windows 98/95/2000, UNIX, Linux, Korn Shell, Perl, HP-UX, IBM-AIX.

BI tools: Cognos 8.x, Business Objects XI, Micro Strategy.

Protocols: TCP/IP,FTP,SFTP,SCP

PROFESSIONAL EXPERIENCE:

Confidential, MI

ETL/Informatica Developer

Responsibilities:

• Worked with Business analysts and the DBA for requirements gathering, business analysis and designing and participated document review meetings.
• Worked on Informatica Power Center tools - Source Analyzer, Target designer, Mapping Designer, Workflow Manager, Mapplet Designer and Transformation Developer.
• Designed and created mappings, sessions and workflows and schedule the workflow as per the Functional & Technical specifications.
• Extracted the data from Oracle11g/10g, XML, Flat files load the data in to Oracle data warehouse.
• Designed mappings using Connected/Unconnected Lookups, Filter, Expression, Aggregator and Router transformations for populating target tables.
• Coordinated with Informatica Admin to setup the environment and to move objects to different repositories and folders.
• Worked with different kinds of Code migration including XML import/export, folder migration, deployment groups and Manual migration.
• Created and Executed workflows and Worklets using Workflow Manager to load the data into the Target Database.
• Extracted and loaded data from XML documents by using XML Parser and Generator transformations.
• Worked Repository Manager to manage & assigned permissions to Folders.
• Defined Target Load Order Plan for loading data into different Target Tables.
• Implemented Slowly Changing Dimensions methodology to keep track of historical data.
• Analyzed Session log files to resolve errors in mapping and managed session configuration.
• Created, configured, scheduled and monitored the sessions and workflows on the basis of run on demand, run on time using Informatica Power Center Workflow Manager.
• Involved in Performance Tuning at various levels including Target, Source, Mapping and Session for large data files.
• Worked extensively in PL/SQL procedures to load the data.
• Involved in Unit and System testing of developed mappings.
• Scheduling Informatica jobs using ESP.
• Scheduled jobs using UNIX scripting and Informatica scheduler. Determine production schedule of data extraction processes. Production support transition.
• Maintained naming standards and warehouse standards for future application development, and also created functional and technical specification documents.

Environment: Informatica PowerCenter 8.6, PowerExchange(PWX), Oracle 11g/10g, DB2, Teradata v12, SQL, PL/SQL, Flat files, XML,Toad, PL/SQL Developer tool, ESP, NT Server, UNIX, Shell scripts, FTP.

Confidential, St. Louis, MO

Sr Informatica Developer/Analyst

Responsibilities:

• Understand the customer Requirements and Technical specification documents.
• Participating in the review of the detail Architecture and design for the project.
• Worked on ETL design, development, administration, source to target mappings, data warehouse transformations, on call support, troubleshooting, testing, and documentation.
• Used Informatica PowerCenter/PowerExchange to extract/transform and load data from different operational data sources like Oracle, Sql Server, XML, Flat files in to staging area (Oracle) and load in to Oracle data warehouse.
• Developed the various mappings using various transformations like source qualifier, joiner, filter, router, expression transformations etc.
• Involved in the design of incremental load.
• Developed standard and re-usable transformations and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and Router.
• Wrote SQL-Overrides and used filter conditions in source qualifier thereby improved the performance of the mapping Involved in performance tuning on Informatica in all levels.
• Developed huge workflows with worklets, event waits, assignments, conditional flows, email and command tasks.
• Applied slowly changing dimensions (SCD) in various complex Mappings to load data from source to target.
• Involved in Production Support by performing Normal Loads, Bulk Loads, Initial Loads, Incremental Loads, Daily loads and Monthly loads.
• Validate the required data at the database level by using tool Toad.
• Files data move to another server by using FTP on UNIX platform.
• Used Toad for DDL’s and to validate the data.
• Resolving technical issues across projects.

Environment: Informatica PowerCenter 8.6/8.1(Repository Manager, Designer, Workflow Manager and Monitor) powerExchange, Oracle 10g, Sql Server, Control M, PL/SQL, XML, Flat files, Unix, Shell Scripts, Toad, Windows NT

Confidential, Dallas, TX

ETL Designer/Developer

Responsibilities:

• Interacted with business representatives for requirement analysis and to define business and functional specifications.
• Delivered responsibilities as Analyst and Programmer including interaction with Business Users to Gathering requirements, Created Technical Specifications, Design, Development and Maintenance.
• Analyzed source data, extracted, transformed, and loaded data in to target data warehouse based on the requirement specification using Informatica PowerCenter.
• Developed data Mappings between source and target systems using Mapping Designer.
• Involved in complete SDLC including analysis, design, development, implementation, QA and maintenance of various software applications.
• Worked with various heterogeneous sources such as Oracle10g, Teradata and Flat Files to load the data into the target Oracle data warehouse.
• Developed complex Informatica mappings using Filter, Sorter, Aggregator, Look up, stored procedure, Joiner, Router transformations for populating target table.
• Written Scripts for Teradata Utilities(FASTExport, MLoad and FastLoad)
• Written PL/SQL stored procedures in Oracle and used in mapping to extract the data.
• Solved common name and address data problems by Informatica Data Quality’s (IDQ) address cleansing and identity matching rules, which reduce project risk and make the quick.
• Used debugger to test the mapping and fixed the bugs and identified the bottlenecks in all levels to tune the performance.
• Extensively used the Informatica Debugger for debugging the Mappings to check the Business rules implemented correctly or not.
• Resolved the production support tickets using solution manager.
• Maintained Functional and Technical specifications documents
• Worked with Workflow Manager Tasks such as Email, Command, Event raise, Event wait, Decision, Assignment.
• Supported post-production maintenance.

Environment: Informatica PowerCenter 8.0 and PowerExchange/PowerConnect, Oracle 10g, SQL, PL/SQL, Teradata, Flat files, TOAD 7.3, Erwin, UNIX, Shell scripts, Windows NT.

Confidential, Phoenix, AZ

ETL /Informatica Developer/Analyst

Responsibilities:

• Participated in Requirement Gathering, Business Analysis, User meetings, discussing the issues to be resolved and translating user inputs into ETL design documents.
• Designed and developed Informatica mappings based on requirements.
• Worked in development, testing and production environments.
• Analysis, Design and Development, testing and implementation of Informatica transformations and workflows for extracting the data from the multiple sources.
• Extensively used Informatica client tools-Designer, workflow manager and workflow monitor.
• Extracted the data from Oracle10g, DB2, COBOL, Flat files load the data in to Oracle database.
• Worked extensively on different types of transformations like Source Qualifier, Expression, Java Transformation, Aggregator, Router, filter, Update strategy, look up, Normalizer, stored procedure.
• Redesigned the broken ETL process.
• Written and modify SQL override in many mappings according to business requirements
• Written pre and post SQL commands to add or recreate indexes to increase the loading performance.
• Used mappings parameters and variables.
• Identified the performance bottlenecks and tuned complex Informatica mappings for better performance.
• Checked session and error logs to troubleshoot problems, and also used debugger for complex problem trouble shooting.
• Establish of automatic email notifications to the concerned persons.
• Scheduled workflows for daily, weekly and monthly loads.
• Worked on FTP connections to move the file to remote servers.
• Create the batch files to invoke the workflow from the desired desktop.
• Used Toad for DDL’s and to validate the data.

Environment: Informatica PowerCenter 8.1/7.3 and PowerExchange, Oracle 10g/9i,DB2,SQL,PL/SQL, Flat files, COBOL, UNIX, Control M, Unix, Business Objects, Windows NT

Confidential, San Jose, CA

7 ETL Developer (Informatica)

Responsibilities:

• Interacted with Business Analyst and DBA to gather the Requirements and Business logics.
• Worked with heterogeneous sources from various channels like Oracle, flat files, DB2.
• Extensively worked on Informatica Power Center Designer (Source Analyzer, Warehouse designer, Transformation Developer, Mapping Designer and Mapplet Designer).
• Worked with loading data from ODS source into Staging tables and staging tables to delimited flat files for Kinaxis purpose.
• Wrote SQL-Overrides and used filter conditions in source qualifier thereby improved the performance of the mapping.
• Extensively used Transformations like Aggregator, Union, Router, Joiner, Expression, Lookup, Update Strategy and Sequence Generator.
• Worked with Stored Procedures, Functions, Packages and Triggers.
• Worked with mapping debugger and Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.
• Worked with FTP, SFTP, SCP connections to store the files in remote server.
• Written UNIX shell scripts along with $Universe for scheduling the sessions and workflows.
• Installed and configuration of Informatica Power center with Windows NT/UNIX operating systems.
• Created and maintained ETL technical documentation.

Environment: Informatica PowerCenter(Repository Manager, Designer, Workflow Manager and Monitor) 7.3/7.1, Oracle 9i, SQL, PL/SQL, DB2, Flat files, ERwin 4.x, TOAD 7.3,Unix, Shell scripts, Windows NT

Confidential, Dallas, TX

Informatica Developer

Responsibilities:

• Involved in the design, development and implementations of the Enterprise Data Warehouse (EDW) process and Data mart.
• Performed data manipulations using various Informatica Transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy and Sequence Generator etc.
• Worked Efficiently with Designer tools including Source Analyzer, Warehouse designer, Mapping.
• Extensively used SQL coding for overriding the generated SQL in staging and also tested the data loaded into the database.
• Created reusable transformations and mapplets to use in multiple mappings.
• Maintaining existing data flow mappings and fixing any defects associated with them as reported by the QC team.
• Experience in Debugging and Performance Tuning of targets, sources, mappings and sessions.
• Handled large volumes of data warehouse database.
• Unix Scripts were written at various situations like event automation and job scheduling.
• Generated various reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @Functions, Cross Tab, Master/Detail and Formulas as per client requirements.

Environment: Informatica Power Center 6.0, Oracle 9i/8.0, SQL*PLUS, UNIX, Business Objects, Windows NT, Windows 2000, Toad.

Confidential

ETL/Informatica Developer

Responsibilities:

• Involved in creating logical and physical data modeling with STAR and SNOWFLAKE schema techniques using ERwin in Data warehouse as well as in Data Mart.
• Extracted data from different sources like Oracle, Teradata, and Flat files implemented business logic and loaded in to the target Warehouse (Oracle).
• Executed Informatics Transformations like Expression, Aggregate, Filter, Update Strategy, and Sequence Generator.
• Involved in analysis, design and development of all interfaces using Informatica Power Center.
• Developed complex mappings using Informatica Power Center Designer to transform and load the data from various source systems like Oracle, Teradata in to the Oracle target database.
• Used complex data transformations with around 22 transformations for each mapping.
• Involved in writing shell scripts on UNIX for Informatica tool to run the Sessions.

Environment: Power Center 6.0/5.x, Oracle 8i, SQL, PL/SQL, Flat files, UNIX, Windows NT.