Closed listing
SR Database developer( Azure and SSIS)
- Halifax, NS, Canada
The annual salary for this position is between $90,000 - $110,000 depending on experience and other qualifications of the successful candidate. · Full-time
This opening has closed.
The original listing is kept below for reference.
Job details
- Pay
- The annual salary for this position is between $90,000 - $110,000 depending on experience and other qualifications of the successful candidate.
- Job type
- Full-time
- Closing date
- Experience
- 10+ years of experience in SQL Server development and ETL solutions.
- Posting language
- English
- Posted
Similar jobs hiring now
Search current openingsOriginal job description
Archived listing. The details below describe a past opening.
Roles And Responsibilities
We are seeking an experienced Senior SQL Server / SSIS ETL Developer with expertise in designing, developing, and supporting enterprise data warehouse and business intelligence solutions. The ideal candidate will have strong hands-on experience with SQL Server, SSIS, T-SQL, ETL development, data warehousing, and performance optimization. The role requires collaboration with business stakeholders, analysts, and global development teams to deliver scalable and reliable data integration solutions.
Required Experience
- 10+ years of experience in SQL Server development and ETL solutions.
- Strong experience with SQL Server Integration Services (SSIS) and T-SQL development.
- Experience working in Banking, Financial Services, Healthcare, or other enterprise environments.
- Experience across the full Software Development Life Cycle (SDLC).
- Design, develop, enhance, and maintain ETL solutions using SQL Server Integration Services (SSIS).
- Build and support enterprise data warehouse solutions by integrating data from multiple source systems.
- Develop and optimize complex T-SQL queries, stored procedures, views, functions, and data transformation logic.
- Create reliable and scalable batch processing solutions to support business reporting and analytics requirements.
- Perform data extraction, transformation, and loading (ETL) activities while ensuring data quality and integrity.
- Monitor, schedule, and troubleshoot ETL jobs using SQL Server Agent.
- Analyze business requirements and translate them into technical ETL and database solutions.
- Participate in data modeling, ETL design, development, testing, deployment, and production support activities.
- Perform query tuning, index optimization, and SSIS package performance enhancements to improve data processing efficiency.
- Manage source code versioning, deployments, and release activities using TFS/Git.
- Investigate production incidents, perform root cause analysis, and implement permanent solutions to improve system stability.
- Collaborate with cross-functional teams, business users, and offshore/onshore stakeholders to deliver high-quality solutions.
- Prepare technical documentation, deployment guides, and support documents.
Database Technologies
- Microsoft SQL Server 2008/2012/2016/2019
- T-SQL
- Stored Procedures, Functions, Views, Triggers
- Dynamic SQL
- SQL Server Integration Services (SSIS)
- SQL Server Reporting Services (SSRS)
- Data Warehousing Concepts
- ETL Design and Development
- Power BI
- Dashboard and Report Development
- Data Modeling
- SQL Server Management Studio (SSMS)
- Team Foundation Server (TFS)
- Git
- Azure Portal
- SQL Server Agent
- ServiceNow
- Confluence
- Grafana
- Prometheus
- AZ-900 Azure Fundamentals Certification.
- Experience with cloud-based data solutions and Azure services.
- Strong analytical and problem-solving skills.
- Excellent communication and stakeholder management skills.
- Experience working with geographically distributed teams.
Application Accepted: 10/5/2026
The annual salary for this position is between $90,000 - $110,000 depending on experience and other qualifications of the successful candidate.
This position is also eligible for Cognizant’s discretionary annual incentive program, based on performance and subject to the terms of Cognizant’s applicable plans.
Benefits: Cognizant offers the following benefits for this position, subject to applicable eligibility requirements:
- Extended Group Health Plan through Manulife
- Prescription drug coverage
- Virtual healthcare through TELUS Health Virtual Care
- TELUS Virtual Pharmacy
- Mental health and counseling services
- Employee Assistance Program (EAP)
- Mental Health Ally Program
- Life Insurance
- Accidental Death & Dismemberment (AD&D) Insurance
- Leave of Absence and Disability support programs
- Wellbeing resources, events, and champion networks
- Group Registered Pension Plan (RPP) for associates on Canada payroll
- Employer matching contributions under the RPP (subject to plan terms)
- Group Registered Retirement Savings Plan (RRSP)
- Competitive group investment rates through Manulife
Our strength is built on our ability to work together. Our diverse backgrounds offer different perspectives and new ways of thinking. It encourages lively discussions, creativity, productivity, and helps us build better solutions for our clients. We want someone who thrives in this setting and is inspired to craft meaningful solutions through true collaboration.
If you are content with ambiguity, excited by change, and excel through autonomy, we’d love to hear from you!
#CB#Ind123
More about this job
Responsibilities
Design, develop, and support SSIS ETL solutions and enterprise data warehouses, integrating data from multiple sources for reporting and analytics. Optimize SQL queries and ETL performance, manage deployments and production incidents, and collaborate with business stakeholders and distributed teams.
Requirements
Requires 10+ years of SQL Server development and ETL experience, including strong hands-on SSIS and T-SQL skills, enterprise environment experience, and familiarity with the full SDLC. Preferred qualifications include Azure experience or AZ-900 certification, strong analytical and communication skills, and experience with distributed teams.
Skills
- SQL Server
- SSIS
- T-SQL
- ETL Development
- Data Warehousing
- SSRS
- Power BI
- Data Modeling
- Query Optimization
- Performance Tuning
- Azure
- SQL Server Agent
- Git
- TFS
- Production Support
- Data Integration
Benefits
- Extended Group Health Plan
- Prescription Drug Coverage
- Virtual Healthcare
- Virtual Pharmacy
- Mental Health and Counseling Services
- Employee Assistance Program
- Mental Health Ally Program
- Life Insurance
- Accidental Death and Dismemberment Insurance
- Leave of Absence and Disability Support
- Wellbeing Resources
- Group Registered Pension Plan
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Data & Analytics
- Software
- Consulting
Keywords
- Microsoft SQL Server
- SQL Server 2008
- SQL Server 2012
- SQL Server 2016
- SQL Server 2019
- T-SQL
- Stored Procedures
- Functions
- Views
- Triggers
- Dynamic SQL
- SSIS
- SSRS
- ETL
- Data Warehousing
- Business Intelligence
- Power BI
- Data Modeling
- Azure
- AZ-900
- SQL Server Management Studio
- SQL Server Agent
- TFS
- Git
- ServiceNow
- Confluence
- Grafana
- Prometheus
- SDLC
- Banking