SUMMARY

• Around 8 years of IT experience in Design, Analysis and development of software applications and implementation of Data warehousing using ETL with Oracle database on windows.
• Experience in developing and maintaining Data Warehouse applications using INFORMATICA
• Power center Developing complex Mappings, Reusable Transformations, Sessions and
• Workflows using Informatica ETL tool to extract data from various sources and load into target tables.
• Have a clear understanding of Data Warehousing concepts with emphasis on ETL and life cycle development.
• Extensively worked with data warehousing, ETL methodologies, technologies, using Informatica Power Center Client tools Designer, Repository manager, workflow manager/monitor and Server tools Informatica Server, Repository Server manager.
• Developed complex mappings in Informatica using different transformations Joiner, Aggregator, Update Strategy, Rank, Router, Lookup - Connected & Unconnected, Sequence Generator, Filter, Sorter, Source Qualifier, Expression, Union, Stored Procedure transformation etc.
• Excellent hands-on ETL Informatica Power Center (Source Analyzer, Warehousing Designer, Mapping Designer, Mapplet Designer, Transformation Developer) and Repository Manager, Workflow Monitor and Repository Server Admin Console with strong business understanding indifferent domains.
• Strong knowledge in Data warehousing concepts, dimensional Star Schema, Snowflakes Schema and Galaxy Schema methodologies.
• Vast Knowledge in Data Warehouse Development Life Cycle where all dimensions of development including Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center
• Good knowledge in working with Slowly Changing Dimension (SCD) Management type 1 and 2
• Served as developer on Informatica components that included Source Analyzer, Target Designer, Transformation Developer, Mapplet Designer and Mapping Designer
• Extensive knowledge in writing, testing and implementation of RDMBS such as SQL, PL/SQL, MYSQL and Sybase Database
• Strong Oracle database experience using Indexes, Triggers and Views. Highly proficient in large volume data migration to Enterprise Data.
• Extensively worked on data warehousing and decision support systems with relational databases such as Oracle design and database development using SQL, PL/SQL, SQL PLUS and TOAD.
• Highly proficient in the integration of various data sources involving multiple relational databases like Oracle 11g/10g/9i,MS SQL Server,DB2,COBOL Files and Flat Files.
• Experienced in supporting end-user reporting needs using Informatica. Efficiently involved in interacting with Business Analysts, Department Managers and Business Users. Competence to Manage and deliver results on multiple tasks by effectively managing time and priority constraints.
• Ability to address any ongoing or changing Business needs.
• Extensively worked in production support environment and process engineering related to day today business activities.
• Excellent communication and strong interpersonal skills with the ability to interact with end-users, managers and technical personnel.
• Highly skilled, motivated team player with excellent communication, inter-personal skills, analytical, logical programming skills and strong desire to achieve specified goals. Have good understanding at the conceptual level and possess excellent presentation.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.1,8.6,7.1,6.2

Data ware housing Concepts: OLTP, OLAP, Data Mart, ODS, Star Schema, Snowflake Schema, Dimensional modeling

Other Tools: Toad, Oracle SQL Developer, SQL Navigator

Databases: Oracle 9i, Oracle 10g, Oracle 11g, SQL, PL/SQL,SQL PLUS

Web Technologies: HTML, DHTML, XML

Operating Systems: Windows and UNIX

PROFESSIONAL EXPERIENCE

Confidential, Rochester, MN

ETL Developer

Responsibilities:

• Created mappings using Flat Files and Relational Targets
• Performed data analysis, assist data analysts with mapping data from existing systems and helped generate required SDLC documentation
• Assist the Development Lead in developing project plans to ensure Informatica solutions are executed flawlessly
• Worked with logical and physical database designs using model viewer Involved in writing the SQL and PL/SQL procedures and program blocks for data extraction, transformation and loading Extensively worked with Transformations like Router, Normalizer, Lookup, Aggregator, Expression and Update Strategy Transformations
• Key tasks included source-target analysis, design of source-target mapping specifications, development of Informatica mappings and workflows and end to end testing of interfaces
• Used Lookup Transformation to access data from tables, which are not the source for mapping and also used Unconnected Lookup to improve performance
• Created and implemented Informatica workflows
• Automation of ETL processes with scheduling tools and exception-handling procedures
• Optimized code performance by analyzing indexes, joins and views
• Developed complex mappings also involving Slowly Changing Dimensions (SCD) Type-I and Type II mappings in Informatica to load the data from various sources
• Used Repository manager to create Repository, User groups, Users and managed users by setting up their privileges and profile
• Used tools like TOAD to run SQL queries and validate the data
• Evaluated the performance issues in the data marts which included analyzing query plans by involving the DBA’s for the SQL override lookups
• Extracted data from various sources like Teradata and relational databases (Oracle)
• Used Debugger to test and track the path of the source data and also to check the errors in mapping
• Worked with fellow employees and client team members in planning, design development of ETL solutions

Environment: Informatica Powercenter 9.1, SQL server 2012, DB2, SQL Navigator, Oracle11g, Erwin, Autosys, Teradata, UNIX, Windows XP

Confidential, Wall-Street, NY

ETL/ Informatica Developer

Responsibilities:

• Worked closely with Business Analyst and the end users in writing the functional specifications based on the business requirement needs.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin 4.5 to design the business process, dimensions and measured facts.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica power center 8.6.1.
• Migrating from informatica 8.1.1 mappings into informatica 8.6.1 which consists of grid technology
• Understanding the domain and nodes as well as by using the informatica integration service to run the workflows in 8.6.1.
• Involved in massive data cleansing prior to data staging.
• Created mapping using XML, COBOL sources.
• Worked on power exchange to access the data from different sources and to avoid manual coding
• Innovative design for Change data capture of Suppliers and millions of Account every business day
• Experience with high volume datasets from various sources like Oracle, Text Files, and Relational Tables and xml targets.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy and Sequence generator, Procedure. Knowledge in use of SQL and Java Transformations.
• Created E-mail notifications tasks using post-session scripts.
• Worked with command line program paced to interact with the server to start and stop sessions and batches, to stop the Informatica server and recover the sessions.
• Created procedures to drop and recreate the indexes in the target Data warehouse before and after the sessions.
• Implemented Type1 and Type2 methodologies in ODS tables loading, to keep historical data in data warehouse.
• Debugging invalid mappings using break points, testing of stored procedures and functions, testing of Informatica sessions, batches and the target Data.
• Tuning the complex mappings based on source target and mapping, session level.
• Involved in performance and tuning the ETL processes.
• Wrote SQL, PL/SQL, stored procedures &triggers, cursors for implementing business rules and transformations.
• Used SQL tools like TOAD 9.5 to run SQL queries and validate the data in warehouse.

Environment: Informatica Power Center 8.6.1/8.1.1, Oracle11i, Informatica Power Connect / Power Exchange, TOAD, XML,PL/SQL, SQL server 2008, Windows

Confidential, Reston, VA

ETL/Informatica Developer

Responsibilities:

• Analyzed business requirements, performed source system analysis, prepared technical design document and source to target data mapping document
• Developed complex mappings using Transformations like Lookup (Connected and Unconnected), Joiner, Sorter, Rank, Source Qualifier, Router, Union, Aggregator, Filter, and Expression in the Power Center Designer.
• Involved in troubleshooting performance issues in the mappings and Optimized performance by tuning the Informatica mappings as well as SQL.
• Worked closely with QA team during the testing phase and fixed bugs that were reported Extensively worked with various re-usable components like tasks, workflows, Worklets,
• Mapplets, and transformations
• Worked with DB2 database and also with mainframe COBOLfiles. Developed Informatica workflows and sessions associated with the mappings using Workflow Manager
• Worked with session logs, Informatica Debugger, and Performance logs for error handling to fix
• Workflows and session failures.
• Created UNIX Shell Scripts for batch scheduling and loading process.

Environment: Informatica Power Center 6.2, Oracle 9i, DB2, PL/SQL, TOAD, SQL* Plus,SQL*Loader, SQL Server 2005, Autosys, and, Windows Server 2003.

Confidential

Informatica Developer

Responsibilities:

• Based on the requirements created Technical design specification documents for ETL Process.
• Analyzed the requirements to identify the necessary tables that need to be populated into the staging area.
• Involved in analyzing the source data coming from different Data sources such as Oracle, Sybase files, Flat files.
• Importing source and target tables from their respective databases.
• Created mappings using transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner and Union.
• Used Parameter files to define values for parameters and variables used in a mappings.
• Used workflow manager to create workflows, sessions. Use Debugger to gain troubleshooting information from the mappings.

Environment: Informatica PowerCenter 7.1, Oracle 10g, SQL, Windows.

Confidential

Jr. Informatica Developer

Responsibilities:

• Analyzed the source data and unloaded source data into flat files
• Executed UNIX scripts to Merge the data and to run sessions and workflows
• Designed and developed mappings in Informatica
• Performed Unit testing and Full volume testing
• Fabricated Files for testing (manually as well as in MS-ACCESS)
• Prepared UTRs for testing
• Target loading of data by running the JCLs
• Helped other team members and POCs in resolving issues
• Managed the Metadata associated with the ETL processes used to populate the data Warehouse.
• Responsible to tune ETL procedures and STAR schemas to optimize load and query Performance.
• Extensively worked in the performance tuning of the programs, ETL Procedures and
• Processes. Coded database triggers, functions and stored procedures and written many SQL
• Queries. Helped coding shell scripts for various administration activities for daily backup.
• Involved in Physical schema implementation, objects like table-space, table rollback
• Segments, Created database structures, objects and their modification as and when needed.
• Managed users & roles for database security, Maintained system security, control and monitor
• User access to database.

Environment: Database: SQL Server; Tools: Informatica 6.1 (ETL), SQL Query Analyser;