We provide IT Staff Augmentation Services!

Informatica Etl Developer Resume

Exton, PA

SUMMARY:

  • Over 6 years of IT experience with strong expertise in design, development and implementation of software applications in Data Warehousing using Informatica PowerCenter 9.1/8.6/ 8.1.1.
  • Strong experience in designing, creating of mapping documents for data loading into Data Warehouse.
  • Proficient Knowledge in Informatica Power Center tools like Designer, Workflow Manager, Workflow Monitor and Repository Manager for migrating.
  • Expertise in implementing complex Business rules by creating robust Mappings / Mapplets, reusable Transformations and Tasks.
  • Experience in creating Complex workflows and Worklets using Informatica 9.x & 8.x.
  • Implemented Slowly Changing dimensions Type1, Type2 & Type 3 methodology for accessing the current snapshot and full history.
  • Experience with SQL Developer as an interface to databases, to analyze, view and alter data.
  • Extensively used SQL and PL/SQL to write Stored Procedures, Functions and Package.
  • Team Player with the ability to communicate effectively at all levels of the development process
  • Exceptional analytical and problem solving skills.
  • Experienced in Full Life Cycle Development of building applications including analysis, design, development, testing and documentation.
  • Extensive experience in Extraction, Transformation and data loading from different heterogeneous source like Oracle, SQL Server, Flat files & XML files.
  • Flexible and Versatile can adapt to any new environment and learn fast with excellent communication, interpersonal skills, analytical and problem solving skills.
  • Extensive experience in UNIX and shell scripting.
  • Extensive experience in Autosys tool for scheduling jobs

TECHNICAL SKILLS:

Operating Systems: Windows 2008/XP, Unix, Linux

ETL Tools: Informatica 9.x, 8.x

Packages: SQL* PLUS, Toad 7.x

Applications: MS Word, Excel and PowerPoint

Web technologies: HTML

Data Bases: Oracle, MS SQL Server

Languages: SQL, Pl/SQL, Unix Shell Scripting

Testing Tools: HP Quality Center

Scheduling Tools: AutoSys

PROFESSIONAL EXPERIENCE:

Confidential, Exton, PA

Informatica ETL Developer

Responsibilities:

  • Involved in client meetings for the development and implementation of the business requirement.
  • Preparing the Technical specification document for the mappings, jobs and their reviews.
  • Designed and developed the mappings to move the data from the source systems and populate the data tables in the Oracle 11g database.
  • Prepared the mapping documents which will represent the mapping rules and business logic.
  • Used different type of transformations to implement the business requirement logic correctly.
  • Used Workflow Manger, Workflow Monitor to test the mapping in DEV before migrating to different environments.
  • Prepared the Test cases and Unit Test plans for the mappings.
  • Daily monitoring the scheduled jobs using Autosys.
  • Finding the reason for any failure of the jobs and alert the respective teams.
  • Maintaining the supporting document for the failure and reviews for the action plans.
  • Prepare the required unit test cases for assigned modules.
  • Self Review of Unit test cases, Integration test cases of all the assigned modules.
  • Do the detailed unit/integration testing.
  • Peer to Peer Review of Test Cases.

Environment: Informatica Power Center 9.6.1, Oracle 11g, PL/SQL, SQL*Plus, SQL*Loader

Confidential, Wilmington, Delaware

Informatica ETL Developer

Responsibilities:

  • Developed various Mappings with the collection of all Sources, Targets, and Transformations using Designer.
  • Participated in all phases including Requirement Analysis, Client Interaction, Design, Coding, Testing and Documentation.
  • Worked extensively with mappings using expressions, aggregators, filters, lookup and stored procedures transformations.
  • Partitioned sources to improve session performance.
  • Designed and built Data Marts for home and business insurance divisions.
  • Migrated the Metadata changes to the Informatica Repository.
  • Taking the Backup of Repository on regular intervals depending on the amount of work done.
  • Extracted huge volumes of data from legacy systems and uploaded into Oracle using SQL*Loader and PL/SQL.

Environment: Informatica Power Center 9.1.0, Oracle 10g, PL/SQL, SQL*Plus, SQL*Loader

Confidential, Edison, NJ

Informatica ETL Developer

Responsibilities:

  • Involved in gathering requirements and translating to technical specifications.
  • Worked on complete SDLC from Extraction, Transformation and Loading of data using Informatica.
  • Wrote stored procedures, functions, and packages in Oracle PL/SQL along with Informatica ETLs to address data warehousing needs.
  • Implemented Oracle partitions to organize data for performance.
  • Created Oracle bitmap indexes.
  • Involved in star schema modeling and ETL architecture for data warehouse.
  • Addressed capacity planning needs and frequent database and ETL tuning requirements.
  • Interacting with QA team for testing.
  • Worked with the other development team.
  • Created mappings to move from Various Systems (CRM, OLTP) to Transaction History database (Reporting Database).
  • Used pmcmd command for running Informatica through UNIX shell script and automated using scheduler tools.
  • Responsible for creating business solutions for Incremental and Full loads.

Environment: SCO UNIX, Informatica Power Center 8.1.0, Oracle 10g, SQL*Plus, TOAD 8.6.1

Confidential, Edison, NJ

Jr Informatica ETL Developer

Responsibilities:

  • Involved in the design, development and implementation of the Enterprise Data Warehousing (EDW) process and Data Mart.
  • Used Informatica PowerCenter 6.2 for migrating data from various OLTP servers/databases to the data mart.
  • The data migration included identifying various databases where the information/data lay scattered, understanding the complex business rules that need to be implemented and planning the data transformation methodology.
  • Used relational sources and flat files to populate the data mart.
  • Translated the business processes into Informatica mappings for building the data mart.
  • Created complex Informatica mappings to load the data mart and monitored them. The mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner, Sequence generator.
  • Used Lookup Transformation to access data from tables, which are not the source for mapping and also used Unconnected Lookup to improve performance.
  • Configured the mappings to handle the updates to preserve the existing records using Update Strategy Transformation.
  • Defined Target Load Order Plan and Constraint based loading for loading data correctly into different Target Tables.
  • Used Debugger to test the mappings and fix the bugs.

Environment: Windows 2000, Informatica PowerCenter 8.1.0, Oracle 9i, SQL*Plus, TOAD.

Confidential, Santa Clara, CA

Jr Informatica ETL Developer

Responsibilities:

  • Business Requirements gathering and analysis provided by the client, preparation of functional specifications and design documents.
  • Performed extensive data analysis along with subject matter experts and identified source data and implemented data cleansing strategy.
  • Prepared technical specifications for the development of Informatica (ETL) mappings to load data into various target tables and defining ETL standards.
  • Worked with various Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer, Informatica Repository Manager and Workflow Manager.
  • Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
  • Created, Tested and debugged the Stored Procedures, Functions, Packages, Cursors and triggers using PL/SQL developer.
  • Involved in Unit testing, System testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.

Environment: Windows 2000, Informatica PowerCenter 8.1.0, Oracle 9i, SQL*Plus, TOAD.

Hire Now