SUMMARY

• Over7years 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 8.x/7.x/6.x.
• Solid understanding and experience in Dimensional Data modeling, star join schema/snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling using ERWIN 4.x.
• Teradata experience using Teradata SQL Assistant; load/unload utilities like BTEQ, FastLoad, MultiLoad, FastExport, Tpump.
• Extensively worked on Data extraction, transformation, loading with Oracle, Teradata, SQL Server and Flat Files using Informatica.
• Developed Mappings using Informatica Power Center Transformations - Connected AND UnConnected Lookup, Filter, Expression, Router, Joiner, Update Strategy, Aggregator, Stored Procedure, Sorter, Sequence Generator.
• 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.
• Expert in the design, development and implementation of RDBMS like SQL Server 2008 /2005/2000 /Oracle10g/9i/8.0 / Teradata.
• Experience in writing UNIX Shell Scripting.
• Experienced in writing PL/SQL Procedures, Functions, Packages, Stored and tuning on queries while extracting and loading data.
• Knowledge in working with scheduling tools like Control M, Autosys.
• Excellent problem solving, analytical, written and communication skills with ability to work both in team as well as an individual.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.0/8.x/7.x, (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor and Informatica Server) ETLData Modeling: ERwin Data Modeler

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: UNIX, Windows XP/Vista, Linux.

PROFESSIONAL EXPERIENCE

Confidential, Denver,CO

Sr. Informatica with Oracle Developer

Responsibilities:

• Extensively used Informatica Power center for extracting, transforming and loading data from relational sources and non-relational sources.
• Developed complex Informatica Mapping, Mapplets and the 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 the deleted records in the source systems and to keep track of historical data.
• Imported Source/Target Tables from the 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 withVariables and Parametersin the mappings to pass the values between sessions.
• Developed Informatica SCD Type-I, Type-II mappings. Extensively used almost all of the transformations of Informatica including complex lookups, Stored Procedures, Update Strategy, mapplets and others.
• Involved in the 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 the dimension tables before loading the fact tables.
• Tuning of SQL queries for better performance. Working with database connections, SQL joins Loops, Aliases, Views, aggregate conditions. Parsing of objects and hierarchies.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading
• Developed Documentation for all the routines (Mappings, Sessions and Workflows).
• Involved in scheduling the workflows through AutoSys using UNIX scripts.

Environment: Informatica 8.6.1, Oracle 10g/9i, PL/SQL, Toad, ERwin, Windows XP.

Confidential, Columbus,OH

RoleInformatica Developer/Database Developer

Responsibilities:

• Involved in developing mapping from the design documents.
• Worked on Informatica PowerCenter 8.6 tools like Sourcce Analyzer, warehouse designer,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 the Informatica PowerCenter Designer.
• Built Repositories using Informatica PowerCenter Repository Manager to store Source,Target Transformations, Mapplet and Mappings metadata information.
• Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems of performance.
• Created Different Fastload, Multiload and BTEQ Scripts to facilitate the ETL Processes and presenting data reports to users.
• Worked on performance tuning and optimization of the Sessions, Mappings, Sources and Target
• Worked with the 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

RoleInformatica Developer

Responsibilities:

• Involved in Systems Study and Analysis and understand the business needs and implement the same into a functional database design.
• Defined the ETL strategy for Data Warehouse population.
• Involved in Data Quality Analysis to determine cleansing requirements.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Performed extensive analysis of metadata to test the integrity, consistency and appropriateness of the data to be brought into the centralized City Data from various sources.
• Installed, Maintained and Documented the Informatica Power Center setup on multiple environments.
• Designed the procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units in tables.
• Worked on Informatica Power Center 8.6 and created Informatica mappings with PL/SQL procedures/functions to build business rules to load data. Most of the transformations used were like the Source qualifier, Aggregators, lookups, Filters & Sequence generators.
• Created sessions and batches to move data at specific intervals & on demand using Workflow Manager.
• Analysis and Design of Migration Procedures for the DB Migration between Relational and Extended ERP Data Sources.
• Performed Database Migration from sources to the Data Warehousing database. Worked closely with Oracle DBA for migration support.
• Created UNIX shell scripts (Scheduler utilities) for automating the backup of Database/ Transaction log.

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

Confidential, Texas

RoleInformatica Developer

Responsibilities:

• Informatica Power Center 8.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 with 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 the complex SQL queries to retrieve the data from different sources to validate.
• Debugged mappings with Informatica debugger and performed unit testing to run the test session.
• Designed and developed efficient Error Handling methods and implemented throughout the mappings.
• Used Dynamic SQL programming technique to build and process SQL statements "on the fly" at run time.
• Extracting Incremental data (Change Data Capture) from Source Systems using Informatica Power Exchange.
• Experienced with Dimensional Data Modeling Techniques like Star Schema, Snowflake Schema, Surrogate Keys, Conformed dimensions and slowly changing dimensions modeling design.
• Used Informatica Tool, Business Objects Data Integrator to integrate Data from Excel files, UDB, Legacy Data providers and third party vendors for the large volumes of data.
• Prepared test data for data driven tests for testing the application dynamically.
• Reviewed computer logs (UNIX logs & Shell Scripts), reported program-processing errors.
• Used AutoSys to schedule the jobs.
• Assisted in updating the logical model with all related entities, attributes and relationship with each entities based on the rules provided by the business manager using Erwin .

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

Confidential

RoleInformatica 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 the data and validated the data.
• Designed and developed complexAggregate, expression, filter, join, Router, Lookup and Updatetransformation rules.
• Developed schedules to automate the update processes andInformatica sessions and batches.
• Analyze, design, construct and implement the 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 the data in staging tables.
• Created Users, user groups, database connections and managed user privileges using supervisor.
• Worked offshore interacting with offshore and onshore team on a daily meeting basis.

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

Confidential

RoleOracle Developer

Responsibilities

• Worked with 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 the Table Spaces, rollback segments and indexes for applications.
• Run the Database in Cost Based mode for better performance. Coded the Procedures and Triggers.
• For connectivity configured the Sqlnet.ora, tnsnames.ora and listener.ora at server side.
• Coded the scripts for loading the data into Oracle Database from flat files using SQL Loader.
• Prepared total documentation about the project, also received appreciation certificate from the manager.

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