EXPERIENCE SUMMARY:

• 5+ Years of experience in information technology and D Confidential Warehouse Development, Design, Mapping, Extraction, Migration, D Confidential Conversion, D Confidential 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 d Confidential models, queries.
• Strong experience in principles of DW concepts like Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions.
• Strong D Confidential Warehousing ETL experience using Informatica Power Center Client tools - Designer, Source Analyzer, Target Designer, Transformation Developer, Mappings and Mapplets Designer along with 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 with 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 the Informatica tool to check the errors in the mapping and made appropriate changes in the mappings to generate the required results
• Develop ETL audits and controls to ensure quality of d Confidential meets or exceeds defined standards and thresholds defined by the 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 d Confidential using Informatica d Confidential quality tool.
• Proficient in developingInformaticaIDQtransformations like Parser, address validator, standardizer, labeler, Match, case, Merger and Exception transformation.
• Played a key role in creating / managing the D Confidential Quality Process
• Understand source system d Confidential representation, formats & d Confidential gaps Created Exception handling process and worked on the best practices and standards for exception handling routines
• Designed Mappings using Informatica Big D Confidential 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 with relational D Confidential bases such as Oracle, DB2, SQL Server, Netezza.
• Excellent knowledge in d Confidential warehouse development life cycle including Software Development Life Cycle (SDLC), including business requirement analysis, d Confidential mapping, build, unit testing, user acceptance testing and implementation of slowly changing dimensions.
• Expert in writing critical ETL procedures that extract d Confidential from different d Confidential feeds, transform and load into D Confidential warehouse using different transformations like Source Qualifier, Expression, Lookup, Aggregate, Update Strategy and Joiner that is used by business users in the form of reports.
• Expert in designing and developing backend PL/SQL packages in d Confidential base 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 with the ability to solve complex problems Can work very well in a team as well as independently under minimum supervision

TECHNICAL SKILLS

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

D Confidential Modeling: Dimensional D Confidential Modeling (Star Schema, Snow-Flake, FACT, Dimensions), Physical and Logical D Confidential 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, D Confidential Analysis, ETL Design, Reporting Environment Design, Development and Testing UAT Implementation

D Confidential bases: Oracle 10g,9i,8i, MS SQL Server, Tera D Confidential, SybaseMS Access, DB2

PROFESSIONAL EXPERIENCE

Confidential

Informatica/ETL Developer

Responsibilities:

• Analyze the business requirements and framing theBusiness Logicfor theETLProcess and maintained theETLprocess usingInformaticaPowerCenter.
• Communicated with business customers to discuss the issues and requirements.
• DevelopedETLprograms usingInformaticato implement the business requirements.
• UsedInformaticaPower Centerto load d Confidential from different d Confidential sources like xml, flat files and Oracle,Terad Confidential, 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 the technical solutions. ProposedETLstrategies based on requirements.
• Extensively used the DQ transformations likeAddress validator, Exception, Parser, Standardizer, Solid experience in debugging and troubleshooting Sessions using the 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 the d Confidential transfer over the network.
• Effectively worked inInformaticaversion-based environment and used deployment groups to migrate the objects.
• Extensively worked on Confidential to capture the d Confidential changes into sources and for delta load. Used Debugger to validate the Mappings and gained troubleshooting information about the d Confidential and error conditions.
• Developing workflows withWorklets,Event waits, Assignments, Conditional flows, Emailand Command Tasksusing Workflow Manager.
• UsedSQLtools likeTOADto runSQLqueriesand validate the d Confidential
• UsedInformaticapower centerandTransformationsusingInformaticaPowerCenterto move d Confidential from multiple sources into target area using complex transformations likeExpressions, Routers, Lookups, Source Qualifiers, XML generator, XML Parser, Aggregators, Filters, Joiners
• Worked with theQuality Assuranceteam to build the test cases to perform unit, Integration, functional and performance Testing.
• Responsible in preparing Logical as well as Physical d Confidential models and document the same
• PerformedETLcode reviews andMigrationofETLObjectsacross repositories.
• DevelopedETL's for masking the d Confidential when made available for the 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 d Confidential on different layers to capture the d Confidential discrepancies/inaccuracies to ensure successful execution of accurate d Confidential loading.
• Involved in implementingchange d Confidential capture ( Confidential )andSCDTypeI, II, III slowly changing Dimensions
• Developed functions andstored proceduresto aid complex mappings
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads, and process flow of the mappings
• Provided 24x7 production supports for business users and documented problems and solutions for running the workflows.

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

Confidential

Informatica/ETL Developer

Responsibilities:

• Perform requirement analysis through coordination with business analysts and define business and functional specifications
• As a team conducted gap analysis and Discussions with subject matter experts to gather requirements, emphasize on problem areas and define deliverables.
• Logical and Physical d Confidential modeling was done using Erwin for d Confidential warehouse d Confidential base in STAR SCHEMA.
• UsingInformaticaPower Center Designer analyzed the source d Confidential to Extract & Transform from various source systems (oracle 11g, DB2,SQLserver and flat files) by incorporating business rules using different objects and functions that the tool supports.
• UsingInformaticaPower Center created mappings and Mapplets to transform the d Confidential according to the business rules.
• Designed theETLmappings between sources to operational staging targets, then to the d Confidential 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 withInformaticapower center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• UsedInformaticaPower Center to migrate the d Confidential 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 the session performance.
• Developed and maintainedETL(Extract, Transformation and Loading) mappings to extract the d Confidential from multiple source systems like Oracle,SQLserver and Flat files and loaded into Oracle.
• Created business rules inInformaticaDeveloperand imported them toInformaticaPower center to load the standardized and good format of d Confidential to staging tables.
• Prepared and documented unit test plans and resolved issues escalated from system testing.
• Used Terad Confidential utilities like Fast Load, Multi load, Fast Export and BTEQ.
• Involved in creating new table structures and modifying existing tables and fit into the existing D Confidential Model.
• Designed and Created d Confidential 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

Informatica/ETL Developer

Responsibilities:

• Gathered, analyzed & documented business requirements.
• Designed & developed technical solutions usingNetezza,Informatica,and Oracle.
• Designed & developed Oraclescripts to load d Confidential into Oraclestaging area & then to Target area.
• Developed UNIX shell scripting for d Confidential warehouse projects.
• Worked with Business Analyst closely to gather most of the Business Requirements for all the Line of Businesses.
• Experience in delivering the Technical process flow for different Line of Business and coordinated with offshore Teams on both Functional and Technical sides.
• Worked on different types ofETL/D Confidential Load processes that pull d Confidential from flat files, XML, intoSQLServer d Confidential base.
• Designed and developed requiredInformaticaMappings, Mapplets, Workflows and transmission of d Confidential 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 d Confidential from different Line of Business Operational D Confidential Store by Scrubbing, Cleansing and Transforming d Confidential before its being utilized by the 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 d Confidential into D Confidential Warehouse/D Confidential 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 the Operational D Confidential Store.
• Created tasks and workflows in the Workflow Manager and monitored the sessions in the 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 that were opened by different SMEs and closed them by providing timely solutions.
• Supported trouble shooting for the D Confidential Issues on theETLside and documented the resolution history for all the issues.
• Experience in driving and delivering time sensitive deadlines on time.
• Conducted Knowledge Transfer and End user for the customer and Tracked the progress of the engagement.

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