Hi,

Hope you are doing well.

I have an immediate requirement. Please let me know if you are interested in this role, and share your updated resume

Role : BI ETL Sr Developer /Lead developer

Location: Remote (Canada)

Mode: Contract

Platform scope

Snowflake, Matillion ETL/ELT, Microsoft Azure data services, Microsoft SQL Server, Azure SQL, Azure Data Lake Storage, Azure Key Vault, Azure DevOps, secure file and API integrations, and enterprise reporting and analytics touchpoints. Additional technologies may include Power BI, Python, PowerShell, REST APIs, SFTP, event-driven integration, and metadata or data quality tooling.

QUALIFICATIONS:

Required Minimum Education and Industry Experience

• Bachelor's degree in Information Technology, Computer Science, Data Engineering, Information Systems, Engineering, or a related field; or an equivalent combination of education and experience.

• 7+ years of progressive experience developing and supporting enterprise ETL, ELT, data integration, data engineering, or data warehouse solutions.

• 3+ years of experience serving as a senior developer, technical lead, workstream lead, or primary technical owner for complex data integration delivery.

• Demonstrated hands-on experience with CI/CD pipelines (Azure DevOps), Snowflake, Matillion, Microsoft Azure, and Microsoft SQL Server in production enterprise environments.

• Experience leading solution design, code review, release coordination, production troubleshooting, and technical mentoring for data integration teams.

ESSENTIAL FUNCTIONS:

- Design, develop, test, deploy, and support complex ETL and ELT pipelines using Matillion, Snowflake, Azure services, and SQL Server.




- Serve as the technical lead for assigned data integration initiatives, translating business and technical requirements into scalable solution designs and delivery plans.
- Build reusable ingestion, transformation, orchestration, and publishing patterns for batch, micro-batch, near-real-time, file-based, API-based, and database-source workloads.
- Develop and optimize Snowflake solutions, including SQL transformations, schemas, tables, views, stages, file formats, streams, tasks, stored procedures, and secure data-sharing patterns as applicable.
- Develop and maintain Matillion jobs, components, variables, environments, orchestration workflows, error handling, scheduling, and operational controls.
- Implement Azure-based integration components using services such as Azure Data Lake Storage, Azure Key Vault, Azure Functions, Logic Apps, Azure Data Factory, and related platform capabilities where appropriate.
- Lead source-to-target mapping, data profiling, transformation rule definition, reconciliation design, and technical data lineage documentation.
- Apply data quality controls for completeness, accuracy, validity, timeliness with measurable validation and exception handling.
- Engineer restartable and supportable pipelines with logging, auditability, checkpoints, alerts, dependency management,



retry behavior, and recovery procedures.
- Optimize pipeline through query tuning and workload analysis.
- Implement secure data integration practices, including least-privilege access, secrets management, encryption, service account governance and masking.
- Create unit and reconciliation tests.
- Lead peer reviews of solution designs, SQL, Matillion jobs, deployment artifacts, and technical documentation to ensure quality, consistency, supportability, and standards compliance.
- Build and maintain CI/CD practices using Azure DevOps, including source control, branching, pull requests, automated deployment, setting-specific configuration, approvals, and rollback planning.
- Coordinate releases across development, test, user acceptance, and production environments, including readiness reviews and post-deployment validation.
- Troubleshoot failed or delayed pipelines, and upstream or downstream integration failures.
- Create and maintain technical specifications, diagrams, source-to-target mappings, runbooks, support procedures, deployment instructions, and knowledge articles.
- Provide estimates, identify dependencies and risks, break work into actionable deliverables, and communicate progress, blockers, decisions, and technical tradeoffs to delivery stakeholders.
- Collaborate with internal teams, managed service providers, and technology vendors to resolve issues, coordinate delivery, and promote effective knowledge transfer.
- Perform other duties as assigned.

Thanks,

Ravi Kumar

Raas Infotek

Newark, DE 19702

Direct No: (phone hidden)

Email: [email protected]

📌 Senior ETL Developer (Canada)
🏢 Raas Infotek
📍 Canada