AbiInitio Snowflake ControlM Developer

Cynet systems Inc; Mississauga; On-site; CAD 80,000 - 100,000; Full time

Job summary

A technology firm is seeking a professional with extensive database expertise. The role requires proficiency in SQL, Oracle, DB2, and Teradata. Ideal candidates will have strong analytical skills and experience with ETL tools like Ab Initio and Spark/Python. The position also involves project exposure, team management capabilities, and familiarity with Agile methodologies. Located in Mississauga, this is an excellent opportunity for those with a background in finance and data warehousing.

Qualifications

• Proficient in SQL and database management.
• Hands-on experience with Oracle, DB2, and Teradata.
• Familiarity with Unix utilities and scheduling tools.

Responsibilities

• Manage teams and ensure effective communication with clients.
• Support data ingestion processes and issue resolution.

Skills

SQL

Database Load/Unload utilities

Oracle

DB2

Teradata

Unix utilities

Data Warehouse concepts

Control-M

Maestro

Autosys

Jira

ServiceNow

ETL tools (Ab Initio, Spark/Python)

Agile Methodology

Snowflake

Job description

Job Description

Database Expertise

• Proficient in SQL.
• Expert in DB Load/Unload utilities.
• Hands‑on experience with Oracle, DB2, and Teradata.
• UNIX Skills: Familiarity with Unix utilities such as more, sed, awk, etc...
• Data Warehousing: Solid understanding of Data Warehouse concepts with strong analytical skills.
• Scheduling Tools: Experience with scheduling tools like Control‑M, Maestro, Autosys etc...
• Ticketing Tools: Working knowledge of Jira and ServiceNow.

Project Exposure

• Experience with at least 2–3 source systems and multiple target systems.
• Daily simple data ingestion processes.
• Domain Knowledge: Background in finance, ideally with exposure to capital markets products.
• Framework Development: Experience in developing and supporting complex frameworks for multiple data ingestion patterns.
• ETL Tools: Proficiency in ETL tools such as Ab Initio, Spark/Python.
• Agile Methodology: Experience working in an Agile project development lifecycle.
• Database Concepts: Strong understanding of databases and related concepts; Snowflake knowledge is a plus.

Familiarity with Jenkins

• Team Management: Ability to manage teams, assign tasks, build teamwork, and ensure effective communication with clients.
• Support Experience: Prior experience in production support and issue resolution is an added advantage.