SUMMARY

• Certified Informatica Power Center Professional.
• 10 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 Confidential 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
• Worked with various domain like utility, telecom, finance, automobile retail.
• 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, Python 2.7

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, Vertica

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, Nexus

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 Ecommerce /Informatica/Database Developer

Responsibilities:

• Gathered requirement with Client and business for Proof of Concept and build Technical Design.
• Parsed the Json files to CSV using python and Java to use it as a source in ETL.
• Imported the source and target from different environments from flat files, databases (Oracle & Vertica) and Json files.
• 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 usingInformatica 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.
• Responsible for performance tuning by determining bottleneck in source, target, sessions, mapping
• Developed Oracle PL/SQL Objects like Tables, Constraints, Views, Stored Procedures and Functions.
• Created shell scripting to automate the archiving process.
• Created tables and table projections using Vertica and Teradata.
• Responsible for mentoring Junior team members
• Responsible for code reviewing
• Performance tune a code in all technical area.

Environment: Linux, JIRA, Informatica, Go plan, Nexus, Teradata, Oracle, Unix, Vertica, Sql developer, Sharepoint, Google DT, python 2.7, gsutil, SVN, Adobe Audience Manager

Confidential, Dallas, TX

Senior Informatica/Database Developer

Responsibilities:

• As a Lead, was involved in daily status, following up the development as well as the business /Testing teams, re-scoping project planning
• Supervising the development team in accomplishing their tasks as per the deadlines
• Mentoring Junior team members
• Gathered requirements from the business analyst to design the database and design programs or PL/SQL Objects .
• Responsible for code reviewing the Informatica process as well as PL/SQL Objects
• Coordinating with business for requirement gathering, clarification and providing solutions for several problems
• Participating in team sizing and effort estimation sessions
• Documented technical specifications and technical design documents and test cases for unit and integrated testing
• Identify in-efficiently written SQL’s for fine tuning in order to improve performance
• Optimize the Informatica code and PL/SQL code.
• Developed Unix Scripts for Automation of patch installations on Linux environment and auditing of the loaded data.
• Created PL/SQL Procedures using Native Dynamic SQL and Cursor Variables
• Performed Performance Testing.
• 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/IBM Mainframe 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.
• Performed performance tuning Confidential each level from creation of database to query modification using explain plan to gathering statistics of the environment including tables and schemas
• Debugged and Troubleshooted issues.
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines forward engineering and reverse engineering Object from AS400/ IBL Mainframe to MariaDB / Oracle/DB2.
• Involved in thorough understanding of retail domain for business implementation.

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 usingInformatica 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 usingInformatica 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 Confidential 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
• Implemented CDC
• 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 foroptimum performance when required replacedfilterswithRouters 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 using (IDQ)
• 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 withUnion, 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
• Designedcomplex mappingsinvolvingtarget load orderandconstraint 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 Confidential 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 inProduction 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
• Developedlogical 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 forChange 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 Confidential 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 Confidential 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 Confidential the Source Level, Target Level, Mapping Level and Session Level
• Assisted with peer code reviews and testing of development team's Confidential -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 Confidential 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 Confidential 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, Spring, Hibernate, Informatica Power center, Jasper iReports, Oracle, winCVS, Rational Rose.

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 Confidential 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