Design, build, and maintain ETL/data pipelines: extract, transform, load, and validate large data volumes. Translate technical specifications into tested applications, troubleshoot pipeline issues, optimize performance, and produce documentation. Collaborate with stakeholders across the SDLC and support deployment/CI-CD processes and BI deliverables (Cognos, PowerBI).
Responsibilities:
- Design, implement, and continuously expand data pipelines by
performing extraction, transformation, and loading activities.
- Required to translate technical systems specifications into
working, tested applications.
- This includes developing detailed programming
specifications, writing and/or generating code, compiling data-driven programs,
maintaining, and conducting unit tests.
- Resolves and troubleshoots technical problems which arise
during the use and operation of software packages, including technical
assistance in implementation, conversion and migrations.
General Skills:
- Experience in programming and analysis; specialized software
package support at the specified experience level
- Ability to collaborate with IT Professionals throughout the
Software Development Life Cycle
- Experience in structured methodologies for the development,
design, implementation and maintenance of applications
- Experience in design, code, test, debug and document
applications
- Experience in the use of object and/or third generation
language development tools
- Experience in one or more programming languages
- Experience in application design, latest design patters,
deployment and troubleshooting
- Experience with relational and hierarchical database
technologies
- Experience in the use of information retrieval packages
using query languages
- Experience with one or more communications protocols
- Experience in structured methodologies for the design,
development, implementation and maintenance of applications
- Experience eliciting and documenting information from
diverse business area stakeholders and subject matter experts
- Excellent analytical, problem-solving and decision-making
skills; verbal and written communication skills; interpersonal and negotiation
skills
- A team player with a track record for meeting deadlines
ETL Skills:
- Knowledge and experience in gathering requirements and
business process knowledge in order to transform the data in a way that’s
geared towards the needs of end users
- Knowledge and experience maintaining and improving already
existing processes.
- Knowledge and experience ensuring that the data architecture
is scalable and maintainable
- Knowledge and experience working with the business in
designing and delivering correct, high quality data
- Experience investigating data to identify potential issues
within ETL pipelines, notify end-users and propose adequate solutions
- Experience preparing detailed documentation for further
reference
Desirable Skills:
- Knowledge and experience with programming Internet-ready
applications
- Knowledge and experience in rapid application development
(RAD) methodologies
- Knowledge and understanding of Information Management
principles, concepts, policies and practices
- Experience with middleware and gateways
- Experience reviewing, analyzing, and modifying product
installation scripts including encoding, testing, debugging
- Ability to provide post-implementation support and resolve
any post-implementation technical issues
- Experience conducting design walkthrough sessions with
project team
- Knowledge and understanding of Accessibility for Ontarians
with Disability Act (AODA) and related regulations and standards
- Ability to provide user and system documentation as required
Requirements
Experience and Skill Set Requirements:
Must Haves:
- Extensive experience in gathering requirements and business
process knowledge in order to design correct and high-quality data
transformation.
Skill Set Requirements:
ETL
Development-Data Integration:
- Extensive
experience in gathering requirements and business process knowledge in order to
design correct and high-quality data transformation.
- Extensive
experience in design, development, and implementation with Azure Data Factory,
Databricks, including:
- Self-Hosted
Integration Runtime
- Data movement, ETL
pipelines
- Performance tuning
on large data volumes
- Complex data
transformations
- ADF Debugger to
validate data transformation.
- Azure Roles
- Experience with
Informatica, including:
- Workflow Manager
- Repository Manager
- Designer
- Workflow Monitor
- Experience with
developing solutions using Logic App and Function App
- Experience in rapid
application development (RAD) methodologies.
- Experience in
maintaining and improving existing ETL processes.
- Experience in
investigating data to identify potential issues within ETL pipelines.
- Experience with
Business Intelligence tools IBM Cognos and Microsoft PowerBI.
Azure
Technologies:
- Experience with
CI/CD (DevOps) pipelines and concepts, including:
- Azure Resource
Management
- GitHub Repo
- Source code version
control
- Branching, pull
requests, build, release, multiple parallel development repositories merge.
- Experience with
Azure DevOps, including:
- Azure Boards
- Azure Test Plans
- Azure Pipelines
- Azure Repos
- Azure Artefacts
Oracle PL/SQL
Development:
- Extensive
experience in designing and developing SQL Server Stored Procedure, Oracle
PL/SQL programs.
Database
Technologies:
- Experience with
Oracle, Microsoft SQL Server database and tools.
- Experience with
relational and hierarchical database technologies.
- Extensive knowledge
of Azure SQL DB and Synapse platforms, including:
- Performance tuning
on large data volume
Similar Jobs
Blockchain • eCommerce • Fintech • Payments • Software • Financial Services • Cryptocurrency
Lead and develop a remote team of Account Executives to drive revenue growth. Hire, train, coach AEs, manage KPIs, forecasting, and pipeline reviews. Build repeatable sales processes, use data to improve performance, collaborate cross-functionally, and incorporate customer feedback into product and strategy improvements.
Blockchain • eCommerce • Fintech • Payments • Software • Financial Services • Cryptocurrency
Advise on federal and state consumer and commercial lending law and bank partnership arrangements. Serve as subject-matter expert on Reg Z/Reg B, fair lending, and licensing; lead cross-functional regulatory issue resolution; counsel senior business, product, compliance, and bank partners; analyze regulatory changes and inform product development from concept through launch.
Blockchain • eCommerce • Fintech • Payments • Software • Financial Services • Cryptocurrency
Lead and own federal bank examinations for Block affiliates, serving as primary regulator contact. Manage exam cycles from First Day Letter through remediation, coordinate cross-functional responses, maintain institutional examination history, and build sustaining relationships with federal regulators to ensure examination readiness and regulatory compliance.
What you need to know about the Toronto Tech Scene
Although home to some of the biggest names in tech, including Google, Microsoft and Amazon, Toronto has established itself as one of the largest startup ecosystems in the world. And with over 2,000 startups — more than 30 percent of the country's total startups — Toronto continues to attract new businesses. Be it helping entrepreneurs manage their finances, simplifying business operations by automating payroll or assisting pharmaceutical companies in launching new drugs, the city's tech scene is just getting started.
