SUMMARY

• Over 9+ years of extensive IT experience with excellent experience working in Database/Data Warehousing area, majorly in analysis, designing, development and implementation of business systems in various environments.
• Six plus years of working experience in ETL development process for Data Warehousing, Data migration and Production support.
• Expertise in Data warehousing concepts and Dimensional modelling (Star and Snowflake Schema) using ERwin.
• Experience in Installation and Configuration of Informatica Power Center on Client/Server environment
• Extensive Data Warehouse experience using Informatica Power Center, Informatica PowerExchange (CDC) for designing and developing transformations, mappings, sessions.
• Proficient with Informatica Data Quality (IDQ) for cleanup and massaging at staging area.
• Proficient in developing JOB streams, Box JOB for scheduling and configuring workflows.
• Experience with Relational and Non - Relational databases i.e. Oracle 11g/11i/10g/9i, SQL Server, DB2, Teradata SQL Assistant and flat files, XML and Spreadsheets.
• Experience in Big Data with deep understanding of the Hadoop Distributed File System Eco System (MapReduce, Pig, Hive, Sqoop, HBase Cloudera Manager) ETL and RDBMS
• Experience in different layers of Hadoop Framework - Storage (HDFS), Analysis (Pig and Hive), Engineering (Jobs and Workflows).
• Hands on experience in Oracle, SQL and PL/SQL Development i.e. Stored Procedures, Functions, Triggers and Packages Development using SQL Developer, SQL *Loader and TOAD Development tool, & working knowledge of SSIS, SSMS.
• Experience with TOAD to test, modify and analyze data, create indexes, and compare data from different schemas
• Experience in Performance tuning of sources, targets, mappings and sessions
• Experienced in developing UNIX shell scripting & Scheduling for ETL processes.
• Developing experience of Reports and Charts using Cognos 8.0 and Oracle Hyperion System 9(BI+).
• Strong knowledge of Software Development Life Cycle (SDLC) including requirement analysis, design, development, testing, and implementation.
• Excellent analytical, problem solving, communication and interpersonal skills.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.1, 8.6.x, 7.x, 6.x, PowerExchange, IDQ

OLAP/Reporting Tools: Oracle Hyperion System 9(BI+), Cognos 6.0, OBIEE

Databases: Oracle 11g/11i/10g/9i, SQL Server 2008 DB2 (UDB), AS400 DB2, Teradata v2r5.0/v2r6.0

Operating Systems: Windows NT, 2000, XP, 2003, Red Hat LINUX, UNIX, HP-UX, AIX, Sun Solaris 5.11/7.0/8.0 , MS-DOS

Languages: SQL, PL\SQL, C, C#, C++, T-SQL, Unix Shell Scripting

Tools: /Utilities: SQL * Loader, Toad, ERwin, Crontab, Autosys, Teradata SQL Assistant 12.0.

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Senior Informatica Developer

Responsibilities:

• Worked on custom Map Reduce programs using Java Involved in creating Hive tables, loading with data and writing hive queries which internally run map reduce for data analysis to meet the business requirements.
• Optimized data transformation processes in the Hadoop and Big Data..
• Actively involved in designing, developing types of transformations in mappings, Mapplets using
• Informatica and loading the data from Teradata warehouse tables to Hadoop.
• Worked with business analysts for requirement gathering (BRD), business analysis, and translated the business requirements into technical specifications to build the Enterprise data warehouse.
• Interacted with both Technical, functional and business audiences across different phases of the project life cycle.
• Developed mappings for fact and dimension tables using the various transformations to extract data from different source databases Oracle, SQL Server and XML Files.
• Did the managed file transfer (MFT) from the legacy server to Informatica server.
• Designed and developed complex ETL mappings by making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator transformations.
• Worked on Migration of mappings from Data Stage to Informatica.
• Created Workflows using various tasks like sessions, events raise, event wait, decision, e-mail, command, work lets, Assignment and worked on scheduling of the workflows.
• Used mapping parameters and variables.
• Prepared mapping specification document, which gives the data flow and transformation logic for populating each column in the data warehouse table.
• Used debugger to analyze the data flow between source and target to fix the data issues.
• Developed PL/SQL procedures, functions to facilitate specific requirement.
• Optimized and Tuned SQL queries and PL/SQL blocks to eliminate Full Table scans to reduce Disk I/O and Sorts.
• Worked extensively on Cognos cube development for the financial reports.
• Changed Cognos financial reports based on end user requirement by applying appropriate filters.
• Created the Cognos connections for web portal and content store.
• Developed a query subject in framework manager in Cognos.
• Integrated the sales force data into target Oracle using Informatica cloud.
• Validated the sales force target data in force.com application.
• Created Invoices, Cash Receipts, RMA, RMA Start into Sales Force from Oracle EBS.
• Extensive knowledge on Master Data Management (MDM) concepts.
• Extensive experience on Designing, Managing and administrating MDM/DIW objects using Kalido DIW/MDM8.5/9 tool.
• Configured business objects Universe.
• Made changes to BO financial reports based on user input.
• Calculated the KPI’s and worked with the end users for OBIEE report changes.
• Created the RPD for OBIEE.
• Worked on creating physical layer, business model, mapping and presentation layer in OBIEE.
• Created source system containers for OBIEE.
• Created subject areas in containers for OBIEE.
• Created narrative reports in OBIEE.
• Administrative role and monitoring and support for several projects in Staging and Production environments for Informatica and OBIEE.
• Created the metadata layer for OBIEE.
• Installed/configured SAP adaptor and JD Edwards (Power Exchange) for Informatica.
• Configured Informatica for the SAP Connector.
• Extracted data from SAP and loaded into Oracle EBS
• Retrieved data from SAP using Informatica Power Exchange.
• Configured SAP IDoc connector for Informatica.
• Retrieved data from SAP IDocs using Informatica connector.
• Configured Informatica Power Exchange add on for SAP Hana (Power Connect)
• Worked on designing catalogs, categories, sub-category and user roles using Kalido MDM 9.
• Used SQL Loader to load huge flat files into Oracle database.
• Implemented audit and reconcile process to ensure Data warehouse is matching with the source systems in all reporting perspectives.
• Prepared the Standard Operating Procedure (Knowledge Transfer) document, which provides necessary information, required for the Maintenance and Operation of the application.
• Created the release requests for QA Builds to include all the release requirements and involved in the implementation of QA, UAT and Production releases.
• Developed a UNIX Shell scripts which will send the reports to client over the network by using file transfer protocol (FTP & SFTP) and generating the log file, which will keep the history for the FTP reports.
• Provided data loading, monitoring, System support and worked on data issues raised by end user during its production support phase.

Environment: Informatica Powercenter 9.1.0 HF1, Oracle 11g, SQL Server 2012/2008 R2, SSIS, Netezza 7.2.0, Oracle SQL* LOADER, Flat Files, UNIX Shell Scripting, TOAD Informatica 9, SalesForce dot com(SFDC), OBIEE, Business Objects, Hadoop.

Confidential, Dallas, TX

Sr. Informatica Developer

Responsibilities:

• Analyzed the source data, coordinated with Data Warehouse team in developing Relational Model and Participated in the Design team and user requirement gathering.
• Created SSIS packages for getting the data from AS 400 into SQL Server
• Built Data Transformation Services (DTS) packages for ETL using DTS wizard
• Created the NZ HOST, NZ DATABASE, NZ USER, NZ PASSWORD environment variables on each server.
• Aware of the Netezza terms FPGA, SPU, snippets.
• Created generate statistics, generate express statistics in Netezza.
• Configured RPD and DAC.
• Created the Visio diagram for Informatica workflows to be scheduled in DAC.
• Scheduled workflows in DAC and populated the Reporting layer of OBIEE.
• Maintained user accounts in DAC.
• Created the source system containers, customized the data warehouse load, manipulated the columns in data warehouse tables etc in DAC.
• Created the custom logical/physical folders in DAC.
• Created stored procedures (NZ-SQL).
• Scheduled the ELT load in Control-M.
• Validated the target data using workbench Aginity of Netezza.
• Created the RPD for OBIEE.
• Worked on creating physical layer, business model, mapping and presentation layer in OBIEE.
• Created source system containers for OBIEE.
• Created subject areas in containers for OBIEE.
• Created narrative reports in OBIEE.
• Retrieved data from SAP using Informatica
• Debugged and corrected the xfr files developed by other ELT developers.
• Fixed numerous bugs with load issues.
• Optimized the NZ-SQL queries.
• Created the format of the unit test documents per Netezza Framework.
• Assisted ELT developers in creating the unit test documents.
• Managed user and folder permissions for the developers.
• Purged old repository objects weekly.
• Created shell script for repository backup weekly.
• Developed data Mappings between source systems to Landing and from Standardization to warehouse components using Mapping Designer.
• Did performance tuning on the ELT code developed by ELT developers.
• Debugged the framework error logs.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Problem resolution involves resolving the issues raised by the client/actuarial users, validation of the data in the database or in the application functionality.
• Worked closely with QlickView Developers.
• Retrieved data from MQ Series sources.
• Expertise in the optimization of the performance of the Designed workflows processes in Informatica and to identify the bottlenecks in different areas after the full volume system run.
• Implemented Slowly Changing Dimension methodology for accessing the full history.
• Created Several Informatica Mappings to populate the data into dimensions and fact tables.
• Worked cooperatively with the team members to identify and resolve various issues relating to Informatica and other database related issues.
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter.
• Developed Workflows and session to load data into targets.
• Extensive use of Command tasks, Decision tasks, email tasks in the workflow design.
• Developed the Test Scripts and performed the Unit Tests on the ETL mappings.
• Used DT/designer to validate the physical model of data warehouse or data mart
• Extensively used transformations such as Source Qualifier, Aggregator, Expression, Lookup, Router, Filter Update Strategy, Joiner, Transaction Control and Stored Procedure etc.
• Scheduled sessions and work flows using Autosys / Informatica scheduler.
• Worked with pre and post sessions and Created Workflows and used various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Session in the workflow manager.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Developed the Test Scripts and performed the Unit Tests on the ETL mappings.
• Successful code migration from DEV to Testing & Production environment

Environment: Informatica Power Center 9.1.0 HF1 / Informatica PowerExchange, Informatica Data Transformation/ Data Exchange (B2B), Netezza 7.2.0, Embarcadero DT Studio 8.6.1, Embarcadero Rapid SQL, Oracle 11g, Oracle EBS, DAC, OBIEE, IDQ (Workbench) 9.0.1, Oracle 10g, PL/SQL, SQL Assistant, Erwin 7.2, MS Visio, Control-M, Microstrategy.

Confidential, FL

Sr. Informatica Developer

Responsibilities:

• Created batch scripts to rename/copy and move the processed files.
• Created a Console Application to send and receive xml file to and from an URL.
• Responsibilities include Production Implementation, Scheduling, Data Loading, Monitoring, Troubleshooting and Support for Global Operations Reporting using Informatica and Business Objects.
• Created the deployment document to be followed for migration of code from one environment to another.
• Worked on Informatica MDM, maintaining the master data repository in Oracle.
• Created custom rules for identifying the duplicate master data into multiple systems.
• Created MDM data lineage using Informatica MDM (Siperion).
• Designed and developed Informatica mappings for data loads and data cleansing. Extensively worked on Informatica Designer, Workflow Manager.
• Extensively used most of the transformations of Informatica including lookups, Stored Procedures, Update Strategy.
• Used Workflow Manager for creating and maintaining the sessions and also to monitor, edit, schedule, copy, aborts and deletes of the session.
• Extensively worked in performance tuning of the programs, ETL Mappings and processes.
• Attended POC of GreenPlum DataBase.
• Involved in configuring GreenPlum for parallel processing for loading and querying.
• Involved in configuration of Power Connect of Informatica Power Center for GreenPlum.
• Created Reusable and Non-Reusable command task in Workflow Manager.
• Created Sessions, command task, reusable worklets and workflows in Workflow Manager.
• Created shell scripts to take the repository backup’s and archiving it for 7 days.
• Used database level Greenplum partitioning and Informatica hash partitioning.
• Did production support after development work is done.
• Design & Customizing the Business process using Informatica transformations including SQL Transformation, Source Qualifier, Lookup, Aggregator (Incremental update), Expression, Joiner, Filter, Router, Update Strategy Transformations.
• Analyzed the systems using Reverse Engineering, met end users and worked with business units in defining the requirements of the project.
• Participated in business requirements and design analysis meetings.
• Analyze Oracle, SQL Server and flat file sources.
• Extensively used SQL and PL/SQL scripts for loading the database tables.
• Designed mappings in Informatica 5.1 using transformations like update strategy, lookup, Router, Filter, sequence generator, joiner, aggregate, expression transformation.
• Develop reusable transformations and mapplets using transformation developer and mapplet designer.
• Design complex mappings involving target load order and constraint based loading.
• Developed various mappings & mapplets to load data from various sources using different transformations like, Expression, Lookup, Aggregator, Update Strategy, Joiner, Router and Filter to store the data in staging area/target tables.
• Set up batches and sessions to schedule the loads at requested frequency.
• Troubleshoot mappings and performance tuning of mappings by identifying source, target and mapping bottlenecks.
• Error checking and testing of ETL procedures and programs using Informatica session log.
• Create training documents and assist in End User training.

Environment: Informatica Power Center 9.1/8.6.1,Power Exchange, DB2, UNIX Sun Solaris, Oracle 11g, PL/SQL,SQL Server 2008 R2,SQL,GreenPlum, Business Objects, MS Access, MS Visio, Autosys, TOAD 9.7.2.

Confidential, Minneapolis, MN

Sr. Informatica Developer

Responsibilities:

• Extracted data from SIM datasets and stored in a staging area using Informatica (truncate and Load).
• Data cleansing, translation, true derivative and true assumptions logic were applied to the data to create seriatim database tables.
• Analyzed business requirements and worked closely with various application teams and business teams to develop ETL procedures that are consistent across all applications.
• Interacted with Business Users and Managers in gathering business requirements.
• Wrote Informatica ETL design documents, establish ETL coding standards and perform Informatica mapping reviews.
• Involved in up gradation of Informatica Power center from version 8.6.1 to 9.1
• Extensively used Teradata utilities like Fast load, Multiload to load data into target database.
• Extensively worked on Power Center Client Tools like Power center Designer, Workflow Manager, and Workflow Monitor.
• Extensively worked on Power Center 8.6 Designer client tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Analyzed the source data coming from different sources (Oracle and SAP Flat files) and worked on developing ETL mappings.
• Created Parameter files and validation scripts.
• Analyzed the source fields and wrote PL/SQL queries for field to field validation by referring source to target mapping document
• Used Mload connection and created used custom Mload Scripts from command task.
• Created Process Control and Metadata for informatica jobs.
• Used User Defined Functions for converting SAP values.
• Created Reusable and Non-Reusable command task in Workflow Manager.
• Created Sessions, command task, reusable worklets and workflows in Workflow Manager.
• Did production support after development work is done.
• Responsible for the Performance tuning at the Source Level, Target Level, Mapping Level and Session Level.
• Created the labels/deployment groups for code migration.
• Worked extensively on SQL, BTEQ Scripts and UNIX shell scripts.
• Performed Unit testing and Data validation testing using Validation scripts.
• Proven Accountability including professional documentation and weekly status report.
• Created Data Validation document, Unit Test Case Document, Technical Design Document, Informatica Migration Request Document and Knowledge Transfer Document.

Environment: Informatica Power Center 8.6.1, Oracle 11g, SAP BW Flat Files, Teradata 13, UNIX, Win XP, SQL * Plus, SQL Assistant, Control-M, Putty, BTEQ.

Confidential, FAIRFAX, VA

Sr. ETL / Database Developer

Responsibilities:

• Responsibilities include Production Implementation, Scheduling, Data Loading, Monitoring, Troubleshooting and Support for Global Operations Reporting using Informatica and Business Objects.
• Extensively worked with the solution architect to implement the project from scratch.
• Training team members to run and monitor workflows in Informatica.
• Lead the team of change Management.
• Created extensive T-SQL procedures.
• Created SSIS packages to get the data from the flat files and load it into Oracle 11g.
• Created the deployment document to be followed for migration of code from one environment to another.
• Created the metadata layer for OBIEE.
• Created batch scripts to rename/copy and move the processed files.
• Designed conceptual, logical and physical data model using Erwin data modeling tool.
• Administrative role and monitoring and support for several projects in Staging and Production environments for Informatica and OBIEE.
• Created ETL Mappings to ensure conformity, compliance with standards and lack of redundancy.
• Exceptional background in analysis, design, development, and implementation and testing of data warehouse development and software applications.
• Designed and developed Informatica mappings, to load data into target tables.
• Worked with static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
• Created Mapplets to be re-used in the Informatica mappings.
• Developed ETL Mappings to ensure conformity, compliance with standards and lack of redundancy.
• Did some MDM management using Informatica MDM tool.
• Worked on batch data process flows and consolidation flags in Informatica MDM.
• Designed and developed Informatica mappings for data loads and data cleansing. Extensively worked on Informatica Designer, Workflow Manager.
• Extensively used most of the transformations of Informatica including lookups, Stored Procedures, Update Strategy.
• Used Workflow Manager for creating and maintaining the sessions and also to monitor, edit, schedule, copy, aborts and deletes of the session.
• Extensively worked in performance tuning of the programs, ETL Mappings and processes.
• Developed Interfaces using UNIX Shell Scripts to automate the bulk load & update Processes.
• Made performance improvements to the database by building Partitioned tables, Index Organized Tables and Bitmap Indexes.
• Developed OBIEE RPD and DAC from end user’s input.
• Extensively used PL/SQL programming in backend and front-end functions, procedures, packages to implement business rules and security.

Environment: Erwin 4.2, Informatica Power Center 8.6.1, Informatica Data Replication 9.1.1 (IDR), Informatica MDM, Oracle 10g/11g, Teradata 13.1, SQL Developer, Crontab scheduler, SQL Server 2008 R2, SQL Server Management Studio, PL/SQL, SQL Assistant, Windows XP, Sun Solaris 5.1.0, UNIX scripting, OBIEE, IBM Vendavo Profit Analyzer.

Confidential, Barnesville, MD

Sr. Informatica Developer

Responsibilities:

• Installation & Configuring Informatica 8.6 on UNIX (SUNos 5.11), Also configuring the High availability option for the same.
• Configuring the domain with various application services like repository services & integration services.
• Flexible implementation & maintain the file system for the above mentioned Data Marts, using soft links on multiple VTIER.
• Performed Informatica PowerCenter HotFix upgrade / TOMCAT upgrade to meet the Organization security standards.
• Creating & maintaining user, groups for Development repository and Quality Check.
• Maintaining the repository & purging the repository objects & Archiving Periodic repository backup.
• Involved in Gathering and Analyze business requirements for the DLC / OT conformed to the business rules &
• Design & Customizing the Business process using Informatica transformations including SQL Transformation, Source Qualifier, Lookup, Aggregator (Incremental update), Expression, Joiner, Filter, Router, Update Strategy Transformations.
• Created Reusable Transformations Logic and Mapplets to use in Multiple Mappings and also worked with shared folders, shortcuts.
• Developed Informatica mapping to handle dynamic partition i.e, to create/add & Archive partitions of an oracle data base tables.
• Flexible Implementation of mapping, sessions and workflows using Parameter file/Global parameters and by implementing Informatica Best Practices
• Worked with various relation and non relational sources like FF (Direct / Indirect), JMS Queues, Relational Tables and ERP systems.
• Significantly Involved in the analysis and Implementation of Performance Tuning techniques for SQL, Transformations, Mappings, Session
• Developed & Tuned DML/DDL SQL’s to implement Data modeling changes, Also developed PLSQL procedure to handle the Informatica JOB metadata.
• Providing the Functional and Technical specification for designing customized workflows & their automation.
• Implemented MDM and Maintained data Integrity by eliminating the redundancy.
• Defined the data model elements, relationship types, global business identifier flags (GBID) in Informatica MDM.
• Configured the stage objects with execution components, cleanse components, cleanse match servers etc.
• Configured the Merge process for match and merge process, population etc.
• Batch processing for Informatica MDM includes data stewardship, batch group etc.
• Flexible Implementation of mapping, sessions and workflows using Parameter file/Global parameters and by implementing Informatica Best Practices
• Change data capture by multiple level scheduling of session and workflow.
• Developed various shell scripts using PMCMD command line program, to execute and maintain the workflow jobs.
• Web logic performance Testing using the HP load Runner.

Environment: Informatica PowerCenter 8.6, Informatica MDM (Siperion), Erwin Data Modeler, Oracle 11g/10g, Oracle 11i (ERP), Teradata V2R6.2, Teradata 12, Compass, TOAD 9.6, OBIEE Reporting, Windows NT/2000, UNIX SUNos 5.11, HP Load Runner 9.50.

Confidential, Chicago, IL

Sr. Informatica Developer

Responsibilities:

• Analyze business requirements to build a data mart design for various business processes conformed to the business rules.
• Improved integrity by Identifying and creating relationships between tables
• Actively involved in upgrading Informatica Power Center from version 7.1 to version 8.6
• Involved in import/export of repositories, backing up the repository
• Worked on variety of data sources such as Oracle, Flat Files, Salesforce.com and XML.
• Extensively worked with Source Analyzer, Warehouse designer and Mapping Designer for developing mappings based on the business logic.
• Implemented CDC using Informatica power exchange to update several tables in near real time for oracle tables.
• Developed various transformations including SQL Transformation, Source Qualifier, Lookup, Aggregator (Incremental update), Expression, Joiner, Filter, Router, and Update Strategy Transformations.
• Implemented IDQ Transformation for heavy cleanup and massaging of the staging tables to eliminate the redundant data, and check for attributes details.
• Created Reusable Transformations Logic and Mapplets to use in Multiple Mappings and also worked with shared folders, shortcuts.
• Flexible Implementation of Mapping using mapping parameters & session variables.
• Implemented effective Performance tuning procedures using Pushdown Optimization, concurrent caching, auto memory calculations.
• Created various UNIX Shell Scripts for pre/post session commands for automation of loads using Autosys.
• Used Workflow Manager to create workflows, worklets with different tasks (Session, Decision, E-mail, Event-Raise and Event-Wait).
• Monitored workflow and review error logs generated for each session using workflow monitor.
• Extensive experience working with SQL and PL/SQL commands, scripts and used command line program pmcmd to start/schedule/stop workflows.
• Worked with Hyperion Essbase, Hyperion Planning and HAL.
• Experienced in Developing Hyperion Essbase Cubes, Hyperion Planning Cubes Load Rules from text files and Oracle server and also develop calc script.
• Created and mapped HAL jobs to load the hierarchies into different planning applications.

Environment: Informatica PowerCenter 7.1, 8.6, Oracle 9i/10g, Windows NT/2000, UNIX, TOAD 7.6, Autosys, Oracle Hyperion system9 (BI+), MS Visio.

Confidential, Pittsburgh, PA

Sr. Informatica Developer / Analyst

Responsibilities:

• Analyzed the systems using Reverse Engineering, met end users and worked with business units in defining the requirements of the project.
• Assisted in designing logical and physical data models for business users to determine common data definitions and establish referential integrity of the system.
• Assisted in designing data model structure and E-R modeling with all the related entities and relationship with each entities based on the rules provided by the end users using ERwin.
• Developed number of Informatica mappings, mapplets and reusable transformations for the product line profitability systems to facilitate daily, monthly loading of Data.
• Extensively used SQL Transformation Source qualifier, Joiner for heterogeneous sources, look-up, filter, aggregator, update strategy transformations to transform data into the ODS tables in Teradata and then into the base tables.
• Implemented Test load and Test session to ensure accuracy and validity of the mapping.
• Debugging invalid mappings using break points, testing of stored procedures and functions used.
• Implemented complex tax calculations using Local Variable.
• Developed and scheduled various Pre and Post Sessions SQL, workflows for all Mappings to load data from Relational Source to Target tables.
• Worked with Relational connection variables, session variables using parameter file.
• Implemented workflow variable for recursive session run using assignment task and Decision task.
• Configured workflow and session to run in recoverable mode.
• Managed the Metadata associated with the ETL processes used to populate the data warehouse.
• Responsible for optimizing mappings by performing Performance Tuning, and ETL procedures.
• Used Autosys for scheduling Command Jobs, Configuring ON HOLD and ON ICE job.
• Performed Unit testing and Integration testing.
• Developed the design documents for end user, which illustrates program development, logic, coding, testing, changes and corrections.
• Provided support in creating adhoc reports using Cognos.

Environment: Informatica PowerCenter 7.1/6.1, Teradata, Oracle 9i, Cognos, SQL, PL/SQL, Erwin, Autosys, Win 2000/NT, Linux, People soft, PMS, MPP .