PROFESSIONAL SUMMARY:

• Over 8 years of combined professional IT experience with expertise in design, analysis, development and implementation of Data warehousing and Business Intelligence applications using ETL and BI tools with Oracle, DB2, MS SQL server and Teradata databases on windows and UNIX platforms.
• Extensively worked on transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Normalizer, Update Strategy, Sequence Generator and Stored Procedure transformations.
• Involved in designing, development and managing the project with onsite and offshore teams.
• Extensive experience in writing PL/SQL programming units like Triggers, Procedures, Functions and packages in Unix and windows environment.
• Expert level experience in Data Integration and Data Warehousing using ETL tool Informatica Power Center / Power Mart 7.x/8.x/9.x (Source Analyzer, Warehouse Designer, Mapping/ Mapplet Designer, Sessions/tasks, Worklets/Workflow Manager), Informatica Data Quality (IDQ).
• Knowledge of Informatica tools Power Exchange, Power Analyzer, DT Studio, Power Connect, Data Mart, OLAP and OLTP, Informatica Data Quality (IDQ).
• Profound knowledge about the architecture of the Teradatadatabase and experience inTeradata Unloading utilities like Fast export.
• Involved in all phases of SDLC in building Data Integration solutions using Informatica.
• Experience in Designing, Installing & Configuring core InformaticaMDM Hub components, Informatica MDMHub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter and IDD & Data Modeling.
• Highly proficient in Data Modeling retaining concepts of RDBMS, Logical and Physical Data Modeling and Multidimensional Data Modeling Schema (Star schema, Snow - Flake Modeling, Facts and dimensions).
• Experience in working with the Heterogeneous data sources such as Salesforce, Oracle, My SQL, Flat files, XML files, Web services.
• Experience in MDM Hub configurations - Data modeling, Data Mappings, Data validation, Match and Merge rules, Hierarchy Manager, customizing/configuring Informatica Data Director.
• Working experience in Data warehousing and Business Intelligence concepts with emphasis on ETL and life cycle development using Power Center, Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Configured different Source Systems of MDMtables in MDM Hub: Landing tables, Base Objects, Staging Tables, and Relationships Base Objects.
• Supported various Webster banking system support staff in data acquisition exercises for the NICE Actimize implementation.
• NICE Actimize system knowledge with strong knowledge on data acquisition, sourcing and integration.
• Expert-level mastery in designing and developing complex mappings to extract data from diverse sources including flat files, RDBMS tables, legacy and COBOL Sources.
• Proficient in implementing Complex business rules by creating re-usable transformations, workflows / worklets and Mappings / Mapplets.
• Expert level knowledge of complex SQL using Teradata functions, macros and stored procedures.
• Experience in Performance Tuning of source, target, mappings, transformations and sessions.
• Experience with Waterfall and Agile software development methodologies.
• Built variety of prototypes to Extract, Transform and Load data from and to SAP using Informatica Power Connect.
• Created SAP BW OHS source definitions in Informatica and configured work flow to run from SAP process chain.
• Complete knowledge of data ware house methodologies, ODS, EDW and Metadata repository.
• Strong SQL knowledge and the ability to write the complex SQL queries.
• Strong experience in development and implementations of Data Warehousing projects.
• Strong knowledge in RDBMS concepts and extensive experience in creation and maintenance of Tables, Views, Materialized Views, Stored Procedures, Packages, Synonyms, Indexes, Triggers, Bulk Load and PL/SQL programming.
• Understanding & working knowledge of Informatica CDC (Change Data Capture) Implementation experience of CDC using stored procedures, triggers and using Informatica Power exchange.
• Expertise in developing Extract and Transformation mappings with various ETL tools.
• Strong expertise in Relational data base systems like Oracle, SQL Server design and database development using SQL, PL/SQL, SQL PLUS, TOAD.
• Domain Data warehousing experience including Investment banking, Credit card and Insurance. Proven ability to implement technology based solutions for business problems.
• Excellent analytical, problem solving and communication skills, with ability to interact with individuals at all levels.
• Extensively involved in Informatica performance issue and Database performance issue.
• Excellent interpersonal, communication and presentation skills with the ability to successfully interact with team members and business customers.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center/Power Mart 9.x/8.x/7.x, Power Exchange, Map Designer, Process designer and Data Profiler Microsoft DTS, DT Studio, Informatica MDM.

Programming languages: PL/SQL programming, SQL, SQL*Plus, Unix scripting, XML, C, C++.

Data Modeling: Erwin 4.1.4/3.5.2, Star Schema Modelling, Snow-Flake Modelling.

Web Technologies: HTML, XML, JSP

Operating Systems: Windows, UNIX, LINUX.

Data Base Utilities: SQL LOADER, UTL FILE, DBMS SQL, DBMS Packages.

Data Base Tools: Oracle 12c/11g/10g/9i/8i, MS SQL Server 2008/2005/2000/7.0/6.5, Toad, MS Access, Teradata V2R5/V2R4/V2R3.

Ticketing Systems: Service Center, Rational Clear Quest, Quality Center.

Scheduling Tools: Unix Scheduler, Informatica Scheduler, Autosys.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Informatica Developer

Responsibilities:

• Involved in full project life cycle - from analysis to production, implementation and support with emphasis on identifying the source and source data validation, developing particular logic and transformation as per the requirement and creating mappings with exceptional handling methods.
• Prepare ETL design document and present the same to various stake holders to identify any risks and also to ensure that requirements are being met.
• Coordinated with business users and business analysts on a regular basis to discuss the business requirement documents and transformed them into technical specification documents.
• Involved in designing, development and managing the project with onsite and offshore teams.
• Worked on Master Data Management (MDM), Hub Development, extract, transform, cleansing, loading the data onto the staging and base object tables.
• Created some exclusive mappings in Informatica Power Center to load the data from external sources to landing tables of MDM hub.
• Involved in daily code review with all the team members.
• Interaction withthe SAP team to understand the migration specifications and underlying Legacy system.
• Created Teradata External loader connections such as MLoad, Upsert and Update, Fastload while loading data into the target tables inTeradata Database
• Involved in analysis and performance tuning of SQL queries and Informatica mappings.
• Worked with IDQ to determine Data Quality issues and Remediation process for bad data.
• Developed Informatica mappings, enabling the extract, transform and loading large volumes of data into target tables by implementing partitioning.
• Co-ordinate, Plan and implement the migration of the ETL code and data to multiple environments and cross functional testing.
• Responsible for preparing various artifacts for documentation and reviewing the ETL process.
• Based on the business requirements created Functional design documents and Technical design specification documents for ETL Process.
• Implementation experience of CDC (Change Data Capture) using stored procedures, triggers and using Informatica Power Exchange.
• Worked with extracting data from external FTP connection in Informatica workflow manager and loaded data into target database.
• Create procedures in Teradata SQL.
• Designing ETL process and creation of ETL design and system design documents.
• Create export scripts using Teradata Fast Export Utility.
• Reviewed data models using Erwin tool to find out data model dependencies.
• Identified Performance bottlenecks in ETL Processes, poorly performing SQLs, functions and procedures, recommended improvements to ETL processes. SQLs and upon approval, made modifications and validated performance improvements.
• Designed and developed process to handle high volumes of data and high volumes of data loading in a given load window.
• Assisted in performance testing, data quality assessment, support & product deployments.
• Worked on Parameterize of all variables, connections at all levels in UNIX.
• Involved in jobs scheduling and production deployment activities creation of the deployment guide migration of the code to production, monitoring and production support in a 24/7 environment.

Environment: Informatica Power Center 9.5.1, Oracle 12/11g, MS SQL Server 2008, PL/SQL, TOAD, Erwin Data Modeler, Linux 2.4, Teradata 13.1, SAP Business Object Data Services 4.2.

Sr.Informatica Developer/Data Analyst

Confidential

Responsibilities:

• Developed complex mappings using Informatica Power Center Designer to transform and load the data from SQL Server to Target system Sales Force and vice versa.
• Extensively used various transformations such as Source Qualifier, Expression, Lookup, Sequence Generator, aggregator, Update Strategy, and Joiner while migrating data from various heterogeneous sources like Oracle, Web services, Business Objects Data Services, DB2, XML and Flat files to Oracle.
• Understanding the Business requirements based on Functional specification to design the ETL methodology in technical specifications.
• Created materialized views for the better performance in reporting.
• Developed data conversion/quality/cleansing rules and executed data cleansing activities such as data consolidation, standardization, matching Trillium for the unstructured flat file data.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 9.1.
• Experience in integration of heterogeneous data sources like Oracle, Teradata, DB2, SQL Server and Flat Files (Fixed & delimited) into Staging Area.
• Uses Teradata SQL Assistant to develop queries and access data base objects.
• Worked on Master Data Management (MDM), Hub Development, extract, transform, cleansing, loading the data onto the staging and base object tables.
• Created Informatica Power Center mappings and loaded data from SQL Server 2012 to Target system Sales Force and vice versa using Informatica Cloud Services.
• Scheduled and Run Extraction and Load process and monitor workflows using workflow monitor.
• Responsible for Creating workflows and Worklets. Created Session, Event, Command, Control, Decision and Email tasks in Workflow Manager.
• Analyzing the sources, transforming data, mapping the data and loading the data into targets using Informatica Power Center.
• Created MDM Cleanse functions in order to use them in IDD and merged multiple cleanse functions.
• Designed and developed Data Profiling in Informatica Designer to profile the Source data to meet business requirements.
• Experienced in the use of agile approaches, including Extreme Programming, Test-Driven Development, Scrum, eXtreme Programming (XP), Lean Analysis, mixed methods, RAD and RUP.
• Created Data Profiles in Profile Manager using Auto Profile and Custom Profile options to validated documented business rules.
• Extensively worked on tuning various client required reports for better performance.
• Involved in Review and Quality checking of other team members Code.
• Troubleshooting and Analysis of Defects and providing recommendations to the customer and actively participated in resolving the issues.
• Developed Test Plan including test scripts for Unit, System, and User Acceptance Testing including resolution of bugs.

Environment: Informatica Power Center 9.1, Oracle Database 10g, UNIX, MS SQL Server 2008, Teradata, DB2, PL/SQL, SQL*Developer, Erwin Data Modeler, MS Visio.

Informatica Developer

Confidential -Pittsburgh, PA

Responsibilities:

• Used ETL process to Extract, Transform and Load different source data into stage area and data warehouse.
• Designed and developed complex mappings, from varied transformations logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner Update Strategy and more.
• Designed and developed Stored Procedure, and Sequence Generator and created mappings.
• Experience in creating mappings, sessions, workflows, reusable mapplets, worklets, scheduling and debugging the mappings.
• Involved in creating templates in Word and Excel for status sheets, for capturing requirements and for various other purposes.
• Having extensive experience in writing ETL technical documentation and testing documents and maintain the source control
• Developed an ETL Informatica mapping in order to load data into staging area. Extracted from flat file and databases and loaded into Oracle target database.
• Performed unit testing to check if data loaded correctly from source to target tables
• Optimizing Informatica Mappings and Sessions to improve the performance.
• Worked as a liaison between developer andend-usersto resolve defects.
• Involved in Unit testing and Integration testing of Informatica workflows.
• Developed various queries and embedded in utilities like UTL for extracting data from source database and loading into the ETL queries using Toad and SQL Developer tool.
• Extensively used SQL, PL/SQL to write stored procedures, functions, package and triggers.

Environment: Informatica Power Center 8.6.1, ODI 11g, SQL, Oracle 10g/11g, BI Publisher, SQL Server 2008, IBM I Series (DB2), MS Access, Windows XP, Toad, Tidal, Cognos 8.4.

Confidential

Responsibilities:

• Involved in requirement gathering, Design, testing, project coordination and migration.
• Used most of the transformations such as the Aggregators, Filters, Routers, Sequence Generator Update Strategy, Rank, Expression, lookups (connected and unconnected), Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
• Created mappings using transformations such as source qualifier, aggregator, expression, lookup, and router, filter and update strategy.
• Scheduled and Run Extraction and Load process and monitor workflows using workflow monitor.
• Responsible for Creating workflows and Worklets. Created Session, Event, Command, Control, Decision and Email tasks in Workflow Manager.
• Maintain the unit test cases and system testing on the mappings, sessions and finally observe the execution of workflows from the workflow monitor.
• Created requirement specifications documents, user interface guides, and functional specification documents, ETL technical specifications document and test case.
• Understanding the Business requirements, Source system and as part of understand the different logical models, then get the knowledge of the Extract, Transformation, Loading specifications of the project.
• Used ETL to standardize data from various sources and load into data stage area, which was in oracle and stage to different Data Marts.
• Utilized Data warehousing or modeling concepts like Star Schema, snowflake schema, Dimensions and Fact tables for defining the Key table structures..
• Extensively used ETL to load data from various source like Oracle, flat files and SQL Server to Target warehouse Database on Oracle DB.
• Error log design, data load strategy, unit and system testing, system migration and job schedules.
• Fine-tunedETL processes by considering mapping and session performance issues.

Environment: Informatica Power Center 8.6, SQL, PL/SQL, Teradata, UNIX, Shell Scripting, HP Quality Center 10.

Informatica Developer

Confidential

Responsibilities:

• Used Informatica as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.
• Responsible for mapping and transforming existing feeds into the new data structures and standards utilizing Router, Lookups (Connected, Unconnected), Expression, Aggregator, Update strategy & stored procedure transformation.
• Responsible for identifying reusable logic to build several Mapplets, developed E-Mail Tasks in the Workflow Manager for sending successful or failure messages.
• Involved in documentation of the project activity all along the course of the project along with Failure Recovery plans.
• Designed and developed UNIX scripts for creating, dropping tables which are used for scheduling jobs.
• Created and Configured Workflows, Worklets and Sessions to transport the data to target warehouse tables using Informatica Workflow Manager.
• Scheduled workflows to extract, transform and load data into warehouse as per Business requirements.
• Improved the session performance by pipeline partitioning.
• Optimized the performance of the mappings by various tests on sources, targets and transformations.
• Developed Procedures and Functions in PL/SQL for ETL.

Environment: Informatica Power Center/Power Mart 8.6, XML, DB2, Informatica Power Connect, Workflow Monitor, ERWIN, windows 2000, Oracle 9i, PL/SQL Developer, SQL Server2000,Toad, UNIX, Microsoft Excel.

ETL/ Informatica Developer

Confidential

Responsibilities:

• Analyzed the existing business model.
• Created mappings using transformations such as source qualifier, aggregator, expression, lookup, and router, filter and update strategy.
• Responsible for tuning the Performance of Informatica ETL mappings.
• Implemented procedures/functions in PL/SQL for stored Procedure Transformations
• Interacted with business users on weekly basis in finalizing high-level business requirements.
• Prepared detail-level design documents based on the discussions to get sign-off from business.
• Analyzed the impact and provided estimations in PD's to Client whenever there was a change in client requirements.
• CreatedInformatica jobs to extract data from different external sources and populate into Data Warehouse tables/flat files by transforming the data as per business requirements.
• Analyzing the impact and providing the Estimations to Client in PD's whenever there is a change in the requirement.
• Provided the warranty support by interacting with production support teams.

Environment: Informatica 8.1, Erwin 4.0, MS SQL Server 2005/2000, Win 2000, Flat Files, Oracle 8i, DB2, SQL, PL/SQL.

Oracle PL/SQLDeveloper

Confidential

Responsibilities:

• Created Oracle database objects like tables, views, Stored procedures, Packages using Oracle Utilities like PL/SQL, SQL* Plus, Toad.
• Designed and developed complex forms and crystal reports as per the client's requirement in Oracle.
• Involved in database development by creating SQL, Oracle PL/SQL Functions, Procedures, Triggers, Packages, Performance Tuning, Records and Collections.
• Developed the ETL mappings in PL and SQL via packages, procedures, functions, views and triggers.
• Extracted data from Flat files using SQL*LOADER.
• Developed Unix Shell Scripts to automate backend jobs, loading data into the Database using SQL* Loader.
• Gathered Statistics and Analyzed Tables and Indexes for Performance tuning.
• Worked on REFCURSOR and collection data type for bulk collection.
• Worked on Dynamic SQL and PL/SQL block in PL/SQL.
• Tuned queries using EXPLAIN plan, SQL Trace, Oracle Hints, Optimizers and Indexes for better query performance.
• Worked on optimizing existing procedures and functions using PL/SQL.
• Developed TOAD, SQL loader scripts to load data in the custom tables.
• Worked with Bulk Collects to improve the performance of multi-row queries.
• Configured oracle reports and crystal reports with internet information services (ISS).
• Analyzed the existing Oracle SQL Queries, Stored Procedures, Functions, Triggers and Cursors on performance issues.
• Involved in database development by creating SQL, Oracle PL/SQL Functions, Procedures, Triggers, Packages, Performance Tuning, Records and Collections.

Environment: UNIX, Solaris 5.9, Oracle 9i, TOAD 10.4, PL/SQL, SQL*Plus 9.2.0.1, SQL Developer 2.9, Forms 6i, Reports 6i, Discoverer 4i, Windows XP, UNIX, SQL * Loader.