OBJECTIVE:

To apply my skills and experience in Data Warehousing and provide innovative solutions in various decision support environments using ETL.

PROFESSIONAL SUMMARY:

• 13 years of experience in implementing Data Warehouses, Relational databases and application development using Informatica, Oracle, SQL Server and Java.
• Over 10 plus years of experience in using Informatica PowerCenter 4.7, 5.1,6.0&6.2, 7.0, 7.1.4, 8.0,8.6, 9.1, 9.5,9.6, 10.2.
• Over 3 years’ experience in using Abinitio tool, ACE as the ETL tool.
• Good working experience with all the components in the GDE in Abinitio. Creating, Executing, Testing and maintaining the graphs in Ab initio.
• Good experience on AbInitio AIR and M commands.
• Well versed with various Ab Initio Parallelism techniques and implemented Ab Initio Graphs using Data Parallelism.
• Excellent working experience in Data Warehouse applications, directly responsible for the Extraction, Transformation and Loading (ETL) of data from multiple sources into Data Warehouse.
• Over 9 plus years of experience in working as Informatica System Administrator
• Expertise in Installing, Configuring and Administration of Informatica products.
• Experience in design, development, testing and implementation of applications in Oracle 9i/8i, SQL Server 7.0, SQL, PL/SQL, MySQL, SQL*PLUS, SQL*Loader, Oracle Developer 2000, Forms 6i/5.0/4.5, Reports 6i/2.5 and ODBC.
• Experience in writing UNIX Shell Scripts and Stored Procedures.
• Have exposure on Informatica Cloud Services
• Experienced as an established hands - on technical leader of Cloud Software Engineering teams.
• Performance Tuning of the systems.
• Experienced in user support and training end users for efficient use of developed applications.
• Excellent analytical and functional skills.

TECHNICAL SKILLS:

ETL Tools: Informatica 6.0/6.2/7.0/7.1/8.0/8.6/9.1/9.6/10.2 PowerCenter / Power Exchange/Data Quality/ Informatica Big Data management.

Abinitio ETL tool Databases: Oracle 7.2/8i/9i/10g/11g/12c, Teradata, DB2, SQL Server 6.5/7.0/2000/2002/2016

Languages: SQL, PL/SQL, SQL*Plus, Visual C++, C++, C, PERL, Java, & HTML

Operating Systems: UNIX, LINUX, Windows 95/98/NT/2000/XP/2012/2016, MS-DOS.

Reporting Tools: Cognos, Business Objects

Utilities: FTP, TOAD, Rapid SQL, Fast load, Multiload, tpump, MS Office, vi editor

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Informatica Administrator/Infrastructure Admin

Responsibilities:

• Installed and upgraded Informatica PowerCenter/Power Exchange/Data Quality software from 9.6 to 10.2.
• Working on a high-profile Integration project, Informatica Server management and Administration, IMAHUB and involved in multiple roles on different projects. Has worked in the capacity as both a Systems Analyst, as well as played major roles in spring bundles, fall bundles each year
• Worked closely with both developers and testers each day to communicate any issues that they are experiencing. Also coordinated and facilitated meetings as needed to discuss and work on project issues.
• Installed and configured Informatica software Installation on various Operating systems like Windows, Unix, Linux etc.
• Worked with the vendor for bug fixing, resolving Production issues and enhancement of the ETL process.
• Coordinated Informatica training classes for a large number of the business users, as well as the IT project members, on how to work with the Informatica Power center tool
• Worked on POC for Power Exchange Change Data Capture using Informatica Power exchange 9.1 HF, 9.6, 10.2 on various relational databases such as Oracle 11gR2,12c, SQL Server Denali, DB2 etc. that act as source and has documented CDC implementation steps and bug fixes for future use.
• Involved in Installing, Configuring and Administration of Informatica products.
• Involved in designing the Data Model, Dimension Model.
• Involved in ADMIN tasks like Creating, Managing User privileges, password management & folders.
• Worked on Migrating Informatica Objects from lower environment to higher environment.
• Devised mechanism and scripted various automated tools for Service monitoring on the Windows, Linux and Unix platforms
• Used Informatica Cloud Data Integration, Electronic Data Interchange (EDI)for global, distributed data warehouse and analytics projects.
• Installed and configured Informatica Big Data Management (BDM) for Hadoop.
• Worked on setting up Informatica CLOUD services and configured agents to access the ON- Premise metadata databases.
• Worked to form a cloud based big data engineering team to deliver platform automation and security.
• Experienced working in building and delivering Cloud Services and Cloud Automation solutions.
• Worked on Agile methodologies and attended Scrum meetings to report daily status on ongoing tasks.
• Developed Administrative scripts for Maintaining a clean and healthy PowerCenter Repository.

Environment: Informatica Power Center 7.1/8.0/9.1/9.6/10.2 , Unix, Oracle 8i, 10g, 11c, 12g, PL/SQL, SQL*Plus, Informatica Power Exchange, Data quality, Big Data Management

Confidential, Charlotte, NC

ETL Developer/Admin/Abinitio Developer/ Admin

Responsibilities:

• Build templates in application configuration environment. Designed the Data Flow from source systems. (SQL Server)
• Very good understanding of data warehouse environments and data models. Involved in Installing, Configuring and Administration of Informatica products.
• Created and maintained Ab Initio Graphs using various components like Join, Rollup, Reformat, Filter by Expression, Joiner, Scan, Lookup, Partition components
• Database experience using Oracle and Teradata.
• Good working experience with all the components in the GDE in Ab initio
• Creating, Executing, Testing and maintaining the graphs in Ab initio.
• Well versed with various Ab Initio Parallelism techniques and implemented Ab Initio Graphs using Data Parallelism
• Involved in designing the Data Model, Dimension Model.
• Involved in ADMIN tasks like Creating, Managing User privileges, password management & folders.
• Responsible for Developing Informatica ETL Jobs for extracting date from Various HP Cloud and Network applications
• Devised incremental strategies for stage extracts & DM loads.
• Designed mappings to capture dimensional changes and to maintain history of the data.
• As an Informatica Consultant was involved in complete SDLC, from requirement gathering client meetings, designing, testing, and fine tuning till delivering the product.
• Involved in Technical Design of DW applications, developed strategies in designing Data Marts & Dimensional Models.
• Extensive experience in developing complex mappings with Custom Transformations.
• Often involved in using XML sources in the mapping.
• Extensively used Informatica to design mappings to perform extraction, transformation & loading into multiple environments.
• Used Cursors and Stored Procedures for ETL Control tables and aggregate tables.
• Migrated objects across different environments, QA and Production.
• Created Materialized views in the ETL side for speeding up the Report build process.
• Created Scripts for refreshing the Materialized views in UNIX.
• Extensively used Unix Shell scripting and Tidal for Automation.
• Created flexible mappings/sessions using parameter & variables.
• Extensively involved in fine tuning the database like creating indexes, partitioning the stage and DM tables, analyzing the queries, tuned the mappings and sessions by using session level partitioning.
• Used Win CVS for Version Controlling.
• Extensive data cleansing knowledge developed different error handling processes.
• Responsible to tune ETL procedures and STAR schemas to optimize load and query Performance.
• Sourced data from 2 systems ICOMS and Vantage to Stage Databases on daily basis as incremental load, and data mart was built every day successful stage run completion.
• Involved in Installing, Configuring and Administration of Informatica products.
• Designed and developed business rules to generate Normalized data using Informatica.
• Involved in ADMIN tasks like Creating, Managing User privileges, password management & folders.
• Involved in Informatica Software Upgrade from 6.0 to 7.1.4
• Mappings were designed to cater the slowly changing dimensions.
• Maintained Shared Folders and Shortcuts, Repositories and User Security via Repository Manger.
• Database objects like Views, Partitioning and Stored Procedures for accomplishing the Complex logical situations were used.
• Migrated Repositories across environments.
• Devised Error Handling strategies during loads to handle volatile data.
• Designed Mapplets to minimize re-creation of similar processes.
• Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.
• Worked with mappings using expressions, aggregators, filters, lookup, update strategy and stored procedures transformations.
• Created UNIX Shell scripts for dynamically incrementing Parameter values during the session run.

Environment: Informatica Power Center 7.1/8.0, Unix, Oracle 8i, 10g, PL/SQL, SQL*Plus, Erwin 4.0, Win CVS, Cognos 7 series, Report Net Report, Toad, Tidal

Confidential, Purchase, NY

ETL Developer/Admin

Responsibilities:

• As a Developer, I was involved in extensive development of the mappings and the functional specifications.
• Provided technical lead to the development team to analyze, design and develop the Functional Model.
• Used Teradata utilities like Fastload, Multiload, Tpump to load data.
• Used BTEQ scripts to transform data and Fastexport scripts to export data.
• The project involved developing mappings for moving data from Flat Files to Staging Area (STG) and then to Data Warehouse (DWH) and then to Data Mart.
• The data to the warehouse was moved in a Normalized fashion while the Data Mart Involved dimensionally modeled data.
• Developed complex mappings using different transformations like Joiner, Filter, Normalizer, Aggregate, Rank, Lookup, Routers, Update Strategies, Stored Procedures etc.
• Developed mapplets, and Reusable lookup transformation that were frequently used.
• Used Update Strategy Transformation to update the slowly changing Dimension tables, Type2 updates was often used.
• Processed cleansing, purging and optimizing of the data using Custom/Advanced External Procedure (AEP) The process involved replacing non-standard data with the standardized data.
• Very efficient Error Handling Strategies were used to document the error handling in the mappings. Standard Error-Codes and Error-Descriptions were used.
• Used Informatica Workflow Manager (Informatica 7.1) to Create, Schedule, Execute and Monitor Sessions, Worklets and Workflows.
• As an Administrator was involved in Creating, Managing User privileges, password management & folders.
• Involved in Admin tasks like migrating the repositories across different environment.
• Extensively used Version Control to control the flow of mappings with checkout/check in procedures
• Workflow automation using PMCMD and Unix shell scripts.
• Created and used pre and post session commands used to do the various pre and post mapping functions. Also created PL/SQL stored procedures.
• Created Shell scripts (which were part of various mappings) to move and create compared files. This was used extensively to find the daily snapshot of the flat files.
• Closely worked with the Project Lead and the QA Team to do the Testing of the mappings.
• Identify test cases for unit testing of the mappings.
• Efficiently did Performance Tuning of the Mappings developed before Migrating the Mappings from Development to Production.
• Migration of the Mappings from Development to QA and then to Production.

Environment: Informatica PowerCenter 7.1 / 6.2, Teradata, PL/SQL, UNIX Shell Scripts, MS Excel, IBM AIX, Sun Solaris 8.0.