PROFESSIONAL SUMMARY:

• 7 years of IT experience with extensive knowledge in Data warehousing, Data Analysis, Reporting and ETL.
• Solid experience in Informatica Power Center (versions till 10.2) including Designer, Workflow Manager, Workflow Monitor, Repository Manager, Repository Server Admin console.
• Having experience in interacting with the client in requirement gathering.
• Having sound knowledge on OLTP, ODS and EDW data modeling (logical and physical design, and schema generation) using Erwin, ER/Studio and other tools for Teradata, Oracle, DB2/UDB and MS SQL Server models & repositories.
• Extensive experience in loading high volume data, requirements gathering, analysis, design, development, test and implementation.
• Strong Data Warehousing ETL experience of using Informatica 10.2/10.1/9.6/9.5/8.6.1/8.1/7.1 Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Strong Emphasis in reviewing End-to-End test requirements, assigning appropriate resources, and initiate the End-to-End planning process.
• Good understanding of the Software Development Life Cycle (SDLC).
• Excellent in interacting with developers at various levels and understanding technical specifications, documentation of the application to be tested.
• Good hands on experience in Informatica Data Quality IDQ technologies.
• Involved in development of Informatica mappings with required transformations like Aggregator, Filter, Lookup, Sorter, Normalizer, Update strategy etc.
• Strong Knowledge on Power center Designer, Workflow Manager and Workflow Monitor.
• Creating sessions and Workflows using Informatica Workflow Manager.
• Used complex transformations like Lookup, Update Strategy, Sequence Generator and Stored Procedure while Developing Mapplets and Mappings using Informatica Designer Tool.
• Involved in Performance Tuning at mapping level and session level.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server 2008/2005, DB2 8.0/7.0, UDB, MS Access and Teradata.
• Strong hands on experience using Teradata utilities (FastExport, MultiLoad, FastLoad, Tpump, TPT, BTEQ and QueryMan).
• Having good knowledge in Autosys, ALM/QC and Clear Quest.
• Extensive experience with managing, leading various complex data warehousing applications and installations, integrations, upgrades, maintenances of ETL, Datamart Siebel 7.0/2000/5.5, Siebel Warehouse 6.3, Siebel EIM, OLAP, OLTP, Autosys, Control M, Sybase, BI, data cleansing, data profiling tools.
• Hands on experience using query tools like TOAD, SQL Developer, PLSQL developer and Query man.
• Expertise in writing large/complex queries using SQL.
• Strong knowledge on Ab Initio GDE ( 3.0/1.15/1.14/1.13 ), Co>Op (3.0/2.15/2.14/2.13/2.12/2.11 ).
• Good Knowledge in Dimensional Data modeling, Star/Snowflake schema design, Fact and Dimensional tables, Physical and Logical data modeling.
• Experience with business intelligence reporting tools using Business Objects, Cognos and Hyperion.
• Experience in supporting large databases, troubleshooting the problems.
• Experience in all phases of SDLC like system analysis, application design, development, testing and implementation of data warehouse and non-data warehouse projects.
• Proficiency in prioritizing and multi-tasking to ensure that tasks are completed on time

TECHNICAL SKILLS:

ETL Tools: Informatica 10.2/10.1/9.6/9.5/8.6.1/8.1/7.1, OBIA,AbInitio(GDE 3.0/1.15/1.14/1.13 ), Co-op (3.0/2.15/2.14/2.13/2.12/2.11 ) SSIS

DB Tools: SQL*Plus, SQL Loader, TOAD, OBIEE, BTEQ, Fast Load, Multiload, FastExport, SQL Assistant, Teradata Administrator, PMON, Teradata Manager, Microstrategy. Cognos, Microstrategy, BO

Databases: Teradata 14/13/12/V2R6.2/V2R5, Oracle 10g, DB2, MS-SQL Server 2000/2005/2008, MS-Access, Oracle, Mainframe, Netezza

Scheduling Tools: Autosys

Version Control Tools: Clear Case

Programming Languages: Java, Visual Basic, SQL, PL/SQL and UNIX Shell Scripting.

Data Modelling /Methodologies: Logical/Physical/Dimensional, Star/Snowflake, ETL, OLAP, Complete Software Development Cycle. ERWIN 4.0

BI: Microstrategy, SAS, Cognos.

Operating Systems: Windows, UNIX, Sun Solaris 2.6/2.7/2.8/8.0, Linux

PROFESSIONAL EXPERIENCE

Confidential - Columbus, OH

Sr. ETL Informatica Developer

Responsibilities:

• Logical and Physical data modeling was done using Erwin for data warehouse database in STAR SCHEMA.
• Worked on Agile Methodology, participated in daily/weekly team meetings, guided two groups of seven developers in Informatica Power Center peer reviewed their development works and provided the technical solutions. Proposed ETL strategies based on requirements.
• Worked with health payer related data such as customers, policy, policy transactions, claims.
• Generated weekly and monthly report status for the number of incidents handled by the support team.
• Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations to implement complex ETL logics.
• Worked with Informatica Power center Designer, Workflow Manager, Workflow Monitor and Repository Manager
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Informatica Designer to create complex mappings from Business requirements.
• Created various transformations like filter, router, lookups, stored procedure, joiner, update strategy, expressions and aggregator to pipeline data to Data Warehouse/Data Marts and monitored the Daily and Weekly Loads.
• Project based on Agile SDLC methodology with 2 weeks of software product release to the business users.
• Analyze the business requirement and create ETL logic to extract data from flat files coming from Manufacturing at different geographic regions and load data in the data warehouse.
• Designed and developed various complex SCD Type1/Type2 mappings in different layers, migrated the codes from Dev to Test to Prod environment. Wrote down the techno-functional documentations along with different test cases to smooth transfer of project and to maintain SDLC.
• Experience in using Stored Procedures, TOAD, Explain Plan, Ref Cursors, Constraints, Triggers, Indexes-B-tree Index, Bitmap Index, Views, Inline Views, Materialized Views, Database Links, Export/Import Utilities.
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded into Oracle.
• Created/modified reference tables for valid data using Analyst tools.
• Developed Informatica Workflows and sessions for mappings using Workflow Manager.
• Deployed the Informatica code and worked on code merge between two different development teams.
• Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems.
• Created Pre-& Post-Sessions UNIX Scripts to merge the flat files and to create, delete temporary files, change the file name to reflect the file generated date etc.

Environment: Informatica Power center Designer 10.2/9.6, Informatica Repository Manager, Oracle10g/9i, DB2 6.1, Erwin, TOAD, Unix- SunOS, PL/SQL, SQL Developer, Teradata.

Confidential - Pittsburgh, PA

Sr. Informatica Developer

Responsibilities:

• Experience working with BA’s, DBA’s and Co Developers to understand the requirements and to pace up the process in meeting the milestone.
• Worked in different stages of project from development, enhancement and production maintenance.
• Worked on view to extract data and load into target based on Incremental strategy.
• Involved in Informatica admin activities like controlling user access using admin console
• Involved in server activates like installing Informatica 9.6.1 in new cloud server.
• Create trigger process to send alert for job completion to downstream process.
• Extensively used Informatica Power Centre tools and transformations such as Lookups, Aggregator, Joiner, Ranking, Update Strategy, XML, Mapplet, connected and unconnected stored procedures / functions / SQL overrides usage in Lookups / Source filter usage in Source qualifiers.
• Understanding & Working knowledge of CDC (Change Data Capture).
• Created flexible mappings/sessions using Parameters, Variables and heavily using parameter files.
• Worked with pre and post sessions and extracted data from Transaction System into Staging Area.
• Extensively Used Environment SQL commands in workflows prior to extracting the data in the ETL tool.
• Enhanced the existing mappings, workflows with new business requirements and report the project status to the management
• Created Sessions, Reusable Worklets and Batches in Workflow Manager and Scheduled the batches and sessions at specified frequency.
• Worked extensively with Mapping Parameters, Mapping Variables and Parameter files for Incremental Loading.
• Participated in Designing and documenting validation rules, Error handling and test strategy of ETL process.
• Modified existing ATT Wifi Universes as per ETL/Business requirements.
• Created multiple Webi Reports as per the client requirements.
• Developed Unix Shell scripts and used them in Informatica Pre- & Post- Session command tasks and Standalone Command tasks.
• Standardized parameter files to define session parameters such as database connection for sources targets, last updated dates for Incremental loads
• Involved in performance tuning with Informatica and database.
• Involved in Performance tuning by tracking the reader, writer, transformation threads in the session logs and used tracing level to verbose during development & only with very small data sets.
• Developed and maintained technical documentation for Informatica servers and repositories.
• Performed Unit and Integration testing and wrote test cases.
• Migrated Informatica folders, mappings, workflow, reusable objects from one environment to another and in the process of change control.
• Involved in Code Reviews & Unit Testing the ETL code developed.

Environment: Informatica Power Center 9.6.1/9.5, Informatica Admin console, Flat Files, Oracle 11g, SAP BI 4.1, Linux, Windows 7.

Confidential - Milwaukee, WI

ETL/Informatica Developer

Responsibilities:

• Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
• Involved in extracting the data from the Flat Files and Relational databases into staging area.
• Mappings, Sessions, Workflows from Development to Test and then to UAT environment.
• Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema.
• Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
• Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.
• Imported various heterogeneous files using Informatica Power Center 8.x Source Analyzer.
• Developed several reusable transformations and mapplets that were used in other mappings.
• Prepared Technical Design documents and Test cases.
• Involved in Unit Testing and Resolution of various Bottlenecks came across.
• Implemented various Performance Tuning techniques.
• Used Teradata as a source system.

Environment: Informatica Power Center 9.5, Informatica Power Exchange 9.5, DB2, Data Modeling, TOAD 9.2, Oracle,11g Unix, Mainframe, IMS DB, Oracle 11g,BTEQ, MS SQL Server7.0/2000,CDC.

Confidential

ETL Consultant/Informatica Developer

Responsibilities:

• Involved in Extraction, Transformation and Loading of data using Informatica.
• Involved in ETL coding using Informatica tool from various source systems according to the PPDM (Professional Petroleum Data Management) standards.
• Generated and Installed ABAP Program/SAP R/3 Code Using Informatica 9.1.
• Developed Power Center mappings using various transformations like Stored Procedure, Union, Lookup, Joiner, Expression, Router, Filter, and Update Strategy.
• Imported an XML file to Designer, performed multiple operations, used in the Mappings and exported into an XML file.
• Involved in implementing processes to capture data change (CDC) and also for Data profiling.
• Created reusable sessions and commands in the Workflow Manager.
• Created, Updated and maintain ETL technical documents.
• Created and Imported/Exported various Sources, Targets, and Transformations using Informatica Power Center, Repository Manager and Designer.
• Developed various Mappings with the collection of all Sources, Targets, and Transformations.
• Created Mapplets with the help of Mapplet Designer and used those Mapplets in the Mappings.
• Developed and scheduled various Pre and Post Sessions, Batches for all Mappings for data loading from Source TXT files, Tables to Target tables in oracle/Teradata environment.
• Worked on Teradata BTEQ & T-SQL Tools for querying and retrieving data.
• Worked with Mload, Fload & Fast export Scripts for loading and exporting data from Teradata database.
• Extensively involved in Performance tuning of ETL processes in Data Warehouse.
• Fined tuned ETL processes by considering mapping and session performance issues.
• Tuned performance of Informatica sessions for large data files by implementing pipeline partitioning and increasing block size, data cache size, sequence buffer length and target based commit interval and resolved bottlenecks.
• The tables had to be populated for use in daily load for the initial load 'inserts' and then updated using incremental aggregation and update strategy transformation.
• Created and managed the global and local repositories and permissions using Repository Manager.
• Created Mappings between Source and Target using Power Center Designer.
• Worked Extensively with Slowly Changing Dimensions i.e. Type1 & Type2.
• Used Dimensional Modeling Techniques to create Dimensions, Cubes and Fact tables.
• Involved in Logical and Physical Database Design, forward engineering & reverse engineering using Erwin tool.
• Imported an XML file to Designer, performed multiple operations, used in the Mappings and exported into an XML file.
• Optimized the mappings by changing the logic, reduced running time and encouraged the usage of reusable objects viz., and mapplets.
• Performed data cleansing activities like Data Enhancement, Parsing, Matching and Consolidation.
• Analyzed and Created Facts and Dimension Tables.
• Involved in Development & Testing Phase

Environment: Informatica Power Center 9.0.1, SQL Server 2008, Oracle 11g, Teradata, UNIX, TOAD, Windows 7

Confidential

ETL/Informatica Developer

Responsibilities:

• Development, Testing, Implementation & Training of users.
• Prepared ETL Specifications and design documents to help develop mappings.
• Performed requirements gathering and Gap analysis for the ETL load.
• Worked as a key player in Database Modeling, Design and Normalization.
• Created mappings for Historical and Incremental Loads.
• Used Version Control to check in and checkout versions of objects.
• Extensively used Visio to create ER diagrams and Data Flow diagram.
• Worked along the development team to ensure clear requirements were presented/ documented. Also ensured delivered components met business requirements.
• Played a key role in defining the file structure for the downstream system to consume the data.
• Tuned Source, Target, Mappings, Transformations and Sessions for better performance.
• Supporting daily loads and work with business users to handle rejected data.
• Prepared and maintained mapping specification documentation.
• Use Debugger to test the mapping and fixed the bugs.
• Imported data from different sources to Oracle tables using Oracle SQL*Loader
• Wrote Oracle PL/SQL, stored procedures and triggers to populate data.
• Create technical design documents and deployment documents for production migration.

Environment: Informatica Power Center, SQL, Windows 2008, UNIX, SQL Server 2000, Oracle 8i, Flat files, SQL *Plus, Business Objects 5.1.6