SUMMARY

• Over 8+ Years of extensive experience on ETL informatica Power Center with strong business understanding and knowledge of Extraction, Transformation and Loading of data from heterogeneous source systems like Flat files, Excel, XML, Oracle, Sybase, SQL Server.
• Extensively involved in ETL Data warehousing using informatica Power Center 9.1, Designer tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
• Extensively worked on transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Normalizer, Update Strategy, Sequence Generator and Stored Procedure transformations.
• Hands on experience in identifying and resolving performance bottlenecks in various levels like sources, mappings and sessions. Hands on experience in optimizing SQL scripts and improving performance loading warehouse
• Strong work experience in Business Requirements Analysis, Designing, coding and testing of Data Warehousing implementations.
• Experience in designing and developing mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
• Experience in coding using Oracle 10g/9i/8i, Teradata, SQL Server 2005/08, SQL, PL/SQL procedures / functions, triggers and exceptions. Good experience in Relational Database Concepts, Entity relational Diagrams.
• Strong experience on Data Design/Analysis, Business Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.
• Very strong in writing SQL Joins, Nested Queries, Unions, Multi - table joins.
• Enhanced performance forInformaticasessions by using physical pipeline partitions and Parameter Files.
• Strong knowledge of software development life cycle (SDLC).
• Worked on automating theInformaticajobs,InformaticaScheduler, Autosys, and UNIX scripts for automation.
• Experienced in integrating from various data sources like Flat Files, XML files, databases (Teradata, Oracle, SQL Server, Sybase, DB2 and MS Access) and handling large volumes of data.
• Good Experience in writing, testing and implementation of the triggers, stored procedures, functions, packages at database level using SQL, PL/SQL.
• Expertise in OLAP/OLTP System Study, Analysis and E-R Modeling, developing database Schemas like Star Schema, Snowflake Schema, Conforming Dimensions and Slowly Changing Dimensions used in relational, dimensional and multi-dimensional modeling.
• Experienced in preparing Technical design document, mapping documents, data definition documents and Detail design document for the Source/Target mapping.
• Excellent problem solving skills with a strong technical background with good communication and interpersonal skills

TECHNICAL SKILLS

Data Warehousing: InformaticaPower Center … InformaticaDesigner, Workflow Manager, Work flow Monitor, Datamart, Mapplet, Transformations, Autosys, Database applications (Teradata Sql assistant, SQL * Plus etc..)

Data Analysis: Requirement Analysis, Business Analysis, detail design, data flow diagrams, data definition table, Business Rules, data modeling, Data Warehousing, system integration.

Data Modeling: Dimensional Data Modeling (Star Schema, Snow-Flake, FACT-Dimensions), Conceptual Physical and Logical Data Modeling, ER Models, OLAP, OLTP concepts

Databases: Teradata, Oracle 10g/9i/8i, MS SQL Server … MS Access, Sybase, DB2

Programming: SQL, PL/SQL, SQL Plus, Unix Shell Scripting, C

Environment: Win … Unix.

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Informatica Lead Developer

Responsibilities:

• Performed major role in understanding the business requirements and designing and loading data into data warehouse (ETL).
• Involved in Project Planning & Design phase
• Designed and developed complex Look up, Sequence Generator, Aggregator, Joiner, Router, Rank, External Procedures and Update transformation rules (business rules).
• Extensively usedInformaticaClient tools - Power Center Designer, Workflow Manager, Workflow Monitor and Repository Manager
• Extracted data from various heterogeneous sources like Teradata, Oracle, Sybase, SQL Server, DB2 and Flat Files.
• Extracting data from Oracle and Flat file, Excel files and performed complex joiner, Expression, Aggregate, 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.
• Worked with Data modeler in developing STAR Schemas
• Involved in performance tuning and query optimization.
• Used SQLDeveloperto develop and debug procedures and packages.
• Involved in developing the Deployment groups for deploying the code between various environment (Dev, QA)
• Created pre sql and post sql scripts which need to be run atInformaticalevel.
• Worked extensively with session parameters, Mapping Parameters, Mapping Variables and Parameter files for Incremental Loading
• Used Debugger to fix the defects/ errors and data issues.
• Expertise in using both connected and unconnected Lookup Transformations.
• Extensively worked with various Lookup caches like Static cache, Dynamic cache and Persistent cache.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
• Monitored and improved query performance by creating views, indexes and sub queriesExtensively involved in enhancing and managing Unix Shell Scripts.
• Developed workflow dependency inInformaticausing Event Wait Task, Command Wait.
• Managed 25 member in a team.
• Coordinate with other application teams, in order to avoid production job conflicts due to dependency

Environment: InformaticaPower Center 9.1, Teradata, Oracle 11i, SQL Server 2008, Sybase, DB2, UNIX, Winscp, Putty, Erwin 7.2, SQL, PL/SQL

Informatica Developer

Confidential

Responsibilities:

• Worked closely with business analysts to gather the requirements.
• Developed mappings, sessions and workflows in Informatica Power Center
• Worked withInformaticapower center, oracle 10g, DB2 Flat files and other sources to integrate data and also worked in Data warehouse Development life cycle.
• UsedInformaticafeatures to implement Type I, II changes in slowly changing dimension tables and also developed complex mappings to facilitate daily, weekly and monthly loading of data.
• According to transformation logic, we used various transformations like sorter, aggregator, lookup, Expression, filters, Update Strategy, Joiner, Router etc. in Mappings.
• Configured the Reusable command task for sending the triggers, invoking different scripts and Reusable Email tasks for sending failure mail along with session details and appending logs with it and success mails. Also used Event wait, Event Raise, Scheduler options in the workflows.
• Developed SQL, PL/SQL, Stored Procedures for Implementing Complex Business Rules, Transformations and Loading.
• Tuned various sql queries, mappings, targets and sources to improve the performance.
• Used session and workflow logs for debugging the session.
• Used debugger wizard to remove bottlenecks at source level, transformation level, and target level for the optimum usage of sources, transformations and target loads.
• Created reports for the daily and weekly status meetings.
• Trouble shoot of long running sessions and fixing the issues.
• Configured the workflows for running concurrently, used various types of migration techniques for moving code to Test environment from Development environment
• Performance tuning on sources, targets mappings and SQL (Optimization) tuning.
• Worked with the QA team to resolve and fix the defects found.

Environment: InformaticaPower Center 9.1, Oracle 11g/10g, SQL Server 2008, PL/SQL, DB2, Windows XP, UNIX.