SUMMARY

• Professional experience of over 7+ years in the field of Enterprise DataWarehousing, Data Integration and Data/code Migration.
• Experience in all the phases of Data Warehouse life cycle involving Requirement analysis, Design, Coding, Testing and Deployment.
• Expert in Database skills using SQL, PL/SQL Developer for debugging applications.
• Experience in writing stored procedures and functions (PL/SQL).
• Strong SQL experience in Coding and Query tuning. Well versed with Oracle SQL tools like TOAD, SQL developer and SQL Plus.
• Extensively worked on various different ETL mappings, analysis and documentation of OLAP reports requirements.
• Strong knowledge of Entity - Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling such as Star Schema and Snow Flake Schema.
• Extensive experience with informatica powercenter 9.0.1/7.x/6.x
• Extensive experience in Extraction, Transformation and Loading from various sources into Datawarehouses and marts using informatica power center(Repository manager, Designer, workflow manager, workflow monitor).
• Very good understanding of Teradata’s MPP architecture such as Shared Nothing, Nodes,AMPs, BYNET, Partitioning, Primary Indexes etc.
• Extensively created and used various Teradata Set Tables, Multi-Set table, global tables, volatile tables, temp tables.
• Experienced in using IDQ tool for profiling, applying rules and develop mappings to move data from source to target systems.
• Experience in writing various ETL procedures in order to load data from different sources like Oracle 10g, DB2, XML Files, Flat Files, MS SQL Server and MS Access into Data marts, Data warehouse using Informatica Power Center.
• Worked on flatfiles both of delimited and fixed length.
• Implemented different Slowly changing dimensions(SCD) using Informatica.
• Designed and developed various complex mappings such as Filter, Router, Connected and Unconnected lookups, update strategy, sorter, Aggregator and Joiner.
• Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control).
• Extensive experience in writing UNIX scripts and also automation of the ETL processes using UNIX shell scripting.
• Extensive experience on working with scheduling tools like SAS Management console, Crontab and lsfadmin tools.
• Worked on performance tuning, identifying and resolving various performance bottlenecks at various levels like sources, mapping and sessions.
• Involved in Unit testing, system testing to check whether the data loads in to target are accurate.
• Expert in debugging, troubleshooting, monitoring, and performance tuning of Sources, Mappings, targets and sessions.
• Experience in designing exception handling procedures to identify, record and report errors.
• Quick learner and excellent team player, ability to meet deadlines and work under pressure with Analytical and Technical aptitude with the ability to solve complex problems.
• Can also work very well in a team as well as independently under minimum supervision.
• Excellent written and oral communication, interpersonal skills and presentation skills.
• Experience in working with senior level managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS

ETL Tools: Informatica 9.1/8.x/7.x (PowerCenter), Informatica Data Quality 9.5

Data Modeling: Relational Modelling, Dimensional Modelling (Star Schema, Snow-Flake, Fact, Dimensions), Data Quality, Entities, Attributes, ER Diagrams.

Databases: Oracle 10g/9i/8i, MS SQL Server 2005/2000, MS Access, Teradata and DB2

Tools: SQL plus, PL/SQL Developer, Toad, SQL* Loader

Query Languages: SQL, PL/SQL, C, C++, Data Structures, UNIX Shell Script, Visual Basic

Job Scheduling Tools: lsfadmin, Crontab, Control-M

Operating Systems: UNIX, Windows NT/2000/2003/XP/Vista/7, MS-DOS

Others: OBIEE,IDQ, MDM, DB2, B2B,HTML,XML, Javascript.

PROFESSIONAL EXPERIENCE

Confidential, Owings Mill, MD

Informatica Developer

Responsibilities:

• Understanding the business rules provided to design and develop mapping for the ETL.
• Involved in complete understanding of business requirement and involved in analyzing, Data profiling the sources to load in Oracle warehouse.
• Prepared technical specifications for the development of Informatica (ETL) mappings to load data into various target tables and defining ETL standards.
• Understanding the business rules provided to design and develop mapping for the ETL.
• Data Modeling(dimensional modeling/STAR SCHEMA) as per new requirements, create and deploy Informatica mappings/workflows.
• Analyze requirements, recommend technical solutions, trouble-shoot data issues, review code/data models. Design or upgrade the dimensional model based on additional new requirements for reporting.
• Designed Sources to Targets mappings from Excel/Flat files to Oracle using Informatica Power Center.
• Responsible for working with DBA and Informatica admin for project coordination.
• Estimated the Database space needed based on the data volume and the data structures.
• Responsible for developing complex Informatica mappings using different types of transformations like UNION transformation, Connected and Unconnected LOOKUP transformations, Router, Filter, Aggregator, Expression and Update strategy transformations for Large volumes of Datasets.
• Developed complex ETL to dynamically build queries based on the rules provided by the end user.
• Responsible for Error Handling in Workflows and sessions using Informatica workflow manager and monitor the workflow run and statistic properties on Informatica Workflow Monitor.
• Responsible for Defining Mapping parameters and variables and Session parameters according to the requirements and performance related issues.
• Wrote test plans and executed it at UNIT testing and also supported for system testing, volume testing and User testing. Also provided production support by monitoring the processes running daily
• Doing Change Requirement for complex Informatica Mappings coding with transformations like lookup, router, aggregator, expression, update strategy, joiner and etc.
• Created Connected, Unconnected and Dynamic Lookup transformations for better performance.
• Extensively used Parameter files, mapping variables in the process of development of the mappings for all the dimension tables.
• Designed Sources to Targets mappings from Excel/Flat files, Xml Files to Oracle using Informatica Power Center.
• Worked on data conversion to load the historic data from MSIS systems to TMSIS systems.
• Worked on handling performance issues, Troubleshootingof Informatica Mappings, evaluating current logic for tuning possibilities.
• Extensively worked on SQL queries along with Informatica to enhance the performance of the system.
• Used Autosys for job scheduling.
• Worked on multiple projects using Informatica developer tool(IDQ) of latest versions 9.1.0 and 9.5.1.
• Involved in migration of the mappings from IDQ to power center.
• Applied the rules and profiled the source and target table’s data using IDQ
• Developed the mappings, applied rules and transformation logics as per the source and target system requirements.
• Worked on different environments with different source and target databases like Teradta, DB2 and SQL server.
• Developed the mapping to process multiple flat file as source and staged the data into Teradata and DB2 databases.
• Involved in Data masking for unit testing and fixing the bugs identified, provided data to the reporting team for their daily, weekly, monthly and quarterly reports.
• Responsible for creating production support documentation.
• Coordinate with business team, get the requirements from them and then coordinate with offshore team to get the work done, keeping timeline in mind.
• Involved in team weekly and by monthly status meetings.

Environment: Informatica Power Center 9.1, IDQ 9.1/9.5.1, Teradata 13.1, Oracle 11g, PL/SQL, UNIX Shell Scripts, Autosys, TOAD, windows XP.

Confidential, New Jersey

Sr. Informatica Production Support

Responsibilities:

• Involved in gathering and analyzing the requirements and preparing business rules and also involved in analyzing the sources to load in oracle Warehouse.
• Generated E-R diagrams based on the actual values and also relationships held in the source data.
• Prepared ETL specifications in order to help develop mapping.
• Responsible for reviewing CDA Change requests, create Logical and physical data Models, review project data models.
• Worked with Power center designer tools in developing mappings and mapplets to extract and load the data from flat files, oracle in to oracle database.
• Responsible for designing/developing/data modeling a star schema data mart using informatica and oracle on a Solaris 10 platform to support claims for veterans who have work-study benefit while working.
• UNIX shell scripts on the mid-tier. Performed data modeling, mapping design, workflow performance tuning and trouble-shooting of various informatica processes.
• Implemented code using various Informatica Transformations like UNION, Expression, Aggregator, Filter, Sequence Generator, Update Strategy, Source qualifier, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Developed SQL overrides in Source Qualifier/Lookup according to business requirements.
• Developed mappings/Reusable Objects/mapplets by using mapping designer, transformation developer and mapplet designer, since different datatype conversions have to be dealt multiple times which are similar and also most of the lookups have been similar
• Worked with different caches in optimizing the transformations such as Index cache, Data cache and Lookup cache (Static, Dynamic, Persistence and Shared).
• Used Informatica Power Center Workflow manager to create sessions, batches to run the mappings daily, biweekly based on the business requirements.
• Implemented different Tasks in workflows which included Session, Command, E-mail, Event-Wait etc.
• Involved in Performance Tuning of SQL Queries, Sources, Targets and sessions by identifying and rectifying performance bottlenecks.
• Created pre-session and post session scripts using UNIX/PL-SQL.
• Tuned the Sources, Targets, Transformations and Mapping to remove bottlenecks for better performance.
• Migrated mappings, sessions, and workflows from development to testing and then to Production environments
• Applied business rules using Informatica Data Quality (IDQ) tool to cleanse data.
• Documented Cleansing Rules discovered from data cleansing and profiling.
• Created deployment groups, migrated the code into different environments.
• Worked closely with reporting team to generate various reports.

Environment: Informatica Power Center 9.1/8.6, IDQ 9.5.0, Unix scripting, MS SQL server 2005, Oracle 10g, Quality Toad.

Confidential - Dubuque, IA

Informatica Developer

Responsibilities:

• Gathered user Requirements and designed Source to Target data load specifications based on Business rules.
• Assisted gathering business requirements and worked closely in various Applications with Business Analyst teams to develop Data Model
• Involved in End to End Data flow design in ETLInformaticamappings.
• Extensively worked onInformaticaDesigner, Work Flow Manager, Work Flow Monitor and Repository Manager..
• Created several complexInformaticamappings, Mapplets depending on client requirements. Extensively worked on Connected & Unconnected Lookups, Router, Expression, Source Qualifier, Aggregator, Filter, and Sequence Generator.
• Developed SQL Scripts and PL/SQL Scripts to extract data from different sources.
• Performed Data cleansing, standardizing incorrect data formats, misspellings, redundant, missing data values and performed de-duplication of customer data.
• Extensively worked with Lookup caches like Static cache, Dynamic cache & Persistent cache.
• Involved in the optimization of SQL queries which resulted in substantial performance improvement for the conversion processes.
• Responsible for performance tuning which includes Tuned sources, targets, mappings, and sessions to improve the performance. To get optimal performance, used parameter files and mapping parameter, Variables in mappings and session variables in workflows.
• Used Workflow Manager to schedule and run batches, sessions, as well as to check session logs and other session related activities.
• Developed UNIX Shell Scripts for automating Batches and Sessions.
• Responsible for Error handling, bug fixing, Session monitoring and log analysis.
• Involved in unit testing, UAT testing and integrated testing of entire process flow.
• DeployedInformaticajobs from Development environment to Test environment and Test to Production Environment usingInformaticaexport/import methodology.
• Developed Business Process diagrams to understand the business and process and developed data flow diagrams using Visio.

Environment: Informatica-Power Center 9.5.1, (Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformations Developer, Workflow Manager, Workflow monitor, Repository Manager), Oracle 11g, Toad, Java, Netbeans, View Point Erwin 7, MS Visio, Windows, Autosys.

Confidential, Dallas, TX

ETL Informatica Developer

Responsibilities:

• Interacted with Business Analysts in order to gather the requirements.
• Analyzed the requirements to identify the necessary tables that need to be populated into the staging database.
• Prepared the DDL’s for the staging/work tables and coordinated with DBA for creating the development environment and data models.
• Worked with Power Center Designer tools in developing mappings to extract and load the data from XML files into different FlatFile formats
• Worked on Informatica Power Center tools like Source Analyzer, Target Designer, Mapping Designer, Workflow Manager, and Workflow Monitor.
• Designed and Developed mappings by using Lookup, Expression, Filter, Update Strategy, Aggregator, Router, transformations to implement requirement logics while coding a Mapping.
• Developed error handling & data quality checks in Informatica mappings.
• Schedule and run Extraction and Load process, monitor task and workflow using the Workflow Manager and Workflow monitor.
• Used Workflow Manager for creating workflows, work lets, email and command tasks.
• Used Informatica features to implement Type II changes in slowly changing dimension (SCD) tables.
• Involved in Performance Tuning of SQL Queries, Sources, Targets and sessions by identifying and rectifying performance bottlenecks.

Environment: Informatica Power Center 8.1, Oracle, Flat files, Shell.

Confidential, North Brook, IL

ETL Informatica Developer

Responsibilities:

• Involved from initial stage of the requirement gathering to understand business requirements subjected to business.
• Created new mappings and also modifications in already existing mappings as per the new business rules.
• Analyzed the business requirements and suggested changes to the design accordingly.
• Prepared ETL Specifications to help in developing various mappings.
• Used different transformations such as Expression, Source Qualifier, Lookup, Filter, Update Strategy, aggregate, Router, Sequence generator and Joiner in order to create mappings.
• Created sessions and Workflows for the mappings.
• Documented the mapping process and the process that can be used in order to facilitate future development.
• Interacted with user for his requirements and also involved in various document preparation such as integration test plan, Unit test plan, Deployment Instructions, Roll Back Plans and Production Move Check lists etc.
• Modifying the queries for performance improvement.
• Involved in performance improvement in informatica.
• Involved in running the loads to the data warehouse involving different environments.

Environment: Informatica Power Center 9, Oracle 11g, TIVOLI

Confidential

SQL, PL/SQL Developer / Informatica Developer

Responsibilities:

• Worked on analysis, design, development, testing and implantation of the various financial systems using Oracle 8i, Developer 2000.
• Coordinated between management, users and technical teams for Requirement Gathering.
• This system consists of the various functional modules: Loan approvals, Deposition of Cash/ Withdrawal of Cash, Change of personnel Information, Bank Details, balance Sheet, Customer Information Database.
• Wrote UNIX Shell Scripts to run database jobs on server side.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins to implement business rules.
• Worked with different functional experts in order to implement their functional knowledge into business rules in turn as working code modules like procedures and functions.
• Involved in daily, weekly and monthly load of data from mainframe data set to Oracle database.
• Used SQL *Loader to load the data.
• Involved in daily, weekly and monthly load of data from mainframe data set to Oracle database.
• Used SQL *Loader to load the data.
• Generated UNIX shell scripts for automating daily load processes.
• Developed Pre and Post SQL scripts, PL/SQL stored procedures and functions.
• Developed Shell Scripts, PL/SQL procedures, for creating/dropping of table and indexes of performance for pre and post session management.
• Used TOAD and SQL navigator extensively.
• Extensively worked with Business team to gather requirements and involved in defining overall ETLArchitecture.
• Developed complex mappings usingInformaticaPower Center Designer to transform and load the data from various source systems like Oracle, flat files and loading to SQL Server target database.
• Used various transformations like Lookup, Expression, Filter, Joiner and Stored Procedure
• Implemented performance tuning logic on Targets, sources, mappings, sessions.
• Ensuring proper Dependencies and Proper running of loads (Incremental and Complete loads) via Workflow Monitor.

Environment: Oracle 8i, SQL, PL/SQL Developer, TOAD 8.0, UNIX Shell Scripting, MS SQL Server 2000, Windows 2000, Informatica Power center 9.