ETLMS SQL ServerMySQLOraclePostgresSQLData MiningPostgreSQLSQL Server
About this role
Role Overview
Design and develop database systems to integrate data from numerous sources, improve data quality, and support clean and efficient data mining and management.
Design and maintain database security architecture.
Develop and map XML schema to support data import from and export to an Oracle database.
Establish related data tables, views, constraints, triggers as well as stored procedures and functions using both T-SQL and PL/SQL to support data import, export, reporting, tracking and quality checking.
Requirements
Bachelor’s Degree or higher from an accredited course of study in engineering, computer science, mathematics, physics or chemistry AND 5 or more years’ of related work experience OR an equivalent combination of technical education and experience
10 years’ experience working with large database systems
Experience in SQL programming and database management systems (e.g., Microsoft SQL Server, Oracle, MySQL, PostgreSQL)
Expertise in Microsoft Excel
Experience developing web applications using Oracle APEX
Demonstrated ability to work in a team dynamic
Experience designing and performing Extract, Transform, and Load (ETL) activities