We provide IT Staff Augmentation Services!

Senior Informatica Consultant Resume

Pleasanton, CA

SUMMARY

  • 7+ years of IT experience with expertise in Design, Development and Implementation of Data Warehouses & Data marts with ETL & OLAP Tools using Informatica Power Center 9.x,8.x, 7.x, Power Exchange 8.x,5.x, SQL Server and Oracle10g/9i/8i.
  • Ability to analyze source systems and business requirements, identify and document business rules, design data architecture.
  • Extensive Knowledge in Dimensional Data modeling, Star Schema modeling, Snow - Flake modeling, Fact and Dimension tables, Physical and logical data modeling using Erwin data modeling tool.
  • Extensively used Informatica Power Center/Power Mart (8.x/7.x) for ETL (Extraction, Transformation and Loading) of data from multiple source systems into Data Warehouse
  • Experience in Performance Tuning of Informatica PowerCenter ETL jobs, Oracle SQL Queries and store procedures.
  • Performed Informatica server administration work, Installations and upgrades.
  • Worked for over three years with Informatica Professional Services team at various client locations.
  • Expertise in using Informatica Webservices, HTTP and XML transformations.
  • Working knowledge of Business Intelligence tool Cognos.
  • Expert in designing most optimized ETL Mapping using Informatica Powercenter, Power Exchange.
  • Strong Experience in writing complex SQL Queries, PL/SQL stored procedures, triggers, creating Tables, Indexes, Views and Materialized Views.
  • Excellent problem solving skills with a strong technical background and good interpersonal skills.
  • Excellent team player, quick learner, ability to work and deliver under tight deadlines.
  • Expertises in UNIX shell scripting, Windows and UNIX operating Systems.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x,8.x/7.x, Power Exchange 8.x

Reporting Tools: Exposure to Cognos, Exposure to Business objects, Data Analyzer

Data Modeling Tools: Erwin 4.0/3.x

Languages: SQL, PL/SQL, C, C++, exposure to Java, UNIX Shell Scripting, Perl

Database/Applications: Oracle 10g/9i/8i, SQL Server2005, DB2,MySQL 5.x

Oracle Utilities: SQL Loader, TOAD, SQL Navigator

Database Skills: Stored Procedures and Packages

Web Technologies: XML, Webservices

Operating Systems: Solaris, HP-UX, Red Hat Linux, MS DOS, Windows NT/2000/XP

PROFESSIONAL EXPERIENCE

Confidential, Pleasanton, CA

Senior Informatica Consultant

Responsibilities:

  • Designed, developed and implemented CDW ETL process
  • Reviewed and approved technical design documents for ETL ahead of implementation
  • Documented ETL and production support transition process
  • Managed and coordinated QA and production releases
  • Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica Designer
  • Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner
  • Worked with various look up cache like Dynamic Cache, Static Cache, Persistent Cache,
  • Re Cache from database and Shared Cache
  • Implemented Slowly changing dimension Type 1 and Type 2 for change data capture
  • Performance tuning of the Informatica mappings using various components like Parameter files, variables and dynamic Cache
  • Designed and developed Oracle PL/SQL scripts for Data Import/Export.
  • Created Mapplets and Reusable Transformations to prevent redundancy of transformation usage
  • Created and Configured Sessions, Worklets and Workflows to load the data into target/s using Informatica Workflow Manager
  • Extensively used debugger to test the logic implemented in the mappings
  • Performed error handing using session logs
  • Tuned performance of Informatica session for large data files by increasing block size, Data cache size and target based commit interval.
  • Developed Shell Scripts for Daily, Weekly and Monthly Jobs which are used for Downloading/Placing Source and Target Files to/From Different Servers.
  • Created Mapplets and Reusable Transformations to prevent redundancy of transformation usage
  • Responsible for Unit & Integration test environments and for data accuracy with consistency throughout its lifecycle
  • Used Informatica Scheduler for scheduling the workflows
  • Developed UNIX shell scripts and Tivoli Job schedules

Environment: Informatica Power Center 9.1/8.6, Oracle 10G, MySQL 5.1/5.5, PLSQL, Flat files, UNIX, Tivoli, HP Quality Center, Share point, VSS, Toad

Confidential, Simi Valley, CA

Senior Informatica Developer

Responsibilities:

  • Developed data Mappings between source systems and warehouse components using Mapping Designer
  • Worked extensively on different types of transformations like source qualifier, expression, Filter, aggregator, update strategy, lookup, stored procedure, joiner, XML Source Qualifier
  • Setup folders, groups, users, and permissions
  • Created, launched & scheduled sessions. Involved in Performance Tuning of Informatica.
  • Extensively Worked with External Loader (Fast Load) connections through workflow manager to load the Target tables
  • Done ETL mapping unit testing, UAT and also developed test plans
  • Developed several reusable transformations and mapplets that were used in other mappings
  • Developed test procedures to compare the aggregates of source and target databases.
  • Mappings were designed to cater the slowly changing dimensions (S.C.Ds)
  • Worked on the server manager to run several sessions and batches concurrently and sequentially
  • Wrote PL/SQL Packages and Stored procedures to implement business rules and validations
  • Documented all the ETL processes infrastructure related documents
  • Performed Production Support for ETL processes

Environment: Power Center 8.6.1, Oracle 10g, DB2, Flat File, Scheduling tool LSF, UNIX Shell Programming, PL/SQL, VSS

Confidential

ETL Informatica Developer

Responsibilities:

  • Involved in detail design and development of mappings using Informatica power center
  • Analyzed the Sources and Targets and designed complex mappings and Transformations
  • Interact with business analysts and translate business requirements into technical specifications
  • Worked on several transformations such as Filter Transformation, Joiner Transformation, Sequence Generator Transformation, Aggregator Transformation, Source Qualifier Transformation, Expression Transformation, Lookup Transformation (Connected and Unconnected), Stored Procedure Transformation (Connected and Unconnected), Joiner Transformation, Router Transformation and Normalizer Transformation in Informatica.
  • Created and Configured Sessions, Worklets and Workflows to load the data into target/s using Informatica Workflow Manager
  • Developed Power Exchange Data maps for loading data from Mainframe (VSAM and SEQ) files into DB2 UDB staging tables
  • Prepare unit and integration test plans, code review, testing, debugging (using Debugger) and deployment of Informatica jobs into production environment
  • Used Third party Scheduler tools to schedule workflows, Unix scripts and Pl/SQL procedures
  • Developed test plan, strategy, test scenarios and test cases
  • Prepared the test execution plan and tracking the execution plan
  • UNIX Shell scripts to abort the job upon critical warnings

Environment: Informatica (Power Center) 7.1, DB2, SQL Server 2005, VSAM Files, UNIX, Oracle 8i, PL/SQL

Hire Now