Resume

Sign in

Informatica Developer

Location:
Milpitas, California, 95035, United States
Posted:
August 28, 2017

Contact this candidate

SUMMARY:

* years of extensive experience in Information Technology with special emphasis on Design and

Development of Data Warehousing using Informatica Power Center 9.6.1/9.1/8.6.1 /8.5.1

● Over 5 years of programming experience as an Oracle PL/SQL Developer in Analysis,

Design and Implementation of Business Applications using the Oracle Relational Database

Management System (RDBMS).

● Expertise in client-server application development using Oracle 11g/10g/9i,SQL, PL/SQL,

SQL*Plus, SQL developer and Toad.

● Created ETL mappings using Informatica PowerCenter to move Data from multiple

sources like XML, Copybooks, SQL server, Flat files, Oracle into a common target area such

as Staging, Data Warehouse and Data Marts.

● Good knowledge on logical and physical Data Modeling using normalizing techniques.

● Implemented Slowly Changing dimension methodology for accessing the full history of

accounts and transaction information.

● Created Tables, Views, Constraints, Index (B tree, Bitmap and Function Based).

● Developed complex database Objects like Stored Procedures, Functions, Packages and

Triggers using SQL and PL/SQL.

● Developed materialized views for data replication in distributed environments.

● Extensively used Informatica Client tools such as Source Analyzer, Warehouse designer,

Mapping Designer, Mapplet Designer, Transformations, Workflow Manager/Monitor.

● Experience in SQL performance tuning using Cost-Based Optimization (CBO).

● Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.

● Experience in ETL techniques and Analysis and Reporting including hands on experience

with the Reporting tools such as Tableau.

● Created Shell Scripts for invoking SQL scripts and scheduled them using Autosys.

● Good knowledge of programming in C.

● Good understanding and exposure to Data Warehousing techniques such as Star-Schema

Modeling, Snowflake Modeling, OLAP, Fact tables, Dimension tables.

● Created and Configured Landing Tables, Staging Tables, Base Objects, Look ups in the Hub,

Foreign Key Relationships, Queries, Query Groups and Packages in MDM.

● Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a

team.

TECHNICAL SKILLS:

ETL Tools Informatica Power Center 9.x/8/x/7.x

Informatica MDM 9.7.1

Informatica Metadata Manager 9.6.1/9.1

Databases Oracle 11g/10g/9i, MS SQL 2000, Teradata,

SQL Server

Programming Languages SQL Plus, PL/SQL, C, Unix Shell Scripting

Data Modelling Erwin 4.0

Data Warehousing OLAP, OLTP, Star Schema, Snowflake

Schema, RDBMS

Operating Systems Windows 10/7/XP/Vista/2003/2K, UNIX,

LINUX

Other Tools TOAD, SQL Developer, Real force

Explorer, Autosys, JIRA, OBIEE, ALM, SVN,

WINSCP, TABLEAU Desktop, R

PROFESSIONAL SUMMARY:

Wells Fargo, San Leandro, CA

Oct’16 – Till Date

Project 1: Prepaid Card (PPDMS)

ETL,Database Developer/QA/Production Support

Wells Fargo is partnering with MasterCard to implement prepaid programs, which offer more flexibility.

This project is implemented in multiple phases.

Responsibilities:

● Receive various processing files (Transaction Journal, Card and Account Extract, Settlement

reports) from Mastercard, load the reports into Pre-Paid database and send the reports to

downstream.

● Created some shell scripts depending on the requirement such as archival of files, removing

junk characters from the file etc.

● Created scripts to create new tables, views, queries for new enhancement in the application using

SQL Plus.

● Created indexes on the tables for faster retrieval of the data to enhance database performance.

● Extensively involved in using hints to direct the optimizer to choose an optimum query

execution plan.

● Extracted the data from files, used webservice transformation to tokenize the credit card

number and writing data into the files.

● Handled errors using Exception Handling extensively for the ease of debugging and displaying

the error messages in the application.

● Involved in testing the code at various stages like SIT and UAT.

● Participated in deploying the code to different environments.

● Tested the Informatica Mappings and workflows using different test cases.

● Worked as a part of Production Support on rotational basis and resolving root causes.

● Extensively used Autosys for scheduling the jobs.

Environment: Informatica 9.6.1, Oracle 11g, UNIX, SQL developer, Autosys 11.3, Flat files

Project 2: Data Quality Solutions(DQS)

ETL,Database Developer

This project is to systematically identify data quality issues for all input data elements, which is, to raise

exceptions dynamically which will be consumed by DQM.

Responsibilities:

● In order to generate exceptions, the metadata setup should be done properly. Business will

provide one time load details in Excel Format for each SOR. We need to insert them in several

metadata tables and validate accordingly.

● Wrote complex SQL queries in order to raise exceptions as per business requirement.

● Created indexes to fine tune the queries and improve the performance.

● Generated Workflows using Informatica for each SOR to load the exception records in the

respective exception tables.

● Consolidated the scripts and pushed into the SVN for movement of code into different

environments like SIT,UAT and PROD.

● Created Synonyms for a set of SOR tables pointing to iHUB validation layer.

● Created scripts to create new tables, views, materialized vies for enhancement in the application

using SQL plus.

● Updated FSD's for any enhancement or creating new FSD for new SOR according to business

requirement.

● Involved in writing several Autosys Scripts to schedule the jobs and monitoring them.

Environment: Informatica 9.6.1, Oracle 11g, UNIX, SQL developer, Autosys 11.3, SVN

Polycom, San Jose, CA

Mar ’16 – Sep'16

Sr. ETL Developer/MDM Consultant/QA

This project is about to calculate sales out percentages for different polycom products.

Responsibilities:

● Extracting the data from salesforce and loading into Oracle database using ETL mappings

and mapplets.

● Wrote Shell Scripts for Data loading and DDL Scripts.

● Created and Configured Landing Tables, Staging Tables, Base Objects, Foreign key

relationships, Queries, Query Groups etc. in MDM.

● Wrote sequences for automatic generation of unique keys to support primary and foreign

key constraints in data conversions.

● Created Mappings for cleansing the data.

● Defined the Match and Merge Rules in MDM Hub by creating Match Strategy, Match columns

and rules for maintaining Data Quality.

● Defining the key type (Fuzzy or Exact) based on column values which was provided by doing

data profiling.

● Created the Batch groups for loading, matching and merging the data.

● Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception

handling.

● Creating indexes on tables to improve the performance by eliminating the full table scans and

views for hiding the actual tables and to eliminate the complexity of the large queries.

● Extracting the data from files and Salesforce into staging area and populated into Data

Warehouse.

● Creation of templates for test scenarios and test scripts.

● Developed type II SCD mappings using various dimension and fact tables.

● Performed Unit testing at various stages of the test cycles.

● Migrated repository objects and scripts from development to QA and to production environment.

Environment: Informatica 9.0.1/9.6.1, Oracle 11g, UNIX, OBIEE, SQL developer, Real force explorer,

Informatica MDM 9.7.1

Wells Fargo, Fremont, CA

Sep ‘13– Feb ‘16

Informatica/ETL Consultant

Project 1:

Information Hub (IHUB):

The Wholesale Information Hub is an integrated model for distributing data from the upstream systems of

record (SOR) for use by the downstream consumers of the data. SOR data from relational and Flat File

Sources is loaded in Landing, Validation and Distribution Layers.

Responsibilities:

● Designed and developed ETL mappings to load data from Sql Server, Oracle, Copy books and

Flat File System of records into Oracle and Teradata database using Informatica PowerCenter

version 9.6.1.

● Closely worked with Data Analysts and Data modelers to understand the Business Requirements

and data elements.

● Worked with Java based Offshore Team to design and build an automation framework which

automatically generates ETL informatica Workflows (XML Files) using Informatica Java API.

● Created Unix Scripts for record count and delimiter count validation of flat file sources.

● Used Autosys for Scheduling the Informatica Workflows.

● Involved in creating the Functional Specification Documents.

● Extensively used informatica debugger to figure out the problems in mappings.

● Used SQL Developer for writing and executing Complex Queries.

● Created Mapping parameters and variables and used them in different parameter files.

● Coordination with offshore ETL team included assigning daily task, mentoring and getting status

updates.

Environment: Informatica 9.6.1, Oracle 11g, UNIX, Autosys

Project 2:

Metadata Manager & Business Glossary:

The Metadata Manager Tool is used to build the Wholesale Metadata Repository (WMR) which is a

browser based application that allows users to view both business and technical metadata.

Responsibilities:

● Involved in creating the Business Glossaries which includes the Business Terms, Attributes and

Business Rules.

● Worked on creating the lineages to check the flow from source to target, which contains the

information of informatica workflows, source files, source and target databases.

● Involved in upgrade from 9.1 to 9.6.1

● Worked on Informatica Analyst tool which is a new feature for creating and updating Business

Glossary as part of 9.6.1

● Hands on creating custom resource file.

● Loading Business Glossary into Metadata Manager.

● Linking Business metadata to Technical Metadata.

● Performed loads on databases and informatica servers to see the updates.

Environment: Informatica Metadata Manager 9.1/9.6.1, OBIEE, Informatica Analyst tool 9.6.1

Project 3:

Business Analyst

● Tracking project deliverables and maintaining status updates of projects, change requests and

document management through SharePoint.

● Documenting and creating and reviewing the System Interface Agreement (Technical Design

Document) to be understood by technology as well as other stakeholders.

● Tracking, scheduling and conduct System Interface Agreement review meetings on a regular

basis.

● Interacting extensively with development and QA teams in order to resolve technical and

implementation issues.

● Member of the Change Control Board and evaluating change requests and approving them.

● Validate the reports by writing the SQL queries and comparing the source data with the target

data.

Oracle, Santa Clara, CA

Mar ‘11– Aug ‘13

ETL Developer

Supply Chain Management:

This is one of the Oracle’s business critical warehouses where we extracted bookings, backlog and

shipping data from Oracle EBusiness Suite to Oracle Warehouse and also worked on development and

maintenance of Sales data warehouse for the marketing department.

Responsibilities:

● Participated in gathering, analyzing, and documenting business requirements,functional

requirements and data specifications.

● Created High level and detail Design documents including Data flow and data mapping.

● Preparation of technical specifications documentation on Report design and Source to Target

mappings (ETL).

● Worked extensively on Source Analyzer, Mapping Designer, Mapplet designer and

Transformation Developer.

● Created SQL Reconciliation Scripts of Oracle for checking validity of the data in the DWH.

● Used Mapplets, Reusable transformations, Parameters and Variables to facilitate the reusability

of Code.

● Used Debugger to validate the mappings and gain troubleshooting information about data and

error conditions.

● Configured and scheduled Pre and Post Session commands with Shell Scripts and called them

using command task.

● Used TOAD to run SQL queries and validate the data in warehouse.

● Assisted in creating fact and dimension table implementation in Star Schema model based on

requirements.

● Designing and creation of complex mappings using SCD type II involving transformations such

as expression, joiner, aggregator, lookup, update strategy, and filter.

● Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.

● Worked on issues with migration from development to testing.

● Developed Test Cases according to Business and Technical Requirements and prepared SQL

scripts to test data.

● Responsible for testing and validating the Informatica mappings against the predefined ETL

design standards.

● Fixing the Issues during the Upgrade like Informatica mappings, mapplets, Sessions, workflow

and worklet.

● Unit testing and system integration testing of the developed code.

● Providing fixes to the issues identified in testing phase.

● Provide production support for the deployed project till it is stabilized.

Environment: Informatica PowerCenter 8.6.1, Oracle 10g, Flat Files, SQL, PL/SQL, Unix, SQL Server,

Windows XP.

Caterpillar, Morrisville, NC

Nov’10 – Feb’11

ETL Developer

Worked on development of marketing and Sales Datamart. This datamart is used by Field Sales agents to

sell to old customers and keep track of items sold and also predict future sales.

Responsibilities:

● Used Informatica Designer to create complex mappings using different transformations to

move data from the source to the Data Warehouse.

● Created Different Mappings, Mapplets, Worklets applied required Transformations based on

Source to Target mapping document specifications.

● Developed reusable mappings using Mapplets, parameters and Variables.

● Worked on different data sources such as Oracle, Teradata, SQL Server, Flat files etc.

● Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression,

Lookup, Update strategy and Sequence generator.

● Worked with command line program pmcmd to interact with the server to start and stop

sessions and batches, to stop the Informatica server and recover the sessions.

● Created complex T-SQL queries and functions.

● Created sessions, batches and scheduled them. Scheduling the sessions to extract, transform and

load data into warehouse database as per Business requirements.

● Created and established different Metadata, and Data load connections while designing mapping

and loading data to Target.

● Implemented SQL Override in mappings Using complex SQL, PL/SQL Logic.

● Scheduled the Sessions and Mapplets using Workflow Manager to load the data into Target

Oracle database.

● Provided Production support. Was actively involved in troubleshooting the issues related to ETL

and reporting that occur on day-day basis.

● Performed Unit Testing and worked with the end user at various stages of the test cycles.

Environment: Informatica Power Center 7.3.1, SQL, PL/SQL, TOAD 10.5, SQL Server 2005/2008

Teradata r12, Unix

Apollo Hospitals, Hyderabad, India

Jul ‘08 – Aug’10

ETL Informatica Designer

Apollo Hospitals Group, today, is an integrated healthcare organization with owned and managed

hospitals, diagnostic clinics, dispensing pharmacies and consultancy services. In addition, the group’s

service offerings include healthcare at the patient’s doorstep, clinical & diagnostic services, medical

business process outsourcing, third party administration services and health insurance. To enhance

performance and service to customers, the company also makes available the services to support business,

telemedicine services, education, training programs & research services and a host of other non-profit

projects. Worked on development of Data warehouse to track effectiveness of treatment and drugs on

patients.

Responsibilities:

● Actively involved in gathering requirements from end users, involved in modifying various

technical & functional specifications in the development.

● Gathered requirements from Hospital administrators and Doctors for Dashboard and Reporting.

● As a member of data warehouse design team, assisted in creating fact and dimension tables

based on requirement of the project.

● Extensively involved in ETL code using Informatica tool in order to meet requirements for

extract, cleansing, transformation and loading of data from source to target data structures.

● Used Source Analyzer and Warehouse designer to import the source and target database schemas,

and the Mapping Informatica Designer to create complex mappings from Business requirements.

● Created various transformations like filter, router, lookups, stored procedure, joiner, update

strategy, expressions and aggregator to pipeline data to Data Warehouse/Data Marts and

monitored the Daily and Weekly Loads.

● Created Mappings, Mapplets, Sessions and Workflows using Informatica Power Center 8.6.

● Involved in Fine tuning SQL overrides in Source Qualifier and Look-up SQL overrides for

performance Enhancements.

● Created reusable Mapplets and transformations in Informatica.

● Worked with health payer related data such as customers, policy, policy transactions, claims.

● Generated weekly and monthly report status for the number of incidents handled by the support

team.

● Extensively used multiple data providers for building reports.

● Involved in documenting the changes to the universe and reports functionality.

● Used combined query functions, sub queries, Grouping, Custom sorts.

● Performed Unit Testing and worked with the end user at various stages of the test cycles.

Environment: Informatica PowerCenter 7, Oracle 9i, SQL* Loader, HP UNIX.

Education:

Bachelor's in Electronics, G. Narayanamma Institute of Technology & Science, AP, INDIA.

(2004-2008).



Contact this candidate