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