SUMMARY

• Around 15 years of IT experience in Development and Implementation and integration of application of data warehouses, analysis, design, development, Testing, Production and implementation, services using Informatica Power center, in various organizations such as Banking, Insurance, Telecommunication, Retail and Financial.
• Strong noledge of Extraction Transformation and Loading (ETL) processes using Informatica power center v.10.1 and v.10.2, UNIX shell scripting, Oracle, SQL server, DB2,Tera Data.
• Proficient in databases like Oracle 10g, 11g 12c, DB2, SQL Server, Teradata (BTEQ and TPT) and Flat Files (delimited files, fixed width files, XML & CSV files) .
• Experienced on Azure designing maps by Informatica Cloud to load information.
• Senior noledge on Power Center components as Power Center Designer, Power Center Repository Manager, Workflow Manager and Workflow Monitor.
• Expertise in working wif operational sources like DB2, SQL server, SAP Application, Oracle, Teradata, SAP HANA, Flat Files, XML’s into a staging area.
• Import and export of tables and objects into SAP S4/Hana since of teh repository.
• Experience wif data integration using SAP ERP, for create reports and send to mail user.
• Knowledge wif Sap application for extract data transform and load, using sap abap utility.
• Good Experience using SSIS wif ETL and extracting information from SQL SERVER Database and generating intefaces for data Integration of another application and load tables for financial reports.
• Experienced in extraction, transformation and load in Salesforce using Informatica Cloud and Informatica Cloud Real Time
• Develop Shells scripting using notepad ++, Visual Code and Sublime like IDE for invoke workflows in Informatica Power Center.
• Developed PL/SQL Procedures, Functions, Packages, Triggers, and Materialized Views.
• Strong noledge of Oracle tools such as TOAD, SQL Plus and SQL Developer.
• Worked extensively on different types of transformations like Source Qualifier, Expression, Aggregator, Router, Filter, Update Strategy, Lookup, Sorter, Normalize, Union, Stored Procedure, and Sequence Generators.
• me worked under scrum methodology life cycle of system.
• Good experience on Data conversion projects, And good noledge on data migration from Legacy systems to Policy center.
• Strong experience in loading and maintaining Data Warehouses and Data Marts using Informatica power center ETL processes.
• Experience in several Modeling like DataVault Model, SnowFlake Model and Star Model.
• Hands on experience in writing, testing and implementation of teh triggers, Procedures, functions at Database level using PL/SQL.
• Involved in Requirements gathering, Logical design model & physical design model meetings to understand teh data flow, frequency of data loads into EDW and create S2T Mapping documents and Visio diagrams.
• Involved in various phases of project life cycle, such as requirements definition, functional & technical design, testing, Production Support and implementation.
• Excellent team member wif problem - solving and trouble-shooting capabilities, Quick Learner, highly motivated, result oriented and an enthusiastic team player.
• Responsible for all activities related to teh development, implementation, supportofETL processes for large-scale data warehouses using Power Center.
• Experience in Debugging and Performance Tuning.
• Experience in ETL Testing, DB Testing, Unit Test and Manual Testing.
• Experience in creation reports on Sap BO
• Involved in implementation activities and Support activities post implementation.

TECHNICAL SKILLS

Operating System: Windows 2012/2008 Server, Windows OS, Linux 6.7 and 10.0, Unix

Programming: PL-SQL, HTML, HTML5 + CSS + JavaScript, Shell Scripts

Database: MS SQL Server 2014,2012, 2008 R2, 2008, Oracle 11g, 10g, BTEQ, Multi Load, Fast Load, Fast Export, Teradata Manager, SQL Assistant, Teradata Administrator, DB2 Hana DB.

ETL Tools: Performance Monitor, TOAD,SQL*Loader, ETL, SQL*Developer, Informatica Cloud, InformaticaPower Center 9. X.10.X, Toad, Data Stage, Pentaho, SSIS.

Application Servers: SAP Reports y SAP ABAP, SAP BO

Data Modeling: MS Visio, DataVaul Model, Star Model and SnowFlake

Scheduling Tools: Control M, Tivoli

EIM Tools: InformaticaMDMMulti-domain

PROFESSIONAL EXPERIENCE

Confidential

ETL Informatica Developer and Analyst

Responsibilities:

• ETL Developments creating a mesh to execute Workflows, and extract information to load it into teh raw.
• Create teh mesh for teh application of rules called derived layer where was apply teh transformations necessary for teh business were made Creating and loading tables to generate teh final files.
• Develop mappings wif several cleanse functions to move data into work tables.
• Create sessions, workflows, and parameter Files and shell script.
• Develop mappings wif teh following transformations (Expression Transformation, Aggregator Transformation, Look up transformation - connected and unconnected, Sorter Transformation, Update Strategy Transformation, Normalizer Transformation, SP Transformation, etc.)
• Generate Scritps to create tables, materialized views, insert script, alter and synonym create in Oracle Database.
• Work team for creation of 450 workflows for teh migration of teh Claims V10 tool.
• Design and development scenarios for unit and integration testing.
• Preparation of test cases and code review document, identify, debug and fix teh defects.
• Update teh code into production wif proper version.
• Create low level design documents, Source to Target mappings, unit test case and test logs documents.

Environment: Informatica Power Center v.9.5, 10.1, 10.2, Oracle 11g, AIX Server, SQL Developer, Visual Code and ALM for attention of defects.

Confidential

Senior ETL Informatica Developer and Technical Lead

Responsibilities:

• Work wif ETL Developers in creating External Batches to execute mappings, Mapplets using Informatica workflow designer to integrate data from several sources like Oracle, DB2, flat files and generate interfaces.
• Performing requirement gathering analysis design development testing implementation support and maintenance phases of Data Integration Projects.
• Creating landing tables Staging tables Base Tables as per teh data model and data sources.
• Developing mappings using various cleanse functions to move data into Stage tables
• Closely worked wif other IT team members business partners data stakeholders steering committee members for all IT and data governance related activities.
• Supporting role towards Business Analyst and Team lead in requirement phase, peer review and preparing high level design.
• Generate Store Procedures to invoke procedures from Informatica Power Center.
• Integrate applications to data Ware House, DataMart.
• Schedule jobs in Tivoli for execution and invocations from teh shell until teh workflows in informatica PowerCenter and IDQ.
• Migrate all projects of teh application of afore Confidential from Datastage to informatica Power Center version 10.02.
• Attend new requirements of several business areas, like cost, Aladdin, and Afore Market and building Etl ‘s in Datastage for to create interfaces for Aladdin Application.
• Create individual mappings (me.e. Stage jobs) for moving data from landing table to staging tables.
• Run teh load jobs for moving data from staging tables to teh creation of flat files and XML files.
• Design and development test scenarios for unit and integration testing, as well as positive and negative testing and generating teh test data as per test cases.
• Preparation of test cases and code review document, debugging teh defects identified and fixing them.
• Updating teh code into production wif proper version.
• Coordinating wif teh Team Lead and end users to understand and analyze business requirements.
• Designing and creating low level design documents, Source to Target mappings, unit test case and test logs documents

Environment: Informatica Power Center v.9.6, 10.1, Oracle 11g, InformaticaData Quality (IDQ) 9.6, Teradata,Toad, SQL*Loader, AIX Server, PL SQL.

Confidential

ETL Informatica Developer PC and Informatica Cloud

Responsibilities:

• Developing complex ETL mapping using Informatica PowerCenter to move information from multiple sources into common target area such as Master Data Management, Data Marts and teh Enterprise Data Warehouse.
• Analyzing existing design and recommending industry best practice design for optimal performance and maintenance.
• Applying Full Software Development Life Cycle (SDLC) experience, including Analysis, Design and Review of Business and Software Requirement Specifications, Development and Testing as per teh SDLC waterfall methodology.
• Handling Change Requests - Understanding teh application work flow in teh existing jobs on Informatica and applying new changes to them, testing & review activities.
• Worked wif ETL Developers in creating External Batches to execute mappings, Mapplets using Informatica Cloud to integrate data from several sources like Oracle, CRM Salesforce, flat files and filling of Staging tables.
• Extraction information from Amazon to generate high-level reports trough Informatica Cloud Tool.
• Experience on mapping and task flows using AWS as S3 connectors.
• Experience wif IICS real time, for generate process and reports wif Salesforce application for a response immediate dat save and recovery data from Oracle database and sql server.
• Develop Shells scripting using notepad ++ and Sublime like IDE for invoke workflows in Informatica Power Center.
• Develop mappings in IDQ using Oracle Database and SQL Server as source and target.
• Using IDQ tool to do data integration for data warehouse Application.
• Generated task flow and mapping to get information for Salesforce using Informatica Cloud Real Time.
• Designing and creating low level design documents, Source to Target mappings, unit test case and test logs documents.
• Create store procedures to call from transformation to Informatica Power Center.
• Using PL SQL from Oracle.
• Designing maps by Informatica Cloud to load information on Azure as Target.
• Interacted wif teh Business Users & Enterprise Data Architects in teh analysis & design of conceptual and logical data model dat is required for solid MDM implementation & ensuring dat it meets teh business requirements and also supports teh products capabilities.
• Involved in implementing teh Land Process of loading teh customer Data Set into Informatica MDM from various source systems.
• Worked w /Data Profiling Team in analyzing teh source systems data for duplicative and quality issues.
• Worked w/ ETL team in configuring teh landing tables' structure according to standardization of teh Client.
• Configured Base Object Tables in schema and relationship tables in hierarchies according to data-model.
• Configured Landing Tables, Staging Tables, Look-ups, Cleanse Lists, Cleanse functions, Mappings, Audit trail/ Delta detection.
• Creating project plans, design and development Building a data model according to business needs by interacting wif data architect.
• Using Parameter File for data mapping configuring.

Environment: InformaticaMDM9.6.0, InformaticaData Quality (IDQ) 9.6.0,InformaticaPower Center 9.6.0, SQL Server 2008, Oracle 11, Informatica Cloud, Informatica Real Time, Salesforce, PL SQL.

Confidential

ETL Developer

Responsibilities:

• Perform analysis, design and implementation of ETL, in environment DEV and QA.
• Building, construction and design of maps, Mapplets and workflows.
• Parameter files in Informatica Power Center, installed on Linux Red Hat 6, Oracle Database 11g R2.
• Validation information ORS, based on methodology Acquisition.
• Homologation, consolidation and standardization, test of data and Test of data Unit in Oracle.
• Perform Designs and Analysis on business systems applications, systems interfaces, databases, reporting, or business intelligence systems.
• Worked wif Business Analyst and end users to generate Requirement Document according to business needs for Customer Master ORS.
• Involved in landing teh data from Seven Different source systems by running external batch process to load business data for creating customer master data. External batch process used was ETL process.
• Developed and managed relationships between data domains for teh data models.
• Mainly involved in ETL developing.
• Extensively used Informatica Client tools - Power Center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Extracted data from various heterogeneous sources like Oracle, SQL Server, Flat Files, Teradata.
• Extracted data from Oracle, Flat file, Excel files and performed complex joiner, Expression, Aggregate, and Lookup, Stored procedure, Filter, Router transformations and Update strategy transformations to load data into teh target systems.
• Created Sessions, Tasks, Workflows and worklets using Workflow manager.

Environment: Oracle 11g,InformaticaMDM(Formerly Siperian) 9.1, TOAD, JBoss, Address Doctor 5.

Confidential

On Site Analyst Developer

Responsibilities:

• Used teh Informatica developer to develop processes for Extracting, Cleansing, Transforming, Integrating, and Loading data into Data warehouse.
• Requirement analysis and gathering to provide technical and architectural support to teh team.
• Documented teh Purpose of Mapping to facilitate teh personnel to understand teh process and in corporate teh changes as and when necessary.
• Primarily involved in Job Design, Technical Reviews and Troubleshooting of jobs. Extensively involved in different Team review meetings and conferences wif remote team.
• Developed PL/SQL Procedures, Functions, Packages, Triggers, Normal and Materialized Views.
• Defect Tracking, unit testing, defect reporting, analyzing results and documentation.
• Designed Informatica jobs using mapping designer to extract data from various source systems, Transformation and conversion of data, Load data to data ware house and Send data from warehouse
• Extensively used Processing Stage like Lookup Stage to perform lookup operations based on teh various target tables, modify stage to alter teh record schema of teh input data set.
• Performed ETL Performance tuning to increase teh ETL process speed.
• Have addressed production, UAT issues, proper action was taken accordingly based on priority and requirement
• Developed Operational Manual Documentation.
• End-to-end implementation, maintenance, optimizations and enhancement of teh application.
• Communication wif clients/onshore manager on day to day basis which includes conference calls and written communications.
• Assisting teh Project Management team in providing teh estimation of projects. This is an important step where we analyze teh requirements and estimate teh effort and time by when we could deliver teh best solution.
• Leading teh team and ensuring teh delivery happens on time wif teh best quality and least defects.
• Handling Change requests - Understanding teh application work flow in teh existing jobs on Informatica and applying new changes to them, testing & Review activities.
• Created reports in BO from SAP.
• Populate tables wif informatica PowerCenter, and cross information to generate sales reports for new products.

Environment: Informatica Power Center 9.1, Oracle 8i, 11g and 12g, Teradata, Toad, Control M, Cognos 8.4, PL SQL, SAP BO.

Confidential

Server Manager and Database, Developer ETL

Responsibilities:

• Operated and Management Windows and Unix servers.
• Monitor databases and processes (BATCH Line).
• Created of boxes for process execution in CONTROL M.
• Monitor ETL processes as well as DTS and Validation Web Services.
• Participate in teh ETL process optimization Exadata.
• Backups databases in SQL Server and Oracle.
• Extract information from AS400.
• Run processes on (back end’s, batch processes, etc.) servers.

Environment: ; Control M, ETL, DTS and SHELLS, SQL Server Management, Oracle, Power Center v9.1 SQL Server and AS400.

Confidential

COB Junior Analyst in Information Systems

Responsibilities:

• Validation, monitor, and analyzed routes Security information systems of teh Bank.
• Process Unix-based application validating high sensitive commands.
• Created users, groups and privileges on Windows and Unix.
• Validated and managed databases like Oracle, SQL Server and Sybase are performing.
• Running scripts, test scripts, validation and detection of defects and results.
• Monitor and validation of teh correct use of access operation systems and applications.
• Conduct meetings to collect information from stakeholders.
• Deliver audit documentation.

Environment: ; Powerbroker, monitoring applications, Windows and Windows Server 2003, Unix, Databases such as SQL, Oracle Sybase, Active Directory Management and FTP backups, average per command line console.