ONTDD-2418-Database-Developer

‹ Back to Current Opportunities

Please contact human resources if you have any questions.

Vantix Systems Inc. is a dynamic and savvy organization based in Edmonton, Alberta, Canada. We are looking for creative and talented professionals to join our team.

Job Opportunity
DescriptionOur Client is seeking a Database Developer to design/develop application and/or data components, with a focus on extract, transform and load (ETL), stored procedures, data schemas/models, data mapping, and queries to implement system-to-system integration. 
SkillsETL, Data Models, Schemas, Oracle, Java, WebServices 
TypeContract 
Project Description 
Experience Required/ Mandatory Skills
  • 5+ Years of ETL Experience
  • 5+ Years of designing/developing/implementing data models, data schemas
  • Perform data mapping, create data models / data schemas and develop ETL scripts and/or web services to facilitate system-to-system data integration
  • Knowledge of programming/development languages, structured query languages
  • Creating data views, functions and stored procedures
  • Knowledge of testing procedures, methods and processes to evaluate and improve quality, performance, and debugging
  • Developing optimized queries for integration with other applications/systems/databases
  • Creating database triggers/procedures for use in automation
  • Develops processes and/or reports to ensures data quality and database security
  • Problem solving skills to identity root causes and identify options/solutions to fulfill/implement complex data/system requirements
  • Identify, evaluate and implement web services, scripts and/or tools to support data validation and cleansing
  • Liaise with internal and external clients to fully understand data content
  • Gather, understand and document detailed business requirements using appropriate tools and techniques
  • Manipulate, analyze and interpret complex data sets relating to the client's business needs
  • Create data dashboards, graphs and visualizations
  • Very strong technical experience/skills in: Database: Oracle Enterprise Edition preferred; Database Design Tool: Oracle Designer preferred; Development/Programming Language: Java Enterprise, Java, Javascript, VB Script, HTML, DHTML, XML, JSON, AJAX, JDBC/SQL, NoSQL; Strong experience with ETL Tools/Software (e.g. Informatica)
  • Experience with designing/developing/implementing data models, data schemas
  • Experience performing data mapping
  • Experience in developing WebServices
  • Strong experience/knowledge in PL/SQL
  • Experience interfacing with relational databases
  • Experience with data/application security
 
Nice To Have Skills
  • Public Sector experience
 
LocationRemote 
Work Environment7.5 months 
Hourly RateNegotiable