SUMMARY

• 7 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.
• Extensive experience with databases (MS SQL Server2008/2012, Oracle 8i/9i/10g/11g, Teradata 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 working with Informatica Data Quality (IDQ ) and MDM .
• 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.5/9.1/8.6.1/8.6 , Big Data edition 9.x, IDQ, MDM

Data Modeling: Dimensional Data Modeling, Star Schema, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin 7.1/4.x

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 9.2/8.6,Oracle SQL Developer, SQL Assistant, Autosys, Control M

Management Tools: MS-Office 2007, MS Project

PROFESSIONAL EXPERIENCE

Confidential - Virginia

Informatica Developer/Admin

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.
• Written Teradata SQL queries to join or any modifications in the table.
• 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.
• Extensively used tools ofMLoad, BTEQ, FastExport andFastLoadto design and develop dataflow paths for loading transforming and maintaining datawarehouse.
• 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.
• Worked with Informatica Data Quality and created Profiles and Scorecards and integrated with Informatica Power Center.
• 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 Confidential 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 Confidential 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 Confidential 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 PowerCenter 9.1.0, Oracle 10g, TOAD, PL/SQL, DB2, UNIX, Windows XP, SQL Server, AutoSys.

Confidential -Minnesota

Informatica Developer

Responsibilities:

• Involved with Business users to identify the process metrics and various key dimensions and measures.
• Developed mappings using the Transformations like Source qualifier, Aggregator, Expression, lookup, Router, Filter, Rank, Sequence Generator, and Update Strategy.
• Successfully Loaded Data into different targets from various source systems like Oracle Database, Flat files, XML files, SQL Server into the Staging table and then to the Confidential database Oracle.
• Performed incremental aggregation to load incremental data into aggregate tables.
• Made use of Post-Session success and Post-Session failure commands in the Session task to execute scripts needed for clean-up and update purposes.
• Performed Unix validation of Informatica mappings for source compatibility due to version changes at the source.
• Involving in trouble shooting of long running sessions and fixing bugs.
• Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Involved in Unit testing, System testing to check whether the data loads into Confidential are accurate, which was extracted from different source systems according to the user requirements.
• Extensive experience in troubleshooting and solving migration issues and production issues.

Environment: Informatica PowerCenter 8.6.1, Oracle 10g, TOAD, PL/SQL, UNIX, Windows XP/7, SQL Server 2008.

Confidential, Charlotte, NC

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: Informatica PowerCenter 8.6.1 (PowerCenter Designer, workflow manager, workflow monitor), Oracle, SQL Server, Windows XP, TOAD, Control - M.

Confidential

Informatica Developer

Responsibilities:

• Analyzed source data and gathered requirements from the business users.
• Prepared technical specifications to develop Informatica ETL mappings to load data into various tables confirming to the business rules.
• Worked with different sources such as relational databases, flat files for extraction using Source Qualifier and Joiner.
• Extensively worked on developing Informatica Mappings, Mapplets, Sessions, Workflows and Worklets for data loads.
• Created sessions and workflows to run with the logic embedded in the mappings using PowerCenter Designer.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to Confidential systems.
• Implemented performance issues on mappings to increase the efficiency of loading the data from various metrics to the Confidential database.

Environment: Informatica PowerCenter 7.1, Oracle 9i, TOAD, UNIX, Windows XP.