Database Developer (PL/SQL, Python)

The

Data Engineer is responsible for designing, implementing and supporting full life-cycle data engineering projects. These projects should include large data ingestion, persistence, transformation, and retrieval. Will develop, maintain, and deploy platform or application code, stored procedures, function, triggers in development, staging and production environments.

• Perform fine tuning and optimization of SQL and PL/SQL code to improve query response.
• Debug and support production issues and assist with system integration and testing.
• Carry out complex DDL, DML and analytical functions to assist developers in application delivery.

Requirements:

• Requires 2+ years’ experience in the design, implementation and support of full lifecycle data engineering projects
• Detailed work experience in SQL Development (PL/SQL and MemSQL preferred) on Oracle Database, SQL & PL/SQL, including ANSI SQL.
• Experience in database analysis, development and maintenance of business applications specific to oil & gas back office operations
• Expertise in various ETL tools such as Mimix Share, SQLLoader, Equalum, Python scripts is preferred
• Familiarity with NoSQL databases and pipelines (Elasticsearch, MongoDB).