SUMMARY

• Over 12 years of IT experience, quick learner, easily adapts to various environments and very effective communication and interpersonal skills.
• Strong experience in Data Warehousing concepts, ETL process using Informatica 10.1/9.1/8.6.1/8.5/8.1 , PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor, OLAP, OLTP, Autosys and Control M.
• Expertise in working with relational database such as Oracle 11g/10g/9i, SQL Server 2014/2008 and Teradata.
• Advanced knowledge of data architecture, design and business processes ODS and Data Warehouse environments.
• Complete knowledge of data modeling principles, Star and Snowflake Schema, Operational Data Store and Slowly Changing Dimensions.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Experience in designing re-usable mapplets and transformations. Worked on implementing Slowly Changing Dimensions-TYPE 1/2 methodology.
• Extensively used Business Intelligence tools like Business objectsXIR2 and OBIEE for decision support systems.
• Good experience in UNIX and writing shell scripts for INFORMATICA pre & post session operations.
• Designed and developed complex mappings, from varied transformation logic like Advanced External procedures, stored procedures, UnconnectedandConnected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more.
• Experienced in tuning Informatica Mappings to identify and remove processing bottlenecks.
• Experience in integration of data sources like Oracle 9i/8i, DB2, SQL Server, Flat Files.
• Experience in developing and maintaining overall test methodology, documenting test plans and test cases based on baseline requirements.
• Excellent technical, logical, analytical and problem-solving skills to provide insight on development and application support.

TECHNICAL SKILLS

ETL: Informatics Power Center 10.1.0/9.1/8.6/8.5/8.1 , BDM, MDM

Operating Systems: Windows Server 2012/2008/2007/ XP, UNIX, RHEL LINUX, HP-UX and DOS

Databases: Oracle 12C/11g/10g/ 9i/8i, MS SQL Server 2014/2008, Teradata

Programming Languages: SQL, PL/SQL, UNIX Shell scripting

Tools: Toad, Erwin 9, Toad Data Modeler, ORACLE SQL Developer, Visio, Autosys, Tidal, Control M, Tivoli.

Reporting Tools: Business objects XIR2, OBIEE 11, Crystal Reports

PROFESSIONAL EXPERIENCE

Confidential

Sr. ETL / Informaticadeveloper

Responsibilities:

• Worked with Business users and architects to understand the requirements and designed ETL solutions.
• Designed and developed ETL mappings, high level design document, Source to Target Mapping document and test cases.
• Modeling the business rules into a functional star schema database design.
• Designed the Logical and physical structure of data marts using Erwin.
• Created several Medium and Complex Informatica Mappings in Power Center Designer to meet the data integration, cleansing and migration needs.
• Involved in Unit and Integration testing. Maintained test logs and test cases for all the mappings. Worked with HP Quality Center, validated test cases.
• Identified reusable functionality, developed reusable transformations, mapplets, sessions and worklets.
• Responsible for Performance tuning at various levels during the development. Identified performance issues in existing mappings by analyzing the data flow, evaluating transformations and tuned for better performance.
• Created Complex ETL Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Dynamic Lookup, and Connected and unconnected lookups, Filters, Sequence, Router and Update Strategy .
• Involved in optimization of ETL jobs and troubleshooting.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Responsible for Unit, Integration, Performance and System Testing of ETL environment and raising the defects in QC tool.
• Created documents and manuals for Informatica Installation, Configuration, Migration procedures ETL Architecture and Naming Standards.
• Prepared UNIX Shell Scripts and these shell scripts will be scheduled in AUTOSYS for automatic execution at the specific timings.
• Ability to meet deadlines and handle multiple tasks, flexible in work schedules.
• Trained people on Informatica PowerCenter 10.2.2 on Administration and Development.

Environment: Informatica Powercenter 10.2.2, Oracle 12c, SQL, PL/SQL, Red Hat Enterprise Linux Server release 7, Shell scripts, Flat Files, TOAD, Business Objects XIR2, OBIEE 11

Confidential, Richmond, VA

Sr. ETL / Informatica Developer

Responsibilities:

• Creating star schema data models, performing ETLs and validating results with business representatives.
• Supporting implemented BI solutions by: monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance and communicating functional and technical issues.
• Developed SQL queries using various joins and developed various dynamic SQL’s throughout the projects.
• Analyzed business requirements and developed test plan, test objectives, test strategies, test cases and created and executed Manual test cases.
• Worked on Informatica PowerCenter tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Involved in developing/tuning mappings to load data from relational tables and flat-file objects to target database and vice versa by applying business functionalities.
• Created various UNIX Shell Scripts for data cleansing and loading process. Maintained the batch processes using Unix Shell Scripts.
• Tuned sources, targets, mappings and sessions to improve the performance of data load.
• Prepared Technical design documents, High Level Design documents and Low Level Design Documents.
• Involved in optimization of ETL jobs and troubleshooting.
• Developed PL/SQL Procedures, Functions and Packages and used SQL loader to load data into the database.
• Designed and developed ETL logic for Dimension Tables using SCD type-1 and Type-2.
• Designed numerous mappings which have complex transformation logics to manipulate and load data to data warehouse.
• Provide support for the Development and testing teams in resolving application, connectivity and database performance issues.
• Performed a key role in implementing the oracle database migration from 9i to 11g R2.
• Sending the updated status report to the client/vendor manager on weekly basis. Discuss the issues and projects status in status call on a weekly basis.

Environment: Informatica Powercenter 10.1.0, Oracle 11g/10g/9i, SQL, PL/SQL, Red Hat Enterprise Linux Server release 6.2, Shell scripts, Flat Files, TOAD, Business Objects XIR2, OBIEE 11, Crystal Reports.

Confidential, Maryland

BI Specialist (ETL Developer/Admin)

Responsibilities:

• Involved in Installing, Configuring and maintaining the Informatica Server and Repository Server.
• Used Informatica PowerCenter/PowerMart 8.6/8.1/7.1 for extraction, loading and transformation (ETL) of data into the data mart.
• Migrated development mappings to production environment.
• Upgraded PowerCenter 8.1.1 to 8.6.1 on Solaris and zlinux.
• Worked with Tiwoli admin teams to schedule Shutdown and Startup scripts for Informatica services in Production.
• Involved in several Informatica Administration tasks like setting up users/folders and migration of the folders across multiple environments.
• Setup Project creations and setup unix accounts.
• Reviewed the CMS standards document to see if the projects are compatible with the standards.
• Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, rank, update strategy, lookup, stored procedure, sequence generator, joiner Transformation.
• Modifiedseveral of the existing mappings and created several new mappings based on the user requirement.
• Fine Tuned existing mappings to handle and extend Business requirements.
• Developed shell scripts for automation of Informatica session loads.
• Used pmcmd commands for interacting with Informatica, especially to invoke and run sessions.
• Created DataFlow Diagrams using Microsoft Visio to depict the flow of the Mappings.
• Extracted data from sources like DB2, Oracle, Informix and Delimited Flat files.
• Responsible for creation of detail design and technical specification documents.
• Supported and solved the production issues for the 3 applications (IUI, HETS and CBO/CSR).
• Worked closely with the scheduling (APCSS) team and Lockheed for some of the scheduling issues related to weekly updates for data mart.
• Wrote NDM (connect direct) scripts to push files from UNIX to mainframe.
• Involved in Informatica server code page changes from ASCII to UNICODE.
• Sending the updated status report to the client/vendor manager on weekly basis.
• Discuss the issues and projects status in status call on a weekly basis.

Environment: Informatica PowerCenter/PowerMart 8.x/7.x, Oracle 10g/9i/8i, SQL, PL/SQL, SQL*Plus, Sun Solaris, UNIX, Shell scripts, DB2, Flat Files, TOAD, F-Secure SSH client 5.3, Windows NT.