SUMMARY:

• 9 Years of experience in Designing, Development and Implementation of Data Warehouses & Data marts with Informatica Power Center 9.1,8.6/7.1
• Strong working experience on DSS (Decision Support Systems) applications, directly responsible for the Extraction, Transformation and Load (ETL) of data from Legacy Systems using Informatica
• Extensive experience in creating the Workflows, Worklets, Mappings, Mapplets, Reusable transformations and scheduling the Workflows and sessions using Informatica PowerCenter
• Extensively experience with complex mappings using Expressions, Joiners, Routers, Lookups, and Update strategy, Source Qualifiers, Aggregators to develop and load data in to different target types
• Expertise in performance tuning.
• Experience working with Type 1 and Type 2 mappings and Change Data Capture
• Expertise in both OLTP and OLAP architecture
• Experience Data modeling (Dimensional & Relational) concepts like Star - Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables
• Loaded various different targets from Flat files (.dat/.csv/.xls/.txt,etc) to OLTP /OLAP databases(Oracle/Teradata/DB2/SQL Server, etc) to ERP systems(SAP).
• Extensive experience in all areas of Project Life Cycle including requirements analysis, system analysis, design, development, documentation, testing, implementation and maintenance
• Extensive experience with Information IDQ for maintaining data quality using data cleansing, data scrubbing, etc
• Experience with various Heterogeneous Systems like Oracle, Teradata, MS SQL, SQL Server, Flat files, Salesforce, SAP, etc
• Strong working experience creating data models using Erwin, MS - VISIO and Toad Data Modeler, ER Studio
• Extensive experience working in a fast paced agile methodology and scrum methodologies
• Strong experience in SQL *Plus and PL/SQL programming language - Database Triggers, Packages, Stored Procedures and Function, views, materialized view etc
• Experience in Dynamic query, bulk collect, collections, global temporary tables, ref cursors, implicit and explicit cursors, exceptions, etc
• Strong experience with query tools like PL/SQL Developer, Toad, SQL*Plus, SQL Developer
• Experienced in working on many complex SQL queries with joins, date functions, inline functions, cursors, ref cursors, collections, partition tables, external tables, materialized views, sub-queries and analytical
• Ability to work in fast paced environment and meet deadlines
• Ability to quickly learn new tools, concepts and environment
• Excellent communication and interpersonal skills, with the ability to manage responsibilities individually or as part of a team environment
• Strong Experience in enhancing performance, fixing bugs in products as well as projects
• Experienced in tuning SQL, PL/SQL queries using hints, bulk load, Explain Plan and SQL Trace, TKPRO
• Analyzed tables and indexes for Cost Based Optimization (CBO) to work efficiently
• Experience in Database designing, structuring, modeling, tuning of all the instances required
• Expert knowledge in ETL and SQL query performance tuning to improve session run times as well as involved in tuning the Oracle SQL queries by using Index techniques, Hints etc
• Ability to explain technical concepts and communicate with users and system administrators at all levels
• Strong understanding of query execution path
• Well versed with System Development Life Cycle (SDLC) & software quality measures
• Handled the DBA activities using oracle pl/sql Programming like creation of Datafiles and moving tables into different tablespaces
• Possess strong skills in the development of applications utilizing Oracle tools including Oracle SQL, PL/SQL, Jaspersoft iReport (Reporting tool)
• Designing Oracle PLSQL based framework that implements the business logic required for achieving the data transformations
• Established standards, guidelines, and procedures for design, development and maintenance
• Mentored, coached, cross-trained junior developers by providing domain knowledge, design advice
• Proven ability in defining goals, coordinating teams and achieving results
• Experience working with L1 and L2 team to resolve failures and production issues.

TECHNICAL SKILLS:

Data Warehousing/ ETL: Informatica PowerCenter 8x/9x

Programming Languages: SQL, PL/SQL, C, C++, HTML, Shell script, Java, JavaScript

Platforms: MS-DOS, Windows 9x/2000/XP, Red Hat Linux 4.0 and 5.3, Solaris, AS 400

Databases: Oracle 9i/10g/11g, Teradata, My SQL, DB2, SQL Server, MariaDB

Modeling Tools: Oracle JDeveloper, MS Visio, Rational Rose

Application Packages: Sql *Loader, Database Import and Export

Reporting Tools: JasperSoft iReports 1.3.2

IDE: Oracle SQL Developer, Quest Toad, Pl/SQL Developer, Eclipse, Ganymede, MyEclipse

Version Control: WinCvs, Totoise SVN, Perforce, Github

Application: Microsoft Office 97/2000/XP/2003/2007 and Acrobat Professional.

Data Modeling: Erwin, Toad Data Modeler, Microsoft Visio

Quality Management: JIRA, HP Quality Center (QC), Inbuilt defect tracking systems

Incident/Log Tracking: BMC Remedy, Splunk, Sumo Logic

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Senior Database Developer

Responsibilities:

• Gathered requirements from the business analyst to design the database and design programs or PL/SQL Objects .
• Code reviewed the PL/SQL Objects
• Loading the data from DB2, AS400 systems into Maria DB target.
• Created mapping to populate data from staging to integration tables using SCD type 1.
• Loaded data to data warehousing tables from integration using SCD type 2
• Developed PL/SQL Objects like Tables, Indexes, Constraints, Sequences, Synonyms, Views, Stored Procedures and Functions in MariaDB, DB2 for I (AS 400) and DB2.
• Optimizing the Queries in MariaDB and DB2 environment.

Environment: MariaDB, DB2, DBeaver, Linux, Toad, JIRA, Sumo Logic, Github, AS400

Confidential, Irvine, CA

Lead ETL/Informatica Developer/ Database Developer

Responsibilities:

• As a Lead, was involved in weekly status, following up the development as well as the business /Testing teams, re-scoping project planning
• Gathered requirements from the business to design the mapping interface for the project
• Finalized the design plan and preparing the ETL design document and STM document.
• Imported the source and target from different environments from flat files, databases (Oracle & DB2) and Salesforce.
• Worked with offshore team and conducted daily meetings to get status
• Analyzed the requirements to identify the necessary tables that need to be populated into the staging database.
• Developed various complex mappings and workflows using Informatica Designer
• Created various mappings using Source Qualifier, Lookup, Joiner, Filter, Aggregator, Update Strategy, Sequence, Union, Filter, Stored Procedure, Joiner, Generator, Router, Expression etc transformations.
• Developed extraction, transformation and loading routines for data capture components.
• Populated staging table from a flat file using various transformation.
• Created mapping to populate data from staging to integration tables using SCD type 1.
• Loaded data to data warehousing tables from integration using SCD type 2
• Implemented automated Error Handling and Audit framework in Informatica
• Responsible for performance tuning by determining bottleneck in source, target, sessions, mapping
• Developed Oracle PL/SQL Objects like Tables, Indexes, Constraints, Sequences, Synonyms, Views, Packages, DBlink, Triggers, Stored Procedures and Functions.
• Developed data conversion for last 15 year’s data into new system.
• Implemented Change Data Capture
• Developed procedures to gather statistics on Data warehousing tables.
• Scheduled the Informatica workflow using Autosys scheduler.
• Developed Jils to create Autosys jobs for scheduling the batch process
• Implemented all the process through UNIX shell script.
• Debugged and Troubleshooter issues.
• Migrated the releases into testing environments
• Provide production support for the deliverables.
• Provided On- call support for the project
• Worked with L2 support team to debug, trouble shoot Autosys Job failures or provide immediate fixes.

Environment: Informatica PowerCenter 9.x, Oracle 11g, Linux, Toad, SQL*Plus, Autosys, Unix, Solaris, Quality Center, BMC Remedy, Splunk, JIRA, Perforce

Confidential, TX

Lead Informatica\Oracle Developer

Responsibilities:

• Gathered requirements from the business to design the mapping interface for the project
• Documented the business requirements, reviewed the requirements and converting the requirements into technical specifications
• Worked with data architect/modeler to improve the design
• Designed various components and interfaces required for the Informatica mappings/workflows
• Finalized the design plan and preparing the ETL design document
• Provided project estimation base on the ETL Specification and Requirement
• Analyzed the requirements to identify the necessary tables that need to be populated into the staging database
• Implemented data from multiple sources such as Flat Files (Fixed Width and Delimited), XML files, Salesforce and different relational sources like Oracle & Sql Server
• Developed various Mappings and Transformations using Informatica Designer
• Created various mappings using Source Qualifier, Lookup, Joiner, Filter, Aggregator, Update Strategy, Sequence, Union, Filter, Stored Procedure, Joiner, Generator, Router, Expression etc transformations
• Loaded Dimension tables using SCD Type 1 and SCD Type 2
• Implemented automated Error Handling and Audit framework in Informatica
• Implemented data quality functions like data cleansing, data scrubbing, etc
• Responsible for performance tuning by determining bottleneck in source, target, sessions, mapping
• Reviewed ETL codes and scripts
• Worked closely with DBAs
• Prepared Technical design document and designed the architecture on Oracle Environment
• Created Oracle PL/SQL object creation from the initial level.
• Developed Oracle PL/SQL Objects like Tables, Indexes, Constraints, Sequences, Synonyms, Views, Packages, DBlink, Triggers, Stored Procedures and Functions.
• Implemented BULK Operations to perform bulk inserts, updates and deletes
• Created PL/SQL Procedures using Native Dynamic SQL and Cursor Variables
• Responsible for performance tuning at each level from creation of database to query modification using explain plan to gathering statistics of the environment including tables and schemas
• Performed unit testing and integrated testing and also assisted the testing team with their test cases to help them generate better quality
• Coordinated with offshore team for on-time and quality deliverables
• Prepared production support document for deployment.
• Developed Unix Scripts for Automation of Unix jobs
• Developed transformation logic and designed various complex Mappings and Mapplets using the Designer
• Tuned Informatica Mappings for optimum performance when required replaced filters with Routers and SQL Overrides.
• Analyzed tables and indexes for Cost Based Optimization (CBO) to work efficiently
• Troubleshoot post production defects. Analyze the existing flow and prepare documents for the any defects and Change requests
• Developed Autosys Jobs to schedule multiple batch processes with dependencies
• Provide production support for the deliverables.
• Provided On- call support
• Responsible for ETL testing and debugging and trouble shooting
• Manage the UAT, Cutover and Go live
• Developed logic for new systems, prepared flowcharting

Environment: Informatica PowerCenter 8.6, Oracle 11g, Linux, Pl/SQL developer, SQL *Loader, SQL developer, SQL*Plus, Toad, Teradata, Salesforce, Autosys

Confidential

Senior Informatica\Oracle Developer

Responsibilities:

• Lead the ETL team in an Agile\SCRUM development framework
• Involved in Data Modeling for designing the Star Schema
• Coordinated with source system owners for day-to-day ETL progress monitoring
• Designed and mapped specifications
• Designed Technical design document, technical specification documents and production support documents
• Responsible for analysis, cleaning, profiling and scrubbing of the data as per the requirements
• Worked extensively with flat file sources, CSV sources and Oracle and Teradata sources
• Loaded data in to staging tables
• Worked on Informatica PowerCenter tool - Source Analyzer, warehouse designer, Mapping Designer, Mapplets, Workflow Manager, Workflow Monitor, Data Analyzer, Metadata Manager and Reusable Transformations
• Developed transformation logic and designed various complex Mappings and Mapplets using the Designer
• Worked with Union, Lookup, Aggregator, Expression, Router, Filter, Update Strategy Joiner, Source Qualifier, Sequence Generator, Stored Procedure, XML Source Qualifier transformations, XML parser Transformations
• Implemented Slowly Changing Dimensions Type 1, Type 2
• Designed complex mappings involving target load order and constraint based loading
• Created reusable transformations and mapplets for better re-usability
• Created reusable sessions and workflows and extensively used parameter files and variables
• Responsible for database designing, structuring, modeling, tuning of all the instances required
• Worked in designing of flow diagrams and ER diagrams and Business Process diagrams using various tools like Visio, JDeveloper
• Responsible for database object creation from the initial level as per designed
• Developed Oracle PL/SQL objects like tables, sequences, constraints, indexes, synonyms, dblinks, views, packages, stored procedures, functions & triggers.
• Developed BULK Operations to perform bulk inserts, updates and deletes
• Responsible for performance tuning at each level from creation of database to query modification using explain plan to gathering statistics of the environment including tables and schemas
• Created PL/SQL Procedures using Native Dynamic SQL and Cursor Variables
• Migrated data to Oracle database using SQL*Loader
• Performed complex data manipulation using PL/SQL language
• Implemented partioning, compression and similar oracle feature to upgrade the performance
• Assisted the texting team during QA and UAT testing and documenting user acceptance criteria
• Debugged, Troubleshoot and bug fixed in existing product
• Re-designed the existing data models to improve the architecture and performance
• Involved in Production support
• Developed batch process to execute multiple jobs using unix cron tab and dbms jobs an dbms scheduler.
• Responsible for Error Handling and bug fixing
• Enhanced the performance of the existing product
• Developed Unix Scripts for Automation of Unix jobs
• Manage the UAT, Cutover and Go live
• Developed logic for new systems, prepared flowcharting

Environment: Informatica PowerCenter 9.1, Oracle 11g, Linux, XML, Pl/sql developer, SQL *Loader, SQL developer, Windows XP, SQL*Plus, Toad, Teradata

Confidential

Senior Informatica\Oracle\Teradata Developer

Responsibilities:

• Lead the ETL team in an Agile/SCRUM development framework
• Coordinated with source system owners for day-to-day ETL progress monitoring
• Responsible for working with DBA and Informatica admin for project coordination
• Developed complex Informatica mappings using different types of transformations like UNION transformation, Connected and Unconnected LOOKUP transformations, Router, Filter, Aggregator, Expression and Update strategy transformations for large volumes of datasets
• Developed logical and physical data-models using Erwin
• Gathered requirements from the business to design the mapping interface for the project
• Designed and reviewed the Technical Specifications based on the requirements provided by the Business Users.
• Converting the requirements into ETL technical specifications
• Reviewed the requirements with business analyst, also worked with them to identify sources and key attribute
• Designed the various components and interfaces required for the Informatica mappings/workflows.
• Created Complex mappings using Aggregator, Joiner, Union, Custom, Router, Expression, Update Strategy, Filter, Sorter transformations, stored Procedure, connected & unconnected lookups, Expressions, source qualifier, sequence Generator, etc. for populating target tables in efficient manner
• Implemented slowly changing dimension Type 1 and Type 2 for Change data capture
• Used Pre-SQL and Post-SQL scripts for loading the data into targets according to the requirement
• Responsible for database designing, structuring, modeling, tuning of all the instances required.
• Developed mappings to load Fact and Dimension tables, SCD Type 1 and SCD Type 2 dimensions.
• Developed oracle PL/SQL objects like. Table, Indexes, Sequences, Synonyms, Views, Packages, Stored Procedures, Functions & Triggers
• Handled DBA activities like instance creation, schema creation, data restoration, creating database backup at multiple levels, etc
• Responsible for Error Handling in Workflows and sessions using Informatica workflow manager and monitor the workflow run and statistic properties on Informatica Workflow Monitor
• Performed performance tuning of source level, target level, mappings and session
• Scheduled multiple batch process to execute multiple jobs using unix cron tab and dbms jobs an dbms scheduler.
• Used Power Center Workflow Manager for session management, database connection management and scheduling of jobs to be done in batch process
• Developed data conversion for historical data into new system
• Extracted data from Flat files, Teradata data warehouse and loaded in to oracle
• Implemented business logic through several Teradata BTEQ scripts
• Worked extensively with the Teradata SQL Assistant to interface with the Teradata
• Used Teradata Utilities (FastLoad, MultiLoad, and FastExport). Queried the Target database using Teradata SQL and BTEQ for validation
• Manage the UAT, Cutover and Go live

Environment: Informatica PowerCenter 8.6, Oracle 11g, Linux, Pl/sql developer, SQL developer, Teradata, Toad

Confidential

Senior Informatica\Oracle Developer

Responsibilities:

• Extensively involved in implementation of effective requirements practices, including gathering User Requirements, creating Business Requirement Document (BRD), and Functional Specification Document (FSD) and continuous improvement of a requirement process
• Effectively delegate work to team members and ensure that the development tasks are completed as per the assigned schedule
• Developed and managed project plans, schedules, issues log and business-technical conflicts document.
• Designed the Technical Specifications based on the requirements provided by the Business Users.
• Analyzed and created Facts, Dimension tables
• Implemented Slowly Changing Dimensions (SCDs, Both Type 1 & 2)
• Followed the agile methodology and the scrums for the development
• Cleanse the source data, extracted and transformed data according to the business rules
• Scheduled multiple batch process to execute multiple jobs using unix cron tab and dbms jobs an dbms scheduler.
• Tuned Informatica mappings for better performance
• Involved in Functional Unit Testing and Integration Testing
• Created and maintained Mappings, Mapplets, Sessions, Workflows and connections throughout the project life cycle
• Created and run shell scripts in the workflows to merge multiple flat files into one
• Used Source qualifier, source Qualifier, Expression, Aggregator, Filter, Joiner, Normalizer, Rank, XML, Sorter, Stored Procedure, Router and Lookup to perform Transformation techniques
• Worked with testing team to understand the validation requirements to design mappings
• Worked with Functional team to make sure required data has been extracted and loaded
• Worked on handling Master and Transactional data using Informatica
• Involved in Functional Unit Testing and fixed the defects to meet the requirements
• Developed Unix Scripts for Automation of Unix jobs
• Extracted data from Flat files, Netezza, SAP systems data warehouse and loaded in to oracle
• Worked with L1 and L2 support team to debug issues, trouble shoot and resolve failures and issues
• Provided production support for few days post production release

Environment: Oracle 11g, Informatica PowerCenter, Linux, Pl/sql developer, SQL *Loader, SQL developer, Netezza

Confidential

Senior Informatica\Oracle Developer

Responsibilities:

• Developed Mapplets, reusable transformations and used them in different mappings
• Developed Workflows and used various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Session in the workflow manager
• Created Post-Session success and Post-Session failure commands in the Session task to execute scripts needed for clean up and update purposes
• Responsible for trouble shooting of long running sessions and fixing the issues
• Implemented daily and weekly audit process to ensure Data warehouse is matching with the source systems for critical reporting metrics
• Involved in writing SQL scripts, stored procedures and functions
• Responsible for Unit testing, Integrated testing
• Extracted from the flat files, relational databases and transformed the data according to the target database and performed loading using Informatica ETL Tool
• Responsible for creating complex mapping using, Lookups, Expression, Filter, aggregator, Update Strategy, Sequence generator and more
• Worked with Informatica data quality functions like data cleanser, scrubber, etc
• Worked with Informatica Scheduler
• Worked on performance issues and bottlenecks to reduce the load time and monitored the data loads
• Migrated data to Oracle database using SQL*Loader
• Created PL/SQL program units to include DML, DDL statements using Dynamic SQL
• Responsible for developing PL/SQL Objects like Tables, Views, Indexes, Materialized views, synonyms, dblinks, procedure functions, packages, etc
• Handled the dba activities using oracle pl/sql Programming like creation of datafiles and moving tables into different tablespaces
• Extensively worked with transformations like Expression, Aggregator, Update Strategy, Union, Joiner, Lookup (Connected, Unconnected), Stored Procedure (Connected/ Unconnected), Rank, Sequence Generator, Router and Filter
• Used Update strategy and Target load plans to load data into Type-2 Type-1 Dimensions
• Worked with L1 and L2 support team to trouble shoot and resolve failures and issues
• Provided production support for few days post production release
• Manage the UAT, Cutover and Go live
• Developed logic for new systems, prepared flowcharting

Environment: Oracle 10g, Linux, Pl/sql developer, SQL *Loader, SQL developer, Windows XP, Informatica Power center Designer, Informatica Power center workflow manger, Informatica Power center Workflow Monitor

Confidential

Senior Informatica\Oracle Developer

Responsibilities:

• Actively involved in understanding business requirements, analysis and design of the ETL process
• Created fact and dimension tables based on
• Designed and created complex source to target mappings using various transformations inclusive of but not limited to Aggregator, Look Up, Joiner, Source Qualifier, Expression, Sequence Generator, and Router Transformations
• Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators, Stored Procedures and Normalizer transformations
• Developed various Oracle PL/SQL Objects like Tables, Indexes, Synonyms, Materialized view, Views, Packages, Triggers, Stored Procedures, and Functions, etc
• Have used BULK Operations to perform bulk inserts, updates and deletes
• Performance tuning at each level from creation of database to query modification using explain plan to gathering statistics of the environment including tables and schemas
• Created PL/SQL Procedures using Native Dynamic SQL and Cursor Variables

Environment: Oracle 11g, Linux, Pl/sql developer, Informatica, SQL developer, Windows XP, Toad.

Confidential

Senior Informatica\Oracle\Teradata Developer

Responsibilities:

• Analyzed business requirements and worked closely with various application teams and business teams to develop ETL procedures that are consistent across all applications and system
• Interacted with Business Users and Managers in gathering business requirements
• Documented Informatica ETL design documents, established ETL coding standards and performed Informatica mapping reviews
• Extensively used Teradata utilities like Fast load, Multiload to load data into target database
• Extensively worked on Power Center Client Tools like Power center Designer, Workflow Manager, and Workflow Monitor
• Worked with Informatica data quality functions like data cleanser, scrubber, etc
• Extensively worked on Power Center 8.6 Designer client tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer and Transformation Developer
• Loaded the data into SAP target environment.
• Analyzed the source data coming from different source and worked on developing ETL mappings
• Created Reusable and Non-Reusable command task in Workflow Manager
• Worked with Informatica Scheduler
• Created Sessions, command task, reusable worklets and workflows in Workflow Manager
• Involved in providing 24/7 production support to solve critical issues
• Responsible for the Performance tuning at the Source Level, Target Level, Mapping Level and Session Level
• Assisted with peer code reviews and testing of development team's T-SQL code
• Proven Accountability including professional documentation and weekly status report
• Database designing, structuring, modeling, tuning of all the instances required
• Developed Oracle PL/SQL Objects like Tables, Indexes, Constraints, Synonyms, Views, Packages, Triggers, Stored Procedures and Functions
• Responsible for Performance tuning
• Investigating and resolving major and minor issues faced in the existing module designed
• Working on DBA level activities or issues. E.g. Creating Roles, reclaiming table spaces, observing issues like fragmentation, etc
• Worked in designing of flow diagrams and ER diagrams and Business Process diagrams using various tools like Visio, JDeveloper
• Extracted data from Flat files, Teradata data warehouse and loaded in to oracle
• Implemented business logic through several Teradata BTEQ scripts
• Worked extensively with the Teradata SQL Assistant to interface with the Teradata
• Used Teradata Utilities (FastLoad, MultiLoad, and FastExport). Queried the Target database using Teradata SQL and BTEQ for validation
• Worked with L1 and L2 support team to trouble shoot and resolve failures and issues
• Provided production support for few days post production release
• Developed logic for new systems, prepared flowcharting

Environment: Informatica, Oracle 11g, Teradata, Linux, Pl/sql developer, SQL *Loader, SQL developer, Windows XP

Confidential

Senior Informatica\Oracle Developer

Responsibilities:

• Involved in the complete life cycle of the data warehouse creation starting form requirements gathering to putting the product into production
• Involved in data modeling for designing the Star Schema
• Involved in the OLTP design which is needed for the OLAP
• Analysis, Cleaning, Profiling and Scrubbing of the data as per the need Worked extensively with Flat file sources, CSV sources and Oracle sources
• Extensively worked with Aggressor, Sorter, Lookup, Router, Expression, Filter, Update Strategy, and Stored Procedure transformations
• Created reusable transformations and mapplets for better re-usability
• Responsible for Unit Testing and Integrated Testing
• Development Oracle PL/SQL objects
• Responsible for performance tuning
• Investigating and resolving major and minor issues faced in the existing module
• Working on minor DBA level activities or issues. E.g. Creating Roles, reclaiming table spaces, observing issues like fragmentation, etc
• Loaded the data into SAP target environment.
• Responsible for database designing, structuring, modeling, tuning of all the instances required
• Database object creation from the initial level as per designed
• Performing performance tuning at each level from creation of database to query modification using explain plan to gathering statistics of the environment including tables and schemas
• Performed complex data manipulation using PL/SQL language
• Worked in designing of flow diagrams and ER diagrams and Business Process diagrams using various tools like Visio, JDeveloper
• Worked with L1 and L2 support team to debug, trouble shoot and resolve failures and issues
• Provided production support for few days post production release

Environment: Oracle 11g, Linux, Pl/sql developer, SQL *Loader, SQL developer

Confidential

Senior Informatica\Oracle Developer

Responsibilities:

• Designed and developed Informatica Mappings based on business requirements and business rules to load data from source flat files and RDBMS tables to target tables
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure and Union to develop robust mappings in the Informatica Designer
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables
• Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems
• Created and maintained documents including data quality plan design, mapping inventory, mapping specifications, change request form, unit test plan, test case list, target-source matrix etc
• Wrote complex SQL queries using joins, sub queries and inline views to retrieve data from the database
• Involved in the performance tuning of the existing reports by effectively using the materialized views and the exchange partitions concepts
• Created PL/SQL program units to include DML, DDL statements using Dynamic SQL

Environment: Informatica PowerCenter, Toad, Oracle 11g, Linux, Pl/sql developer, SQL *Loader, SQL developer

Confidential

Senior Informatica\Oracle Developer

Responsibilities:

• Collaborated with Business analysts and the DBA for requirements gathering, business analysis and designing of the data marts
• Worked on dimensional modeling to Design and develop STAR Schemas
• Loaded the Data ware housing tables from Sql Server environment.
• Identifying Fact and Dimension Tables for providing a unified view to ensure consistent decision making
• Worked on Informatica tool Source Analyzer, Warehouse Designer, Mapping Designer, Workflow Manager, Workflow Monitor, and Repository Manager
• Scheduled multiple batch process to execute multiple jobs on defined time.
• Extensively used Transformations like, Aggregator, Router, Joiner, Expression, Lookup, Update Strategy, and Sequence Generator
• Migrated data to Oracle database using SQL*Loader
• Created PL/SQL objects like Tables, Views, Package, Procedure, functions, etc

Environment: Informatica PowerCenter, Oracle 11g, Linux, Pl/sql developer, SQL *Loader, SQL developer

Confidential

Senior Informatica\Oracle\Teradata Developer

Responsibilities:

• Designed and developed Informatica Mappings based on business requirements and business rules to load data from source flat files and RDBMS tables to target tables
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure and Union to develop robust mappings in the Informatica Designer
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse
• Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems
• Responsible for database designing, structuring, modeling, tuning of all the instances required
• Developed Oracle PL/SQL Objects like Table, Indexes, Views, Packages, Triggers, Stored Procedures, and Functions
• Implemented BULK Operations to perform bulk inserts, updates and deletes
• Created PL/SQL Procedures using Native Dynamic SQL and Cursor Variables
• Migrated data to Oracle database using SQL*Loader
• Created PL/SQL program units to include DML, DDL statements using Dynamic SQL
• Responsible for ETL testing and debugging

Confidential

Informatica\Oracle Developer

Responsibilities:

• Responsible for designing, requirement reviews and peer reviews throughout the SDLC cycle.
• Created mappings to load data from various sources, using different transformations like Source Qualifier, Expression, Lookup, Aggregator, Update Strategy, Joiner, Normalizer, Filter and Router transformations, Union transformations, etc
• Designed of Technical design document, technical specification documents and production support documents
• Developed Oracle PL/SQL Objects like Table, Indexes, Views, Packages, Triggers, Stored Procedures, and Functions
• Handled performance tuning at each level from creation of database to query modification using explain plan to gathering statistics of the environment including tables and schemas
• Developed Unix Scripts for Automation of Unix jobs
• Scheduled multiple batch process to execute multiple jobs on defined time.
• Created and maintained documents including data quality plan design, mapping inventory, mapping specifications, change request form, unit test plan, test case list, target-source matrix etc
• Analyzed the data for defects and fine tuning the approach for design
• Created unit test cases and plan for unit testing approach

Environment: Java Designer, Informatica Power center workflow manger, Informatica Power center Workflow Monitor

Confidential

Oracle/Informatica Developer

Responsibilities:

• Performed data transformations, migration, conversion and interface, data loading, database modeling
• Used Informatica Power Center to extract, transform and load data from multiple input sources like XML files, Flat Files, and relational tables to an Oracle database
• Used transformations like Source qualifier, Joiner transformation, Update Strategy, Look up transformation, Rank transformations, Expressions, Aggregator and Sequence generator
• Designed reusable transformations using Transformation Developer
• Created Mapplets using Mapplet Designer to generate different mappings for different loads
• Created mapping parameters and variables
• Worked with Informatica Scheduler
• Created Worklets to run several sessions sequentially and concurrently
• Developed schedules to automate the updated processes and Informatica Sessions/Worklets
• Writing PL/SQL procedures for processing business logic in the database
• Used pmcmd command for scheduling of sessions
• Creating reports using reporting tools like Jasper iReports
• Handled performance tuning at each level from creation of database to query modification using explain plan to gathering statistics of the environment including tables and schemas
• Developed Unix Scripts for Automation of Unix jobs
• Responsible for ETL testing and debugging

Environment: Jasper Reports, Oracle 10g, Linux, Unix, Sql Developer, Toad, Informatica Power center Designer, Informatica Power center workflow manger, Informatica Power center Workflow Monitor