SUMMARY

• 9+ years of IT experience in System Analysis, Design and Development in the field of Databases.
• 8+ years of Functional and Technical experience in Decision Support Systems - Data Warehousing and ETL (Extract, Transform and Load) using Informatica PowerCenter tools.
• Experience with working as a team through the project’s Software Development Life Cycle (SDLC) to analyze, gather project requirements, and to develop, test and maintain developed software using various approaches like Waterfall and Agile.
• Experience in OLAP concepts, Data Warehousing concepts and Relational & Dimensional Data Modeling (Star and Snowflake Schema).
• Designed customized ETL process to manage Metadata Dependencies and Relationships.
• Extensive experience in Power Center Repository Manager, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
• Experience in finding and fixing Data Quality problems using tools like Informatica Analyst, Data Explorer which enables profiling and analysis of data along with universal connectivity to all types of data sources.
• Experience in working on Informatica Cloud using various tasks like Data Replication, Data Synchronization etc.
• Well acquainted with Performance Tuning of sources, targets, mappings and sessions to overcome bottlenecks in mappings using Informatica and Database concepts.
• Highly proficient in designing and developing complex mappings from varied transformation logic like Lookups, Router, Filter, Transaction Control, Aggregator, Stored Procedure, Joiner, Update Strategy, SQL, Java, Union etc.
• Understanding & Working knowledge of InformaticaCDC (Change Data Capture) and Veeva Salesforce Data tables (SFDC).
• Involved in Parsing, Standardization, Matching, and ETL integration implementations.
• Thorough understanding on Match and Merge concepts in defining Match path components and Match rules and configuring theMatch and Merge Rulesto optimize the better Match percentage using IDQ results.
• Involved in creating Data Maps, extracting (incremental) CDC data from Oracle sources, exporting and updating them to the repository, importing the required source files on the staging environment by using Informatica Power Exchange.
• Extensively worked with ETL tools to extract data from Relational and Non-Relational databases i.e. Oracle, SQL Server, DB2, and Flat files.
• Extensive experience in various database development using PL/SQL, TSQL, Stored Procedures, Triggers, Functions and Packages.
• Knowledge of preparing SSAS Cubes for data analysis using SQL Server for basic Star and Snowflake Schemas as well as parent-child schemas.
• Experience with DAC administration in executing and monitoring Data Warehouse Applications.
• Experience in analyzing large databases, searching for patterns and summarizing data.
• Strong knowledge and experience in performance tuning both Informatica and Database.
• Involved in maintaining jobs and supporting jobs in Production Environment.
• Experience in creating Test cases for different sources like Relational sources, Flat files etc.
• Experience in Upgrading, Installing and Configuring Power Center 8.x/7.x/6.x on Client/Server environment.
• Experience with TOAD as an interface to databases, to analyze and view data.
• Experience of writing UNIX scripts as pre-sessions and/or post-sessions.
• Excellent analytical, problem solving, communication skills. Ability to interact with individuals at all levels.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.x/8.x/7.x/6.x, Informatica Power Exchange, Data stage 8.1, Cognos 7.x

Cloud Integration Tools: Informatica Cloud

EIM Tools: Informatica Data Quality 9.x/Informatica Data Explorer

Databases: Oracle 11g/10g/9i, SQL Server, DB2, Teradata V2R5, MySQL, Netezza

Database Tools: TOAD, SQL*Plus, Oracle SQL Developer, WinSQL

Operating Systems: MS Windows 2000/XP/Win7, UNIX.

Languages: C/C++, PL/SQL, UNIX/Linux Scripting, HTML, SQL

Modeling Tools: Toad Data Modeler, Microsoft Visio, Erwin 4.x/7.2

Scheduling Tools: UC4 Operations Manager 8.x/6.x, Informatica Scheduler, Control-M, Tivoli, Autosys

PROFESSIONAL EXPERIENCE

Confidential, Warren, NJ

Lead Informatica Developer/Analyst

Environment: HR Mart - Informatica Power Center 9.1, Oracle SQL Developer, Flat Files, Autosys, UNIX

Responsibilities:

• Assessed and Created Technical Specification Documents based on the requirements.
• Involved in assessing the previous HR system layouts and created design document for the ETL process
• Involved in ETL coding using Informatica tool to extract, transform, cleanse and load data from different source systems according to the DataMart standards.
• Developed Power Center mappings using various transformations like Aggregator, SQL, Normalizer, Union, and Lookups etc.
• Optimized some of the older code by changing the logic, reduced running time and encouraged the usage of reusable objects viz., and reusable transformations.
• Working with data conversions, standardizing, correcting, error tracking and enhancing the source data.
• Developed transformation logic and designed various simple and Complex Mappings in Designer with performance, accuracy and efficiency to achieve operational objectives.
• Converted several standalone procedures/functions in PL/SQL to packaged procedure for code reusability, modularity and control.
• Created shell scripts to implement miscellaneous tasks like copying source files, creating indicators, cleaning up files once the process is complete etc.
• Created mapplets and incorporated into PowerCenter mappings to standardized data.
• Setup Informatica batch jobs using Informatica Scheduler for DataMart.
• Provided monitoring and production support for the ClaimPATH nightly run loads.
• Performed audits on the data whenever a break in the data was identified.
• Involved in Migration of objects from Dev and Test server to Production servers.
• Worked with pmcmd command to communicate with the Informatica server, to perform various operations like start/stop workflows, gettaskdetails, getworkflowdetails by checking the performance detail and session logs.
• Created autosys scripts to schedule and process the jobs on a daily basis.
• Involved in monitoring tasks, workflows and performance for mappings in Workflow monitor.
• Fined tuned ETL processes by considering mapping and session performance issues.
• Prepared/maintained documentation on aspects of ETL processes to support knowledge transfer to other team members.

Confidential, Mooresville, NC

Lead Informatica Developer

Environment: Informatica PowerCenter 9.5, DB2, UNIX, Oracle SQL Developer, JCL, Mainframe.

Responsibilities:

• Interfaced with business to understand the requirements for the project.
• Assessed and Created Technical Specification Documents based on these meetings.
• Worked with technical lead to formulate the design for the new PVS and Adhoc process.
• Estimated and planned the development work using Agile Software Development.
• Involved in improving the functionality of existing Dotcom load process.
• Working on ETL coding using Informatica tool to extract, transform, cleanse and load data.
• Developing Power Center mappings using various transformations like Aggregator, Normalizer, Union, XML, Java etc.
• Created and developed the Adhoc process related to adding and removing of different products on Confidential website.
• Involved in creating the process to replicate and replace the current BODL model
• Developed the process to transfer existing and new attributes from BODL attribute dictionary to commerce database
• Assisted in the process of transferring product details and prices from Confidential to Google and Ebay feeds.
• Worked with QA testers and actively involved in setting up test cases.
• Involved in monitoring tasks, workflows and performance for mappings in Workflow monitor.
• Tuned the existing ETL processes by for mapping and session performance issues.
• Setup Informatica jobs using JCL on mainframe
• Prepared/Maintained documentation on aspects of ETL processes to support knowledge transfer to other team members

Confidential, Commack, NY

Sr. Informatica Developer

Environment: Informatica PowerCenter 9.5, Informatica Cloud, Oracle 11g, Veeva Salesforce, TOAD, UNIX, Informatica Scheduler, Windows 7.

Responsibilities:

• Involved in assessing the technical and business requirements needed for replacing the CRM system.
• Involved in estimates, planning and identifying options for potential risks/data gaps.
• Analyzed existing application and system to formulate logic for new process.
• Consult with Business analysts and Architects to understand, anticipate and meet current and future needs for the project.
• Used Informatica Cloud as Data Replication tool to extract data from Veeva Sales force.
• Worked on ETL coding using Informatica tool to cleanse, enrich and standardized data from various sources into staging.
• Created Data Replication Jobs to replicate Sales force tables in Oracle. Data synchronization Jobs were also created to synchronize data back to Sales force tables.
• Used Application Source qualifier to retrieve data from Salesforce and load data into SAP using BAPI transformations.
• Created scripts to createnew tables, views, queriesfor new enhancement in the application using TOAD.
• Developed Power Center mappings using various transformations like Aggregator, Union, Lookup, Joiner, Expression, Router, Filter, and Update Strategy.
• Involved in implementing processes to capture Delta changes along with Data profiling.
• Created process to extract and load product data from Oracle to SAP using BAPI transformation.
• Fined tuned ETL processes by considering mapping and session performance issues.
• Helped in Performance Tuning for Oracle using features such asQuery Optimizer, Execution Plans, Indexes and Database Partitioning.
• Designed and setup tasks using informatica scheduler to run the jobs based on schedule or on demand.
• Created Task flows and Schedules to run Cloud Jobs based.
• Provide on call support for the production systems and provide solutions when needed.
• Support any minor enhancements or service requests for the ETL process.
• Created, Updated and maintain ETL Technical Design documents (TDD).