ROLE : SQL SSIS Developer
Type : Hybrid Halifax, Nova Scotia area (3 days onsite) ( LOCAL CANDIDATES ONLY - NO RELOCATION)
Must have valid work Visa in Canada can work on T4
Skills
- SQL Developer
- SSIS
- Cloud / Azure experience
- Banking / Finance domain
- PowerShell, Git , python etc.
Job Description :
We are seeking a skilled SQL Developer with expertise in SSIS (SQL Server Integration Services) to join our dynamic team. The ideal candidate will have strong experience in designing, developing, and maintaining database systems and ETL solutions to support our business needs. You will work closely with cross-functional teams, including data analysts, developers, and business stakeholders, to ensure the integrity, performance, and scalability of our database systems.
Key Responsibilities :
Design, develop, and maintain SQL databases to meet application and reporting requirements.Create, implement, and optimize SSIS packages for data integration, transformation, and migration.Develop complex T-SQL queries, stored procedures, views, and triggers to support application functionality.Required Skills and Qualifications :
Proven experience as an SQL Developer , with a focus on database development and management.Strong proficiency in T-SQL (Transact-SQL) for writing complex queries and scripts.Hands-on experience developing and deploying SSIS packages for data integration and transformation.In-depth understanding of relational database design principles and data normalization.Familiarity with SQL Server performance tuning , indexing, and optimization techniques.Experience with data integration between multiple systems using SSIS and other ETL tools.Strong analytical and problem-solving skills with attention to detail.Knowledge of data warehousing concepts and experience with OLAP / OLTP systems is a plus.Excellent communication and teamwork skills, with the ability to work effectively in a collaborative environment.PLUS :
Experience with SSRS (SQL Server Reporting Services) or other reporting tools.Familiarity with cloud-based database platforms such as Azure SQL Database or AWS RDS .Exposure to scripting languages like PowerShell , Python, or C#.Knowledge of version control tools like Git for managing database scripts and changes.Certification in Microsoft SQL Server or related technologies is a plus