ETL Developer

Information Technology   |   Calgary

Job Description

Information Technology

Required Skills

  • 5+ years’ experience developing complex ETL stored procedures
  • Developing ETL processes to monitor, control and maintain data integrity, accuracy and security
  • Experience analyzing ETL processes for speed optimization and contributing to system architectural design and planning discussions
  • Experience working with conceptual, logical and physical data models, data flows and databases; along with creating/maintaining conceptual, logical and physical data documentation
  • Experience developing and maintaining methods, processes and functionality utilized to accomplish data conversion requirements
  • Expertise with the creation, maintenance and tuning of database objects (specifically stored procedures)
  • Some experience conducting data profiling and designing target data structures (data models) in compliance with the corporate data architecture
  • Broad experience with Enterprise ETL Tools (SSIS, SAS DI, Informatica, etc.)
  • Experience facilitating, gathering and documenting requirements through design sessions with business clients
  • Experience on projects with formal development methodologies and change management procedures

Desirable Skills

  • Experience in Python development tools and libraries
  • Databases, and a good understanding of SQL queries
  • Linux usage and shell scripting
  • Docker/Kubernetes
  • OOP and Agile methodologies
  • Git or similar source-control tools (we use Github)