We provide IT Staff Augmentation Services!

Etl/informatica Developer Resume

Maha, NE

SUMMARY

  • Around 2+ years of IT experience and extensive ETL tool experience using Informatica Power Center 10.x/ 9.x/8.x with strong working experience in Oracle SQL, PL/SQL.
  • Responsible for all phases of the System Development Life Cycle (SDLC), from Requirement gathering Analysis, Design, Development, Production in various industries viz., Insurance, Finance, Telecom, Retail.
  • Strong understanding of the principles of DWH using Fact Tables, Dimension Tables and Star Schema modeling using Ralph Kimball and Bill Inman Methodologies Expertise in working with data modelers to translate business rules/requirements into logical and physical models using Erwin tool.
  • Proficient in the Integration of various data sources like Oracle11g/10g, COBOL and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
  • Extensively worked with Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalize, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and XML Source Qualifier.
  • Expertise in developing Mappings and Mapplets, Sessions, Workflows, work lets and Tasks using Informatica.
  • Very strong experience in Informatica Power centre suite which includes Designer, Workflow Manager, Workflow Monitor and Repository Manager.
  • Experience in integration of various data sources with Multiple Relational Databases like Oracle, Teradata, SQL Server and Worked on integrating data from flat files like fixed width, delimited, CSV,HL7(health level) and EPIC EXT Files.
  • Expertise includes Data Modeling, Data Cleansing, and Transformation, Integration, Data import, Data export, Data stage and use of ETL tool including Informatica.
  • Developed logical data models and physical data models.
  • Proficient in developing Slowly Changing Dimension Mappings of type I, II and type III.
  • Experience in all stages of ETL - requirement gathering, designing and developing various mappings, unit testing, integration testing and regression testing.
  • Experience in resolving on-going maintenance issues and bug fixes, monitoring Informatica sessions as well as performance tuning of mappings and sessions.
  • Implemented RelationalModeland DimensionalModelforDataMarts and generated DDL scripts.
  • Expertise in creating Complex Informatica Mappings and reusable components like Reusable transformations, Mapplets, Work lets and reusable control tasks to work with reusable business logic.
  • Having good knowledge on different data provisioning techniques likeSAPLandscape Transformations (SLT) and Data Services (DS).
  • Excellent track record in working various types of projects, OLTP, Data Warehousing, Business Intelligence.
  • Excellent exposure on Oracle Partitioning including Range partitions, List Partitions.
  • Expertise in Dynamic SQL, Collections and Exception handling.
  • Good Experience in Performance tuning of the Queries and attacking the bottlenecks of the applications.
  • Expertise in unit testing of Informatica mappings using debugger.
  • Experience in Performance Tuning and Debugging of existing ETL processes.
  • Expertise working with PL/SQL Stored Procedures, Cursors, Functions and Packages.
  • Worked with UNIX shell scripting for enhancing the job performance.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 10.x/9.x/8x(Workflow Manager, Workflow Monitor, Source Analyser, Mapping Designer, Mapplet Designer, Transformation developer), Informatica MDM, DWH, SSIS

Scheduling Tools: Control-M, Autosys

Languages: C, C++,Java, SQL, PL/SQL

RDBMS: Oracle 11g/10g, DB2, Teradata 14/13, SQL Server, Exadata, Mata data

Tools: /Utilities: Toad, Perl, UNIX Shell

Operating Systems: Windows, UNIX, Linux

Web Technologies: HTML, CSS, XML, JAVA SCRIPT

PROFESSIONAL EXPERIENCE

Confidential, Omaha, NE

ETL/Informatica Developer

Responsibilities:

  • Analyzed the business requirements and framing the business logic for the ETL process.
  • Designed and Developed complex mappings, reusable Transformations for ETL usingInformatica Power Center 9.
  • Currently working on Enterprise wide Data Warehouse for CMS (Healthcare Project) on Informatica and DB2.
  • Created complex SCD type 1 & type 2 mappings using dynamic lookup, Joiner, Router, Union, Expression and Update Transformations also implementing CDC usingInformaticaPower Exchange 8.x/9.x.
  • Designed and developed mappings using Source Qualifier, Aggregator, Joiner, Router, Lookup, Sequence Generator, Stored Procedure, Expression, Filter, Rank and XML Transformations.
  • This project involves the development ofInformaticasolution with source as file and target database asgreen plumfor their reporting and analytical purposes.
  • Extensively used Change data capture concept inInformaticaas well as in the Oracle Database 10g to capture the changes to the data mart.
  • Change data capture enabled us to reduce the time taken to load the data into the data mart by allowing only the changed data.
  • DevelopedSSISPackages for migrating data from Staging Area of SQL Server 2008 to SQL Server 2014.
  • Worked on extracting data from the heterogeneous source systems like MS SQL Server, Oracle,HL7Files and loading into Landing Layer and then to Data Warehouse
  • Working on Dimension as well as Fact tables, developed mappings and loaded data on to the Relational database.
  • Developed variousPL/SQLprocedures and functions as per the client requirement.
  • UsedSQL* loader to load data from flat files to database.
  • Handling various exceptions to troubleshootPL/SQLcode.
  • Created new tables, views, Indexes and complex queries using Joins, Sub queries to meet the requirements.
  • Experience in working with Code migration, Data migration and Extraction/Transformation/ Loading usingInformaticaPowerCenter andPowerExchangewith Oracle, SQL Server, Teradata, XML, Flat files, and Cobol on UNIX, Windows.
  • Worked on Healthcare and retail domains.
  • Written SQL overrides in source Qualifier according to business requirements.
  • Implemented variables and parameters in the mappings.
  • Created workflows and work lets for designed mappings..
  • Generated completion messages and status reports using workflow manager.
  • Involved in writing ETL specifications and unit test plans for the mappings.
  • Redesigned some of the mappings in the system to meet new functionality.
  • Used workflow Monitor to monitor the performance of the Jobs.
  • Extensively worked in the performance tuning of the ETL process.
  • Involved in writing procedures, functions in PL/SQL.
  • Involved in maintaining and granting the privileges for read and write operations.

Environment: InformaticaPower Center 10.x, 9.x, Informatica MDM HUB, Exadata, Teradata, Oracle 10g/11g, DB2, SQL Server, Erwin, Windows XP, UNIX.

Confidential, Irving, TX

ETL/Informatica Developer

Responsibilities:

  • Interacted with business to gather requirements, to understand the Business Requirements and Business Rules
  • Subjected to Business, analyzed the data and delivered the client expectation.
  • Prepared ETL Specifications to help develop mappings.
  • Developed and maintained ETL (Data Extract, Transformation and Loading) mappings to extract the Data from multiple source systems like Oracle and Flat Files and loaded into Oracle.
  • UsedPowerExchangeto source copybook definition and then to row test the data from data files, VSAM files.
  • Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the requirements.
  • Maintained WarehouseMetadata, naming standards and warehouse standards for future application development.
  • Fixed the issues with special characters in theGreen plummappings resulted saving of 30% time in daily streams.
  • Worked on Informatica Power Centertools like Source Analyzer, Target Designer, Mapping Designer, Workflow Manager, and Workflow Monitor.
  • Worked onFACETSData tables and created audit reports using queries and Re-engineering and capturing of transactions with legacy systems.
  • Designed and developed ETL and Data Quality mappings to load and transform data from source to DWH usingPowerCenter and IDQ.
  • Developed SQL overrides in Source Qualifier/Lookup according to business requirements.
  • Designed and Developed mappings by using Lookup, Expression, Filter, Update Strategy, Aggregator, Router, transformations to implement requirement logics while coding a Mapping.
  • Tuned the Sources, Targets, Transformations and Mapping to remove bottlenecks for better performance.
  • Performed tuning of Informatica sessions by implementing database partitioning, increasing block size, data
  • Cache size, sequence buffer length, target based commit interval and SQL overrides.
  • Createdpre-session and post session scripts using UNIX/PL-SQL.
  • Tuned the Sources, Targets, Transformations and Mapping to remove bottlenecks for better performance.
  • Involved in scheduling the UNIX shell scripts which runs Informatica workflows usingControl-M jobs.
  • Documented the process for further maintenance and support.

Environment: Informatica Power Center 9.x, Oracle 10g, Delimited Flat Files, Metadata Manager, Exadata, SSIS, Teradata, Facets, PL/SQL, Toad 10.6, UNIX, Win SCP, and Control-M.

Hire Now