SUMMARY:

• Around 7 years of experience in ETL (Extract Transform Load), Data Integration and Data Warehousing using Informatica, Ab Initio, Teradata, Hadoop and Oracle technologies.
• Extensively worked on Analysis, Design, Development, Implementation, Modeling, Testing, and support for Data warehousing applications.
• Around 1 year of hands on experience in Hadoop tools like Hive, Sqoop and Hbase .
• Excellent understanding / knowledge of Hadoop architecture and various components such as HDFS, Job Tracker, Task Tracker, NameNode, Data Node, and MapReduce programming paradigm.
• 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 Admin Console, Repository Manager, Designer, Workflow Manager and Workflow Monitor).
• Experience in resolving on - going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Extensively worked with XML files as the Source and Target, used transformations like XML Generator and XML Parser to transform XML files, used Oracle XMLTYPE data type to store XML files.
• Worked on Slowly Changing Dimensions (SCD’s) and its implementation to keep track of historical data.
• Strong experience in Creating Database Objects such asTables, Views, Functions, Stored Procedures, Indexes, Triggers, Cursors in Teradata.
• Good working knowledge on Teradata components such as FLOAD, MLOAD, BTEQ and Fast Export.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL..
• Experience on Data Modeling Tools Erwin 4.0, Sybase Power designer.
• Experience in importing and exporting data using Sqoop from HDFS to Relational Database Systems and vice-versa.
• 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.x/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 QualityOperating 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 11g/10g/9i/8i RAC, SQL Server, DB2 z/OS, Teradata (V2R12, V2R6,V2R5)

Reporting Tools: Crystal Reports, Tableau

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

Scheduler: Control-M, AutoSys, Active Batch 7

PROFESSIONAL EXPERIENCE:

Confidential, Westchester, PA

Sr. ETL /Informatica Developer

Responsibilities:

• Analyzed the requirements to identify the necessary tables that need to be populated into the staging database
• Created mappings using transformations like Source Qualifier, Aggregator, Expression, lookup, Router, Filter, Update Strategy, Joiner, Union, and Stored procedure, and XML transformations.
• Worked on Informatica Power Center tools - Source Analyzer, Warehouse Designer, Mapping &Mapplet Designer, and Transformation Developer.
• Converted existing PL/SQL Packages to ETL Mappings using Informatica Power Center.
• Used Error handling strategy for trapping errors in a mapping and sending errors to an error table.
• Implementedparallelismin loads bypartitioningworkflows usingPipeline, Round-Robin, Hash, Key Range and Pass-through partitions.
• Worked on Exchange Management Console(EMC) or theExchange Management Shell(EMS) related topics.
• Extensively used Informatica Power Center to extract data from various sources, which included Flat files, Sqlserver, Oracle, Ms-Access and XML.
• Extensively involved in performance tuning, recommending SQL queries for better performance.
• Developed in SCRUM iterations using Agile Methodology, Iterative development and Sprint Burn down with Story Boards.
• Estimates and planning of development work using Agile Software Development.
• Used Change Data Capture (CDC) to simplify ETL in data warehouse applications
• Used debugger to debug mappings to gain troubleshooting information about data and error conditions.
• Used Mapping variables for Incremental Extraction of operational data.
• Wrote UNIX Shell scripts to automate workflows.
• Schedule and Run Extraction and Load process, monitor task and workflow using the Workflow Manager and Workflow monitor.
• Used Workflow Manager for creating workflows, work lets, email and command tasks.
• Used Informatica features to implement Type I, II changes in slowly changing dimension tables.
• Used FTP services to retrieve Flat Files from the external sources.
• Involved in Performance Tuning at various levels including Target, Source, Mapping, and Session for large data files.
• Extracted the data from Teradata into HDFS using the Sqoop and Exported the patterns analyzed back to Teradata using Sqoop .
• Worked on Migration Strategies between Development, Test and Production Repositories.
• Supported the Quality Assurance team in testing and validating the Informatica workflows.
• Did unit test and development testing at ETL level in my mappings.

Environment: Informatica Power Center 9.5.1( Power Center Repository Manager, Designer, Workflow Manager, and Workflow Monitor),,Teradata 14.10, Oracle 11g, PLSQL Developer, SQL, PLSQL, Sqoop, Hive, UNIX Shell Scripting, Autosys .

Confidential

Sr.ETL / Informatica 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.
• Closely working with IDQ 5.1.
• 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.
• Worked on the Teradata stored procedures and functions to confirm the data and have load it on the table.
• Migrated data from Sybase legacy system to oracle 11g.
• Worked on Teradata Multi-Load, Teradata Fast-Load utility to load data from Oracle and SQL Server to Teradata.
• UsedSQL Assistantto querying Teradata tables.
• Was involved in the performance tuning mappings, sessions, Source and Target.
• Was involved in unittestingby usingDebuggerand writing simple test scripts and eliminating thebottlenecksfor optimumperformance.
• Maintained Development, Test and Production Repositories using Repository Manager. Also used Repository Manager to maintain the metadata, Security, Backup and Locks.
• Extracted data from various heterogeneous sources like Oracle, SQL Server, Teradata, MS Access, and Flat files.
• UsedTeradata Data Moverto copy data and objects such as tables and statistics from one system to another.
• 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 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, Teradata12.0/8.5, Sybase, IDQ 9.5

Confidential, Riverwoods, IL

ETL /Informatica 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.
• Used Teradata utilities fastload, multiload, tpump to load data
• Wrote, tested and implemented TeradataFastload, Multiload and Bteq scripts, DML and DDL.
• Performed tuning and optimization of complex SQL queries using TeradataExplain
• Expert level knowledge of complex SQL usingTeradatafunctions, macros and stored procedures.
• Modified the existing BTEQ script to enhance performance by using Volatile tables, incorporating parallelism, collect stats when needed and using the index techniques
• Used BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching the business requirements and TeradataRDBMS.
• 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, Teradata, SQL Server 2005,SSIS 2005, UDBDB28.1, XML,Autosys, TOAD 6.0, SQL, PL/SQL, UNIX

Confidential

 Informatica Developer

Responsibilities:

• Responsible for developing ComplexInformaticamappings 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.
• Responsible for DefiningMapping parametersandvariablesandSession parametersaccording to the requirements and performance related issues.
• Responsible for creating Workflows and sessions usingInformaticaworkflow manager and monitor the workflow run and statistic properties onInformatica Workflow Monitor.
• Responsible forUnitandRegressiontesting of theInformaticaMappings created according to the business requirements.
• Performance tuning of Informatica code for better performance has been done.
• UsedVersion controlprovided 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