SUMMARY

• 6+years of IT experience as an ETL Developer/Program analyst, which includes Data Warehouse/Database Developer experience using Informatica Power Centre 9.1.6/8.x/7.x as ETL tool.
• Hands on experience in Optimizing Database querying, data manipulation and population using SQL and PL/SQL in Oracle, Teradata, DB2 UDB and SQL Server databases.
• Expertise with server - client computing and relational database environments.
• Experienced with data management and data processing techniques in SQL Server 2007. Also Verified and debugged SQL code.
• Software quality assurance and development experience with a wide variety of projects and environments.
• Experience in Data Warehouse/Data Mart Development Life Cycle using Dimensional modeling of STAR, SNOWFLAKE schema, OLAP, Fact and Dimension tables.
• Experienced in using Systems Development Methodology (SDM) documentation including Business Requirements Specs (BRS), Functional Specs (FS), ETL design and Test Plan Report.
• Extensive knowledge in developing system requirements, coding, system integration, system testing and verification & validation of software application.
• Good understanding of development lifecycle of projects with Informatica, Oracle and Teradata.
• Experienced in writing and modifying ETL design documentation, test results documentation and standard operating procedures (SOP) documentation.
• Experience in developing Shell scripts on UNIX and experience with UNIX command line.
• Experienced in manual, automation testing and quality assurance.
• Developed dashboard reports using OBIEE 11g/10g.
• Knowledge of automated test tools - QuickTest Pro, WinRunner and LoadRunner.
• Self motivated and industrious professional with good technical, communication, interpersonal and leadership qualities with excellent analytical and problem solving skills applied to simplify business processes.
• Enthusiastic learner, creative and smart worker with strong work ethics and commitment to work to achieve Client's objectives.

TECHNICAL SKILLS

ETL TECHNOLOGY: Informatica Power Center 9.1/8.6/8.1/7.5 , Power Exchange 9.1/8.6

DATA WAREHOUSE: Multidimensional Model Design, Star Schema Development, Erwin 7.1

WEB TECHNOLOGIES: HTML, .NET

DATABASES: Oracle11g/10g, MS SQL Server 2007, MS Access, MySQL, DB2Teradata 13/V2R5

PROGRAMMING: C, C++, SQL, PL/SQL, HTML,UNIX Scripting#

REPORTING TOOLS: OBIEE 11g/10g, Bugzilla, CVC, SVN

OPERATING SYSTEMS: Windows NT/XP/7, Sun Solaris, Linux, UNIX, MS-DOS

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

Sr. ETL Developer

Responsibilities:

• Interacted with business community and gathered requirements based on changing needs. Incorporated identified factors into Informatica mappings to build Data Warehouses.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse.
• Developed mappings to extract data from SQL Server, Oracle, Flat files, DB2, Mainframes and load into Data warehouse using the PowerCenter, PowerExchange.
• Conducted Database testing to check Constraints, Field size, Indexes, Stored Procedures, Created testing metrics using MS-Excel.
• Implemented various identifying Bottleneck Performance Tuning technique on Source, Targets, Mapping, Sessions and Workflows.
• Designed and developed UNIX shell scripts to schedule jobs. Also wrote pre-session and post-session shell scripts, Wrote PL/SQL scripts for dropping, rebuilding indexes.
• Performed Configuration Management to Migrate Informatica mappings/sessions/workflows from Development to Test to production environment.
• Collaborated with Informatica Admin in process of Informatica Upgradation from PowerCenter 8.6 to PowerCenter 9.1.
• Extensivly worked with various caches customization like Static cache,Dynamic cache,and persistant cache.
• Developed workflow dependency Informatica task using Event wait task, Command task, Event raise, Decision task and Control task.
• Worked closely with the business analyst’s team in order to solve the Problem Tickets/ Service Requests.
• Involved in L3 support of the project.
• Constructed MLOAD and Fast load Teradata script to load huge set of data.
• Worked with Offshore team for development, testing and production support.

Environment: Informatica Power Center 9.1/8.6, Oracle 11g, SQL, PL/SQL, Informatica Power exchange 9.1/8.6, MS SQL Server 2007, Teradata 13, Flat Files, Windows XP, Microsoft office 2007, UNIX Shell Scripting, Linux,SQL*Loader TOAD, SQL Developer

Confidential, Stamford, CT

Informatica Developer

Responsibilities:

• Involved in overall SDLC lifecycle of the project in all stages right from the Analysis, requirement gathering, IVSC SDM design, development & reporting requirements.
• Created documents like the TDD, STT and UTP to suffice all the business requirements for the project.
• Involved in analyzing the different interfaces and source systems like AMS, EBIZ, LAI, AFC, and AutoVIN which were as part of the initial phase of the SDM working closely with the Business.
• Worked very closely with Architects to drive the Logical & physical models for the project looking into different subject areas and inter relations between each entity which derived in creating different set of tables for SRC, XREF, STG & TGT tables for the respective Dimension & Fact tables in the SDM.
• Design and develop Extract Transform and Load (ETL) and Data Integration (ETL) solutions for complex functional and technical requirements using Informatica Power Center and Power Exchange.
• Design and develop CDC and Data map using Power Exchange 8.6.
• Creating Power Exchange Registration and Customizing power Exchange connection property and creating restart token.
• Created workflows and used various Tasks like Email, Timer, Scheduler, Control, Decision and session in the workflow manager.
• Designed same set of mappings, mapplet & components to reuse for both Historical initial loads and incremental loads to pick data without manual intervention.
• Defined Target load order plan for loading data into different Target Tables.
• Documented different scenarios in the UTP and their results considering the business requirements for each table separately. Did Performance tuning and optimized if any bottlenecks were found in different areas.
• Worked with the business users to assist them with the system and UAT and system end to end test.
• Developed ftp scripts for external file processing with the system to integrate with Informatica. Documented the issues & failures occurred during each phase of the project.
• Did the code migration each environment to the other keeping in sync all the required objects of Informatica, UNIX, Windows and the DB scripts in a synchronized manner using versioning and migration documents.
• Used my expertise in debugging issues and knowledge sharing when others in the team required it.
• Created Project run book for the production support team and transitioned it over to them along with all the issues and resolutions. Worked on Production support until transition was done to the support team and as part of thewarrantyof the project developed. Documented all the process in detail at every phase of the project.

Environment: Informatica PowerCenter 8.6, PowerExchange 8.6, Oracle11g, Toad, SQL Server 2007, HP Quality Center 9.2, Clear case, Windows XP, Microsoft office 2007, MS Visio 2007, Unix, Linux

Confidential, Phoenix, Arizona

Informatica Developer

Responsibilities:

• As a team member involved in collecting all the requirements for building the database.
• Involved in Creation and designed required tables, indexes and constraints for all production activities.
• Coordinate with internal and external customers as necessary.
• Involved in creation of Logical Data Model for ETL mapping and the process flow diagrams.
• Worked with SQL developer to write the SQL code for data manipulation.
• Develop, execute and maintain appropriate ETL development best practices and procedures.
• Involved in unit testing of the mapping and SQL code.
• Developed various mappings using Mapping Designer and worked with Source qualifier, aggregator, connected unconnected lookups, Filter transformation, and sequence generator transformations.
• Involved in performance tuning of source & target, mappings, sessions and workflows.
• Worked with connected, unconnected lookups and reusable transformations and mapplets.
• Utilized Unix Shell Scripts for adding the header to the flat file targets.
• Used SQL, PL/SQL for database related functionality.
• Prepared test plans, test cases and procedures for both automated and manual testing.
• Reviewed requirements, software design, and coding.
• Involved in different Team review meetings.

Environment: Informatica PowerCenter 8.6, SQL Server, Oracle 10g, Teradata V2R5, Toad, UNIX Shell Scripting, Flat Files, C#, CVS.

Confidential, Plano, TX

Informatica Developer

Responsibilities:

• Developed ETL jobs to extract information from Enterprise Data Warehouse.
• Responsible for developing the mappings from given technical documents using various transformations like Aggregator, sorter, update, expression, etc.
• Experience in modifying changes to the existing mappings according to user requirements.
• Worked with sources like flat files, oracle and DB2 tables and Target database is oracle.
• Wrote various types of SQL queries involving joins, aggregate calculations and tuning the queries to optimize performance.
• Performed extensive testing and wrote queries in SQL to ensure loading of the data.
• Performed unit testing at various levels of the ETL and documented the results.
• Set Standards for naming conventions and best practices for Informatica mapping development and migration of mappings to QA and Production.
• Created Session, Event, command, and Control Decision and Email tasks in Workflow Manager.
• UsedInformaticadebugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Extensively used Expression, Joiner for heterogeneous sources, lookup, filter, aggregate, and update strategy transformations to transform data before loading into the target tables.
• Developed workflow sequences to control the execution sequence of various jobs and to email support personnel.
• Responsible for implementation of one time data movement and data replication methods.
• Prepared migration checklist, fixed the errors, documented the changes applied and test results.
• Setting up batches and sessions to schedule the loads at required frequency using Power Center Workflow manager and also using scheduling tools. Generated completion messages and status reports using Workflow manager.
• Developed and implemented the UNIX shell scripts for the start and stop procedures of the sessions.
• Used UNIX shell scripts to run the batches too.
• Used Agile software development methodologies based on iterations which allowed the project to adapt the changes quickly.

Environment: InformaticaPower Center 8.1, Oracle 10g, DB2 OS/390 8.1.5, SQL Plus, PL/SQL, Microsoft Sql Server 2005, UNIX, Agile framework, Windows XP.

Confidential, Grand Rapids, MI

Database Developer/ETL Developer

Responsibilities:

• Worked with business analyst for requirement gathering, business analysis, and testing and project- coordination.
• Analyzed mapping logic to determine the reusability of the code.
• Performed System Design, Functional Coding, System Integration, Unit& Integration testing per company and customers requirement.
• Created Unit test plans and did unit testing using different scenarios separately for every process. Involved in System test, Regression test & supported the UAT for the client.
• Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
• Involved in Data Modeling and design of Data Warehouse and Data Marts in Star Schema methodology with conformed and granular dimensions and fact tables.
• Used SQL, PL/SQL for database related functionality.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Created and maintained the Shell Scripts and Parameter files in UNIX for the proper execution of Informatica workflows in different environments.
• Performed various software development tasks, including software Requirements Specification (SRS), Software Requirements Document (SRD), and Low Level Requirement documents.
• Resolving the issues and problem reports from the customer, Verification and Validation team.
• Extensiveindividual knowledge of understanding SDLC processes.
• Prepared test plans, test cases and procedures for both automated and manual testing of Applications and Client-Server architecture.
• Used SQL queries in MS Access and SQL Server databases to query backend DB tables for data and interface verification.
• Used software configuration management tools (CVS, SVN).
• Performed the System and Software Reviews.
• Involved in Estimation and Planning.
• Demonstrated good co-ordination and communication skill between the teams.

Environment: Informatica Power Center 8.1, Unix Shell scripting, Oracle, SQL, PLSQL, flat files, DB2.

Confidential, Jersey City, NJ

Informatica Developer

Responsibilities:

• Gathered business and technical requirements for project.
• Developed number of complex Informatica mappings, mapplets and reusable transformations to implement the business logic and load the data incrementally.
• Extensively used ETL to transfer data from different source system and load the data into the target database
• Performed System Design, Functional Coding, System Integration, and Unit& Integration testing per company and customers requirement in project.
• Performed various software development tasks, including software Requirements Specification (SRS), Software Requirements Document (SRD), and Low Level Requirement documents.
• Designed the reusable code for the data validation across the release.
• Developed Test Cases for testing the ETL mappings.
• Resolved the issues and problem reports from the customer.
• Used SQL queries in MS Access and SQL Server databases to query backend DB tables for data and interface verification.
• Involved in unit testing of the mapping and SQL code.
• Developed mappings to load data in changing the dimensions.
• Involved in performance tuning of source & target, mappings, sessions and workflows.
• Worked with connected, unconnected lookups and reusable transformations and mapplets.
• Utilized Unix Shell Scripts for adding the header to the flat file targets.
• Prepared test plans, test cases and procedures for both automated and manual testing.
• Established and Executed Test procedures.
• Prepared Quality Documents.
• Documented Test results.
• Reviewed requirements, software design, and coding.
• Resolving the issues and problem reports from the customer, Verification and Validation team
• Demonstrated good co-ordination and communication skill between the teams.

Environment: Informatica Power Center 7.5, Oracle 10g, SQL Server (7.0), SQL,PL/SQL, UNIX, Windows XP, C, C#.