PROFESSIONAL SUMMARY:

• Around 8 years of Overall work experience on Data Warehousing ETL and Database Programming.
• 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.
• Experienced in programming as an Oracle PL/SQL Developer in Analysis, Design, Data Modeling(logical and physical), and Implementation of Business Applications using the Oracle Relation Database Management System(RDBMS)
• Used major components like Serializers, Parsers, Mappers and Streamers in Data Transformation Studio for conversion of XML files to other formats.
• 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.
• Worked on Performance Tuning Informatica Targets, Sources, Mappings and Sessions.
• Experience in developingInformatica Reusable componentsfor using them across the projects.
• Extensively worked withInformatica Mapping Variables, Mapping ParametersandParameter Files.
• Experienced in UNIX work environment, File Transfers, Job Scheduling and Error Handling.
• Experience on ER Data Modeling tools likeERwin, ER-StudioandVisioin developing Fact & Dimensional tables, Logical and Physical models.
• Hands on experience in resolving the production issues in 24/7 environment.
• Outstanding communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high compliance to new technologies and tools

TECHNICAL SKILLS

ETL Tools: Informatica 9.6/9.1/8.x/7.x(PowerCenter/PowerMart) (Designer, Workflow Manager, Workflow Monitor, Service Manager, Power Connect)

Data Modelling: Physical Modelling, Logical Modelling, Relational Modelling, Dimensional Modelling, (Star Schema, Snow-Flake, Fact Dimensions), Entities, Attributes, Cardinality, ER Diagrams.

Reporting Tools: Business Objects XI r2, Cognos 8.2/10, Qlikview.

Databases: Oracle 11g/10g/9i, MS SQL Server 2008/2005,Teradata,MS Access and DB2

Languages: SQL,PL/SQL,C, Data Structures, Facets, Unix Shell Script, Visual Basic

Web Technologies: HTML, XML, Web Applications, SOAP, Java Script

Database Tools: SQL Plus, PL/SQL Developer, TOAD, SQL * Loader, Active Batch

Operating Systems: Windows NT/2000/2003/XP/VISTA/7,UNIX,MSDOS,and LINUX

PROFESSIONAL EXPERIENCE:

Confidential, Farmington, CT

Sr. Informatica Developer

Responsibilities:

• Conducted JAD sessions with business users and SME's for better understanding of the reporting requirements.
• Design and developed end-to-end ETL process from various source systems to Staging area, from staging to Data Marts.
• Develop high level and detailed level technical and functional documents consisting of Detailed Design Documentation function test specification with use cases and unit test documents
• Analysis of source systems and work with business analysts to identify study and understand requirements and translate them into ETL code
• Responsible for the Extraction, Transformation and Loading (ETL) Architecture & Standards implementation.
• Developed the documenting and outlining transformation logic to Evariant's Data Extract-Transform-Load ("ETL") team.
• Responsible for offshore Code delivery and review process
• Used Informatica to extract data from DB2, UDB, XML, Flat files and Excel files to load the data into the Teradata
• Worked in all phases of Data Integration from heterogeneous sources, legacy systems to Target Database.
• Worked on Informatica Power Center tool - Source Analyzer, Warehouse designer, Mapping and Mapplet Designer, Transformations, Informatica Repository Manager, Informatica Workflow Manager and Workflow Monitor
• Involved in Design Review, code review, test review, and gave valuable suggestions.
• Worked with different Caches such as Index cache, Data cache, Lookup cache (Static, Dynamic and Persistence) and Join cache while developing the Mappings.
• Created partitions for parallel processing of data and also worked with DBAs to enhance the data load during production.
• Performance tuned Informatica session, for large data files by increasing block size, data cache size, and target based commit
• Worked on CDC (Change Data Capture) to implement SCD (Slowly Changing Dimensions).
• Cleanse, standardize and enrich customer information using Informatica MDM
• Eliminated and prevent duplicated and inconsistent data using Informatica MDM
• Worked with data Extraction, Transformation and Loading data using BTEQ, Fast load, Multiload.
• Used the Teradata fast load/Multiload utilities to load data into tables
• Involved in writing a procedure to check the up-to-date statistics on tables.
• Used Informatica command task to transfer the files to bridge server to send the file to third party vendor.
• Took part in migration of jobs from UIT to SIT and to UAT
• Created FTP scripts and Conversion scripts to convert data into flat files to be used for Informatica sessions
• Involved in Informatica Code Migration across various Environments.

Environment: Informatica Power Center 9.1, Oracle 11g, Teradata V 13.0, Fast load, Multiload, Teradata SQL Assistant, MS SQL Server 2012, SQL, PL/SQL, T-SQL, SQL*Plus, TOAD, Erwin, AIX, Shell Scripts, Autosys, Unix.

Confidential, San Antonio, TX

Sr Informatica Developer

Responsibilities:

• Translated Business Requirements into Informatica mappings to build Data Warehouse by using Informatica Designer, which populated the data into the target.
• Created project plan for Development, QA and Production PowerCenter upgrade.
• Worked on Informatica object Migration using Repository Manager.
• Designing and developing the ETL frame work and processes using Informatica 9.1/8.6, to run on the Domain, Integration Services and Nodes
• Extracted data from various source systems like Oracle, XML and flat 2files and loaded into relational data warehouse and flat files.
• Designed and developed complex mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Stored Procedure and more.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager
• Involved in coding of the Business Rules through PL/SQL using the Functions, Cursors and Stored Procedures.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.
• Maintained good interaction with analysts, Project Managers, architects and testers to have efficient and better results.
• Used SQL tools like TOAD to run SQL queries and validate the data.
• Partially involved in writing the UNIX Shell Scripts, which triggers the workflows to run in a particular order as a part of the daily loading into the Warehouse.
• Designed and developed various kinds of reports based on user requirement. Provide weekly status report on support tasks, monthly reports and metrics on monitoring and support initiatives and quarterly reviews on existing processes.
• Provided production support for business users and documented problems and solutions for running the workflows.

Environment: Informatica Power Center 9.1/8.6, Oracle 11g, TOAD, PL/SQL, OBIEE, Flat Files, COBOL, MS SQL Server, SQL *Loader, UNIX Shell Scripting, Autosys, Tidal, Windows XP.

Confidential, Charlotte, NC

ETL/Informatica Developer

Responsibilities:

• Extensively involved in almost all the phases of Project Life Cycle (SDLC) right from Requirements Gathering to 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, 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.1.
• Designed, developed Informatica Power Center 9.5 mappings to extract, transform and load the data into Oracle 11g target tables.
• Extensively worked on Informatica tools like source analyzer, mapping designer, workflow manager, workflow monitor, mapplets, worklets 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.
• Worked on agile methodology.
• Prepared an ETL technical document maintaining the naming standards.
• Created deployment groups in one environment for the Workflows, Worklets, Sessions, Mappings, Source Definitions, Target definitions and imported them to other environments.

Environment: Informatica Power Center 9.5, Informatica Power Exchange 9.1, Informatica Data Quality (IDQ) 9.5, Informatica Analyst, Informatica MDM Multi-Domain 10.0, IDD/BDD, Oracle 11g, PL/SQL, SQL, Flat Files, TOAD, Unix, SQL Server 2012.

Confidential

ETL/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 8.6.0, Oracle 10g, PL/SQL, Toad, UNIX, HP Quality Control, Service Now.

Confidential

Software Developer

Responsibilities:

• Interacted with Business analysts and systems analysis, gathering, design, testing and documentation to understand the business requirements.
• Involved in developing the logical and physical data models.
• Created users/groups and folders using repository manager.
• Involved in staging the data from external sources and was responsible for moving the data into the warehouse.
• Created reusable transformations and mapplets and used them in mappings.
• Created complex mappings in PowerCenter designer using Aggregate, Expression, Filter, and Sequence generator, Update Strategy, Union, Lookup, Joiner and Stored Procedure Transformations.
• Used Normalizer transformation to handle the COBOL files.
• Written SQL override queries in Source Analyzer to customize mappings.
• Used workflow manager for creating, validating, testing the sequential and concurrent sessions.
• Used workflow monitor to monitor the progress of the workflow.
• Involved in performance tuning at source, target and session and database connection level.
• Created E-mail notification tasks using post-session scripts.
• Debug mappings to gain troubleshooting information about data and error conditions using Informatica debugger.
• Involved in project planning and coordinating business, source and development teams to meet the project deadlines.
• Involved in creating sales dashboards/Reports to compare current cycles and previous cycle sales using pivot table views.
• Involved in a project with OBIEE team.
• Developed Oracle forms screens for entering the customer data.
• Worked in database structure changes, index sizing and data conversion.
• Designed and developed various UNIX shell scripts.
• Extensively worked on SQL*LOADER, import and export utilities.

Environment: Informatica 7.1.4/8.1, Oracle 11g, PL/SQL, SQL*Loader, SQL, Forms 11g, Windows XP, UNIX and shell programming, OBIEE.