RQ09427 - Software Developer - ETL - Senior

Cloud SynApps Inc.; Mississauga; On-site; CAD 80,000 - 120,000; Full time

Job summary

A fast-growing consulting firm seeks a Senior Software Developer who will design and maintain ETL processes using tools like Microsoft Azure. This role requires extensive experience with database management, cloud applications, and data integration, contributing to innovative solutions in a dynamic environment.

Qualifications

• Experience with ETL languages and development techniques.
• Understanding of data modeling and warehouse design.
• Strong communication skills for collaboration.

Responsibilities

• Design, implement, and expand data pipelines.
• Resolve technical problems during software use.
• Provide post-implementation support.

Skills

Collaboration

Analytical Skills

Problem-Solving

Communication

Tools

Azure Data Factory

Azure SQL Database

Power BI

Job description

RQ09427 - Software Developer - ETL - Senior

Cloud SynApps is a fast-growing consulting and systems integration firm focusing on cloud applications, primarily on Salesforce-based platforms. With major operations in Canada, the USA, and India, we have built a strong Salesforce practice and are expanding into various verticals such as Insurance and Telecom.

We are one of the largest system integrators for Vlocity (recently acquired by Salesforce) and Clariti Solutions (formerly BasicGov Applications), implementing solutions for municipal, provincial, state, and federal clients. Our team possesses deep industry expertise, guided by core values of transparency, respect, dignity, and integrity. We invest heavily in developing unique Salesforce-based solutions and accelerators tailored to our clients' needs.

Responsibilities :

• Design, implement, and expand data pipelines through extraction, transformation, and loading activities.
• Translate technical specifications into working, tested applications, including developing detailed programming specifications, coding, maintaining, and conducting unit tests.
• Resolve and troubleshoot technical problems during software use and operation, providing assistance in implementation, conversion, and migration processes.

General Skills :

• Experience in programming and analysis, supporting specialized software packages.
• Ability to collaborate with IT professionals throughout the Software Development Lifecycle.
• Experience in structured methodologies for application development, design, implementation, and maintenance.
• Proficiency in designing, coding, testing, debugging, and documenting applications.
• Experience with object-oriented and third-generation programming languages and tools.
• Knowledge of application design, patterns, deployment, and troubleshooting.
• Experience with relational and hierarchical database technologies.
• Experience with information retrieval packages and query languages.
• Knowledge of communication protocols.
• Ability to elicit and document information from stakeholders and subject matter experts.
• Excellent analytical, problem-solving, decision-making, verbal and written communication, interpersonal, and negotiation skills.
• Proven team player with a track record of meeting deadlines.

ETL Skills :

• Business process knowledge to transform data for end-user needs.
• Maintaining and improving existing processes.
• Ensuring scalable and maintainable data architecture.
• Designing and delivering high-quality, correct data.
• Investigating data issues within ETL pipelines and proposing solutions.
• Experience with programming internet-ready applications and rapid application development methodologies.
• Understanding of information management principles and policies.
• Experience with middleware and gateways.
• Reviewing, analyzing, and modifying product installation scripts.
• Providing post-implementation support.
• Conducting design walkthroughs with project teams.
• Knowledge of Accessibility for Ontarians with Disabilities Act (AODA) and related standards.
• Providing user and system documentation as required.

Skills and Requirements :

• Designing, developing, and maintaining database backends and ETL applications for Data Warehousing and Business Intelligence.
• Using ETL languages and development techniques to build application functionality with high-quality code.
• Ensuring application scalability and compliance with standards and best practices.
• Testing, debugging, and documenting applications.
• Clear and professional collaboration within development teams and with clients.

Mandatory Skills :

• Experience with Microsoft Azure Data Factory, Azure SQL Database, Azure Data Lake, and Power BI.
• Implementing and maintaining ETL schedules and dependency logic.
• Data integration, cleansing, and analytics experience.
• Data modeling and warehouse design principles.
• Database management and administration experience.
• Constructing complex SQL queries and performance tuning.
• Experience with Git and source control strategies.
• Creating technical documentation including mappings, diagrams, and architecture artifacts.
• Gathering and validating business requirements.
• Experience across the software development lifecycle.
• Strong communication skills for understanding and conveying instructions and requirements.

Nice-to-have Skills :

• Understanding of AODA regulations.
• Designing dashboards, KPIs, and reports.
• Programming languages such as C# and scripting languages like PowerShell.
• Experience with SaaS solutions deployment.

J-18808-Ljbffr

Create a job alert for this search

Senior Software Developer • Mississauga, Peel Region, Canada