SUMMARY

• 6 years of extensive experience withInformaticaPower Center in all phases of Analysis, Design, Development, Implementation and support of Data Warehousing applications using Informatica Power Center 9.x/8.x/7.x,IDQ,Informatica ETL Developer etc.,
• Databases: 6 years of experience usingOracle, DB2, MS SQL Server,Teradata,TeradataSQL Assistant, MYSQL.
• SDLC:Have good experience in a Full life cycle ofSoftware Development (SDLC) including Business Requirements Gathering & Analysis, System Study, Application Design, Development, Testing, Implementation, System Maintenance and Documentation.
• Experience in working withORACLE 11g/10g,PL/SQLand tuning.
• Worked and have good knowledge inAgileandWaterfallmode of Software Development methodology.
• Experienced in writing SQL, PL/SQL programming, Stored Procedures, Package, Functions, Triggers, Views, Materialized Views.
• Have worked in Financial and Investments areas and so have good ability to handle huge and confidential data.
• Experience writing daily batch jobs usingUNIXshell scripts, and developing complex UNIX Shell Scripts for automation ofETL.
• Experience with Teradata 15/14/13 utilities like Fast Load and Multi Load and Tpump and Teradata Parallel transporter and highly experienced in Teradata SQL Programming. Expert in performance tuning and dealing with huge volume of data.
• Proficient in implementing complex business rules through different kinds ofInformatica transformations,Workflows/WorkletsandMappings/Mapplets.
• Strong knowledge inRDBMSconcepts,Data Modeling(FactsandDimensions,Star/Snow Flake Schemas),Data Migration,Data CleansingandETLProcesses.
• Hands on experience in tuning mappings, identifying and resolvingperformance bottlenecksin various levels likesources,targets,mappings, andsessions.
• Working inAgilespace gave an advantage learning different kinds of Test strategies likeFunctional, RegressionandIntegration testing.
• Have experience workingOnsiteandOffshorewhich gained excellent communication and instant problem - solvingskills.
• Advanced Knowledge ofOracle PL/SQLprogramming, stored procedures & functions, indexes, views, materialized views, triggers, cursors and tuningthe SQL query.
• Extensively worked on transformations such asSource Qualifier,Joiner,Filter,Router,Expression, Lookup,Aggregator,Sorter,Normalizer,Update Strategy,Sequence GeneratorandStored Procedure transformations.
• Hands on experience identifying and resolving performance bottlenecks in various levels like sources, usingExtract Transform and Load (ETL)and strong understanding ofOLTP, OLAPconcepts.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading intodata warehouse.
• Hands on experience in resolving theproduction issues in 24/7environment.
• Excellent problem solving, analytical, technical, interpersonal and communication skills with strong leadership abilities, motivated and adaptive with the ability to grasp things quickly. Extremely diligent strong team player with an ability to take new roles.

TECHNICAL SKILLS

ETL Tools: InformaticaPower Center 10.1/9.6/9.5/8.6/8.1/7.1, Metadata Manager,IDQ,SSIS,DataStage.

Reporting Tools: Business Objects XIR2/6.1/5.0,Qlikview,OBIEE, Oracle Analytics, etc.

Databases: Oracle 12C/11g/10g, MS SQL Server 2008/2005/2000, MS Access, IBM, DB2,Teradata15.0/14.0,Netezaa.

DataModeling: Data Modeling, Dimensional Data Modeling, Star Schema Modeling, Snow Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.

DB Tools: TOAD, SQLDeveloper,SQL Assistant, Visio, ERWIN, Tivoli Job Scheduler, Control-M, Tidal.

Languages: C, C++, Java, SQL, PL/SQL, Unix Shell Scripting

Operating Systems: UNIX, Windows 7/Vista/Server 2003/XP/2000/9x/NT/DOS

PROFESSIONAL EXPERIENCE

Confidential, Detroit, MI

Informatica IDQ/ETL Developer

Responsibilities:

• Worked inAgile development methodologyenvironmentandInteracted with the users, Business Analysts for collecting, understanding the business requirements.
• Worked on building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Involved in theinstallationand configuration of Informatica Power Center 10.1andevaluated Partition concepts inPower Center 10.1
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Created stored procedures, views, user defined functions and common table expressions.
• Generatedunderlying data for the reportsthroughSSISexportedcleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Involved inIDS Serviceslike building Business logics, analyzing the structure and data quality, creating a single view of data etc.
• Workedon Informatica cloudfor creating source and target objects, developed source to target mappings.
• Involved in importing the existing Power center workflows as Informatica CloudService tasks by utilizing InformaticaCloudIntegration.
• Involved inData integration,monitoring,auditingusing Informatica CloudDesigner.
• Worked on Data Synchronization and Data Replicationin Informatica cloud.
• WrittenPL/SQLscripts,createdstored procedures and functions and debuggedthem.
• Created Mapplets, reusable transformations and used them in different mappings.Used Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Involved in Production Support by performing Normal Loads, Bulk Loads, Initial Loads, Incremental Loads, Daily loads and Monthly loadsandDeveloped reports based on issues related to the data warehouse.
• Used different Informatica DataQualitytransformations in the Developer andConfigured match properties match paths,fuzzy match key,fuzzyand exactmatchcolumns
• Createdprofiles, rules, scorecards for data profiling and quality usingIDQ.
• Used Informatica DataQualityfor addresses and names clean-ups and developed error handling & data quality checksto pull out the right data
• UsedIDQto cleanse and accuracy check the project data, check for duplicate or redundant records.
• Used debugger to test the mapping and fix the bugs and identified the bottlenecks in all levels to tune the performance and Resolved the production support tickets using remedy.
• Developed monitoring scripts inUNIXand moved DataFiles to another server by using SCP on UNIX platform.
• Extensively usedTeradataUtilities likeFast-Load, Multi-Load, BTEQ & Fast-Export.
• CreatedTeradata External loaderconnections such asM Load, Upsert and Update, Fast loadwhile loading data into the target tables in Teradata Database.
• Involved creating the tables inTeradataand setting up the various environments likeDEV,SIT,UATand PROD.

Environment: Informatica Power Center 10.1, Oracle12C, Informatica Cloud, IDS 9.6.1, IDQ 9.6.1 Teradata 14.0, SQL Server 2014, Teradata Data Mover, Autosys Scheduler Tool, Netezza, UNIX, Toad, PL/SQL, SSIS, Power Connect, DB2, Business Objects XI3.5.

Confidential, ST Petersburg, FL

Informatica/ETL Developer

Responsibilities:

• Involved in gathering and analysis business requirement and writing requirement specification documents and identified data sources and targets.
• Translated Business Requirements intoInformaticamappings to buildData Warehouseby usingInformaticaDesigner, which populated the data into the targetStar Schema.
• UsedInformaticaclient tools -Source Analyzer,Warehouse designer,Mapping Designer,Mapplet Designer, andTransformationDeveloperfor defining Source & Target definitions and coded the process of data flow from source system todata warehouse. Performed extraction, transformation and loading of data from RDBMS tables and Flat File sources into Oracle RDBMS in accordance with requirements and specifications.
• Worked onAgile Methodology, participated in daily/weekly team meetings, guided two groups of seven developers inInformaticaPower Center/Data Quality(IDQ)and proposedETLstrategies based on requirements.
• Performed thoroughdata profilingto understand the quality of source data and to find data issues usingIDQ.
• Involved in massive data profiling usingIDQprior to data staging.
• Created Design Specification Documents includingsourcetotargetmappings.
• Responsible for performance tuningETLprocess to optimize load and query Performance
• Extensively involved in coding of the Business Rules throughPL/SQLusing the Functions, Cursors and Stored Procedures.
• Developed stored procedures, functions and database triggers usingPL/SQLaccording to specific business logic.
• Extensively used various transformationsLookup, Update Strategy, Expression, Aggregator, Filter, Stored Procedures and Joineretc.
• WrittenPreandPost SessionSQLcommands (DDL & DML) to drop and recreate the indexes on data warehouse.
• Developed process forTeradatausingShell ScriptingandRDBMSutilities such asMLoad,Fast Load(Teradata).
• Extensively usedpmcmdcommands on command prompt and executed UNIX Shell scripts to automate workflows and to populate parameter files.
• Partially involved in writing theUNIX Shell Scripts, which triggers the workflows to run in a particular order as a part of the daily loading into the Warehouse
• UsedInformaticaData Quality(IDQ)fordata quality,integrationandprofiling.
• Extracted data from various source systems likeOracle,SQL Server,XMLandflat filesand loaded into relationaldata warehouseand flat files
• Involved writingBTEQ scriptsfor validation & testing of the sessions, data integrity between source and target databases and for report generation.
• Migrated the codes fromDevtoTesttoProdenvironment. Wrote down the techno-functional documentations along with different test cases to smooth transfer of project and to maintainSDLC.
• Identified the bottlenecks and improved overall performance of the sessions
• Created Dimensions and Fact tables for the data mart and also implementedSCD (Slowly Changing Dimensions)Type I and II for data load.
• Experience in SchedulingInformaticasessions for automation of loads inAutosys.
• Providedproduction supportby monitoringthe processes running daily

Environment: InformaticaPower Center10.x/9.x,IDQ,Erwin, Oracle 11g/10g, PL/SQL, SQL*Loader, TOAD, MS SQL Server 2012/2008,Autosys.

Confidential, Warren, NJ

Informatica/ETL Developer

Responsibilities:

• Involved in all phases ofSDLC from requirement, design, development, testing and support for production environment.
• Head complex ETL requirements and design. Implement anInformaticabased ETL solution fulfilling stringent performance requirements.
• Collaborate with product development teams and senior designers to develop architectural requirements to ensure client satisfaction with product.
• Assess requirements for completeness and accuracy. Determine if requirements are actionable for ETL team.
• Applied the rules and profiled the source and target table's data usingIDQ.
• Cleanse and Scrub the Data in uniform data type and format applying MDMInformatica andIDQtools and Load to Stage and Hub tables and then to the EDW and Finally to Dimension and rollup/aggregate the data by the business grains into the FACT tables.
• Extensively worked onInformaticaMappings, Sessions, Workflows and UNIX Shell scripts to provide end to end solution to ID Re process.
• Extensively worked withTeradatautilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
• Worked with DBA for distribution key, random distribution and Organization Key on tables.
• Integrating withJSONand XML sources usingInformaticaPower Center 9x.
• Used variousInformaticatransformations for ETL loads (Java, SQL, HTTP etc.)
• Provided technical guidance for re-engineering functions of SQL Server warehouse operations intoNetezza.
• ManagedNetezzaqueries by performance tuning and techniques such as CBT and Collocation.
• Involved in Performance/Query tuning. Generation/interpretation of explain plans and tuning SQL to improve performance.
• Involved in writing UNIX shell scripts to run and schedule batch jobs.
• Involved in unit testing and documentation of the ETL process.

Environment: Informatica, IDQ9.6.1, MDM, Oracle 11g,Netezza, Teradata,SQL server 2008 R2, SQL, PL/SQL, Linux,Windows 7 Enterprise.

Confidential, Tampa, FL

Informatica Developer

Responsibilities:

• Involved in the requirements definition and analysis in support of Data Warehousing efforts
• Worked on ETL design and development, creation of theInformaticasource to target mappings, sessions and workflows to implement the Business Logic.
• Used variousTransformationslike Joiner, Aggregate, Expression, Lookup, Filter, Union, Update Strategy, Stored Procedures, and Router etc. to implement complex logics while coding a Mapping.
• Extracted datafromFlat files, SQL ServerandOracleandloaded them intoTeradata.
• Involved inData Profiling&Data Analysison heterogeneous Database sources likeOracle,flat files.
• Extensively worked onInformaticaData Quality(IDQ9.6.1)for data analysis, data cleansing, data validation, data profiling and matching/removing duplicate data.
• Designed and developedInformaticaDQ Jobs, Mapplets using different transformation like Address validator, matching, consolidation, rules etc. for data loads and data cleansing.
• Preparation oftechnical specificationfor the development of Extraction, Transformation and Loading data into various stage tables.
• Used theIntegration servicein PowerCenter 9.6.1 to start multiple instances of the same workflow.
• Implementeddifferent Tasksin workflows which included Session, Command, E-mail, Event-Wait etc.
• CreatedData BreakpointsandError Breakpointsfor debugging the mappings using Debugger Wizard.
• ScheduledandRun Workflowsin Workflow Manager and monitored sessions using InformaticaWorkflow Monitor.
• Validated and tested the mappings usingInformaticaDebugger, session logs and workflow logs.
• Worked on migrating existing PL/SQL packages, stored procedures, triggers and functions toInformaticaPower Center.
• Transformed bulk amount of data from various sources toTeradatadatabase by usingBTEQ, MLOAD and TPUMP scripts.
• Transferred data usingTeradatautilities likeSQL Assistant,Fast ExportandFast Load.
• Involved inPerformance Tuningof SQL Queries, Sources, Targets and sessions by identifying and rectifying performance bottlenecks.
• Worked onAutosys Schedulerto automate the Workflows.
• Testedall the mappings and sessions inDevelopment, UATenvironments and also migrated into Production environment after everything went successful.

Environment: InformaticaPowerCenter 9.6.1, InformaticaData Quality(IDQ8.6.1),InformaticaData Quality(IDQ8.6.1), SQL Server, Oracle 11g, PL/SQL, Flat files, MySQL,Teradata13, WinSCP, Notepad++, Toad, Quest Central, UNIX scripting, Windows NT.

Confidential

Informatica Administrator

Responsibilities:

• Installed and configured Informatica Power Center 9.1.
• Configured Load balancing and Grid in Informatica.
• Creation and maintenance of Informatica users and privileges.
• Created Native Groups, Native Users, roles, and privileges and assigned them to each user group.
• Developed a standard ETL framework to enable the reusability of similar logic across the board. Involved in System Documentation of Dataflow and methodology.
• Installation and configuration of B2B DX, MFT and troubleshoot the issues.
• Developed mappings to extract data from SQL Server, Oracle, Flat files and load into DataMart using the Power Center.
• Written pre session and post session scripts in mappings.
• Created deployment groups and assigned the permissions to the deployment group.
• Created Informatica Folders and assigning the permissions to the Folders.
• Created OS profiles for the user which used to run the applications.
• Migration of Informatica Mappings/Sessions/Workflows from Dev to Test and Test to Stage and Stage to Prod environments.
• Coordinated with UNIX and Database Administrators for creating OS profiles and file systems.
• Handled outages when there is any maintenance in UNIX and DATA BASE.
• Collaboratively worked with Application Support Team, Network, Database Teams, and UNIX teams.
• Bouncing Activities or Restarting the Service in Network Changes or in any maintenance and Communicating to Business.

Environment: Informatica powercenter 9.1 HF4, Oracle11.2.0.3.0, Linux and OS.