SUMMARY

• Over 7 years of experience in Information Technology in requirement gathering, data analysis, design, development of software applications and expertise in Data warehousing solutions.
• Around6years of experience in Informatica Designer Components Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor using Informatica Power Center 9.x/8.x/7.x/6.x.
• Developed Mappings using Informatica Power Center Transformations - Connected AND UnConnected Lookup, Filter, Expression, Router, Joiner, Update Strategy, Aggregator, Stored Procedure, Sorter, Sequence Generator.
• Extensively worked on Data extraction, transformation, loading wif Oracle, Teradata, SQL Server and Flat Files using Informatica.
• Solid understanding and experience in Dimensional Data modeling, star join schema/snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling using ERWIN 4.x.
• Experienced in working wif Teradata Utilities like Fastload, Multiload, Tpump and Fast Export. Also worked extensively on Teradata Query Submitting and processing tools like Bteq and Teradata SQL Assistant (Queryman).
• Strong Knowledge of Teradata RDBMS Architecture.
• Expert in teh design, development and implementation of RDBMS like SQL Server /2000 / Oracle10g/9i/8.0 / Teradata.
• Developed reusable Transformations and Mapplets by using Mapplet designer.
• Worked on Slowly Changing Dimensions (SCD’s) and its implementation to keep track of historical data.
• Proficient in troubleshooting, problem solving, Testing & Debugging errors using Informatica Debugger.
• Experience in performance tuning of sources, transformations, targets, mappings, worklets, workflows, and sessions.
• Experienced in writing PL/SQL Procedures, Functions, Packages, Stored and tuning on queries while extracting and loading data.
• Involved in migration/conversion of ETL processes from development to production environment.
• Experience in developing Shell scripts on UNIX and experience wif UNIX command line.
• Identified and debugged teh errors before deploying and worked on migration of teh maps and workflows from development to testing, testing to QA and from QA to production.
• Excellent problem solving, analytical, written and communication skills wif ability to work both in team as well as an individual.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.1/8.x/7.x, (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor and Informatica Server) ETL

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWIN.

Databases: Oracle 10g/9i/8.0, MS SQL Server 2000/2005/2008, Teradata,DB2

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

Tools: TOAD, SQL*Plus, Excel, Word, Autosys, Control-M

Environment: WINDOWS 95/98, WINDOWS- NT/2000/XP Professional, MS-DOS, UNIX, Sun Solaris and HPAIX.

PROFESSIONAL EXPERIENCE

Confidential, St Louis, MO

Informatica Developer/Teradata Developer

Responsibilities:

• Participated in Business and Specification requirements gathering sessions.
• Create Technical Design document, Source to Target mapping documents based on teh Business requirement.
• Worked wif business analysts to identify appropriate sources for data warehouse and to document business needs for decision support for data.
• Participated in Data profiling to check teh consistency of data and to validate teh business requirements.
• Used all teh Informatica power center 9.1.0 client components like Designer, Workflow Manger, Workflow Monitor
• Loaded data from various sources (Flat files, Oracle, SQL Server) using different active and passive transformations and transformations like Source Qualifier, Joiner, Router, Sorter, Aggregator, Normalizer,Joiner,Connected and Unconnected Lookup, Expression, Sequence Generator, Union and Update Strategy to load teh data into teh target.
• Created new Mappings and Mapplet, Redesigned some of teh existing mappings in teh system to meet new functionality.
• Extensively involved in capturing teh incremental changes in teh source systems for updating in teh staging area and data warehouse respectively
• Develop BTEQ scripts to transform data from teh source and populate tables in EDW.
• Develop FASTEXPORT scripts to load data from one server to another.
• Develop FASTLOAD, MLOAD scripts to load high volumes of data from flat file to tables in Teradata.
• Develop store procedure to load teh data from source tables and populate table in EDW.
• Used Teradata SQL Assistant to test teh performance of queries.
• Extensively worked on WLM Scheduler for creating and modifying jobs, schedules.
• Achieved performance improvement by analyzing explain plan, identifying and defining indexes, Collect statistics on columns dat are used in Joins and compression on appropriate attributes to save teh disk space.
• Involved in resolving Production Support issues for business users and documented problems and solutions for running teh workflow
• Performed unit testing on teh code developed
• Used TSRM(Tivoli Service Request Manager) application for ticket management.
• Closely worked wif Data Architect and Business Objects developer to achieve expected results.
• Involved in Production deployment and production support.

Environment: Informatica 9.1.0/8.6.1 Teradata 13, Teradata Utilities, Teradata SQL Assistant, Oracle 10g/9i, UNIX, WindowsXP, ERWin

Confidential, Denver,CO

Sr.Informatica Developer

Responsibilities:

• Extensively used Informatica Power center 8.6.1 for extracting, transforming and loading data from relational sources and non-relational sources.
• Developed complex Informatica Mapping, Mapplets and teh corresponding workflow to facilitate daily, monthly and yearly loading of data.
• Used Informatica PowerCenter for ETL extraction, Transformation and loading data from heterogeneous source systems to Staging area.
• Developed Informatica mappings, re-usable transformations, re-usable mappings and Mapplets for data load to data warehouse.
• Created complex mappings which involved Slowly Changing Dimensions, implementation of Business Logic and capturing teh deleted records in teh source systems and to keep track of historical data.
• Imported Source/Target Tables from teh Respective databases and created reusable transformations like Joiner, Routers, Lookups, Rank, Filter, Expression and Aggregator inside a Mapplet and created new mappings using Designer module of Informatica.
• Worked wifVariables and Parametersin teh mappings to pass teh values between sessions.
• Developed Informatica SCD Type-me, Type-II mappings. Extensively used almost all of teh transformations of Informatica including complex lookups, Stored Procedures, Update Strategy, mapplets and others.
• Involved in teh Development of Informatica mappings and mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.
• Extensively used Informatica Scheduler for enabling smooth loading. Used Decision task for updating teh dimension tables before loading teh fact tables.
• Tuning of SQL queries for better performance. Working wif database connections, SQL joins Loops, Aliases, Views, aggregate conditions. Parsing of objects and hierarchies.
• Used Informatica debugging techniques to debug teh mappings and used session log files and bad files to trace errors occurred while loading
• Developed Documentation for all teh routines (Mappings, Sessions and Workflows).
• Involved in scheduling teh workflows through AutoSys using UNIX scripts.

Environment: Informatica Power Center 8.6.1, Oracle 10g/9i, SQL, PL/SQL, Flat Files, Toad 9.6, XML, MS Access, UNIX, UDB DB2 8.1, Shell Script

Confidential, Columbus,OH

Informatica Developer/Teradata Developer

Responsibilities:

• Involved in developing mapping from teh design documents.
• Worked on Informatica PowerCenter 8.6 tools like Sourcce Analyzer, warehousedesigner,Mapping Designer,Server Manager, Mapplets, and Reusable Transformations.
• Developed complex Mappings, Sessions, and Workflows using Informatica Mapping Designer, Workflow Manager respectively.
• Used various Transformations like Router, Filter, Joiner, Update Strategy and connected And unconnected lookups for better data messaging and to migrate clean and consistent data using teh Informatica PowerCenter Designer.
• Built Repositories using Informatica PowerCenter Repository Manager to store Source,Target Transformations, Mapplet and Mappings metadata information.
• Identified teh bottlenecks in teh sources, targets, mappings, sessions and resolved teh problems of performance.
• Created Different Fastload, Multiload and BTEQ Scripts to facilitate teh ETL Processes and presenting data reports to users.
• Worked on performance tuning and optimization of teh Sessions, Mappings, Sources and Target
• Worked wif teh Business Analysts for requirements gathering, business analysis and testing
• Used PL/SQL Procedures and Unix Scripting to populate reporting tables.

Environment: Informatica PowerCenter 8.6.1, SQL Server2008, Erwin, Teradata, ORACLE 9i, WINDOWS XP, UNIX,DB2

Confidential, CT

Informatica Developer

Responsibilities:

• Interacted closely wif Business Users in teh Requirements gathering phase.
• Worked wif Data Architect in teh logical and physical design of teh data model.
• Documented teh design by creating High-level design document and a Low-level design document.
• Developed mappings in Informatica to load teh data from various sources into teh Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter and Source Qualifier transformations.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Performed Mapping Optimizations to ensure maximum Efficiency.
• Developed teh sessions and workflows in teh workflow Manager
• Created worklets when a group of sessions need to run multiple times
• Implemented Error Rejection process to load bad/invalid records into a separate reject table
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager.
• Used PMCMD command to start, stop and ping server from UNIX and created UNIX Shell scripts to automate teh activities.
• Responsible for UNIX shell scripts for backup and monitoring database
• Assisted DBA in writing Stored Procedures, triggers and functions in Oracle.
• Played a key role in all teh testing phases and responsible for production support as well.

Environment: Informatica Power Center 7.1, Oracle 10g, DB2, TOAD, SQL Server 2005/2000, PL/SQL, XML, Windows NT .

Confidential, Texas

Informatica Developer

Responsibilities:

• Informatica Power Center 7.1 was used to extract, transform and load data from different operational data sources like Oracle, SQL server, DB2, Flat files in to Data staging area (Oracle).
• Developed complex mappings wif various Informatica transformations like Aggregator, Lookup (Connected, Unconnected), Source Qualifier, Update Strategy, Router, Joiner, Filter and Expression.
• Involved in admin tasks like analyzing Table Space requirement, load balancing and Performance.
• Wrote teh complex SQL queries to retrieve teh data from different sources to validate.
• Debugged mappings wif Informatica debugger and performed unit testing to run teh test session.
• Involved in fixing of invalid Data Conversion, Data Mappings, Performance tuning, testing of Stored Procedures and Functions, Acceptance Testing of Informatica Sessions, Batches and teh Target Data.
• Experienced wif Dimensional Data Modeling Techniques like Star Schema, Snowflake Schema, Surrogate Keys, Conformed dimensions and slowly changing dimensions modeling design.
• Prepared test data for data driven tests for testing teh application dynamically.
• Good experience in UNIX shell scripts in Unix Environment.
• Used Auto Sys to schedule teh jobs.
• Assisted in updating teh logical model wif all related entities, attributes and relationship wif each entities based on teh rules provided by teh business manager using Erwin .

Environment: Windows XP/NT, Informatica Power Center 7.1, UNIX, SQL Server 2000/, Oracle 9i, SQL, PL/SQL,ERWIN, Toad.

Confidential

Informatica Trainee/Developer

Responsibilities:

• Extracted Data from Different Sources by using Informatica.
• Extensively used Informatica client toolsSource Analyzer, Warehouse designer, Mapping designer and Mapplet Designer.
• Extracted data from different sources of databases. Createdstaging areato cleanse teh data and validated teh data.
• Designed and developed complexAggregate, expression, filter, join, Router, Lookup and Updatetransformation rules.
• Developed schedules to automate teh update processes andInformatica sessions and batches.
• Analyze, design, construct and implement teh ETL jobs using Informatica.
• Developedmappings/Transformations/mappletsby usingmapping designer, transformation developer and mapplet designer in Informatica Power Center 6.1.
• DevelopedShell scriptsto setup runtime environment, and to run stored procedures, packages to populate teh data in staging tables.
• Created Users, user groups, database connections and managed user privileges using supervisor.
• Worked offshore interacting wif offshore and onshore team on a daily meeting basis.

Environment: Informatica Power Center 6.1, Oracle 9i, MS SQL SERVER 2000, SQL, PL/SQL,SQL*Loader, UNIX Shell Script.

Confidential 

Oracle Developer

Responsibilities:

• Worked wif DBA in installing Oracle 8i on Solaris UNIX Box and Windows.
• Reviewed application requirements and recommended Database configuration.
• Designed various data entry forms, Query screen and Output Reports
• Created primary Database storage structures (Table Spaces) and objects (Tables, Views, and Indexes).
• Managed teh Table Spaces, rollback segments and indexes for applications.
• Run teh Database in Cost Based mode for better performance. Coded teh Procedures and Triggers.
• For connectivity configured teh Sqlnet.ora, tnsnames.ora and listener.ora at server side.
• Coded teh scripts for loading teh data into Oracle Database from flat files using SQL Loader.
• Prepared total documentation about teh project, also received appreciation certificate from teh manager.

Environment: SQL, PL/SQL, Shell scripting, Oracle 8i, Sun Solaris UNIX, Win NT.