SUMMARY

• Around 8 years of extensive experience in Data migration, Database design and expertise in use of Informatica Power Center 9.x in data warehousing.
• Proficient in Design, Development, Implementation, Administration and Support of Informatica, DAC and Oracle Database.
• Extensively worked on Informatica Designer Components - Source Analyzer, Power Center Designer, Transformation Developer, Mapplet and Mapping Designer.
• Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).
• Implemented complex business rules in Informatica by creating Reusable Transformations, and robust mappings/mapplets. Experience in loading data, troubleshooting, Debugging and tuning of Informatica mappings.
• Designed and developed complex custom mappings, from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Sorter, Normalizer, Sequence Generator, Router, Filter, Expression, Aggregator, Joiner, Rank, Update Strategy, Stored procedure, XML Source qualifier, Input and Output transformations.
• Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control).
• Installed and Configured DAC (Data Warehouse Administration Console) to manage ETL process.
• Expertise in Data Modeling concepts including Dimensional Modeling, Star and Snowflake schema, Experience in CDC and daily load strategies of Data warehouse and Data marts, Slowly changing Dimensions (Type1, Type2, and Type3) and Surrogate Keys and Data warehouse concepts.
• Hands-on experience in Performance tuning of Informatica ETL Queries.
• Proficient in using Informatica workflow manager, workflow monitor, server manager, PMCMD (Informatica command line utility) to create, schedule and control workflows, tasks, and sessions.
• Experience in writing UNIX shell scripts and handling files with UNIX scripts.
• Expertise in developing PL/SQL Stored Procedures, Packages, Functions, Triggers, Indexes and Shell scripting.
• Experienced in coding using SQL, PL/SQL stored procedures/functions, triggers and packages.
• Extensive experience with ETL/Data warehousing tools in Financial, Healthcare, and Retail Industry.
• Created test cases and was part of UAT, SIT and functional testing.
• Excellent Team player with strong Analytical and Logical skills, Good communications skills.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 8.x/9.x, DAC, TOAD

Database Tools: HP Quality Center, Putty, PL/ SQL Developer.

ERP Applications: Oracle R12/11i (Inventory, Purchasing, OM and Financials)

Databases: ORACLE 8i/9i/10g, 11G, MS ACCESS, MS SQL Server 2008 R2/2014.

Languages: C, C++, SQL, PL/SQL, Shell Scripting.

Methodologies: SDLC, Agile.

Web and Application servers: HTML, XML, IIS.

Operating Systems: Windows 2000/2003/XP/Vista/7/8, UNIX, Linux.

PROFESSIONAL EXPERIENCE

Confidential, Branchburg, NJ

Sr. ETL Developer

Responsibilities:

• Involved in working with super users to gather Financial Analytics requirements and also to understand the existing issues.
• Understand and discuss ETL requirements with the Business and Functional requirement leads.
• Preparing detailed Technical design document on ETL process and fixed existing internal defects.
• Implemented Slowly Changing Dimension (SCD type II) design for the Data Warehouse.
• Developed several complex custom mappings in Informatica a variety of Power Center transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using the Informatica Power Center.
• Developing workflows with Worklets, Event waits, Assignments, Conditional flows, Email and Command Tasks using Workflow Manager.
• Migration of code between the Environments and maintaining code backups.
• Expertise in Performance Tuning by identifying the bottlenecks at sources, targets, Power Center Transformations and sessions like re-designing the mappings. Collected performance data for sessions and tuned by adjusting Informatica session parameters.
• Used debugger in debugging some critical mapping by setting breakpoints and trouble shoot the issues by checking sessions and workflow logs created and maintained various project related documents like high level design documents.
• Creating checklists for Coding, Testing and Release for a smooth, better & error free project flow.
• Creating the Release Documents for better readability of code/reports to end users.
• Handling User Acceptance Test & System Integration Test apart from Unit Testing with the help of Quality Center as bug logging tool. Created & Documented Unit Test Plan (UTP) for the code.
• Creating materialized views, tables, views based on the requirements in SQL developer. Creating Stored Procedures for the target MV.
• Created mappings and workflows in Informatica to call procedures and executing them.
• Used Workflow Manager for scheduling the interfaces.
• Unit testing Deploying all the Materialized Views, ETL objects to TEST. Fixing the defects found in System Testing, Debugging Mappings, Transformations, Workflows, Worklets, Sessions using Informatica Power center to fix the defects.

Environment: Informatica Power Center 9.6, SQL developer, Teradata, Oracle EBS, Oracle 11g, LINUX, WinSCP, Flat files, Unix Shell Scripting.

Confidential, Sterling, VA

Sr. Informatica Developer

Responsibilities:

• Interacted with Business Analysts and Users for gathering and analyzing the Business Reports Requirements.
• Closely worked with ETL team to configure Informatica connections, source DB connection and target DB connection in DAC.
• Worked closely with the Project Manager and Data Architect. Assisted Data Architect in design by doing source data analysis, rectifying the requirement documents, creating source to target mappings.
• Gathered requirements for GAP Analysis, translated them into technical design documents and worked in making recommendations to close the GAP.
• Worked with power center tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Extensively used Informatica Transformation like Source Qualifier, Rank, SQL, Router, Filter, Lookup, Joiner, Aggregator, Normalizer, Sorter etc. and all transformation properties.
• Developed ETL mappings, transformations using Informatica Power center.
• Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems.
• Responsible in developing the ETL logics and the data maps for loading the tables.
• Designed for populating Tables for one time load and Incremental loads.
• Worked on Informatica tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once. Monitored Workflows and Sessions using Workflow Monitor.
• Created complex mappings that involved implementation of Business Logic to load data in to staging area.
• Used Informatica reusability at various levels of development.
• Monitored incremental and full load of data through Data Warehouse Administration Console (DAC) and Informatica.
• Created, launched & scheduled sessions.
• Developed interfaces for loading the lookup and transactional data.
• Delivered the assignments before the deadlines.
• Did error analysis for continued improvement of the system by catching data anomalies and code issues.
• Wrote unit test cases, test scenarios, unit test documents and also verified the test scenarios of the QA team. Unit tested for all the possible test scenarios.

Environment: Informatica Power Center 9.5, SQL developer, Oracle EBS, Oracle 11g, Oracle DB, DAC 11g Windows XP/ NT/2003, UNIX, Linux, Shell scripting, SQL, PLSQL.

Confidential, Las Vegas, NV

Informatica Developer

Responsibilities:

• Requirement gathering and then develop and design ETL solutions as required.
• Understanding the requirement and Data model to develop the mappings accordingly.
• Creating High Level Design and Low Level Design documents.
• Designed and Developed Informatica Mappings from Scratch to Load the Data from Source System to Staging system and Warehouse System.
• Developed many complex Full/Incremental Informatica Objects (Workflows / Sessions, Mappings/ Mapplets) with various transformations.
• Writing ETL codes, UNIX scripts, SQL queries to check the desired results.
• Delivering the code on time as per schedule.
• Provided technical leadership to the team in order to produce system designs for the framework and code that are scalable, robust, reusable and flexible.
• Involved with the Data Modelling team and provided suggestions in creating the data model.
• Responsible for taking end-to-end ownership of the system for all the technical aspects.
• Implementing best practices and taking delivery standards to the next level.
• Owning design and code reviews and proactively improving system scalability, robustness, performance and flexibility.
• Provide inputs to Project Manager for project planning, providing robust estimates for development tasks.
• Mentoring team and ensuring that design, code / technical deliverables are of high quality.
• Ensuring high quality and zero defect deliveries.
• Involved in Coding, testing and preparing jobs as per the requirements specification.
• Performing Unit Testing for the development /enhancement performed.
• Responsible for debugging any defects came across in the developed mappings and providing logical answers to Testing team.

Environment: Informatica Power Center 9.1, SQL developer, Oracle EBS, Oracle 11g, LINUX, WinSCP, Flat files, Unix Shell Scripting.

Confidential

ETL Developer

Responsibilities:

• Involved in daily meetings to understand the existing issues and gather requirements.
• Implementing Slowly Changing Dimension (SCD type II) design for the Data Warehouse.
• Developing several complex mappings in Informatica a variety of Power Center transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using Informatica Power Center.
• Developing workflows with Worklets, Event waits, Assignments, Conditional flows, Email and Command Tasks using Workflow Manager.
• Creating Checklists for Coding, Testing and Release for a smooth, better & error free project flow.
• Redesigned some of the mappings and mapplets in the system to meet new functionality.
• Developed Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy and Aggregator.
• Created Sessions, reusable Worklets and Batches in Workflow Manager and Scheduled the batches and sessions at specified frequency.
• Created reusable Mapplets and Transformations to reduce the complexity in mappings and to handle repetitive tasks such as setting and getting Dimension details.
• Collected performance data for sessions and performance tuned by adjusting Informatica session parameters.
• Worked extensively on bug fixing on Mappings, and performing Unit and Integration Testing.
• Defined, captured metadata and rules associated with ETL process.

Environment: Informatica Power Center 9.1.0, SQL developer, Oracle 11g, LINUX, WinSCP, Flat files, Unix Shell Scripting.

Confidential

System Administrator

Responsibilities:

• Experience as a system administrator.
• Expertise in active directory concepts like DNS, DHCP, creating users, groups and assigning the appropriate permissions.
• Expertise in rebuilding the production servers using Altris tool and troubleshooting the network issues while building the servers.
• Experience is checking the server configuration and configuring the same after the server rebuilds.
• Experience in fixing the network related issues.
• Experience in fixing and updating the SQL and IPAK patches to the latest version of windows as per the client requirement.
• Experience in assigning the Virtual and dynamic IPs to the servers.
• Expertise in using the IADMIN tool and updating the tool with the changes in the server configurations.
• Worked with various data centers of multiple locations and configured their servers to the best of their interests.
• Worked in collaboration with data center management services team to check if the hardware packages are delivered to the respective data centers on time.
• Worked on various hardware failure requests for the servers and involved the corresponding teams at the local data centers to fix the issues and keep the servers running.
• Experience in maintaining the SLAs of the clients.
• Attended the project meetings and provided the service improvement plans for the project.

Environment: Windows Server 2008, SQL and IPAK versions Windows R2 2008, Altris tool for rebuild, IADMIN console, SharePoint.