SUMMARY:

• 8+ Years of IT Experience in Designing, Development and Implementation of Data Warehouses & Datamarts with ETL & OLAP Tools using Informatica Power Center 9.5/ 9.1/8.x/7.x .
• Experience in using Informatica Power Center tools such as Source Analyzer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Experience in designing and developing mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy.
• Worked on Oracle PL/SQL programming, stored procedures, creating triggers, sequence generator on the target table.
• Proficient in using Informatica Big Data edition 9.x
• Experience in extracting data from HDFS and also loading into Hive table.
• Extensive experience with databases (MS SQL Server2008/2012, Oracle 8i/9i/10g/11g, and IBM DB2).
• Experience of handling slowly changing dimensions to maintain complete history using Type I, Type II .
• Strong knowledge of Entity - Relationship concept, Facts and dimension tables, OLTP Data Modelling and Data warehousing concepts(Star Schema and Snow Flake Schema).
• Strong experience in performance tuning, debugging and Error handling of mappings, sources and targets for better performance, also identified and fixed the bottlenecks.
• Experience in preparing and running Sessions/tasks, Work Flows and Batch processes in Informatica Server.
• Experience in extracting data from HDFS and also loading into Hive table.
• Having a good understanding of Teradata.
• Worked on-call and Production Support.
• Have good experience as Informatica administrator in creating domains, repositories and folders.
• Excellent written and verbal communication skills, good analytical reasoning and ability to learn quick and high adaptability to new tools and technologies.

TECHNICAL SKILLS:

ETL: Informatica Power Center 9.6/9.5/9.1/8.6.1/8.6, Informatica Big Data Edition 9.x, Informatica DQ 9.x

Data Modeling: Dimensional Data Modeling, Star Schema, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin

Data Bases: Oracle 11g/10g/9i, MS SQL Server2008/2012, MS Access, Teradata

Operating System: Windows 98/NT/2000/XP/7, UNIX, MS-DOS

Applications: MS Office, MS Project, Toad 10.6/9.2,Oracle SQL Developer, SQL Assistant

Management Tools: MS-Office 2013, MS Project

PROFESSIONAL SUMMARY:

Confidential, Salem NH

Informatica Developer

Responsibilities:

• Involved in gathering and analyzing the requirements and preparing business rules.
• Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations to implement complex logics while coding a mapping.
• Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded into Oracle.
• Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager.
• Involved in creating new table structures and modifying existing tables and fit into the existing Data Model.
• Extracted data from different databases like Oracle and external source systems like flat files using ETL tool.
• Extracted data from Hadoop File Systems (HDFS) and also loaded into Hive tables.
• Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data.
• Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica 9.5.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.
• Involved in Performance Tuning of mappings in Informatica.
• Good understanding of source to target data mapping and Business rules associated with the ETL processes.

Environment: Informatica 9.5, Informatica Big Data edition 9.x, Oracle 11g,SQL, PL/SQL, Toad 10.6, Erwin,SQL Loader, Control-M, Unix, Flat files, FTP, GIT, Version Manager.

Confidential, Charlotte NC

Informatica Developer

Responsibilities:

• Interacted actively with Business Analysts and Data Modelers on Mapping documents and Design process for various Sources and Targets in corresponds to project coordination.
• Used transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure and update strategy to meet business logic in the mappings.
• Built DQ transformations using Informatica Data Quality (IDQ).
• Written Teradata SQL queries to join or any modifications in the table.
• Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
• Created Workflows and used various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Session in the workflow manager.
• Involved in loading of data into Teradata from legacy systems and flat files using complex scripts.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed. Debugged the mapping of the failed session.
• Developed, executed Test Plans and Test Cases to validate and check Referential integrity of data extracts before loading it to Data Warehouse.
• Developed FTP scripts and Extraction of Unstructured Data from various Verizon Data formats using Perl/Shell Scripts. XML/flat file formats and extracted successfully.
• Extensively worked on SQL tuning process to increase the source qualifier throughput by analysing the queries with explain plan, creating new indexes, partitions and Materialized views.
• Designed and developed error handling and rekey mechanism in Informatica.
• Created repository & assigned grants to users to access the repository.

Environment: Informatica Power Center 9.5, Informatica Power Exchange 9.5, IDQ 9.x,Teradata, Oracle 11g, PL/SQL, XML, Flat files, UNIX (AIX 5.3), Toad, SQL * Loader, AS400, DB2, Shell & Perl Scripting, HP Quality Center.

Confidential, Herndon VA

Informatica Developer

Responsibilities:

• Involved in various phases of SDLC from requirement gathering, analysis, design, development and testing to production.
• Involved in discussion with business users and defining Functional and Technical business requirements
• Identified all the conformed dimensions to be included in the target warehouse design and confirmed the granularity of the facts in the fact tables
• Extensively created Reusable Transformations and Mapplets to implement the business logic for loading to the target database
• Extensively used all the Transformations like source qualifier, aggregator, filter, joiner, Update Strategy, Unconnected and connected Lookups, Router, Sequence Generator etc. and used transformation language like transformation expression, constants, system variables, data format strings etc.
• Extensively worked on Workflow Manager and Workflow Monitor to create, schedule, monitor Workflows, Worklets and various tasks like command, assignment, control and session tasks
• Extracted data from various source systems like Oracle, SQL Server and flat files as per the requirements
• Developed various sessions containing multiple sources file
• Designed and developed UNIX shell scripts as part of the ETL process to compare control totals, automate the process of loading, pulling and pushing data from and to different servers
• Implemented Slowly Changing Dimension(SCD)Type 1 and Type 2 for inserting and updating Target tables for maintaining the history
• Provided production support by monitoring the processes running daily
• Extensively worked on ETL performance tuning to tune the data load and worked with for SQL query tuning.

Environment: Informatica Power Center 9.1, UNIX, PL/SQL, Oracle, MS SQL Server 2005/2000, Erwin

Confidential, Plano, Texas

Informatica Developer

Responsibilities:

• Involved in requirement analysis, ETL design and development for extracting data from the source systems like Oracle, flat files, XML files and loading into datamart.
• Developed complex mapping logic using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Sorter, Router, Update strategy and Sequence generator.
• Extensively used various oracle utilities like triggers, cursors, PL/SQL procedures and functions.
• Converted functional specifications into technical specifications (design of mapping documents).
• Developed complex mappings to load data from multiple source systems like Oracle, flat files and XML files to datamart in Oracle database.
• Created Perl scripts for better handling of incoming source files such as moving files from one directory to another directory and extracting information from file names, such as date, for continuously incoming sources.
• Wrote scripts to ensure e-mails sent to respective people on Failure/Success, error handling, control /auditing of different processes.
• Involved in Performance Tuning of existing mappings as well as new ones.
• Wrote complex SQL scripts to avoid Informatica joiners and Look-ups to improve the performance as the volume of the data was heavy.
• Used the Rational Clearcase for versioning the various objects like the mappings, workflows, SQL scripts.
• Involved in Unit and Sub System Testing.
• Wrote views, procedures and developed sessions for QA and production support.

Environment: s: JDK1.5, Struts1.2, Tiles, Hibernate, JSP, JSF, Servlets, Web Services, JMS, JSTL, XML, XMLSpy, JavaScript, Websphere6.0, Oracle 9i, Rational Rose, Subversion, Eclipse, JUnit, ANT.

Confidential, Tampa, Florida

Informatica Developer

Responsibilities:

• Designed and Developed mappings needed for enhancement of project.
• Worked with Informatica Powercenter 8.6 Mapping Designer, Workflow Manager, Workflow Monitor and Admin Console.
• Created Informatica Mappings to populate the data into dimension and Fact tables
• Exported and Imported mappings between different Informatica folders and also Repositories
• Used different transformations like Aggregator, Lookup, Filter, Expression, Router, Update Strategy and Sequence Generator
• Informatica Debugger is used to test the mappings and fixing the bugs.
• Provided Production Support for IDS DSS and created Unix Shell Scripts to delete data that is older than 3 years from fact tables
• Experience in working with Informatica Service and Repository Service
• Familiar with Data Warehouse Architecture, design methodologies and best practices
• Experience with server log files, editing UNIX scripts, FTP files and checking space on server
• Scheduled Informatica sessions and workflows using Informatica Scheduler
• Performance and fine tuning of Informatica mappings
• Loaded data into datamarts on a daily basis
• Created new repositories and new folders within the repositories using Repository Manager
• Experience with Designer, Workflow Manager, Workflow Monitor and Repository Manager
• Involved in System testing and User Acceptance Testing

Environment: s: Informatica Power Center 8.x, Oracle 9i, DB2, TOAD, Erwin, SQL, PL/SQL, XML, Windows XP, HP UNIX

Confidential

Informatica Developer

Responsibilities:

• Designed and developed data tables to store employee payroll information.
• Interacted with end users to prepare system requirements.
• Identify the data and activities that need to be maintained.
• Experience in writing PL/SQL scripts, Stored Procedures and functions and debugging them.
• Responsible for Migration of Stored Procedures into Informatica Mappings for improving Performance issue.
• Involved in Performance Tuning of application by identifying bottlenecks in SQL, thus providing inputs to the application programmer, thereby correcting and implementing the right components.
• Created Session Task, Email and Workflow to execute the mappings. Used Workflow Monitor to monitor the jobs, reviewed error logs that were generated for each session, and rectified any cause of failure.
• Defined Target Load Order Plan for loading data into Target Tables.
• Involved in the documentation of the ETL process with information about the various mappings, the order of execution for them and the dependencies.

Environment: s: Informatica Power Center 8.x/7.x, Oracle 9i, TOAD, Windows 2000, PL/SQL, MS Excel, IBM UDB DB2, Erwin, UNIX, Business Objects, Autosys.