SUMMARY

• Over Eight years of IT experience in analysis, design, development and implementation of Data warehouses, data marts and Decision Support Systems (DSS) using Informatica Power Center, TDM, ODI with Oracle, MS SQL server, DB2 and Teradata databases.
• Experience in Information Technology with special emphasis on Design and Development of Data Warehousing using Informatica Power Center 10.2/9.1/9.0.1/8.6 / 8.5 / 8.1.1 , Microsoft SQL Server 2012/2008R 2/2008/2005/2000 , T - SQL.
• Extensive experience with T-SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity.
• Hands on experience with Informatica ILM Workbench for data masking and TDM.
• Hands on experience creating mappings, Jobs, application and import sources to TDM repository, creating rules and Policies.
• Development and analysis and testing in the various areas of Data warehousing.
• Extensively used Informatica Client tools such as Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformations, Workflow Manager/Monitor, Informatica Repository Manager and Informatica Server Manager.
• Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server 2008r 2/2005/2000.
• Proficient in Oracle 10g/9i, T-SQL, PL/SQL, SQL*Plus, SQL developer and Toad.
• Extensive experience in data migration and integration using Data Loader.
• Thorough understanding of Software Development Life Cycle (SDLC) including requirements analysis, system analysis, design, development, documentation, training, implementation and post-implementation review.
• Proficient in implementing complex business rules through Informatica transformations, Workflows/Worklets and Mappings/Mapplets.
• Experience in debugging and Performance tuning of targets, sources, mappings, sessions and system and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.
• Experience in Installation, Configuration, and Administration of Informatica Power Center Client, Server and having handled FTP systems and release management.
• Experience in installing and configuring Oracle BI Applications (Informatica, DAC, OBIEE)
• Experience in design and development of Oracle Fusion Applications using Fusion technology stack which includes Oracle Data Integrator 10g/11g/12c.
• Worked on ODI 11g and ODI 12c studios.
• Gathering requirements from users to develop interfaces and packages.
• Good Understanding on ODI Navigators like Designer, Topology, Operator and Security Navigator.
• Sound knowledge on knowledge modules like RKM, LKM, CKM, IKM, and JKM.
• Experience in 24X7 on call Production support and preparing procedures/documentation whenever necessary.
• Possess excellent documentation skills, prepared best practices document’ s and have experience in data modeling and data modeling tools like Erwin.
• Extensive Experience in writing SQL queries, stored procedures, functions, packages, triggers, exception handlers, Cursors.
• Expert in Unit Testing, Integration testing and System Testing.
• Committed team player with multitasking capabilities. Excellent interpersonal and human relations skills. Strong communication skills, both verbal and written, with an ability to express complex business concepts in technical terms.

AREAS OF EXPERTISE

• Data Warehousing
• Informatica
• Unix
• Data Modeling.
• Structured Query Language PL/SQL Programming
• Scheduling
• Teradata
• OBIEE
• OLAP, OLTP
• Oracle 10g/9i/8i

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 10.2/9.x/8.x, ODI - Oracle Data Integrator 12c, Informatica IDQ

RDBMS: Oracle 8x/9x/10x, Teradata 13, IBM DB2, MS SQL Server, My SQL, Sybase, MS Access.

Data Management Tools: Test Data Management 10.1.x, 9.6.x

Business Intelligence: OBIEE 10G / 11G.

Scheduling Tools: Tidal, Autosys, Control-M.

Data Modeling: Erwin, ER Studio, MS Visio.

Dimensional Data Modeling: Star Schema Modeling, Snow-Flake Schema Modeling, Fact and Dimension Tables, Logical and Physical Data Modeling.

Programming Languages: SQL, T-SQL, PL/SQL, UNIX Shell Scripting.

Operating Systems: Windows 10,8/ Oracle Linux 4,5,6 / Red hat Linux

PROFESSIONAL EXPERIENCE

Confidential, Phoenix

Informatica Developer

Responsibilities:

• Involved in Applications Development and Project Management teams coordinating, scheduling and implementing.
• Understand the business needs and designs programs and systems that match the complex business requirements and records all the specifications that are involved in the development and coding process.
• Involved in Design meeting and reviews with Solution architects and Data architects for the data flow.
• Design, Develop, test and document best practice and scalable Informatica workflows, mappings, mapplets and transformations programs primarily using Informatica PowerCenter.
• Extract, Transform & Load into relational model structures of transactional databases.
• Performance improvement & tuning of Informatica mappings, SQL scripts.
• Extensively used Push Down Optimization in informatica for code optimization.
• Technical reviews, Data validation & end to end testing of ETL Objects, Source data analysis and data profiling.
• Create necessary documentation and update the project documentation (Change Requests and JIRA’s) on the confluence
• Worked on various data store like Netezza, MS SQL Server, Oracle 11g and Message Queues.
• Creates deployment instructions including failure recovery procedure and monitors successful data load of deployments.
• Participate in multiple mock data conversion tests to validate the conversion process and reduce implementation risk.
• Involved in Installing, coding, testing, implementing, debugging and documenting the complex programs.
• Responsible for assisting the project manager by compiling information from the current systems, analyzing the program requirements and ensuring that it meets the specified time requirements.
• Resolves moderate problems associated with the designed programs and provides technical guidance on complex programming.
• Ensures that all the standard requirements have been met and is involved in performing the technical analysis reviews.
• Work closely with Application Level Managers and Quality Assurance teams to fix the issues during development and production.
• Complete User Acceptance Testing (UAT) to understand the test process and fix any defects as found.
• Work closely with ALMs and QA teams to help them in setting up with right configuration for testing the product.
• Created and deployed the Tidal jobs.
• Worked closely with Operation teams to support the developed code.

Environment: Informatica Power Center 10.2.x, Oracle 11g, SQL Developer, Windows 10/Windows 8, SQL Server 2008/2012, Netezza, Tidal.

Confidential, Brentwood

Informatica TDM Lead/Test Data Engineer

Responsibilities:

• Worked closely with the Applications Development and Project Management teams coordinating, scheduling and implementing.
• Participated in the entire Software Development Life Cycle (SDLC) phases including Data Analysis, Design, Coding, Testing and Deployment.
• Involved in business requirement analysis and prepared functional requirement document
• Implemented different design patterns to Mask and generate test data as per functional test needs.
• Created different complex masking rules as per the enterprise needs to mask data across different databases.
• Extensively used In-place and In-stream masking to mask sensitive information according to the business needs.
• Created new generation rules and extensively used different advanced rules to generate realistic and valid data.
• Worked on different masking types like substitution, key, random, SSN, shuffle, credit card etc.
• Created rules, policies and used them across various projects for masking sensitive information.
• Created entities and plans to generate complex mappings using Informatica TDM.
• Generated test data using reference lookup strategy and entity strategy in various databases.
• Worked on creating numerous dictionaries and added to the LKP folder in the Informatica metadata.
• Created Data Flow Mappings to extract subset of data from production and Loaded to Target.
• Support the Client Reporting Production Environment as a priority.
• Involved in the analysis of source to target mapping provided by data analysts and prepared function and technical design documents.
• Worked on various tasks like Session, E-Mail task and Command task.
• Standardized parameter files to define session parameters such as database connection for sources targets.
• Involved in test data preparation as per test data strategy and standards.
• Performed tuning of Informatica Mappings for optimum performance.
• Used debugger to validate the mappings and gain troubleshooting information about data and error conditions.
• Extensively used Unix Scripting, Scheduled PMCMD and PMREP to interact with Informatica Server from command mode.
• Created Users, Groups, Roles and grant privileges to the users. Create folders, Relational and Application connections and configure the ODBC connectivity.
• Involved in the Upgrade of Informatica PowerCenter v9.1 to v9.6.1 and v9.6.1 to v10.1.
• Involved in the installation and upgrade of Informatica TDM.
• Worked with Admin team for migration strategy to the upgraded environments.
• Functionality, Back-end and Regression testing during the various phases of the application and Data Integrity/back end testing by executing SQL statements.
• Deliver end-to-end Data Archive and Data Subset solutions using Informatica Power Center, ILM and TDM.
• Scheduled meetings with Senior Data Leads and analyzed the data.
• Prepared the documents for all the modules developed.

Environment: Informatica PowerCenter 10.1.x/9.6.x, Informatica TDM 10.1/9.6.1, Oracle 11g, SQL Server 2012/2008, Windows 7, UNIX/Linux, Netezza, DB2, Toad, ER Studio.

Confidential, San Francisco

Sr. Informatica Developer

Responsibilities:

• Worked closely with the Applications Development and Project Management teams coordinating, scheduling and implementing.
• Participated in the entire Software Development Life Cycle (SDLC) phases including Data Analysis, Design, Coding, Testing and Deployment.
• Extensively worked on Error logging logic to capture the rejected/wrong data in the mapping for further analysis.
• Worked on Message Queues.
• Translated business, and functional requirements into technical document specifications.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy and Sequence generator, Procedure. Knowledge in use of SQL and Java Transformations.
• Extensively worked on Informatica Designer, Workflow Manager, and Workflow Monitor.
• Created expedited, emergency and standard RFC for code changes in Production.
• Created ETL mappings and Mapplets to extract data from source systems into Oracle.
• Responsible to tune ETL procedures and STAR schemas to optimize load and query Performance.
• Implemented Type II slowly changing dimension to keep a full history of dimensional data in the table
• Worked on connected and unconnected lookups.
• Analyzed/Profiled the source data and involved in the gap analysis and implemented rules to cleanse the data.
• Created different shell scripts and used them as pre/post session commands
• Create/Maintain database stored procedures, functions, packages, views, types, tables.
• Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Used Autosys for scheduling the jobs
• Produced a Unit-test Document, which captures the test conditions and scripts, expected/actual results
• Designed and Developed the Informatica workflows/sessions to extract from Flat Files, transform and load the data into Oracle.
• Developed data models according to company standards. Used DB2 Connect to extract multiple database source systems to single analytical system for large databases and 24*7 Production support for data warehousing

Environment: Informatica 9.5.1, Oracle 11g, Autosys, SQL Developer, UNIX, DB2, Message Queues, XML’s. ER Studio.

Confidential, Buffalo NY

Informatica Developer

Responsibilities:

• Worked closely with the Applications Development and Project Management teams coordinating, scheduling and implementing.
• Participated in the entire Software Development Life Cycle (SDLC) phases including Data Analysis, Design, Coding, Testing and Deployment.
• Translated business, and functional requirements into technical document specifications.
• Extensively worked on Informatica Designer, Workflow Manager, and Workflow Monitor.
• Created expedited, emergency and standard RFC for code changes in Production. Created ETL mappings and Mapplets to extract data from source systems into Oracle.
• Created different transformations for loading the data into targets using various transformations like Source Qualifier, Joiner transformation, Router, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, and Sequence Generator.
• Responsible to tune ETL procedures and STAR schemas to optimize load and query Performance.
• Implemented Type II slowly changing dimension to keep a full history of dimensional data in the table
• Worked on connected and unconnected lookups.
• Analyzed/Profiled the source data and involved in the gap analysis and implemented rules to cleanse the data.
• Created different shell scripts and used them as pre/post session commands
• Implemented error logging logic to capture the rejected/wrong data in the mapping for further analysis.
• Create/Maintain database stored procedures, functions, packages, views, types, tables.
• Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Used Autosys for scheduling the jobs
• Produced a Unit-test Document, which captures the test conditions and scripts, expected/actual results
• Closely worked with Business Objects (BO) team to ensure proper data in the reports
• Designed and Developed the Informatica workflows/sessions to extract from Flat Files, transform and load the data into Oracle.
• Created many files during the process, fixed length record file was created in one of the process which is like the COBAL layout.

Environment: Informatica 9.1, Oracle 11g, Autosys, SQL Developer, UNIX, Business Objects.

Confidential

ETL / DB Developer

Responsibilities:

• Involved in design and development of Business Requirements in liaison to business users and Technical teams by gathering requirement specification documents and identifying data sources and targets.
• Analyzed application requirements and provided recommended design and studied the current system to understand the existing data structures.
• Participated actively in user meetings and collected requirements from users.
• Maintained Offshore team with 6 resources for development works.
• Designed and developed star schema model for target database using ERWIN Data modeling.
• Used Informatica Power Center for extraction, transformation and loading (ETL) of source data on heterogeneous Database sources like Oracle, SQL Server, DB2, Teradata & flat files.
• Designed and developed several complex mappings using various transformations like Source Qualifier, Aggregator, Router, Joiner, Union, Expression, Lookup (Connected & unconnected), Filter, Update Strategy, Stored Procedure, Sequence Generator and used reusable transformations as well as mapplets.
• Worked with Workflow Manager for the creation of various tasks like Worklets, Sessions, Batches, Event Wait, E-mail notifications, Decision and to Schedule jobs.
• Extensively used the Slowly Changing Dimensions-Type II in various data mappings to load dimension tables in Data warehouse.
• Used ODI 11g for extraction, loading and transformation ETL of data in the data warehouse
• Worked on Oracle Data Integrator components like Designer, Operator, Topology and Security Components.
• Extensively involved in production issues.
• Gathering requirements from users/business to develop interfaces, packages, Load plans.
• Used Yellow Interfaces Reusable mappings in ODI 11g for developing most complex interfaces.
• Administered the repository by creating folders and logins for the group members and assigning necessary privileges using Informatica Repository Manager.
• Was responsible for the version control and up-gradation.
• Involved in the creation of partitions in Mapping to improve the performance of Informatica sessions.
• Involved in extensive performance tuning by determining bottlenecks using Debugger at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Extensively involved in coding of the Business Rules through PL/SQL using the Functions, Cursors, Triggers and Stored Procedures in the server side.
• Involved in creation of Classes, Objects and Universes for reporting purpose using Business Objects Designer.

Environment: Informatica Power Center 9.X / 8.x, MS SQL server 2005/2008, Oracle Data Integrator 11g, Oracle 8i/9i, Teradata r12, SQL, PL/SQL, Shell Scripts, Windows XP, Unix, Espresso (ESP) Workload Manager.