SUMMARY:

• Over 13+ years of IT experience working on all phases of Software Development Life Cycle (SDLC) including application Design, Development, Production Support & Maintenance Projects
• Wide range of experience in Software development, Data Integration, Master Data Management(MDM), Data Quality assurance(IDQ), Metadata Management(IMM) and Data Governance Solutions.
• Extensive knowledge on Analysis, Designing of Documents like Technical Requirement Documents (TRD), Specification Design Documents (HLD and LLD) and Unit Test Plan.
• Extensive experience in Data Extraction, Transformation and Loading Data using Informatica Power Center 9.x/8.x (Admin Console, Informatica Service, Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Informatica Power Exchange 9.X
• Expertise in Master Data Management Concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• Experienced in integration of various data sources like Oracle 11g/10g, MS SQL Server 2012/2008 and Flat Files into staging area.
• Slowly Changing Dimensions Management including Type 1, 2, 3, Hybrid Type 3, De - normalization, Cleansing, Conversion, Aggregation, Performance Optimization.
• Worked on non-relational sources like Flat Files and used secure FTP.
• Worked on Exception Handling Mappings for Data Quality, Data Profiling, Data cleansing and data validation by using IDQ
• Installing and Configuring of Informatica MDM Hub Console, Hub Store, Cleanse and Match Server, Address Doctor, Informatica Power Center applications.
• Knowledge on implementing hierarchies, relationships types, packages and profiles for hierarchy management in MDM Hub implementation.
• Worked on Oracle PL/SQL programming, Stored Procedures, Creating Triggers and Sequence Generator on the Target Table.
• Extensively used SQL statements to query the Oracle Database for Data Validation and Data Integrity
• Created the SQL Views, Table pairs and created the DVO jobs for validating the Source and Target Tables data as part of Automation Testing.
• Developed Several Testing Strategies-Integration, System, and High-availability and Disaster recovery - which constituted to overall project effort
• Restoring the Database to Disaster Recovery Server.
• Worked on Performance Tuning Informatica Targets, Sources, Mappings and Sessions.
• Experience in developing Informatica Reusable components for using them across the projects.
• Extensively worked with Informatica Mapping Variables, Mapping Parameters and Parameter Files.
• Experienced in UNIX work environment, File Transfers, Job Scheduling and Error Handling.
• Experience on ER Data modeling tools like Erwin, ER-Studio and Visio in developing Fact & Dimensional tables, Logical and Physical models.
• Worked on OLTP and OLAP Systems.
• Good understanding of Kimball and Inmon methodologies.
• Excellent knowledge of both Batch and Online Systems.
• Excellent experience in project management, handling offshore and onsite teams (12 resources).
• Extensive knowledge in maintaining monthly metrics, weekly status reports and daily execution reports.
• Self-motivated and ability to meet operational deadlines in a demanding fast-paced environment and Capable of working independently as well as in a team.
• In-depth knowledge of the software development life cycle (SDLC) and excellent analytical and programming skills. .
• Comprehensive problem-solving abilities, good verbal and written communication skills.

TECHNICAL SKILLS:

Informatica Tools: Informatica Power Center 10.1/9.6/8.6/7.1, Informatica Power Exchange 9.5, Informatica Data Quality (10.1/9.6/9.1/8.6 ), Informatica MDM Multi-Domain 10.1/9.5, Informatica Data Director (IDD/BDD), SIF, Informatica Metadata Manager 9.6.1, Business Glossary, Informatica B2B(DX/DT)

Databases: SQL Server 2012 / 2008, Teradata 14, Oracle 11g / 10g, DB2.

Data Modeling: Erwin 4.1/3.X, SAP PowerDesigner 15

Scheduling Tools: UC4, Skybot, Tivoli, Crontab, Autosys, Control-M

Operating system: Red Hat Linux, UNIX, Solaris and Windows XP/Vista/7

Languages: SQL, PL/SQL, T-SQL, Java, C, C++, Shell Scripting

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Sr. Informatica Developer

Responsibilities:

• Extensively involved in almost all the phases of Project Life Cycle ( SDLC ) right from Requirements Gathering to Development, Testing and Implementation etc.
• Learned the company’s EDW architecture which consists of sources, middleware, staging area, data warehouse, and reporting tools.
• Worked on data profiling & various data quality rules development using Informatica Data Quality.
• Implemented Exception Handling Mappings by using Data Quality, Metadata, Data validation by using Informatica Analyst.
• Involved in implementing the Land Process of loading the customer Data Set into Informatica MDM from various source systems.
• Worked on data cleansing and standardization using Cleanse Adapter’s in Informatica MDM.
• Interacted with business analyst, ETL team lead, and data base admin to gather information and to collect business requirements to develop Informatica Mappings.
• Implemented Change Data Capture using Informatica Power Exchange 9.5.
• Designed, developed Informatica Power Center 9.6 mappings to extract, transform and load the data into Oracle 11g target tables.
• Designed and development of Metadata Repository backup/recovery strategy.
• Extensively worked on Informatica tools like source analyzer, mapping designer, workflow manager, workflow monitor, mapplets, work lets and repository manager.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables
• Used Debugger in Informatica Power Center Designer to check the errors in mapping.
• Created test cases and completed unit, integration and system tests for Data warehouse.
• Wrote SQL, PL/SQL, stored procedures for implementing business rules and transformations.
• Involved in Performance tuning for sources, targets, mappings, sessions and server.
• Closely moved with the Micro strategy reporting team and helped them to get the data for creating report.
• Writing Teradata SQL queries to join or any modifications in the table
• Worked on agile methodology.
• Prepared an ETL technical document maintaining the naming standards.
• Created deployment groups in one environment for the Workflows, Work lets, Sessions, Mappings, Source Definitions, Target definitions and imported them to other environments.

Environment: Informatica Power Center 9.6.1/10.1, Informatica Power Exchange 9.5, Informatica Data Quality (IDQ) 9.6.1/10.1, Informatica Analyst 9.6.1/10.1, Informatica Business Glossary, Informatica Metadata Manager 9.6.1, Informatica MDM Multi-Domain 10.0, IDD/BDD, Informatica DVO 9.6.1, Informatica B2B(DX/DT), Teradata 14, Oracle 11g/12c, PL/SQL, SQL, Flat Files, TOAD, Unix, Shell Scripting, SQL Server 2012.

Confidential, Atlanta, GA

Sr. Informatica Developer

Responsibilities:

• Worked with end users to understand the Business Requirements, Designing the Workflow, Implementing and Supporting on ongoing basis.
• Designed data transformation from staging to fact and dimension tables in the warehouse.
• Loaded data to the interface tables in oracle from multiple data sources using Informatica.
• Implemented Aggregator, Filter, Joiner, Expression, Lookup, Normalize and Update Strategy transformations.
• Extensively worked on the performance tuning of the Informatica Power Center Mappings as well as the tuning of the sessions.
• Implemented variables and parameters in transformations to calculate billing data.
• Worked on Informatica MDM Hub configurations - Data modeling & Data Mappings (Landing, staging and Base Objects), Data validation, Match and Merge rules, writing and customizing user exits, customizing/configuring Business Data director (BDD)/Informatica data director (IDD)applications.
• Created sessions, sequential and concurrent batches for the mappings using Workflow Manager.
• Writing stored procedures, functions and packages to implement business logic.
• Developing, executing & monitoring Autosys (Process Scheduler) jobs

Environment: Informatica Power Center 9.5, Informatica/Siperion MDM 9.5/9.7, Oracle 11g, Flat Files, Autosys, HP ALM (Application Lifecycle Management), Win SCP

Confidential, Dallas, TX

Sr. Informatica Developer

Responsibilities:

• Customer support in business and IT related services, answering customer queries in business processing of the application and implementing process change or data changes as per the agreed SLA.
• Analysis and Understanding the requirements & functional specifications.
• Knowledge Transfer to the offshore team with business functionality and the new requirements.
• Impact analysis for requirement changes, finding affected list of programs and homogeneous implementation
• Involved in production support activities. Ensured the batch cycle gets completed in time. Also, fixed the issues within the time mentioned in Service Level Agreements (SLA).
• Analyzing modifications, finding affected list of mappings/components.
• Handling Ad-Hoc Requests
• Testing the Applications for the business requirement and responsible for delivery from offshore.

Environment: Informatica Power Center 8 /9.1, Informatica Data Quality (IDQ) 9.1, Informatica Analyst, TOAD, Oracle 11g, DB2, Flat Files, XML Files, SQL Server 2008, Erwin, Skybot, UNIX Shell Script.

Confidential, Woodland Hills, CA

Sr. Informatica Developer

Responsibilities:

• Analyzed functional specification documents and worked closely with the various application teams and functional teams to design Technical specification documents.
• Studied the data requirements and the impact analysis on the existing schema.
• Participated in the review meetings with functional team to signoff the Technical design document.
• Written Unix Shell Scripts to schedule the Informatica jobs using PMCMD command.
• Created various active and passive transformations to support voluminous loading of data target table using Informatica Power Center.
• Designed reusable transformations and mapplets.
• Mapped the source and target databases by studying the specifications and analyzing the required Business logic.
• Responsible for optimizing the ETL mappings and monitoring the load process in order to check the data.
• Involved in identifying surrogate keys for the fact table.
• Defined data definitions and created target tables in the database .
• Written PL/SQL Procedures, Function and Packages to perform database operations and pre-& post session commands.
• Prepared User documentation to train users and functionality of each report.

Environment: Informatica Power Center 7.1, Oracle 10g, PL/SQL, Toad, UNIX, HP Quality Control, Service Now

Confidential, CA

Informatica Developer

Responsibilities:

• Designed, developed, and managed the workflow processes to reflect business requirements with several adapters, exceptions and rules
• Implemented various business rules of data transformations using various Informatica transformations like Normalizer, Source Qualifier, Update Strategy, Lookup (connected/unconnected/static cached/dynamic cached), Sequence Generator, expression, Aggregator, XML (source and generator), Stored Procedures.
• Worked on CDC (Change Data Capture) to implement SCD (Slowly Changing Dimensions).
• Used Teradata as a Source and a Target for few mappings. Worked with Teradata loaders within Workflow manager to configure Fast Load and Multi-Load sessions.
• Experience with Teradata as the target for the data marts, worked with BTEQ, Fast Load and Multi-Load.
• Involved in creation of initial data set up in the Production environment and involved in code migration activities to Production.
• Provided administrative functions like creating repositories, backing up repositories, setting up users, assigning permissions and setting up folders in Repository manager.
• Wrote shell script utilities to detect error conditions in production loads and take corrective actions, wrote scripts to backup/restore repositories, backup/restore log files.
• Migrated Informatica objects from development to QA and production using deployment tool.
• Provided production support and involved with root cause analysis, bug fixing and promptly updating the business users on day-to-day production issues.

Environment: Informatica Power Center 6, Teradata, Oracle PL/SQL, SQL*Plus, Windows, UNIX, AUTOSYS.

Confidential, Wilmington, Delaware

Informatica Developer

Responsibilities:

• Worked with end users to understand the Business Requirements, Designing the Workflow, Implementing and Supporting on ongoing basis.
• Designed data transformation from staging to fact and dimension tables in the warehouse.
• Loaded data to the interface tables in oracle from multiple data sources using Informatica.
• Implemented Aggregator, Filter, Joiner, Expression, Lookup, Normalize and Update Strategy transformations.
• Extensively worked on the performance tuning of the Informatica Power Center Mappings as well as the tuning of the sessions.
• Implemented variables and parameters in transformations to calculate billing data.
• Worked on Informatica MDM Hub configurations - Data modeling & Data Mappings (Landing, staging and Base Objects), Data validation, Match and Merge rules, writing and customizing user exits, customizing/configuring Business Data director (BDD)/Informatica data director (IDD)applications.
• Created sessions, sequential and concurrent batches for the mappings using Workflow Manager.
• Writing stored procedures, functions and packages to implement business logic.
• Developing, executing & monitoring Autosys (Process Scheduler) jobs

Environment: Informatica Power Center 9.5, Informatica/Siperion MDM 9.5/9.7, Oracle 11g, Flat Files, Autosys, HP ALM (Application Lifecycle Management), Win SCP

Confidential San Mateo, CA

Mainframe Tester

Responsibilities:

• Design Analysis
• Design and Development.
• Testing - Automated test cases for Validation
• Requirement Analysis
• Creating Test Cases for Release items
• Requirement Traceability
• Test Data preparation
• Test Case Review
• Test Execution
• Defect Management
• Coordination with the Development Team
• Prepare daily, weekly, monthly status reports
• Attend internal audits to check project health status

Environment: z/OS, COBOL, DB2, MVS/JCL, VSAM, QMF, SPUFI, CICS, FILEAID, HP Quality Centre, BMC, CONTROL-M