Data Warehouse ETL developer - Senior ETL Developer

United Software Group Inc; Canada; On-site; CAD 90,000 - 120,000; Full time

Job summary

A software solutions provider is seeking an experienced ETL developer in Canada with strong proficiency in Teradata SQL and BTEQ. Candidates should have 8-10 years of ETL development experience and 6+ years working in enterprise data warehouses. Strong documentation skills and the ability to translate business requirements into technical solutions are essential. This role necessitates independent work in a variety of environments, with a focus on high-quality standards and compliance.

Qualifications

• 8-10 years of experience in ETL development using various versions of Teradata.
• 6+ years in Enterprise Data Warehouse ETL development.
• 6+ years of experience with SQL proficiency.

Responsibilities

• Document ETL logic and workflow processing.
• Work within systems development lifecycle and release management.
• Design, code, test, debug, and document ETL processes.

Skills

Teradata SQL

BTEQ

ETL development

SQL proficiency

UNIX

Documentation

Communication skills

Job description

Note: Strong proficiency in Teradata SQL and BTEQ is required.

• 8-10 years of experience ETL development using various versions of Teradata
• 6+ years of Enterprise Data Warehouse ETL development.
• 6+ years of experience with proficiency in SQL with Teradata Oracle and/or Databases.
• Expert at documenting ETL logic and workflow processing.
• Experience in working within systems development lifecycle and release management, releases.
• Excellent written and verbal communication skills.
• Develops statements of problems and requirements. Can translate both business to technical and technical to business written and verbal communications.
• Able to work independently in all of the above areas of knowledge.
• Experience working with UNIX.
• Designs, codes, tests, debugs and documents data warehouse ETL or reporting code according to customer standards, policies, procedures, security and compliance requirements.
• Understands and foresees implications of decisions.
• Understands the core business process and purpose of the functional area.
• Individuals understand their own area and are able to perform all facets of their role.
• Individuals should have experience in most issues that may arise, although require guidance with new assignments or assignments outside normal scope of work.
• And should be able to manage projects with oversight from their supervisor.
• Works on a large portfolio of applications, Provides application design and documentation that spans multiple applications and/or functions.