SUMMARY

• 7+ years of experience in Analysis, Development, and Implementation of business applications including Development and Design of ETL methodologies using Informatica Power Center for Insurance, Pharmaceutical, Financial, and Telecom sectors.
• Expertise in OLTP/OLAP System Study, Analysis and E - R modeling, developing Database Schemas like Star schema and Snowflake schema Dimensional Data Modeling used in relational, dimensional modeling and Slowly Changing Dimensions.
• Experience in Creating Repository, Folders and Target Databases and developing Strategies for Extraction, Transformation and Loading (ETL) mechanism using Informatica PowerMart and PowerCenter.
• Performed source system analysis, data transformation and loading Design, develop and unit test Informatica Power Center transformations.
• Extensively used Source qualifier to trim the spaces from char columns, SQL override, filtering, Update and sorting for relational tables.
• Good Experience in Configuring Data ware Administration Console (DAC).
• Good Experience in backup and recovery in informatica and Oracle PL/SQL.
• Involved in the installation and configuring the Informatica Power Center server and client.
• Performed ETL procedure to load data from different sources into data marts and Data Warehouse using PowerCenter.
• Develop, execute ETL test plans, Document ETL processing and generate required metadata.
• ETL experience in development of mappings and tuned existing mappings for better performance using Informatica Power Center as per the business rules.
• Good Experience in creating aggregate tables and time series analysis.
• Experience in Debugging and Performance tuning of targets, sources, mappings and sessions. Experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations and Mapplets.
• Extensive experience with various databases Oracle 11g/10g/9i/8i, SQL Server 2000/2005/2008 , Sybase and DB2.
• Good Experience with Teradata database including fastload, multiload, BTEQ Scripts.
• Expertise in writing Oracle PL/SQL Stored Procedures/Functions/Packages and Triggers.
• Experience in Performance tuning of targets, sources, mappings and sessions.
• SQL Tuning and creation of indexes for faster database access, better query performance in Terabyte level database by creating Explain Plain for query and indexing the required columns.
• Expertise in writing DDL, DML, DCL, and TCL commands.
• Experience with UNIX commands and writing Shell scripts.
• Experience with reporting tools like Business Objects and Crystal Reports for different types of application.
• Experience in developing Dashboards using the Xcelsius reporting tool for different environments.
• Created and maintained several custom reports for the client using Business Objects and generated reports using BO tools querying database.
• Create different type of reports including Cross-tab, Conditional, Drill-down, Summary and Sub reports.
• Extensively used different performance tuning methods like Caching, Aggregate tables and creating indexes on tables.
• Good Knowledge on SDLC (software development life cycle), and expertise in Unit testing, integration Testing and sanity testing.
• Excellent communication skills and experience working with business user’s community and leads/managers.

TECHNICAL SKILLS

ETL Tools: Informatica 9.x,8.x/7.x/6.x (Power Center, Power Mart), and SQL*Loader

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

Data modeling Tools: Erwin

Methodologies: Star Schema, and Snowflake Schema

Query Tools: SQL, PL/SQL, SQL*Plus, and TOAD

OLAP/Reporting Tools: SAP BO, Crystal Reports, Xcelsius, Cognos

Languages: C, C++, Visual Basic, Java and PL/SQL

Internet Technologies: HTML, XML, VBScript, ASP, Javascript

Protocols: FTP and TCP/IP

Operating Systems: UNIX, Linux, and Windows 95/98/2000/2000/ NT/XP Pro

PROFESSIONAL EXPERIENCE

Confidential, Florence, SC

Sr. Informatica Developer

Responsibilities:

• Worked Extensively with ERP functional team to gather the data mappings for ETL specifications and Documenting ETL process design.
• Analyzed system documentation like Requirements document, Gap Analysis User Interface
• Specifications to develop technical document of the business flow and develop and execute the mappings.
• Used Informatica Designer to create complex mappings using different transformations, Mapplets and Reusable Transformations for cleansing and move data to a Data Warehouse.
• Created Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, connected and Unconnected lookups, Filters, Sequence, Router and Update Strategy and Stored Procedures.
• Developed the transformation logic, identifying and tracking the slowly changing dimensions and heterogeneous sources.
• Worked with Power Center - Designer tool in developing mappings to extract and loading the data from stage to pre-load and later to data warehouse.
• Responsible for monitoring all the sessions that are scheduled, running completed and failed using Workflow Monitor.
• Wrote PL/SQL stored Procedures and Functions for Stored Procedure Transformations.
• Extensively used SCD’s (Slowly Changing Dimension) to handle the Incremental Loading for Dimension tables, Fact tables.
• Involved in debugging the Mappings that failed using debugger to validate the Mappings and gain troubleshooting information about data and error conditions.
• Modified all the existing Informatica Mappings by applying performance tuning techniques for better performance.
• Fixed bugs relating to daily load of data into Data warehouse for Business Intelligence reports.
• Extensive use of SQL Query, Joining tables, SQL functions in Queries, PL/SQL with the use of Cursors, REF Cursors and loops.
• Designed and Build DAC execution plans and monitored tasks for the load phase.
• Migrated code/objects from the development environment to the QA/testing environment to facilitate the testing of all objects developed and check their consistency end to end on the new environment.
• Used PMCMD command mode to schedule and run workflows. Developed UNIX Shell scripts to archive files after extracting and loading data to Warehouse. Written UNIX shell scripts to automate manual tasks.
• Used session and workflow error logs to debug the session and find problems in the mapping.
• Used Debugger to create debug sessions and break points to test the mappings developed.
• Used SAP BO in creating various reports as peer the requirements.
• Developed Full client reports, Webi reports and scheduled the reports and Created List Reports and Cross Tab Reports and Drill Through reports.
• Performed Unit Testing and Integration Testing for both Full and Incremental Loads.
• Participated in weekly end user meetings to discuss data quality, performance issues. Ways to improve data accuracy and new requirements, etc.,

Environment: Informatica Power Center 9.1/8.6.1(Designer, Workflow Manager, Workflow Monitor, Repository Manager), Oracle EBS/11g, CIS (Client Information System), SQL Server, TOAD for Oracle, SAP Business Objects DAC 7.9.6.1, Linux, Windows XP.

Confidential, Houston, TX

Sr.Informatica Developer

Responsibilities:

• Responsible for requirement gathering, data analysis, design, development, testing and systems implementation.
• Identifying ETL specification based on Business Requirements/Mapping Document. Formulating and documenting ETL process design.
• Extensively using Informatica client tools to extract data from different sources like flat files and oracle.
• Developing complex Mappings using Transformations (Filter, Router, Expression, Joiner, Connect Lookup, Unconnected Lookup, and Updates Strategy) on the extract data according to the Transformation Business Rules and User requirements.
• Developed mappings for all Staging Tables and ODS.
• Performed tuning of SQL queries for speedy extraction of data and resolve and troubleshoot production Issues.
• Troubleshoot the existing code as well as new code as the requirement changes.
• Performed Unit Testing and Created UNIX Shell scripts and provided on-call support during the off hours.
• Did overnight schedule monitoring during critical month-end/quarter-end positions, source system upgrades and during integration/system tests.
• Responsible for Testing and Validating the Informatica mappings against the pre-defined ETL design standards.
• Worked with Power Center - Designer tool in developing mappings to extract and loading the data from stage to pre-load and later to date warehouse.
• Involved in the process in documentation of source-to-target documentation design documentation of the Data Warehouse Dimensional Upgrades. Extensively used Informatica for loading the historical data from various tables for different departments.
• Involved in different Team review meetings.
• Involved in Unit Testing and tuned for better performance.
• Used SQL*Loader for loading bulk data from flat files
• Generated weekly and monthly report Status for the number of incidents handled by the support team.
• Responsible for development and support of ETL routines required for populating the data warehouse and Experience in loading high-volume data, tuning and troubleshooting of mappings and created documentation to support for the Application.
• Worked on sliced metrics to create an Executive Dashboard.
• Involved in creating Workflows, Worklets and Configured Sessions, Used pmcmd command of Informatica in UNIX scripts.
• Involved in the debugging of the mappings by creating breakpoints to gain troubleshooting information about data and error conditions.
• Performance tuned the workflows by identifying the bottlenecks in targets, sources, mappings, sessions and workflows and eliminated them.
• Monitored and managed Workflow to ensure data movement process.

Environment: Informatica Power Center 8.5.1/8.1.1 , Oracle 10g/9i, SQL server, Toad, PL/SQL,IDQ,Unix, Xcelsius,BO 6.5, Unicenter, Windows 2000, Test Director.

Confidential, Tampa,FL

Informatica Developer

Responsibilities:

• Developed the Dimensional modeling of the Data warehouse and used ERWIN 4.0 to design the business process, grain of the data representation, dimensions and fact tables with measured facts.
• Designed and created mappings using tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager.
• Involved in various phases of the project from design to development to integration and acceptance testing.
• Extensively used various Transformations like Source Qualifier, Aggregator, Filter, Joiner, Sorter, Lookup, Update Strategy, Router, Sequence Generator etc. and used transformation language like transformation expression, constants, system variables, data format strings etc.
• Analyzed the session logs, bad files and error tables for troubleshooting mappings and sessions
• Debugged maps using Debugger and Transformation’s verbose data.
• Performance tuning of mappings, transformations and sessions to optimize session performance.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Created shared folders, local and global shortcuts to reuse metadata.
• Resolved the performance issues for huge volume of data and increased the performance significantly.
• Created various sessions, tasks like event raise and event wait.
• Scheduled and monitored workflows by use of Workflow Manager and Workflow Monitor.
• Defined parameters, variables and parameter files for flexible mappings/sessions.
• Involved in Unit testing and Integration testing.
• Created the reports using Business Objects functionality’s like Queries, Sub queries, Slice and Dice, Drill Down, Cross Tab, Master Detail reports.
• Prepared various kinds of documents like Test case document, mapping design document.
• Involved in the performance tuning of the mappings to tune the data load, and worked with DBAs to tune SQLs for better performance.
• Involved in the migration of code from development to QA environment and then to production.

Environment: Informatica Power Center 8x, SQL, MS SQL, Windows NT, SQL Server, SQL * Loader, Unix shell scripting, Business Objects 6, Toad, ERWIN 4.0.

Confidential

Informatica Developer

Responsibilities:

• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer, Workflow Manager and Monitor
• Used Source Analyzer and Warehouse Designer to import the source and target database schemas and used mapping designer to map the source to the target.
• Used transformation Developer to create the Joiner, filters, Router, Expressions and Aggregation transformations in mappings.
• Extensively used transformations like lookup, aggregate, joiner, filter, and sequence generator, expression to create complex mappings
• Created connection pools, physical tables and defined Primary key - Foreign key joins, complex joins in the physical layer of the repository
• Involved in Testing of Sales reports, Master-detail reports using Report Studio.
• Involved with all the phases of the life cycle starting from gathering requirements for designing DS systems, data modeling involving in the design of the logical and physical databases, Data warehouse design with decision support in mind and development.
• Involved in designing the Dimensional model of the Data warehouse by using Erwin 4.1 to identify the business process, grain of the data representation, dimensions and fact tables with measured facts.
• Identified all the confirmed dimensions to be included in the target warehouse design and confirmed the granularity of the facts in the fact tables.
• Write Informatica ETL design documents, establish ETL coding standards, develop Informatica mappings and perform reviews of the same.
• Mapplets and reusable transformations have been part of the mappings since different data types conversions have to be dealt multiple times which are similar and also most of the lookups have been similar.
• Created reusable email tasks in workflows to send post session and suspension emails as per user requirements.
• Created and maintained folders in the repository manager to logically organize all the metadata in the repository including mappings, schemas and sessions

ENVIRONMENT: Informatica 7, ORACLE 9i, XML, PL/SQL Developer, DB2, TOAD, Power mart, Cognos 6, SQL Server 2000, UNIX, Business Objects 5, Windows XP, Windows 2003.

Confidential

ETL Developer

Responsibilities:

• Responsible for Design and Development of ETL and the reporting application.
• Communicated with the users to observe various business rules in implementing the data warehouse.
• Analyzed the specifications and identifying the source data that needs to be moved to the data warehouse.
• Involved in the requirements definition and analysis in support of data warehousing efforts.
• Involved in developing Data warehouse using Star Schemas.
• Analyze the source data structure and perform the Logical mappings.
• Applied various Transformations on the source data to populate the data marts.
• Most of the transformations were used like the Source qualifier, Aggregators, Connected & Unconnected lookups, Filters & Sequence Generator.
• Developed mappings using Informatica Designer to load data from various source systems to target database.
• Responsible to tune ETL mappings to optimize load and query Performance.
• Wrote SQL Queries, Triggers, PL/SQL Procedures, Packages and Shell Scripts to apply and maintain Business Rules.
• Used Business Objects for report creation.
• Developed Unix Shell scripts.

Environment: Oracle 8i, Informatica Power Center 6.1/5.1, Business Objects5.X, Windows 2000, SQL, PL/SQL, TOAD, MS Excel.