PROFESSIONAL SUMMARY:

• 18+ years of experience in implementing Data Warehouses, Relational databases and application development using Informatica, Oracle, SQL Server and Java.
• Over 15 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, 10.4.
• Over 11 plus years of experience as Informatica Administrator that includes PowerCenter, Data Quality, Power Exchange, DVO, Informatica BDM with Hadoop, RULEPOINT and Process Monitoring
• Over 3 years’ experience in using Abinitio tool, ACE as the ETL tool
• 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 11 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 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 with Hadoop
• /Proactive monitoring/Rule Point/RTAM
• 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

Responsibilities:

• Installed and upgraded Informatica PowerCenter/Power Exchange/Data Quality software from 10.2 to 10.4.
• Working on Informatica Server management and Administration.
• Worked with installing and configuring Big Data Integration and Informatica cloud services (IICS)
• Created Real-time alert management which is basically a bunch of rules for monitoring PowerCenter repository. Session run, end time, abnormal termination etc. can be easily caught and reported for monthly analysis. With Rule point data Analysis, the repository data can be analyzed in real time.
• Worked on setting up Informatica Big Data Management.
• 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 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 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 ADMIN tasks like Creating, Managing User privileges, password management & folders.
• Worked on Automated in house tool for promoting code from lower to higher environment through Unix Shell scripts.
• 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.
• 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 /10.4, Unix, Oracle 8i, 10g, 11c, 12g, 12c, 19c, PL/SQL, SQL*Plus, Informatica Power Exchange, Data quality, Big Data Management

Confidential, Secaucus, NJ

Informatica Administrator/Developer

Responsibilities:

• Installed and upgraded Informatica PowerCenter/Power Exchange/Data Quality software from 9.6 to 10.2.
• Setup and configuration support for Informatica PowerCenter, Power Exchange, Data Quality, B2B Data Exchange, Managed File Transfer.
• Setup Cron jobs for scheduling Admin related tasks in Red Hat Enterprise Linux
• Provide 24/7 on-call support for Informatica platforms
• Manage and execute scheduled maintenances during database outages and OS platform outages.

Confidential, Charlotte, NC

Informatica Administrator/Developer

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 with installing and configuring Proactive Monitoring (v2.6) which requires Rule point 5.2 HF3 and RTAM 3.1 HF1 to be installed/configured.
• Created Real time alert management which is basically a bunch of rules for monitoring PowerCenter repository. Session run, end time, abnormal termination etc. can be easily caught and reported for monthly analysis. With Rule point data Analysis, the repository data can be analyzed in real time.
• Worked on setting up Hadoop environment and developed code using Informatica Developer to extract data from Hadoop and did the ETL work. Data was loaded into Microsoft SQL server database.
• 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 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 the 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.