Data engineer-PlSQL

Steneral Consulting
Houston, Canada
$102.2K-$142K a year (estimated)
Full-time
We are sorry. The job offer you are looking for is no longer available.

Title : PL / SQL Developer

Location : Houston TX

Summary :

The Sr. Data Engineer isresponsible for designing implementing and supporting fulllifecycle data engineering projects. Theseprojects should include large data ingestion persistencetransformation and retrieval.

Will develop maintain and deployplatform or application code stored procedures function triggers indevelopment staging and production environments.

Perform finetuning and optimization of SQL and PL / SQL code to improve queryresponse. Debug and support production issues and assist withsystem integration and testing.

Carry out complex DDL DML andanalytical functions to assist developers in applicationdelivery.

Requirements :

Bachelors degree in Computer Science Engineering or otherequivalent degree with 5 years data engineering experience orMasters degree in Computer Science Engineering or other equivalentdegree with 2 years data engineering preferred.

High school diplomaor GED is required. Requires 2 years experience in thedesign implementation and support of full lifecycle dataengineering projects.

Experience in event driven and cloudbasedarchitectures and working knowledge of containerization andstreaming technologies.

Detailed work experience on OracleSingleStore or IBM I DB2 database SQL & PL / SQL including ANSISQL. Experience in database analysis development and maintenance ofbusiness applications specific to oil & gas backofficeoperations.

Expertise in various ETL tools such as SQL*LoaderEqualum Python scripts. Familiarity with NoSQL databases andpipelines (Elasticsearch MongoDB).

Inregard to Python they might ask about where acandidate has used Python in Data Loading or moving data from onesource into specific table structure possibly using ElasticSearch.

They will also want to know what theyhave done creating any Rest APIs

Airflow is another tool they willexpect the candidate has worked with in their recent experience. Itis expected they can discuss how and why use of Airflow made sensein their project.

Big Data / Databricks is notpart of this role. Candidates with the bulk of their experience onCloud and Big Data work will probably not be a fit for this role .

Please note that all candidates must have applicationsexperience.

30+ days ago
Related jobs
Promoted
Systematix
Canada

The Sybase Administrators will collaborate with our client’s Database Platform Administrators, System Administrators and Application Support teams as required, to maintain system availability targets. Sybase Database Administrators. The Sybase DBA's will provide Sybase database support services incl...

Promoted
Green Courte Residential Holdings.
Canada
Remote

Given the rapid pace of change in the data and analytics role, the Senior Data Engineer will also be a key technical visionary for GCRH, helping the company find new efficiencies using technology by building a deep understanding of GCRH’s value proposition and processes, continually staying informed...

Promoted
Apex Systems
Canada

Apex Systems is a global IT services provider, and our staffing practice has an opening in the Online Retail space for Data Analysts with strong experience in investigative data analysis that results in growth combined with experience in SQL, databases of a terabyte or more and optimum queries to pl...

SJ Health Insurance Advocates
Canada

Develop and maintain databases by acquiring data from primary and secondary sources and build scripts that will make our data evaluation process more flexible or scalable across datasets. Create and maintain rich interactive visualizations through data interpretation and analysis, with reporting com...

SIX Payment Services
Canada

Worldline is hiring a senior database administrator to join our North America IT operations team. As a Worldline DBA, you will be a critical member of the team managing our production and non-production databases. You will build, configure, and optimize SQL Server database engines in a variety of en...

Schenker of Canada Limited
Canada

This position is also responsible for performing administrative functions within the SCAN database to direct work flow, monitor requisitions supplies, and to troubleshoot. Responsible for maintaining accurate SCAN database records on a daily basis, while ensuring updates are entered, modified, and d...

Big Viking Games
CA
Remote

As a Senior Data Engineer, you will be responsible for designing, implementing, and maintaining data pipelines that process and analyze large volumes of data. We are looking for a Senior Data Engineer to join our team and help us build and maintain our data infrastructure. Big Viking Games is on the...

Macropus Global
Canada

Administer the SAP database with Database Administrator (plan and perform database upgrades, apply database maintenance, design and maintain physical database layout, perform database reorganizations, design and implement backup and restore strategy, maintain database security, administer database p...

Blazesoft
India

Senior Gaming Business Analyst is a critical position driving data-driven decision-making, optimizing business performance, and shaping the strategic direction of the gaming brands within the company. Data Analysis - Analyze large datasets to understand gaming operations, player behaviour, and reven...

CB Canada
Canada

The Select Group is seeking a Data Analyst for their top telecommunication client. For this role, the Analyst will join a team that manages the data lakes within the Google Cloud. ...