ETL developer Resume

SUMMARY

Around 7 years of IT experience as Software Engineer, Software developer in ETL domain.
Certified ODI 11g Developer
Experienced in operating Business Intelligence Applications e.g. Oracle Data Integrator.
Expertise in Data Warehousing, ETL programming and fulfillment of data warehouse project tasks including Data Extraction, Cleansing, Transforming and Loading.
Skilled in Installing and configuring various Oracle Products like Oracle Data Integrator, SQL developer, Toad.
Skilled in installing and configuring the ODI repository by using Repository Creation Utility and Master Repository Creation Wizard.
Skilled in ODI development for creating interfaces, procedures, packages, scheduling ODI Scenarios.
Experienced in working with various data sources like flat files, COBOL files, Oracle Tables, MYSQL tables.
Skilled in Developing Demonstrations on ETL Tool ODI for Sales Consultants.
Experienced in configuring ODI Agents, ODI Console.
Experience in web technologies like XML, CSS.
Skilled in creating ETL Transformations, BI reports.
Experienced in Production support, maintenance of Data Loading in Data warehouse.
Provided 24 X 7 and 365 days support for Business - Critical Applications

TECHNICAL SKILLS

Databases: Oracle 11g, MYSQL

Web Technologies: HTML, XML, Java Script, CSS, ASP.NET

Tools: /IDE: Toad for Oracle, SQL Plus, SQL Developer, Oracle Data Integrator, OBIEE 11g, Tableau 10.1

Operating Systems: Windows

PROFESSIONAL EXPERIENCE

Confidential

ETL developer

Environment: Languages: SQL; Database: Oracle 11g Tools: ODI (11.1.1.5) ; O/S: Windows. SQL Developer: Version 3.2.20.09

Responsibilities:

Data profiling for Confidential and data corrections after data profiling is done.
Data loading in oracle tables from EXCEL, CSV and txt files.
Creating header formats in fixed length file e.g. Creating COBOL copybooks and reverse engineer them in ODI.
Implementing business process rules into the interface.
Unit testing of data.
Creating reports and building dashboard in OBIEE 11g as per the client requirements per file.
Automated testing of claims and members using ODI procedures.

Confidential

ETL developer

Environment: Languages: SQL; Database: Oracle 11g Tools: ODI (11.1.1.5) ; O/S: Windows.

Responsibilities:

Confidential

ETL developer

Environment: Languages: SQL; Database: Oracle 11g Tools: ODI (11.1.1.5) ; O/S: Windows. OBIEE 11g

Responsibilities:

Data profiling
Data corrections after data profiling is done.
Data loading in oracle tables from EXCEL files.
Implementing business process rules into the interface.
Unit testing of data.
Creating models in OBIEE
Creating facts and dimensions in BMM layer
Creating reports and dashboard with prompts to present the current and over the years business view.

Confidential

Sr. ODI Consultant/Developer

Environment: Languages: SQL, Database: Oracle 11g, Tools: ODI 11g (Version 11.1.1.7) O /S: Windows.

Responsibilities:

Created Models and data stores for getting files and database objects.
Creating several reverse engineering Models as per the requirements.
Loading metadata data from FLAT files, XML files and XL sheets and Data Base table’s source system into RDBMS target system.
Mapped Logical resources to Physical resources in different contexts.
Scheduling the scenarios by using ODI Scheduler.
Created interfaces for loading data from database to CSV files.
Developed packages for file operations using ODI Tools.
Performed Debugging and Tuning of mapping and sessions.
Monitored performance using Batch load and Array fetch.
Monitoring the Execution Logs in operator navigator.
Used CDC features for Incremental data loads.
Created jobs parallel and serial using Load plans with condition based using CASE.
Implemented Send E-mail to the DBA, Support team on execution failure.
Worked on Delimited flat files, oracle sources, MS Excel to load into oracle target database.
Taking Back-up of Projects & Repositories on weekly basis.
Implemented version control mechanism to maintain the code versions.