Applications Developer 3

As an Implementation Engineer at Oracle Utilities Analytics Insights (OUAI), you will work with a team to implement SaaS-based energy efficiency and customer engagement programs on behalf of our utility partners. You will collaborate with a diverse group, including a Project Manager, a Senior Implementation Engineer, as well as members of the Product Engineering, Product Management, and QA teams. Setting up new programs for our utility clients is the lifeblood of Oracle Utilities Analytics Insights (OUAI), and we rely on Implementation Engineer's input and expertise for our overall success.

Our Implementation Engineers rely on a diversified technical skill-set, including:data manipulation via complex SQL queries, Extraction-transformation and Loading (ETL) for custom interface development, experience on the Linux command line, shell scripting, and software development using high-level programming languages such as Python or Java. We do not expect you to immediately be masters of the full spectrum of technologies used, but through on the job training and coaching, you will gain the necessary skills required to launch energy efficiency programs for new utility clients.
About You

Bachelors/Masters degree in computer science or related field

5+ years of experience working on ETL using specific tools or pl/sql

Self-starter with the ability to work independently and take initiative. Ability to translate ideas and business requirements into fully functioning ETL workflows.

You are able to write SQL for large data sets and have recent experience with relational databases, Oracle preferred

knowledge of database administration (table/partition, DML, DDL, procedure and packages)

You have experience in Linux and are not afraid of the command line

You demonstrate some programming knowledge (Java, Python, shell scripting)

You have experience in business intelligence, reporting and visualization tools

You are a smart, talented engineer, looking for an exciting, fast-paced company to expand your toolbox and develop your skills.

Strong verbal and written communication skills

Career Level - IC3

Responsibilities 

Analyze data and develop interfaces to extract, transform, and load utility data from the utility clients using sql/plsql to meet Oracle Utilities Analytics Insights (OUAI)s data standards

Develop and deploy ETL job workflow with reliable error/exception handling and rollback framework.

Adapt ETL code to accommodate changes in source data and new business requirements.

Spearheads development of ETL code, metadata definitions and models, queries and reports, schedules, work processes and maintenance procedures.

Ensures data quality throughout entire ETL process.

Code development with Python, Shell scripting in UNIX/LINUX environments.

Manages automation of file processing as well as all ETL processes within a job workflow.

Prepare & analyze the data and build visualizations for the Energy & Water use cases.

Ensures compliance with regulatory requirements for data transmission, storage, and data access including documentation, testing, and remediation

Monitor production jobs and tasks

Build and maintain a deep understanding of our products with the ability to explain them to others; think about how client customization and delivery can be speed up and improved

Skills:
Analytics,ETL (Extract, Transform, Load),Python (Programming Language),SQL (Structured Query Language)