SUMMARY

• 7+ years of IT experience including 6+ years of expertise in Analysis, Design, Development, Implementation, Modeling, Testing, and support for Data warehousing applications.
• Extensive experience in using Informatica tool for implementation of ETL methodology in Data Extraction, Transformation and Loading.
• Extensively worked on Dimensional modeling, Data migration, Data cleansing and Data Staging of operational sources using ETL processes and providing data mining features for data warehouses.
• Involved in Full Life Cycle Development of building a Data Warehouse.
• Extensive experience with Healthcare, Financial Investment and Retail.
• Have clear understanding of Data warehousing and Business Intelligence concepts with emphasis on ETL and life cycle development Using Informatica PowerCenter (Repository Manager, Designer, Workflow Manager and Workflow Monitor).
• Worked on Slowly Changing Dimensions (SCD’s) and its implementation to keep track of historical data.
• Actively involved in Performance Tuning, Error handling Product support on various Platforms.
• Experience in coding using SQL, SQL * plus, PL/SQL procedures/functions, triggers and exceptions. Good experience in Relational Database concepts, Entity relation diagrams.
• Have work experience with Relational data model Erwin 4.0.
• Performed system Analysis and QA testing and involved in Production Support.
• Expertise in OLTP/OLAP System Study, Analysis and E - R modeling, developing database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional data modeling.
• Experience in UNIX working environment, writing UNIX shell scripts for Informatica pre & post session operations.
• Experience creating reports using WEBI (SAP Business Objects 4.0 Suite) and Report Studio (IBM Cognos)
• Experience in implementing update strategies, incremental loads and change Data capture.
• Knowledge of complete software development life cycle including Requirement Analysis, Requirement Gathering, Cost Estimation, Project Management, Design, Development, Implementation and Testing.
• Excellent communication and interpersonal skills. Ability to work effectively as a team member as well as an individual.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.5.0/9.1/8. x/7.x/6.x/5.x (Source Analyzer, Repository Manager, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Workflow Monitor, Warehouse Designer and Informatica Server), Data Quality, SSIS

Operating Systems: Microsoft Windows 7/Vista/XP/2000/NT, UNIX

Language: SQL, PL/SQL, XML, UNIX Shell Scripting

Business Intelligence: SAP Business Objects, OBIEE, IBM Cognos

Database: Oracle 10g/9i/8i RAC, SQL Server, DB2 z/OS, Teradata V2R5

Reporting Tools: Crystal Reports, Tableau

Tools: /Utilities: PLSQL Developer, TOAD, SQL Developer, Erwin, Microsoft Visio, Talend 5.3.1

Scheduler: Control-M, AutoSys, Active Batch 7

PROFESSIONAL EXPERIENCE

Confidential, Albany, NY

Sr. Informatica ETL Developer

Responsibilities:

• Analyzed functional specifications and the business requirements of the project.
• Used Informatica 9.5 PowerCenter Designer and used transformations like Source Qualifier, Expression, Filter, Router, Joiner, Sequence developer, Update Strategy, Lookup, Sorter, Aggregator, Normalizer, XML Source Qualifier, Stored Procedure etc. for extraction, transformation and loading of data.
• Used Talend 5.3.1 extensively for profiling the data and accessing the data quality of the source data.
• Created new Pre-stage tables and staging tables for the data loads.
• Developed complex mappings in Informatica to load the data from various sources.
• Created Stored procedures to use oracle generated sequence numbers in Mappings instead to using Informatica Sequence generator.
• Created RollBack Stored Procedure to roll back data loaded.
• Created complex Mappings and implemented Slowly Changing Dimensions (Type 1, Type 2 and Type 3) for data loads.
• Created complex Mappings to implement data cleansing on the source data.
• Created Mappings to implement one time as well as Incremental loads.
• Created Mappings to load 150 million historical Transactions.
• Extensively used Informatica debugger to eliminating thebottlenecksfor optimumperformance. Also involved in troubleshooting existing ETL bugs.
• Used Mapping Variables, Mapping Parameters and Session Parameters to increase the re-usability of the Mappings.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Used Informatica Update Else Insert session property and Update Override extensively to improve the performance of the data loads.
• Developed Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Created various batch Scripts for scheduling various data cleansing scripts and loading process.
• Created Technical Documentation for all the developed mappings for presentation with Business.
• Extensively usedErwinforLogical and Physical data modelingand designedStar Schemas.
• Created deployment groups, migrated the code into different environments.
• Worked closely with reporting team to generate various reports

Environment: Informatica 9.5 (Power Center Repository Manager, Designer, Workflow Manager, and Workflow Monitor), SAP Business Objects 4.0, Oracle 11g, SQL Developer 3.2.1, Toad, PLSQL, SQL, Active Batch 7, Talend 5.3.1, ERWIN

Confidential, Boston, MA

Sr. Informatica ETL Developer

Responsibilities:

• Was the only developer in the Migration project and was responsible for all the roles of the project like building the tables in the new database, requirement gathering form the customer, designing the technical specs and technical documentation, development of Mappings and Workflows as per the business requirement and testing.
• Wrote DDL’s for the tables that have to be created in the new database, also built the back-out script for the DBA.
• Developed complex SQL for extracting and querying the data from the Oracle tables.
• Expertise in SQL.
• Built the Mappings with Informatica 9.5.0 PowerCenter Designer using transformations like Source Qualifier, Expression, Filter, Router, Joiner, Sequence developer, Update Strategy, Lookup, Sorter, Aggregator, Normalizer, XML Source Qualifier, Stored Procedure.
• Extensively worked with Slowly Changing Dimensions Type1, Type2, and Type3 for Data Loads and Data Transformations.
• This involved cleansing, consolidating and re-structuring of the data as part of the data conversion and ongoing data integration processes.
• Built Scripts using Unix Shell Scripting and used the scripts in the Pre-Session Command of the session to populate the parameter file.
• Built Scripts which will send a Post-Session fail email with the error data to the on-call team in HTML formatted report.
• Migrated data from Sybase legacy system to oracle 11g.
• Built Shell Script which will FTP the data onto the server in .dat format, merge the file form different organizations and make it into a delimited source file.
• Was involved in the performance tuning mappings, sessions, Source and Target.
• Was involved in unittestingby usingDebuggerand writing simple test scripts and eliminating thebottlenecksfor optimumperformance.
• Used PLSQL Developer for running SQL queries.
• Extracted data from various heterogeneous sources like Oracle, SQL Server, Teradata, MS Access, and Flat files.
• Extensively worked with Look up Caches like Shared Cache, Persistent Cache, Static Cache, and Dynamic Cache to improve the performance of the lookup transformations.
• Extensive expertise in using both connected and unconnected Lookup Transformations.
• Performed extraction, transformation and loading of data from RDBMS tables and Flat File sources into Oracle 10g in accordance with requirements and specifications
• Responsible for creating Workflows and sessions usingInformaticaworkflow manager and monitor the workflow run and statistic properties onInformatica Workflow Monitor.
• Involved inPerformance tuningfor sources, targets, mappings and sessions.
• Involved in scheduling the Informatica workflows usingAutosys.

Environment: Informatica PowerCenter 9.1/8.6(Power Center Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Oracle 11g, PLSQL Developer, SQL, PLSQL, UNIX Shell Scripting, Autosys, Sybase.

Confidential, Torrance CA

Informatica ETL Developer

Responsibilities:

• Created complex mappings in PowerCenter Designer usingAggregate, Expression, Filter, Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML, Source Qualifier and Stored procedure transformations.
• Developedmappings/mappletsby using Mapping designer, Transformation developer and Mapplet designer in InformaticaPowerCenter
• HandleSlowly Changing Dimensions (SCD)(Type I, Type II and Type III) based on the business requirements.
• Designed and developed Informatica mappings for data sharing between interfaces utilizing SCD type 2 and CDC methodologies.
• Worked withInformaticaData 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.
• Utilized of Informatica IDQ to complete initial data profiling and matching/removing duplicate data.
• Worked with analysts, using work sessions, to translating business requirements into technical user specifications, including data, process and interface specifications.
• Involved in documenting the modifications and intended functionalities of the interface.
• ETL interface builds in Informatica power center custom source qualifiers SQL to load data into data warehouse
• Used InformaticaPowerCenter forextraction, loading and transformation(ETL) of data in the data warehouse.
• Used InformaticaPowerCenter and its all features extensively in migrating data from OLTP to Enterprise Data warehouse.
• Worked closely with client in understanding the Business requirements, data analysis and deliver the client expectation.
• UsedInformatica Power Center Workflow managerto create sessions, batches to run with the logic embedded in the mappings.
• Extracted data from different sources likeOracle,flat files,XML,DB2andSQL Serverloaded into Data Ware House (DWH).
• Proficient in ETL (Extract - Transform - Load) using SQL Server Integration Services 2005 (SSIS) and Informatica PowerCenter tool.
• Involved in creation ofFolders,Users, RepositoriesandDeployment Groupsusing Repository Manager.
• DevelopedPL/SQLandUNIX Shell Scriptsfor scheduling the sessions in Informatica.
• WrotePL/SQLstored procedures & triggers, cursors for implementing business rules and transformations.
• PerformedUnittestingon the Informatica code by running it in theDebuggerand writing simple test scripts in the database thereby tuning it by identifying and eliminating thebottlenecksfor optimumperformance.
• Worked extensively with different caches suchas Index cache, Data cache and Lookup cache (Static, Dynamic, Persistence and Shared).
• Migrated mappings, sessions, and workflows from development to testing and then to Production environments.

Environment: Informatica PowerCenter 9.1/8.6.1 (Power Center Repository Manager, Designer, Workflow Manager, and Workflow Monitor), IDQ 8.6.1, Oracle 11g, SQL Server 2005,SSIS 2005, UDBDB28.1, XML,Autosys, TOAD 6.0, SQL, PL/SQL, UNIX

Confidential, Harrisburg, PA

Informatica ETL Developer

Responsibilities:

• Worked on Informatica - Source Analyzer, Data warehousing designer, Mapping Designer & Mapplet and Transformations.
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translates business rules and functionality requirements into ETL procedures using Informatica Power Center.
• Implemented logical and physical data modeling with STAR schema techniques in Data Mart.
• Performance tuning of Informatica sessions for large data files has been done by increasing block size, data cache size and, sequence buffer length.
• Extensively used various transformations Lookup, Update Strategy, Expression, Aggregator, Filter, Stored Procedures and Joiner etc.
• Used Informatica Power Center Workflow manager for session management, database connection management and scheduling of jobs to be run in the batch process.
• Responsible for the definition, development and testing of the processes/programs necessary to extract data from the client's operational databases, Transform and cleanse the data, and Load it into the data marts.
• Performed Unit Testing and tuned the Informatica mappings for better performance.
• Developed data conversion/quality/cleansing rules and executed data cleansing activities such as data
• Implementation of SCD type1/type2/type3 in existing ETL interfaces for capturing slowly changing dimensions.
• Performed planning and execution of large data conversion.
• Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
• Developed UNIX Shell scripts to automate repetitive database processes and maintained shell scripts for data conversion.
• Customization of the Oracle Out of The Box ETL interfaces using Informatica for Extracting various data from OLTP systems.
• Implemented Change data capture and incremental logics in inventory ETL Interfaces by identifying the audit columns for the data.
• ETL mapping Documents for every mapping and Data Migration document have been developed for smooth transfer of project from development to testing environment and then to production environment.
• Worked in debugging using Session Log messages, Server Messages.
• Performed extraction, transformation and loading of data from RDBMS tables and Flat File sources into Oracle 9i in accordance with requirements and specifications.
• Used TOAD to run SQL queries.
• Extensively used SQL*Loader to load data from flat files to database tables in Oracle.
• Responsible for the analyzing and comparing complex data from multiple sources (Oracle, flat files).
• Responsible for writing Unix Shell Scripts to schedule the jobs.
• Actively interacted with business analysts
• Worked with Business analysts and the DBA for gathering requirements and for project coordination.

Environment: Informatica Power Center 8.1.1(Power Center Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Power Exchange, Erwin, Oracle 10g, Windows NT, Flat files, Sybase, SQL, PL/SQL, SQL*Loader, Cognos 7, Autosys, UNIX, UNIX Shell Scripts

Confidential

ETL Informatica Developer

Responsibilities:

• Responsible for developing Complex Informatica mappings using different types of transformations like UNION transformation, Connected and Unconnected LOOKUP transformations, Router, Filter, Aggregator, Expression and Update strategy transformations forLarge volumes of Data.
• UsedVersion control provided byInformaticaon each and every object used. In this way, each and every version of the process will be available for recovery or research purposes.
• As an Informatica consultant streamlined and tuned accounting related ETL to be more efficient using Teradata.
• Migrated data from existing Teradata and other legacy systems.
• Using of SQL tools likeTOADto runSQL queriesto validate the data.
• Assisted in Designing database solutions to meet both business and technical requirements.
• DevelopedUnix Scriptsfor updating the control table.
• Responsible for providing first level operational support for development and production database systems.

Environment: Informatica PowerCenter 8.1.1, Informatica Power Exchange, Business Process Modelling (BPM), SAP R/3 7.1, Oracle 9i,Mainframe,DB2, Flat files, TOAD, Visio,PL/SQL,SQL,UNIX (AIX), Unix Shell Scripting,Windows XP

Confidential

ETL Developer

Responsibilities:

• Developed Informatica mappings, Reusable transformations. Developed and wrote procedures for getting the data from the Source systems to the Staging and to Data Warehouse system.
• Extensively used transformations to implement the business logic such as Sequence Generator, Normalizer, Expression, Filter, Router, Rank, Aggregator, Look Up (Target as well as Source), Update Strategy, Source Qualifier and Joiner, Designed complex mappings involving target load order and constraint based loading
• Create/build and run/schedule Workflows and Worklets using the Workflow Manager.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes. Coded Database triggers, functions and Stored procedures and written many SQL Queries. Helped coding shell scripts for various administration activities for daily backup. Involved in Physical schema implementation, objects like table-space, table rollback segments, Created database structures, objects and their modification as and when needed.
• Performance Tuning of the Informatica Mappings by adopting Explain plans, cutting down query costs using Oracle hints, changing the mapping designs.
• Responsible to tune ETL procedures and STAR schemas to optimize load and query Performance.
• Optimizing/Tuning mappings for better performance and efficiency, Creating and Running Batches and Sessions using the Workflow Manager, Extensively used UNIX Shell scripts for conditional execution of the workflows. Optimized the performance of Mappings, Workflows and Sessions by identifying and eliminating bottlenecks
• Performed Unit Testing at development level, Source code migration and documentation
• Managed users & roles for Database security, Maintained system security, Control and Monitor user access to database.
• Involved in full life cycle development including Design, ETL strategy, troubleshooting Reporting, and Identifying facts and dimensions.
• Managed the Metadata associated with the ETL processes used to populate the data warehouse.
• Assigned predefined profiles and roles to the users to maintain database security, CPU activity, idle time and quota management on table-spaces.

Environment: Informatica Power Center 6.1, Oracle 8i, PL/SQL, UNIX (AXI), Erwin and Toad