SUMMARY

• 5+ Years of experience in information technology and Data Warehouse Development, Design, Mapping, Extraction, Migration, Data Conversion, Data validation and Development of ETL.
• Extensively worked in Extraction Transformation Loading (ETL) process using Informatica 10.2/9.x/8.x/7.x/6.x, Informatica Power Exchange 9.x Oracle, SQL Server, Mainframes, Netezza, DB2, SAP, Salesforce, Seibel, Linux, Unix and developing user - centric data models, queries.
• Strong experience in principals of DW concepts like Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions.
• Strong Data Warehousing ETL experience using Informatica Power Center Client tools - Designer, Source Analyzer, Target Designer, Transformation Developer, Mappings and Mapplets Designer along wif Workflow Manager and Monitor tools.
• Proficient in using Informatica Designer, Workflow manager, Workflow Monitor, Repository Manager to create, schedule and control workflows, tasks and sessions
• Translate complex functional and technical requirements into detailed design.
• Extensive experience in performance tuning of existing workflows wif pushdown optimization, session partitioning etc.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, Union, Rank, Normalizer, Update strategy and Router transformations for populating target table in efficient manner.
• Extensive experience in using Debugger utility of teh Informatica tool to check teh errors in teh mapping and made appropriate changes in teh mappings to generate teh required results
• Develop ETL audits and controls to ensure quality of data meets or exceeds defined standards and thresholds defined by teh business customer
• Experience in identifying, researching, and resolving ETL issues and producing root cause analysis documentation.
• Experience in Agile software development methodology and implementations.
• Designed and developed business rules to generate consolidated data using Informatica data quality tool.
• Proficient in developingInformaticaIDQtransformations like Parser, address validator, standardizer, labeler, Match, case, Merger and Exception transformation.
• Played a key role in creating / managing teh Data Quality Process
• Understand source system data representation, formats & data gaps Created Exception handling process and worked on teh best practices and standards for exception handling routines
• Designed Mappings using Informatica Big Data Edition(BDE).
• Created Physical Objects and Applications.
• Imported Mappings to applications and executed them using UNIX commands.
• Exported mappings and Rules from BDE to Power center for scheduling workflows.
• Expertise in working wif relational Databases such as Oracle, DB2, SQL Server, Netezza.
• Excellent noledge in data warehouse development life cycle including Software Development Life Cycle (SDLC), including business requirement analysis, data mapping, build, unit testing, user acceptance testing and implementation of slowly changing dimensions.
• Expert in writing critical ETL procedures dat extract data from different data feeds, transform and load into Data warehouse using different transformations like Source Qualifier, Expression, Lookup, Aggregate, Update Strategy and Joiner dat is used by business users in teh form of reports.
• Expert in designing and developing backend PL/SQL packages in database layer, functions and triggers.
• Extensive experience in Requirement Gathering, Customization, Maintenance and Implementation of various Business Applications.
• Hands on experience in resolving errors using Debugger, Log files of Session & workflows and troubleshooting, performance tuning, and optimization ETL Mappings.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
• Performed activities including execution of test plans and design of exception handling strategy. Completed documentation in relation to detailed work plans, mapping documents.
• Analytical and Technical aptitude wif teh ability to solve complex problems Can work very well in a team as well as independently under minimum supervision

TECHNICAL SKILLS

Data warehousing ETL: Informatica Power Center 10.x/ 9.x /8.x/7.x/, DW Designer, Mapping Designer, Work Flow Manager, Meta data reporter, Power Analyzer, Work Flow Monitor, Mapplet, Transformations, SSIS

Data Modeling: Dimensional Data Modeling (Star Schema, Snow-Flake, FACT, Dimensions), Physical and Logical Data Modeling, Entities, Attributes, Cardinality, ER Diagrams, ERWIN 4.5/4.0, DB Designer

Reporting & BI: SQL Server Reporting Services, Tableau, Power BI

Job Scheduling: Autosys, Control M, CA WorkStation

Programming: SQL/ PL SQL, Transact SQL, Unix Shell Scripting, HTML, C, C++

System Design & Development: Requirements Gathering and Analysis, Data Analysis, ETL Design, Reporting Environment Design, Development and Testing UAT Implementation

Databases: Oracle 10g,9i,8i, MS SQL Server 2000/2005/2008 , Tera Data, SybaseMS Access, DB2

Environment: RHEL (Red Hat Enterprise Linux)4.0, UNIX (Sun Solaris 2.7/2.6, HP-UX 10.20/9.0, IBM AIX 4.3/4.2), Windows 10/7/2003/2000/ XP/98, Win NT, Linux, MS-Dos.

PROFESSIONAL EXPERIENCE

Confidential, St, Doral, FL

Informatica/ETL Developer

Responsibilities:

• Analyze teh business requirements and framing theBusiness Logicfor theETLProcess and maintained theETLprocess usingInformaticaPowerCenter.
• Communicated wif business customers to discuss teh issues and requirements.
• DevelopedETLprograms usingInformaticato implement teh business requirements.
• UsedInformaticaPower Centerto load data from different data sources like xml, flat files and Oracle,Teradata, Salesforce.
• Worked on Agile Methodology, participated in daily/weekly team meetings, guided two groups of seven developers inInformaticaPowerCenter peer reviewed their development works and provided teh technical solutions. ProposedETLstrategies based on requirements.
• Extensively used teh DQ transformations likeAddress validator, Exception, Parser, Standardizer, Solid experience in debugging and troubleshooting Sessions using teh Debugger and Workflow Monitor.
• Extensively worked onUNIX shell scriptsfor server Health Check monitoring such as Repository Backup, CPU/Disk space utilization,InformaticaServer monitoring, UNIX file system maintenance/cleanup and scripts usingInformaticaCommand line utilities.
• Used relationalSQLwherever possible to minimize teh data transfer over teh network.
• Effectively worked inInformaticaversion-based environment and used deployment groups to migrate teh objects.
• Extensively worked onCDCto capture teh data changes into sources and for delta load. Used Debugger to validate teh Mappings and gained troubleshooting information about teh data and error conditions.
• Developing workflows wifWorklets,Event waits, Assignments, Conditional flows, Emailand Command Tasksusing Workflow Manager.
• UsedSQLtools likeTOADto runSQLqueriesand validate teh data
• UsedInformaticapower centerandTransformationsusingInformaticaPowerCenterto move data from multiple sources into target area using complex transformations likeExpressions, Routers, Lookups, Source Qualifiers, XML generator, XML Parser, Aggregators, Filters, Joiners
• Worked wif theQuality Assuranceteam to build teh test cases to perform unit, Integration, functional and performance Testing.
• Responsible in preparing Logical as well as Physical data models and document teh same
• PerformedETLcode reviews andMigrationofETLObjectsacross repositories.
• DevelopedETL's for masking teh data when made available for teh Offshore Dev. Team
• Developed UNIX scripts for dynamic generation ofParameter Files& for FTP/SFTP transmission
• Migrated codes from Dev to Test to Pre-Prod. Createdeffective Unit, Integration test of data on different layers to capture teh data discrepancies/inaccuracies to ensure successful execution of accurate data loading.
• Involved in implementingchange data capture (CDC)andSCDTypeI, II, III slowly changing Dimensions
• Developed functions andstored proceduresto aid complex mappings
• Provided Knowledge Transfer to teh end users and created extensive documentation on teh design, development, implementation, daily loads, and process flow of teh mappings
• Provided 24x7 production supports for business users and documented problems and solutions for running teh workflows.

Environment: InformaticaPowercenter10.x/9.6, Oracle 11g, Teradata, PLSQL,SQLdeveloper, TOAD, Putty, Unix,Netezza,MicrosoftSQLServer 2008, and Microsoft Visual studio

Confidential, Chicago, IL

Informatica/ETL Developer

Responsibilities:

• Perform requirement analysis through coordination wif business analysts and define business and functional specifications
• As a team conducted gap analysis and Discussions wif subject matter experts to gather requirements, emphasize on problem areas and define deliverables.
• Logical and Physical data modeling was done using Erwin for data warehouse database in STAR SCHEMA.
• UsingInformaticaPower Center Designer analyzed teh source data to Extract & Transform from various source systems (oracle 11g, DB2,SQLserver and flat files) by incorporating business rules using different objects and functions dat teh tool supports.
• UsingInformaticaPower Center created mappings and Mapplets to transform teh data according to teh business rules.
• Designed theETLmappings between sources to operational staging targets, then to teh data warehouse using Power Center Designer.
• Involved in Design, analysis, Implementation, Testing and support ofETLprocesses for Stage, ODS and Mart.
• DocumentedInformaticamappings in Excel spread sheet.
• Developed mappings/Reusable Objects/Transformation/Mapplets by using mapping designer, transformationdeveloperand Mapplets designer inInformaticaPower Center.
• Worked wifInformaticapower center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• UsedInformaticaPower Center to migrate teh data from different source systems.
• Extensively used Autosys for Scheduling and monitoring.
• Responsible for developing, support and maintenance for theETL(Extract, Transform and Load) processes usingInformaticaPower Center 9.5 by using various transformations like Expression, Source Qualifier, Filter, Router, Sorter, Aggregator, Update Strategy, Connected and unconnected look up etc.
• Extensively used various Performance tuning Techniques to improve teh session performance.
• Developed and maintainedETL(Extract, Transformation and Loading) mappings to extract teh data from multiple source systems like Oracle,SQLserver and Flat files and loaded into Oracle.
• Created business rules inInformaticaDeveloperand imported them toInformaticaPower center to load teh standardized and good format of data to staging tables.
• Prepared and documented unit test plans and resolved issues escalated from system testing.
• Used Teradata utilities like Fast Load, Multi load, Fast Export and BTEQ.
• Involved in creating new table structures and modifying existing tables and fit into teh existing Data Model.
• Designed and Created data cleansing, validation and loading scripts for warehouse using InformaticaPower Center 9.1.1/8.6.

Environment: InformaticaPower Center 10.0/9.1.1,Power Exchange 10.1,Oracle 11g, MySQL,XML, Flat Files,SQLAssistant, Toad, PL/SQL,Erwin, Unix shell scripting, Unix, Windows

Confidential, Detroit, MI

Informatica/ETL Developer

Responsibilities:

• Gatheird, analyzed & documented business requirements.
• Designed & developed technical solutions usingNetezza,Informatica,and Oracle.
• Designed & developed Oraclescripts to load data into Oraclestaging area & then to Target area.
• Developed UNIX shell scripting for data warehouse projects.
• Worked wif Business Analyst closely to gather most of teh Business Requirements for all teh Line of Businesses.
• Experience in delivering teh Technical process flow for different Line of Business and coordinated wif offshore Teams on both Functional and Technical sides.
• Worked on different types ofETL/Data Load processes dat pull data from flat files, XML, intoSQLServer database.
• Designed and developed requiredInformaticaMappings, Mapplets, Workflows and transmission of data between organizations using MFT.
• UsedETL,InformaticaDesigner to design mappings and coded it using reusable Mapplets using various Transformations like Joiner, Aggregate, Expression, Filter, update Strategy.
• Designed and DevelopedInformaticaMapping to load data from different Line of Business Operational Data Store by Scrubbing, Cleansing and Transforming data before its being utilized by teh Downstream Systems.
• Involved in extensive performance tuning by determining Bottlenecks at various points like Sources, Targets, mapping and sessions and providing solutions.
• Strong understanding of Performance tuning inInformaticaand loading data into Data Warehouse/Data Marts usingInformatica.
• Created design documentInformaticamappings based on business requirement and encode them into HLDs and LLDs for various modules of project.
• Tuned theInformaticaCode for Performance, Creating Aggregates, DrillDowns, Cache Management, Tweaking Business Models.
• CustomizedInformaticaMappings, Configured, Scheduled and Executed Full and Incremental loads on teh Operational Data Store.
• Created tasks and workflows in teh Workflow Manager and monitored teh sessions in teh Workflow Monitor and also setup Project Folders in all Environments ofInformatica.
• Involved in Performance Unit Testing, SIT and UAT forETLprocess.
• Worked on REMEDY Ticketing System to resolve issues dat were opened by different SMEs and closed them by providing timely solutions.
• Supported trouble shooting for teh Data Issues on theETLside and documented teh resolution history for all teh issues.
• Experience in driving and delivering time sensitive deadlines on time.
• Conducted Knowledge Transfer and End user training for teh customer and Tracked teh progress of teh engagement.

Environment: InformaticaPowerCenter 9.5.1SQLServer 2008, ERWIN 4.5, Flat Files, XML, Files, Oracle 11g,Netezza9.8,OBO,SQL,PL/SQL,UNIX AIX

Confidential

ETL Developer

Responsibilities:

• Design,Develop and Documentation of theETL(Extract, Transformation & Load)strategy to populate theData Warehousefrom teh various source systems.
• Extensively usedInformaticaDesignerto create and manipulatesource definitions, target definitions, mappings, Mapplets, transformations, re-usable transformations.
• Involvedin loading teh data fromSource Tables to ODS (Operational Data Source) Tablesusing Transformation and Cleansing Logic usingInformatica.
• Worked wifRepository Managerfor managing of repositories and folders.
• UsedInformaticaPower Exchangeto implement changes or updates on Source systems.
• Created different source definitions to extract data fromFlat Files and Relational Tables for Power Center.
• Based on teh logic, used various transformation likeSource Qualifier, Normalizer, Expression, Filter, Router, Update Strategy, Sorter, Lookup, Aggregator and Joinerwere used.
• Created mappings in designer to implement thetype 2slowly changing dimensions.
• Involved in performance tuning ofmappings, transformations and sessionsto optimizesession performance.
• Developedworkflow tasks like reusable Email, Event wait, Timer, Command, Decision.
• UsedInformaticadebugging techniquesto debug teh mappings and used session log files and bad files to trace errors occurred while loading.
• CreatedMaterialized viewsfor summary tables for better query performance.
• Creating Test Documents forUnit Test, Integration Test and UAT to check teh data quality
• Created UNIX shell scriptsfor automation.
• Developed Documentation for all theroutines (Mappings, Sessions and Workflows).
• PerformedError checking and debugging.

Environment: InformaticaPower Center9.5.1,Oracle 11g, PL/SQL,Autosys,SQLserver, TOAD, Windows, UNIX.