We provide IT Staff Augmentation Services!

Senior Etl Informatica Developer And Technical Lead Resume

PROFESSIONAL SUMMARY:

  • Around 13 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, Data Quality in various organizations such as Banking, Insurance, Telecommunication and Financial
  • Strong knowledge of Extraction Transformation and Loading (ETL) processes using Informatica power center, UNIX shell scripting, Oracle, SQL server, DB2,Tera Data
  • Proficient in several 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
  • Extensive knowledge on the Power Center components as Power Center Designer, Power Center Repository Manager, Workflow Manager and Workflow Monitor.
  • Expertise in working with various operational sources like DB2, SQL server, SAP Application, Oracle, Teradata, Flat Files, XML’s into a staging area.
  • Good Experience in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
  • Experienced in extraction, transformation and load in Salesforce using Informatica Cloud and Informatica Cloud Real Time
  • Develop Shells scripting using notepad ++ and Sublime like IDE for invoke workflows in Informatica Power Center
  • Extraction information from Amazon to generate high - level reports trough Informatica Cloud Tool
  • Experience on mapping and task flows using AWS as S3 connectors
  • Developed PL/SQL Procedures, Functions, Packages, Triggers, Normal and Materialized Views.
  • Experience in several facts of MDM implementations including Data Profiling, Data extraction, Data validation, Data Cleansing, Data Match, Data Load, Data Migration, Trust Score validation.
  • Strong knowledge 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.
  • I worked under scrum methodology life cycle of system.
  • Extensive experience in design of Multi-Dimensional modeling concepts like Star and Snowflakes schema.
  • Good experience on Data conversion projects, And good knowledge 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.
  • Hands on experience in writing, testing and implementation of the triggers, Procedures, functions at Database level using PL/SQL.
  • Involved in Requirements gathering, Logical design model & physical design model meetings to understand the 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 with problem-solving and trouble-shooting capabilities, Quick Learner, highly motivated, result oriented and an enthusiastic team player.
  • Responsible for all activities related to the development, implementation, support of ETL processes for large-scale data warehouses using Power Center.
  • Experience in Debugging and Performance Tuning.
  • Experience in ETL Testing, DB Testing 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, Unix

Programming: PL: SQL, HTML, HTML5, 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.

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

Application Servers: SAP Reports y SAP ABAP, SAP BO

Data Modeling: MS Visio

Scheduling Tools: Control M, Tivoli

EIM Tools: Informatica MDM Multi: domain

PROFESSIONAL SUMMARY:

Confidential

Senior ETL Informatica Developer and Technical Lead

Responsibilities:

  • Worked with 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 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 the data model and data sources.
  • Developing mappings using various cleanse functions to move data into Stage tables
  • Closely worked with other IT team members business partners data stewards 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, Datamarts
  • I was scheduled job in tivoli for execution and invocations from the shell until the workflows in informatica PowerCenter and IDQ
  • I programmed BP's for to send files in trough the Sterling B2B of IBM trough of several server and differents mail boxes.
  • I was migrate all projects of the application of afore Confidential from Datastage to informatica pwercenter version 10.02
  • I did attend new requirements of serveral business areas, like cost, Aladdin, and market to afores and building Etl ‘s in Datastage for to create interfaces for Aladdin Application.
  • Created individual mappings (i.e. Stage jobs) for moving data from landing table to staging tables.
  • Ran the load jobs for moving data from staging tables to the 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 the test data as per test cases.
  • Preparation of test cases and code review document, debugging the defects identified and fixing them.
  • Updating the code into production with proper version.
  • Coordinating with the 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 9.6, Oracle 11g, Informatica Data 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 the 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 the SDLC waterfall methodology
  • Handling Change Requests - Understanding the application work flow in the existing jobs on Informatica and applying new changes to them, testing & review activities
  • Worked with 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 with IICS real time, for generate process and reports with Salesforce application for a response immediate that 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 for for to do data integration for datawarehouse 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 with the Business Users & Enterprise Data Architects in the analysis & design of conceptual and logical data model that is required for solid MDM implementation & ensuring that it meets the business requirements and also supports the products capabilities.
  • Involved in implementing the Land Process of loading the customer Data Set into Informatica MDM from various source systems.
  • Worked w /Data Profiling Team in analyzing the source systems data for duplicative and quality issues.
  • Worked w/ ETL team in configuring the landing tables' structure according to standardization of the 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 with data architect.
  • Using Parameter File for data mapping configuring

Environment: Informatica MDM 9.6.0, Informatica Data Quality (IDQ) 9.6.0, Informatica Power 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 file 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 with Business Analyst and end users to generate Requirement Document according to business needs for Customer Master ORS.
  • Involved in landing the 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 the 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 the target systems.
  • Created Sessions, Tasks, Workflows and worklets using Workflow manager.

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

Confidential

On Site Analyst Developer

Responsibilities:

  • Used the 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 the team.
  • Documented the Purpose of Mapping to facilitate the personnel to understand the process and in corporate the 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 with 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 the various target tables, modify stage to alter the record schema of the input data set
  • Performed ETL Performance tuning to increase the 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 the application.
  • Communication with clients/onshore manager on day to day basis which includes conference calls and written communications.
  • Assisting the Project Management team in providing the estimation of projects. This is an important step where we analyze the requirements and estimate the effort and time by when we could deliver the best solution.
  • Leading the team and ensuring the delivery happens on time with the best quality and least defects.
  • Handling Change requests - Understanding the application work flow in the existing jobs on Informatica and applying new changes to them, testing & Review activities.
  • I created reports in BO from SAP, this reports I populate the tables with informatica PowerCenter and Within the reports I made information crossings to generate sales reports and reports of campaigns of new telephony products, internet and mobile products for the best decision making in the marketing area

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:

  • Operating area Managing Windows and Unix servers
  • Monitoring databases and processes (BATCH Line),
  • Creation of boxes for process execution in CONTROL M,
  • Monitoring ETL processes as well as DTS and Validation Web Services,
  • Had the opportunity to up level to Informatica PC area
  • Participate in the ETL process optimization Exadata,
  • Doing backups of databases in SQL Server and Oracle
  • Extraction of information from AS400.
  • Processes running on (back end’s, batch processes, etc.) servers.

Environment: ; Use Control M for BATCH process monitoring ETL, DTS and SHELLS, backups from SQL Server Management Scripts and Oracle backups using RMAN, Data processing Use Power Center v9.1 for creating ELT in extracting data from various sources databases such as Oracle, SQL Server, and AS400.

Confidential

Junior Analyst

Responsibilities:

  • Validate, monitoring and analyzed routes Security information systems of the Bank
  • Unix-based application validating high sensitive commands,
  • Changes to users, groups and privileges on Windows and Unix
  • Monitoring nationwide
  • Validated and managed databases like Oracle, SQL Server and Sybase are performing
  • Running scripts, test scripts, validation and detection of defects and results,
  • The main activity was the monitoring and validation of the correct use of access systems operating and applications,
  • Meetings to collect information
  • 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.

Hire Now