[The logo is protected from the company]

Compuware Corporation

New technologies offer incredible potential: revenue growth, improved customer satisfaction and stronger brand image. However, these innovations can also make technology environments more complex.To reach its full potential, technology must be easy to use. And it must perform.For nearly 40 years, Compuware has delivered software, experts and best practices to make your applications work well and deliver business value. Our people and software ensure that critical technologies work like they s... Read More

Address      One Campus Martius Detroit Michigan 48226 United States of America
Website      www.compuware.com/
Holding      No Holding Details

View Company Page
Apply to job

SQL Developer

Company Message:

Compuware Corporation, the technology performance company, provides software, experts, and best practices to ensure the world's most important technologies work well and deliver value. Compuware customers include 46 of the top 50 Fortune 500 companies and 12 of the top 20 most visited U.S. web sites. The company's ongoing success depends on our employees--a diverse team of people with a set of key, common attributes. We seek positive, assertive team players who have a strong desire to succeed in a team and customer oriented environment. Learn more: http://www.compuware.com.
Position Description & Responsibilities:

    * Coordinate with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
    * Involved in writing major ETL packages used in Data warehouse to load the data into different stages like Landing, CRF, ODS, and EDW.
    * Create huge set of external tables to load the data into landing area tables from different formats of files (.DAT,.SUM, etc.) available in Oracle directory.
    * Involved in the creation of database objects such as tables, views, stored procedures, functions, packages, Indexes and Scheduler jobs, chains and Queues.
    * Create Data Structures including Tables and Views, and applied referential integrity.
    * Participate in designing of data conversion/interface with the use of SQL*Loader.
    * Create various packages to export the data in multiple formats to generate the reports for other third party interfaces, and involved in generating the automatic reports in daily manner using the DBMS_SCHEDULER job and chain utilities.
    * Develop SQL*loader scripts to load data in the custom tables.
    * Involved in documentation of user requirements and testing of developed modules.
    * Work in the Production Support team and fix high priority bugs.
    * Develop SQL scripts to create database tables, synonyms, sequences, and created users, roles, and granted privileges to them.
    * Perform unit testing and integration testing for various development applications in ORACLE 10g.
    * Involved in formulating general methodologies, naming conventions, and coding standards for various procedures and packages.
    * Work on SQL*Loader to load data from flat files obtained from various facilities every day.

Qualifications:

 Strong working knowledge of Oracle 10g Release 2.  This includes:

    * Working knowledge of SQL and experience with Oracle External Tables, Table/Index partitioning.
    * Understanding how Oracle features are implemented in data warehousing environments.
    * Working knowledge of table and index creation options for data warehousing environments.
    * Strong knowledge of PL/SQL including developing packages, etc.
    * Ability to write ETL code in PL/SQL and to migrate an existing data warehouse environment to a new structure.
    * Innovative in use of both SQL and PL/SQL.
    * Working knowledge of TOAD 10.6, Windows XP, and COBOL.

Other Job Information

Vacancy type:

Full Time

Contact Mode:

not provided

Fax:

(517) 267-5253

Contact Name:

not provided

Job Duration:

not provided

Phone:

(313) 227-7300

Email:

detroit@compuware.com

News - Compuware Corporation

Related Jobs

Engineering Program Manager

The Engineering Program Manager is responsible for leadi ...   [more]

Dot net developers

Windows application development experience using C#.Net, ...   [more]

Java developers

2- 5 yrs of experience in Core Java and J2EE Experience ...   [more]

VC++ Developers

2-5 years Development experience using C,C++, VC++, MFC   [more]

develop superior video products

Providing stellar products and services takes a great te ...   [more]

Software Developer

As a senior software developer you will be involved in n ...   [more]

Senior Software Developer

As a senior software developer you will be involved in n ...   [more]

3D Game Developer

    *   Write/edit programming script to create and enha ...   [more]

Expand

Collapse