Innovations technological

Hello,

Please let me know if you would be interested for the below mentioned position, please send the resume to sandeep@captevo.com

DETAILS:

Position: Oracle Datawarehouse Developer

Location: Farmington, MI

Duration: 1 year (C2H)

Interview: Telephonic + F2F

Looking for GC EAD, GC or USC's

Job Description:

Responsible for assisting in the design and architecture of dimensional Enterprise Data Warehouses and data marts utilizing Oracle, DB2, and SQL Server data sources.

Develop stored procedures, database triggers, complex SQL queries, and PL/SQL programming.

Develop logical and physical Data Models, ER Diagrams, and star transformation models.

Design, develop and modify ETL transformation code/logic/programs for an Oracle environment.

Model subject areas to provide a consistent and reliable Enterprise Data Warehouse.

Create Metadata documentation (e.g., business glossary and data definitions) for enterprise Master Data Management.

Define the usage of queries and reporting tools to support corporate business units or external customers when combining and analyzing large volumes of information contained within the corporate data warehouse.

Analyze company and client needs to formulate business solutions based on IT and business goals; design specifications to enable others to develop effective business solutions in-line with defined requirements.

Develop test plans that encompass unit testing and analysis of test results.

Plan and schedule workload to meet assigned target dates.  May assist group/unit staff in resolving work related problems. Function effectively in a highly team oriented atmosphere.

Communicate both orally and in writing with clients, group members, outside vendors, and others regarding impact of activity on their assignments, program changes and specifications, project schedules, or other areas of mutual concern.

Participate in the requirements gathering phase, design, and preparation of specification of a project and/or existing application systems.

Develop, test, and support new or revised systems from prepared specifications.  Obtain approvals and consult with production control as needed to prepare programs/systems for implementation; correspond with clients to implement operations programs/enhancements and identify/resolve problems.

Document new and existing systems, adhering to department or corporate documentation standards, develop workflow, write client manuals and instructions and create data model definitions in line with project requirements.  Provide a clear record of activities taken on specific program or system projects.

May prepare project plans and schedules for employees and vendors to use in systems design and installation.

Reviews completed systems and workflow processes to ensure that procedures, flow, and functions meet specifications and requirements based on defined expectations.

The above duties may be performed independently or with team members.

Other activities as assigned by Leadership.

REQUIREMENTS

Over four years of experience in ODS and dimensional Data Warehouse Development with star schema and business modeling techniques.

Over four years of experience with PL/SQL and Oracle Databases preferably 10g or 11i.

Working knowledge of data modeling techniques, dimensional models and hyper-normalized models or dimensional-normal form or 3NF.

Working knowledge of all data warehousing components (Sourcing, ETL, Data Modeling, and Reporting).

Very strong communication skills.

Oracle Warehouse Builder experience a plus.

SQL Server experience a plus.

Bachelor's Degree in computer related field relevant business experience.

Basic knowledge of project/system management methodologies.

Demonstrated knowledge of data structure concepts and practices.

Demonstrated knowledge of software development life cycle methodologies.

Demonstrated knowledge of one or more software development platforms.