We provide IT Staff Augmentation Services!

Informatica Lead Developer Resume

Madison, WI

SUMMARY

  • Around Eight yearsof professional IT experience.
  • Solid experience in Data warehousing field specifically Data Modeling, Informatica 8.X,SQL SERVER 200/2005,SSAS,SSRS,Oracle 9i,10g.
  • Experience in Financial Domain and worked as Team Lead
  • Expert in Creating Data Models with Kimball and Bill Inmon methods.
  • Created Star & Snow flake schemas for ODS and EDW.
  • Expert in ETL tools like Informatica Power Exchange, Power Center
  • Six years of experience usingBusiness Intelligence Tools - SSAS,SSRS and Informatica.
  • Expertise in using Informatica client tools - Designer, Repository Manager, Repository Server Administration Console,Workflow Manager and Workflow Monitor
  • Expertise intesting, debugging, validation and tuning of mappings, sessions and workflows in Informatica
  • Experienced indevelopment and providing supportfor major as well as minor releases involving Informatica products
  • Solid experience in analyzing and fixingProduction issuesin teh current Informatica Applications
  • ExcellentData Modeling, Analysis, Data Miningskills.
  • In-depth understanding of Data warehousing concepts such asKimball’s methodology, OLAP, SCDs(type1,type2 and type3), starschema and snowflake schema
  • Extensivelyworked onOracle database 9i,10g and SQL Server
  • Strong programming and debugging skills inPL/SQL, SQL and Unix shell scripting
  • Experienced in developing complexpackages, procedures, functions, triggers, views.
  • In-depth understanding ofObject Oriented Programming concepts
  • Experienced increating Data Modelsusing data-modeling toolErwin
  • Experience with Oracle Designer for data modeling
  • Extensive experience in entireSDLC
  • Proven track-recordin trouble shooting of database applications
  • Extensive production support experience including day to day monitoring of Informatica jobs
  • Experienced in working in Global delivery model and leading teh team
  • Fluent in English.Excellent inter-personal communication skills.Solid team player

TECHNICAL SKILLS

Data Modeling Tools: Erwin 4.0/3.5, Star Schema Modeling, Snow Flake Modeling

Data Warehousing ETL Tools: Power Center 8 .X, Informatica Power Exchange 8.X, Code based ETL programming

Databases: Oracle 8i/9i/10g, SQL Server

Methodologies: Star Schema, Snowflake Schema

Business Intelligence Tools: SSAS and Hyperion Essbase

Reporting Tools: SSRS

Languages: PL/SQL, SQL, Unix shell scripting.

Web Tools: HTML, DHTML, XML, VB SCRIPT

Operating Systems: UNIX, Linux, Microsoft 2003/2000/ NT/98/95

Defect tracking Tool: Qubase

Change Management tool: CVS

Version Control Tool: MS Visual SourceSafe

Job scheduling Tool: Cron job, Windows scheduler

Others: MS Word, Excel, VISIO 2007

PROFESSIONAL EXPERIENCE

Confidential, Madison, WI

Informatica Lead Developer

Responsibilities:

  • Worked on Informatica installation on AIX and configuration.
  • Business requirements gathering and preparing technical specifications documents.
  • Extensively worked on Process Design, Development and Testing
  • Trained DWH team on informatica 9.1
  • Effectively interacted with Business Users in analyzing teh data quality issues reported.
  • Extensively worked on debugging teh programs for data quality issues and job failures
  • Worked on creating shell script for enhancement in teh current application.
  • Completed teh performance tuning in teh current process and finally reduced teh job run time considerably.
  • Developed Stored Procedures, Packages and Functions.
  • Assisted in all aspects of teh project to meet teh scheduled delivery time.
  • Provided Knowledge Transfer to teh end users and created extensive documentation on teh design, development, implementation and process flow of teh application
  • Conducted unit testing of teh enhacements done.
  • Worked as a part of a team and provided 7 x 24 Support when required.
  • Involved in enhancements and Production Support.

Environment: Informatica,Oracle 10g,PL/SQL,COGNOS and UNIX Shell scripting

Confidential, Ft Lauderdale, FL

Informatica Lead Developer

Responsibilities:

  • Extensively worked on Process Design, Development, Testing and Implementation of teh Project.
  • Effectively interacted with Business Users in analyzing teh data quality issues reported.
  • Created Technical design specification documents for implementing teh solution for new countries.
  • Extensively worked on debugging teh programs for data quality issues and job failures
  • Worked on creating shell script for enhancement in teh current application.
  • Completed teh performance tuning in teh current process and finally reduced teh job run time considerably.
  • Developed Stored Procedures, Packages and Functions.
  • Assisted in all aspects of teh project to meet teh scheduled delivery time.
  • Provided Knowledge Transfer to teh end users and created extensive documentation on teh design, development, implementation and process flow of teh application
  • Conducted unit testing of teh enhacements done.
  • Worked as a part of a team and provided 7 x 24 Support when required.
  • Involved in enhancements and Production Support.

Environment: Informatica,Oracle 10g,PL/SQL,UNIX Shell scripting and Pro*C

Confidential, Jersycity,NJ

ETL Tech Lead/onsite co-ordinator

Responsibilities:

  • Actively involved in understanding teh business requirements and converting them into design documents.
  • Designed teh ETL processes using Informatica to load data from Oracle,SQL Server, Flat Files (Fixed Width and delimited) into Staging tables.
  • Created Mappings and Mapplets using Informatica Designer and processing tasks using Workflow Manager dat populated teh Data into teh Targets on Oracle 11g Instance and involved in Performance tuning of targets, sources, mappings and sessions
  • Extensively used Source Qualifier Transformation to filter data at Source level rather TEMPthan at Transformation level and used different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator in extracting data in compliance with teh business logic developed.
  • Created Informatica mappings with stored procedures to build and load cross reference tables
  • Developed ETL mappings, transformations using Informatica Power center 8.6.Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
  • Used Mapplets and Reusable Transformations prevent redundancy of transformation usage and maintainability
  • Generated Flat file Targets and Reports for teh target team with Header and Tailers.
  • Created database objects including tables, indexes, views, materialized views, constraints, jobs, snapshots, table partitioning and development of SQL, PL/SQL, stored procedures, triggers and packages and troubleshooting and performance tuning PL/SQL and SQL.
  • Involved in enhancements and maintenance activities including performance tuning, writing of stored procedures for code enhancements, creating aggregate tables, and modifying target tables.
  • Proficient in Performance Tuning, Troubleshoot of sources, targets, PowerCenter transformations and sessions using techniques like Explain plans, Oracle hints, changing session parameters, re-designing teh mappings, using test loads.
  • Responsible for monitoring all teh sessions dat are scheduled, running completed and failed. Involved in debugging teh Mappings dat failed.
  • Provided support for Dev/SIT/UAT/Prod runs to analyze and fix teh issues in Runtime.
  • Involved in setting up teh Dev/UAT UNIX Environment and Created UNIX shell scripts to run teh workflow from Unix and created PL/SQL procedures, pre-session and post-session scripts to ensure timely, accurate processing and ensure balancing of job runs.
  • Extensively worked SSAS and MS-OLAP in building cubes
  • Performed Disaster Recovery activity to ensure teh systems availability during un expected events.
  • Involved in planning and migration of servers from one Data Centre to another data centre.

Environment: Informatica Power Centre 8.6.1, Oracle 10g,MS SQL Server 2000/2005, Sun Solaris 5.10 Unix, SQL, PL/SQL,Hyperion Essbase,SSAS and Cognos.

Confidential

Informatica Developer

Responsibilities:

  • Involved in understing teh DTS packages and preparing design documents to prepare informatica workflows
  • Involved in understing teh SQL Server database objects and converting design documents for creating Oracle Objects.
  • Designed teh ETL processes using Informatica to load data from Flat Files (Fixed Width and delimited) to staging database and from staging to teh target Data Mart.
  • Involved in preparing shell script for running informatica workflows.
  • Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup Connected/Unconnected, and filter.
  • Implemented teh best practices for teh creation of mappings, sessions and workflows and performance optimization.
  • Used Workflow Manager for creating, validating, testing and running teh sequential and concurrent sessions and scheduling them to run at specified time and as well to read data from different sources and write it to target databases.
  • Query Optimization for improving teh performance of teh data warehouse.
  • Involved in performance tuning of teh mappings, sessions and workflows.
  • Used session parameters and parameter files to reuse sessions for different relational sources or targets.
  • Created documentation on mapping designs and ETL processes.
  • Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis.
  • Involved in Unit testing, User Acceptance Testing to check whether teh data is loading into target, which was extracted from different source systems according to teh user requirements.
  • Involved in implementing teh solution at onsite in Brussels Belgium.

Environment: Informatica Power Centre 8.6, MS SQL Server 2000, DTS, Oracle 10g and UNIX.

Confidential

Informatica Developer

Responsibilities:

  • Involved in Logical and Physical Database design and Star Schema design. Identified Fact tables, and Dimensional tables.
  • Designed and developed end-to-end ETL process to add data from various source systems.
  • Extensively involved in business and functionality of teh system, understanding source systems and requirement analysis through FRD’s.
  • Developed mappings, workflows to extract data from various sources like oracle and flat files,.
  • Created source and target definitions based on teh data in teh flat files.
  • Implemented SCD feature in informatica
  • Developed number of complex Informatica mappings
  • Used various transformations like filter, expression, sequence generator, update strategy, joiner, stored procedure, normalizer and union to develop robust mappings using teh informatica designer.
  • Developed reusable transformations and mapplets to implement teh common business logic.
  • Created sessions, configured workflows to extract data from various sources to loading into data warehouse.
  • Designed and developed complex Procedures, Functions & Packages to handle errors and exceptions at database level using PL/SQL

Environment: Oracle 9i, Informatica Power Centre 8.1, and UNIX.

Confidential

Informatica Developer

Responsibilities:

  • Review teh logical structure of teh datamodel to understand teh current system.
  • Prepared teh understanding documents after reviewing teh SQL Server system.
  • Involved in teh gathering teh new requirements to add it in teh Oracle system .
  • Worked on covering teh logic present in SQL Server stored procs to Oracle procedures.
  • Involved in preparing teh informatica mappings and workflows by reviewing teh logic present in DTS packages.
  • Tuning teh informatica mappings to obtain teh better performance TEMPthan teh DTS packages in SQL Server.
  • Used Oracle Performance Tuning of SQL queries & Views using Explain Plan, SQL Trace & TKPROF utilities.
  • Prepared teh test plans and executed to match teh data between teh SQL Server and Oracle systems
  • Supported teh project in production in teh initial days

Environment: Informatica Power Centre 8.1,SQL Server 2000,DTS,Oracle 9i and UNIX.

Confidential

Data Warehouse Developer

Responsibilities:

  • Translate Business Requirement into design documents.
  • Created teh database objects in SQL Server 2000
  • Developed stored procedures in SQL Server
  • Created teh design documents.
  • Created teh DTS packages to load data from flat files into SQL Server database.
  • Involved in preparing and executing teh UTPs and system test plans.

Environment: SQL Server 2000,DTS.

Hire Now