Professional Summary

• Good working experience in GREENPLUM Database.
• Strong SQL knowledge to overwriting source table data, and PL/SQL programming to improve performance in ETL
• Proficient to write PL/SQL Packages, Functions, Stored Procedures, Triggers and Views.
• Excellent skills in retrieving/manipulating data by writing complex SQL Queries and optimizing data performance
• Strong Working experience on Oracle 10g, 11g SQL and PL/SQL .
• Having good knowledge in full life cycle development of a Data warehousing project.
• Used different sources and targets like Oracle tables, SQL Server tables, Flat Files, XML files etc.
• Extensive experience in dealing with STAR, SNOWFLAKE, 3rd Normal form, Normalized and Denormalized data structures, data modeling
• Proficient in using Informatica workflow manager, workflow monitor, pmcmd Informatica command line utility to create, schedule and control workflows, tasks, and sessions.
• Experience in Performance Tuning of sources, transformations, targets, mappings, worklets, workflows, sessions and batches.
• Extensively used ETL methodology for supporting Data Extraction, transformation and loading processing, in a corporate-wide-ETL Solution using Informatica.
• Having Over 7 Years of Professional experience in the field of IT in analysis, design and development with an emphasis on Data Warehousing ETL Technologies using Informatica power center Client tools Designer, Work Flow Manager and Work Flow Monitor.
• Experienced in complex queries in SQL oracle as per the requirement specified.
• Good knowledge on OBIEE 11g, TABLEAU 9.0 reporting tools.
• Experienced in the UNIX Shell scripting, PERL scripting.
• Have done POC on Perl scripting.
• Adequate knowledge on Normalization techniques for designing relational database.
• Good in understanding of existing business requirements also questioning requirements when needed.
• Excellent attitude towards teamwork.
• Worked extensively in team oriented environment with strong analytical, interpersonal and communication skills.

Technical Skills

EXPERIENCE

Confidential

Role: Sr Informatica Developer

Environment: Informatica Power Centre 9.x, Oracle, Control-M, OBIEE 11g, UNIX

ETL Responsibilities:

• Created Informatica mappings to build business rules to load data
• Used Informatica power center to extract, transform and load data from multiple input sources like Oracle and flat files to target data base Oracle 11g
• Wrote procedures, packages in oracle as per the requirement.
• Used mapping designer and mapplets to generate different mappings for different loads
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed. Debugged the mapping of the failed session.
• Used various transformations like source qualifier, expression, filter, lookup, update strategy, aggregator transformations etc.
• Tuned SQL Queries in Source qualifier Transformation for better performance
• Designed/developed Stored Procedures for data mappings to implement complex business logics and called from Informatica Stored Procedure Transformations
• Created triggers, PL/SQL stored procedures and responsible for SQL tuning
• Wrote the PL/SQL procedures for data extraction, transformation and loading
• Involved in Fine tuning SQL overrides and Look-up SQL overrides for performance Enhancement
• Designing, Scheduling Monitoring of workflows.

Obiee 11g Responsibilities:

• Extensively used OBIEE Administration tool for Developing and customizing the Physical layer, Business layer, Presentation layer. And modifying it according to the business requirements. Based on the requirements created Presentation catalogs, Folders in Presentation Layer.
• Developed Reports with different views using BI Analytics/Answers.
• Extensive experience in building Interactive Dashboards with drill-down drill-across capabilities, using global local Filters and Guided Navigation

Confidential

Role: Sr Informatica Developer

Environment: Informatica 9.1, Oracle11g, UNIX, Shell scripting, Greenplum, Tableau

Responsibilities:

• Created Informatica mappings to build business rules to load data.
• Used Informatica power center to extract, transform and load data from multiple input sources like Oracle and flat files to target data base Green plum.
• Used various transformations like source qualifier, expression, filter, lookup, update strategy, aggregator transformations etc.
• Written complex queries and functions as per the requirement.
• Developed PL/SQL stored procedures for source pre load and target pre load to verify the existence of tables.
• Involved in performance tuning of sources, targets, mappings, and workflows. Also involved in tuning of SQL queries and PL SQL procedures.
• Extensively used Debugger to identify data transfer problems in mappings.
• Written psql procedures in Greenplum as per the requirement.
• Analyze the existing OBIEE reports and RPD to prepare the design for Tableau reports.
• Created sample workbooks, worksheets for data validation in tableau.
• Involved in Tableau tds creation. Publish the workbooks through tabcmd utility.
• Extensively worked with Tableau Metadata.

Confidential

Role: Tableau Developer, Etl DEveloper

Environment: Oracle11g, OBIEE 11g, Tableau, UNIX, Shell scripting, Java

Description: This project is to develop a tool to convert OBIEE RPD for a particular star into Tableau TDS files.

Responsibilities:

• Analyzing OBIEE metadata of a particular RPD
• Loading RPD metadata into tables.
• Created stored procedures to extract data from OBIEE repository tables
• Write complex queries to convert presentation columns to physical columns
• Create stored procedures to convert OBIEE derived logical columns and measures to Tableau metrics
• Wrote complex queries and functions as per the requirement.
• Convert OBIEE metadata to TABLEAU TDS file for reporting
• Perform unit testing validations.

Confidential

Role: Sr. Informatica Developer

Environment: Informatica Power Center9.1, Oracle11g, UNIX, Shell scripting

Responsibilities:

• Get the requirements for the enhancements to be done.
• Preparation of LLD and get it approved by BA.
• Implemented the Change request with Informatica mappings and stored procedures.
• Written shell scripts for file handling process.
• Done unit testing and prepare the test results.
• Involved in deployment plan for the change request.
• Provided production support hyper care for the change request implemented.

Confidential

Role: Informatica Developer

Environment : Oracle11g, UNIX, Shell scripting, Perl, Java

Responsibilities:

• Written shell scripts to extract OBIEE metadata.
• Create materialized Views.
• Written PL/SQL stored procedures, functions, packages to parse the metadata as per the requirement.
• Extensively worked with XML files.
• Using stored procedures data is loaded into dimensions and facts.
• Created OBIEE reports on data mart.

Confidential

Role: Informatica Developer

Environment: Informatica 8.6.1, OBIEE 10.1.3.4.1, Oracle 10g, SQL Server 2005, SFDC, Windows XP, Linux, Toad, APEX explorer

Responsibilities:

ETL Developer

• Analysis of the Specifications provided by the client.
• Involved in creation of low level design from high level design documents.
• Involved in data profiling of Operational data bases.
• Interacted with business for gathering requirements and resolving open issues.
• Extracting source data from Flat Files, RDBMS, SFDC and moving into Staging area and transferring to Oracle database using Informatica.
• Implemented mappings with various transformations depending upon requirement.
• Prepared Unit Test Specifications UTS for various mappings.
• Performed Unit Testing with UTS.
• Performed Integration testing and UAT.
• Involved in solving data issues raised in UAT by business.
• Created different schemas based upon scripts provided by data Modeler.
• Created scripts to create backup tables and refresh data from one schema to another.
• Performed smoke testing before giving system to business.
• Created one time mappings to update data in extra needed columns from source system.
• Prepared deployment document before production release and CR release.

OBIEE Developer

• Designed and developed the OBIEE Metadata Repository .rpd using OBIEE Admin tool by importing the required objects Dimensions and Facts with integrity constraints into Physical Layer using connection pool, developing multiple Dimensions Drill-Down Hierarchies Logical Facts Measures objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• Evaluated and validated the business model in Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the business model layer.
• Developed many Reports, Dashboards with different Views Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, Tabular with global and local Filters using OBIEE Presentation server.
• Created adhoc reports through answers to perform data validation.

Confidential

Role: Informatica Developer

Environment: Informatica 8.6.1, OBIEE 10.1.3.4.1, Oracle 10g, DAC, OBIA 7.9.6.1

Responsibilities:

• Analysis of the Specifications provided by the client.
• Involved in creation of low level design from high level design documents.
• Implemented mappings with various transformations depending upon requirement.
• Modified existing mappings based upon requirements.
• Importing extra added columns into respective Physical layer, BMM layer and Presentation layer.
• Modified Physical, BMM and Presentation Layers based upon business requirement.
• Create new graphs for audit process and change exsisting graphs according to the given requirements.
• Created execution plans and involved in full and incremental loads by using DAC.
• Prepared Unit Test Specifications UTS for various mappings.
• Performed Unit Testing with UTS.
• Performed Integration testing and UAT.
• Involved in solving data issues raised in UAT by business

Confidential

Role: Informatica Developer

Environment: Informatica Power Center 8.1, Oracle11g, UNIX, Shell scripting

Responsibilities:

• Created Informatica mappings to build business rules to load data.
• Used Informatica power center to extract, transform and load data from multiple input sources like Oracle and flat files to target data base Oracle 10g.
• Wrote procedures, packages in oracle 10g as per the requirement.
• Used mapping designer and mapplets to generate different mappings for different loads.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed. Debugged the mapping of the failed session.
• Used various transformations like source qualifier, expression, filter, lookup, update strategy, aggregator transformations etc.
• Designing, Scheduling Monitoring of workflows.
• Scheduling workflow using Unix Shell Scripting.