SUMMARY

• Over 9+ years of IT Experience in Data Warehousing, Database Design and ETL Processes in the Test and Production environments of various business domains like finance, telecommunications and health care industries.
• Highly proficient in Development, Implementation, Administration and Support of ETL processes for Large - scale Data warehouses using Informatica Power Center.
• Worked extensively on ETL process using Informatica Power Center 9.x/8.x/7.x .
• SQL database experience in a high transaction and multi server production environment.
• Experience in Database Development, Data Warehousing, Design and Technical Management.
• Good understanding in database and data warehousing concepts (OLTP & OLAP).
• Hands on Experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2005/2008.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions and at database.
• Extensive experience with data modeling techniques, logical and physical database design.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using DTS and SSIS services.
• SQL Server 2008/2005 RDBMS database development including T-SQL programming.
• Extracted data from File Sources, Relational Sources, XML and COBOL sources using Informatica PowerCenter.
• Experience in different Databases like Oracle 11i/10g/9i/8i/7x, SQL Server . .
• Expert in implementing business rules by creating Re-Usable Transformations like Mapplets and Mappings. Worked on Informatica BAPI transformation to Load and extract data from SAP R/3 system.
• Proficient in using Informatica Workflow Manager to create & schedule sessions and batches.
• Expert in using debugger in Informatica Designer tool to test and fix errors in the mappings.
• Worked on Informatica Administration for managing privileges to users, folder management, Migration from TEST to PROD Environments.
• Experience in administrating the created reports and assigning permission to the valid users for executing the reports.
• Worked on OLAP Data warehouse, Model, Design and Implementation
• Experience in upgrading from Informatica Powercenter 8.1 to Informatica Powercenter 9.1.
• In-depth understanding of Data Warehousing and Business Intelligence concept
• Designed and developed efficient Error handling methods and implemented throughout the mappings in various projects.
• Responsible for interacting with business partners to identify information needs and business requirements for Reports.
• Good Knowledge of Kimball and Inmon data warehouse design approaches and considerations
• Good understanding of dimensional models, slowly changing dimensions, star & snowflake schemas.

TECHNICAL SKILLS

Databases: Oracle 10g/9i/11i/R12, DB2, SQL server 7.0/2000/2005/2008 Languages Transact: SQL, PL/SQL,HTML, C

Operating Systems: Windows NT/98/2000/XP/Vista/2003, Linux, Unix, MS-DOS, Sun Solaris.

OLAP/Reporting Tools: SQL Server Analysis Service(SSAS), SQL Server Reporting Service(SSRS), Share Point MOSS 2007, Business Objects 6.x, Cognos Framework Manager

ETL Tools: SQL Server Integration Services (SSIS), SQL Server DTS, Informatica Power Center 9.x/8.x/7.x, Informatica Data Quality Suite 8.5, Cognos Data Manager, Pentaho Kettle

Data Modeling Tools: Microsoft Visio 2000/2003

SQL Server Tools: SQL server Management Studio, SQL server Query Analyzer, SQL server mail service, DBCC, BCP, SQL server profiler

Web Technologies: MS FrontPage, MS Outlook Express, FTP, TCP/IP, LAN,PHP

Other Tools: Microsoft Office, MS Visio, Visual Basic 6

PROFESSIONAL EXPERIENCE

Confidential

Sr. Data Curation ETL Specialist

Responsibilities:

• Design, architect, develop, and deliver applications using Informatica Power Center and FME server.
• Analyzing data structures in existing legacy systems to design extract, transform and load processes and data warehouse data structures using Informatica and FME server.
• Develop routines for ETL performance optimization.
• Providing technical support for issues including hands-on troubleshooting and implement enhancements and customizations.
• Using standard data modeling, data flow, and data documentation tools to analyze, document and present data analysis work.
• Support to the Confidential data curation program for various data enhancement, update, and creation activities.
• Providing assessments of technical and operational practices based on leading industry standards specific to the requested technology.
• Planning, organizing, and conducting research in a variety of areas, such as new or existing products, science, social science, law or business in support of an IT initiative.
• Searching sources such as reference works, literature, documents, newspapers, statistical records, and other sources of information. May use Internet, Intranet, magazines, periodicals, journals, and other media to perform research.
• Analyzing information and statistical data to prepare reports and studies for use by professionals.

Confidential, Columbia, MD

Sr. Informatica Developer

Responsibilities:

• Worked with Business Analyst and Analyzed specifications and identified source data needs to be moved to data warehouse, Participated in the Design Team and user requirement gathering meetings.
• Gathered user Requirements and designed Source to Target data load specifications based on Business rules.
• Used Informatica Power Center 9.6.1 for extraction, loading and transformation (ETL) of data in the DataMart.
• Designed and developed ETL Mappings to extract data from flat files, MS Excel and Oracle to load the data into the target database.
• Developing several complex mappings in Informatica using a variety of transformations, Mapping parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using Informatica PowerCenter.
• Expertise in conversions from SQL Server to Teradata.
• Extensively used ETL processes to load data from various source systems such as Oracle, Teradata and Flat Files, XML files into target system Oracle by applying business logic on transformation mapping for inserting and updating records when loaded.
• Use of Aggregator, Filter, Router, Expression, Joiner, Union, Normalizer and Sequence generator transformations.
• Ran the workflows on a daily and weekly basis using Active Batch Scheduling tool.
• Examined the workflow log files and assigning the ticket to the Informatica support based on the error.
• Experience in developing Unix Shell Scripts for automation of ETL process.
• Involved in doing error handling, debugging and troubleshooting Sessions using the Session logs, Debugger and Workflow Monitor.
• Performed operational support and maintenance of ETL bug fixes and defects.
• Maintained the target database in the production and testing environments.
• Created Mapping Parameters and Variables.
• Worked with Teradata utilities such as Mload, Fload, export etc. to load or extract tables.
• Created repository scripts automating export and import of Informatica Objects
• Supported migration of ETL code from development to QA and QA to production environments.
• Developed automated Test scripts using QTP to perform Functional and Regression testing
• Migration of code between the Environments and maintaining the code backups.
• Designed and developed Unix Shell Scripts, FTP, sending files to source directory & managing session files
• Done extensive testing and wrote queries in SQL to ensure the loading of the data.
• Developed PL/SQL code at the database level for the new objects.

Environment: Informatica Power Center 9.6/9.5, Oracle 11g, Teradata, Flat files, XML, Erwin, UNIX, PL/SQL Developer, Serena Dimensions

Confidential

Informatica Developer

Responsibilities:

• Worked with Business Analyst and Analyzed specifications and identified source data needs to be moved to data warehouse, Participated in the Design Team and user requirement gathering meetings.
• Worked on Informatica - Repository Manager, Designer, Workflow Manager & Workflow Monitor.
• Involved in discussing Requirement Clarifications with multiple technical and Business teams.
• Created Technical Design Document from the functional specification documents.
• Worked on Informatica tools such as Source Analyzer, Data Warehouse Designer, Transformation Designer, Mapplet Designer and Mapping Designer to designed, developed and tested complex mappings and mapplets to load data from external flat files and RDBMS.
• Used Informatica PowerCenter 9.1 for extracting Oracle, flat files for Data Extraction Involved in the development of Informatica mappings and also tuned them for better performance.
• Extensively used various transformations like Source Qualifier, Joiner, Aggregators, Connected & Unconnected lookups, Filters, Router, Expression, Rank, Union, Normalizer, and Update Strategy & Sequence Generator.
• Used SQL, PL/SQL, TOAD to validate the Data going in to the Data Ware House.
• Worked with BA in the QA phase of testing.
• Worked on Informatica Schedulers to schedule the workflows.
• Documented the approach in the Technical Design Document to be approved by the client and performed part of the data modeling in Erwin.
• Extensively involved in ETL testing, Created Unit test plan and Integration test plan to test the mappings, created test data. Use of Debugging tools to resolve problems.
• Used workflow monitor to monitor the jobs, reviewed error logs that were generated for each session, and rectified any cause of failure.
• Created Documentation(Runbook,Technical Design Document and Low Level Design Document) for Supporting the Application using Microsoft Word, Visio.

Environment: Informatica Power Center 9.1/8.6, Oracle 11g, PL/SQL, SQL, SQL*LOADER, Erwin, TOAD, Shell Scripting

Confidential

Informatica Developer

Responsibilities:

• Extensively Working on Informatica tools such as Source Analyzer, Warehouse Designer, Transformation Designer, Mapplet Designer and Mapping Designer
• Using Informatica Powercenter 8.6 and 9.1 to make the changes to the existing ETL mappings in each of the environments.
• Involved in the migration of Informatica 8.6 workflows into Informatica 9.1 version.
• Wrote PL/SQL procedures which are called from Stored Procedure transformation to perform database actions such as truncate the target before load, delete records based on a condition and rename the tables.
• Create ETL mappings with complex business logic for high volume data loads using various transformations such as Aggregator, Sorter, Filter, Normalizer, SQL Transformation, Lookup, Joiner, Router, Update Strategy, Union, Sequence Generator, transformation language likes transformation expression, constants, system variables, data format strings etc.
• Extensively worked on building workflows, worklets, sessions, command tasks etc.
• Extensively worked on ETL performance tuning for tune the data load, worked with DBAs for SQL query tuning etc.
• Proficient in implementing all transformations available on the SSIS toolbox.
• Using Source Qualifier & Lookup SQL overrides, Persistent caches, Incremental Aggregation, Partitions, Parameter Files etc for better performance.
• Created sessions to use pre & post session’s stored procedures to truncate the tables, drop & create indexes on tables for bulk loading.
• Working on change requests to the existing processes in production
• Used Event wait Task, Control Task, Email Tasks, Command Tasks, Link conditions in workflows.
• Bulk load the database tables from flat files using Oracle SQL Loader.
• Working on creating & modifying the unix shell scripts.
• Provide test data in QA/UAT for the downstream application testing.
• Involved in analyzing existing logical and physical data modeling with STAR and SNOWFLAKE schema techniques using Erwin in Data warehouse.
• Extensively worked on the Repository Manager to create/modify/delete users/group/roles.
• Involved in running the loads to the data warehouse and data mart involving different environments.
• Responsible for definition, development and testing of processes/programs necessary to extract data from client's operational databases, Transform and cleanse data, mask the data needed and Load it into data marts.
• Extensively used PL/SQL, TOAD programming in backend and front-end functions, procedures, packages to implement business rules.
• Integrated various sources into the Staging area in Data warehouse
• Provided production support to schedule and execute production batch jobs and analyzed log files in Informatica 8.6/& 9.1 Integration servers.
• Developed shell scripts to automate the data loading process and to cleanse the flat file inputs

Environment: Informatica Power Center 9.1/8.6, Oracle 11g/10g PL/SQL, SQL, SQL*PLUS, SQL*LOADER, TOAD, Erwin, Shell Scripting using AWK/ SED

Confidential

ETL Engineer

Responsibilities:

• Designed and developed various Informatica mappings using transformations like Expression, Aggregator, External Procedure, Stored Procedure, Lookup, Filter, Joiner, Rank, Router, Update Strategy and XML. Developed various Ad-hoc mappings for various business needs.
• Designed, tested, and deployed plans using Informatica Data Quality Suite 8.5
• Developed and tested all the backend programs, Error Handling Strategies and update processes.
• Experience in using Normalizer transformation for normalizing the XML source data.
• Extensively used XML transformation to generate target XML files.
• Developed Scripts to automate the Data Load processes to target Data warehouse.
• Responsible to tune ETL procedures and schemas to optimize load and query Performance.
• Involved with the Architecture group to develop ETL metadata strategies and Informatica objects reuse policies. Developed reusable Informatica Mapplet’s and Transformations.
• Developed ETL technical specs, Visio for ETL process flow and ETL load plan, ETL execution plan, Test cases, Test scripts etc.
• Involved in production support activities with Installation and Configuration of Informatica Power Center 8.6.
• Analyzed, Designed and Implemented the ETL architecture and generated OLAP reports.
• Used Informatica Workflow Monitor to monitor and control jobs.
• Developed stored procedures using PL/SQL and driving scripts using Unix Shell Scripts.
• Wrote stored procedures, functions, and database triggers. Created database triggers on tables to generate surrogate keys.
• Coordinated with Business Users to understand business needs and implement the same into a functional Data warehouse design.
• Interpreted logical and physical data models for Business users to determine common data definitions.
• Installation, Configuration and Deployment of Informatica 8.6 with Informatica GRID option.
• Assisted in documenting business requirements for data warehousing and integration needs.
• 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 4.0.
• Used SQL tools like TOAD to run SQL queries and validate the data loaded into the target tables.

Environment: Informatica Power Center 8.6, Informatica Data Quality Suite 8.5, IDQ, Teradata V2R6, Oracle 10g, DB2, TOAD, Erwin 3.5.2, PL/SQL, WINCVS, Windows XP, UNIX, Sun Solaris.