Browse
Employers / Recruiters
Negotiable
Full-time
Continue
By pressing the button above, you agree to our Terms and Privacy Policy, and agree to receive email job alerts. You can unsubscribe anytime.
Interview: Phone and F2F

–American Honda

Description:


Description

Seeking an experienced Senior Developer who specializes in Oracle
database and PL-SQL / Data warehouses / Unix servers and shell
scripting.
Ability to design solutions and conduct data analysis is required.
Informatica knowledge is a plus.
Auto industry, CRM and knowledge of marketing concepts are pluses.

Responsibilities

The position will be supporting a custom CRM application, specifically
the analytical repository.
The repository is an Oracle database, the OS is Unix AIX 6.x.
The responsibilities for the position include the analysis, design,
development and 24/7 support of the production processes and
applications.
The candidate will work under the supervision of the ECRM team lead.
Will be part of a team responsible for supporting CRM analytics and
Campaign operations.


Musts


Oracle Database | · Strong understanding of Oracle
| PL/SQL techniques to write stored
| procedures, triggers and packages that
| analyze several million rows across
| several database tables.
| · Ability to grasp relational data
| models quickly and program using SQL
| and PL/SQL
| · Clear understanding of SQL's
| analytical processing capabilities
| such as RANK, DENSE RANK etc.
| · Strong understanding of Oracle
| dynamic SQL and ability to write
| complex procedures using dynamic SQL.
| · Performance tuning methodologies and
| understanding of Relational database
| join techniques like HASH, NESTED
| LOOPS etc and the use of Oracle Hints.
| · Advanced knowledge of Oracle
| Indexing techniques like BIT Map
| indexes and Index Organized tables.
| · Optimize and tune stored procedures,
| embedded SQL, taking advantage of
| Oracle specific features
| · Oracle Data Partitioning techniques
| to manage, support and performance
| tune very large databases (VLDB's)
| · Understanding of Parallel execution
| features of Oracle to dramatically
| reduce response times for data
| intensive operations.
| · Bulk Collect functionality,
| pipelined functions and other features
| of Oracle PL/SQL.
| · Ability to write efficient PL-SQL
| procedures.
| · Design complete solutions.
--------------------+-----------------------------------------
Data | · Knowledge of Informatica is a plus.
transformation | · Familiarity with Extraction,
(ETL) | Transformation and Loading (ETL tools)
| to facilitate loading large amounts of
| data.
| · Strong ETL design and development
| abilities. PL-SQL and Stored
| Procedures to upload data from
| different sources.
--------------------+-----------------------------------------
Unix OS | · Experience working with Unix
| servers.
| · Experience with Shell scripting.
--------------------+-----------------------------------------
Database / Other | · Experience in the analysis, design,
| development, deployment & tuning of
| large scale databases.
| · Experience in the design and
| development of data warehousing.
| · Expert knowledge of SQL. Ability to
| write and understand complex SQL
| required.
| · Query analysis and tuning experience
| (hints, explain plan, TKPROF).
| · Expert knowledge of Oracle PL/SQL
| best practices and development
| methodologies or standards - Stored
| Procedures, Packages, Triggers,
| Debugging, Tuning.
| · Data modeling Experience a plus.
| · Data Warehousing experience a plus.




Bachelor's degree in Computer Science or related discipline or have equivalent experience


Business Experience

5 plus years experience with major DBMS
5 plus years experience with coding, testing, and design
5 plus years experience with software development methodologies

Wants

Motivated self starter.
Ability to work in a fast paced environment.
Ability to work in a team environment where team conducts code and
design reviews prior to implementation.
Ability to lead minor tasks and follow up on progress specially if
depending on others to do their tasks.


Last updated on Nov 10, 2016

See more

More jobs at ipjdnw7f5napvetweqr2ziz9mno8hm0423sbqrczl5q6rasimprbblk5rouuuujo

Analyzing

Stamford, Connecticut

 · 

30+ days ago

Dallas, Texas

 · 

30+ days ago

Atlanta, Georgia

 · 

30+ days ago

Hanover, New Jersey

 · 

30+ days ago

New Hartford, New York

 · 

30+ days ago

More jobs like this

Analyzing
Mobile Backend Developer
C
crjdnwsnowo2i4nz45b1teboszrxlg0351vr73gpqw7yanury9u287prckhdnkww

Dallas, Texas

 · 

30+ days ago

Web developer
G
Green ·  Environmental consulting firm

San Jose, California

 · 

30+ days ago

Web Developer Job
TT
The Talently ·  AI recruitment platform

San Francisco, California

 · 

30+ days ago

Cumming, Georgia

 · 

30+ days ago

 · 

30+ days ago

Mobile Software Developer for Robotics Application
roboticsunlimitedinc ·  Robotics design and manufacturing

Pensacola, Florida

 · 

30+ days ago

QA Engineer (Automation)
AnchorFree ·  Online privacy and security

Mountain View, California

 · 

30+ days ago

Full stack
R
rqjdnwbs34lmixfu3kkfd08vmgygir029fesnaptym1rbs1iivifcavlyk16brnc

Phoenix, Arizona

 · 

30+ days ago

VMware and Windows Engineer - ONSITE
B
b6jdnwcpcemgg8el3r9winlpunj8hc038b1vkhowrzxn9gitznreodi38t7rirkp

Chesterfield, Virginia

 · 

30+ days ago

Developed by Blake and Linh in the US and Vietnam.
We're interested in hearing what you like and don't like! Live chat with our founder or join our Discord
Changelog
🚀 LaunchpadNov 27
Create a site and sell services based on your CV.
🔥 Job search dashboardNov 13
Revamped job search UI with a sortable grid, live filtering, bookmarks, and application tracking.
🫡 Cover letter instructionsSep 27
New Studio settings give you control over AI output.
✨ Cover Letter StudioAug 9
Automatically generate cover letters for any job.
🎯 Suggested filtersAug 6
Copilot suggests additional filters above the results.
⚡️ Quick applicationsAug 2
Apply to jobs using info from your CV. Initial coverage of ~200k jobs in Spain, Germany, Austria, Switzerland, France, and the Netherlands.
🧠 Job AnalysisJul 12
Have Copilot read job descriptions and extract out key info you want to know. Click "Analyze All" to try it out. Click on the Copilot's gear icon to customize the prompt.
© 2024 RemoteAmbitionAffiliate · Privacy · Terms · Sitemap · Status