Data Engineer - Data Mart

Data Engineer, Oracle, SQL, PostgreSQL, AWS, Python, Perl
Full Time
Depends on Experience
Travel not required

Job Description

100% Remote Work  

  • Evaluate Oracle PL/SQL Code and check for compatibility with PL/pgSQL in PostgreSQL, look for retrofitting options. 
  • Check dynamically generated SQL within middleware, application server objects, Java classes and shell scripts. Design and develop repository-based SQL code that could be dynamically constructed at runtime. 
  • Evaluate and innovate the mapping of application functionality requirements using cloud native technologies such as AWS Lambda. 
  • Refactor and Retrofit embedded and dynamic/generated SQL from Oracle to PL/pgSQL in PostgreSQL together with related schema changes, including within C++, C#, Python, Perl, Java classes, batch programs, external scripts, PL/SQL DB objects (procedures, functions, triggers, views, etc.) and SQL stored within DB tables. 
  • Inventory and evaluate objects to be refactored, cataloging specific migration topics to be addressed (e.g. a Decode function, pipelined functions, types, table functions) within the objects, and assessing.

Requirements

 

Basic knowledge of database, BI reporting and analytics tools; Analytical and problem solving skills.

Database and reporting mart development and management experience; 

  • Proficient in SQL programing
  • Cloud data migration experience
  • Knowledge in data governance, data quality and master data management

 

Dice Id : 10268099
Position Id : 796513
Originally Posted : 2 months ago
Have a Job? Post it