Job Title: SQL developer Location: Toronto, ON Duration: 12+ Months Key Responsibilities - Design, develop, and maintain stored procedures that support business reporting needs.
- Optimize queries and database operations to ensure performance and reliability.
- Collaborate with business to translate reporting requirements into data flows/ Queries
- Create, manage existing SSIS packages to support data extraction, transformation, and loading (ETL) processes.
- Ensure data quality, integrity, and security throughout the data flow process.
- Work closely with data engineering and data architects to understand and implement best practices for data integration.
- Troubleshoot and resolve issues related to job execution and data flow interruptions.
- Develop and maintain automated scripts and workflows to enhance batch job scheduling and maintenance.
- Maintain comprehensive documentation for all developed procedures, packages, and job scheduling processes.
- Ensure that all database solutions adhere to company policies, industry regulations, and security standards.
- Assist with audits and implement improvements based on audit findings.
Must Have - Proven experience in SQL development, including creating and optimizing stored procedures.
- Strong knowledge of SQL Server Integration Services (SSIS) for developing ETL packages.
- Familiarity with job scheduling and batch processing concepts.
- Proficiency in working with SQL Server and understanding of database design principles.
- Knowledge of UNIX-like operating systems and shell scripting skills.
- Ability to interpret business requirements and translate them into technical solutions.
- Strong problem-solving skills with a detail-oriented mindset.
- Bachelor’s/master’s degree in computer science, Information Technology, or a related field (or equivalent experience).
- Minimum 7-8 years of relevant experience in SQL development and database management.
Nice to have - Experience with additional data integration tools and technologies.
- Proficiency in writing and optimizing code in at least one programming languages like Python.
- Familiarity with agile development methodologies.
- Knowledge of data warehousing concepts and data modelling best practices.
Mindlance is an equal opportunity employer. We are committed to inclusive, equitable, barrier-free recruitment and selection processes, and work environment in accordance with the Accessibility for Ontarians with Disabilities Act (AODA). We will be happy to work with applicants requesting accommodation at any stage of the hiring process.