SQL Server Integration Services (SSIS)
SereneAid
- Fredericton, NB
- Permanent
- Part-time
Client: Service New Brunswick (SNB), Government of New Brunswick
Position Overview
As an SSIS Developer, the resource will support the ERP Business Transformation Project, focused on enabling data-driven decision-making across Human Resources, Financial Management, and Procurement domains. The role involves designing and implementing robust data migration (ETL) solutions using SQL Server Integration Services (SSIS) while collaborating with cross-functional and multi-vendor teams including internal SMEs and implementation partners.Requirements Mandatory Requirements (M1–M5)
M1 – Education
The candidate holds a Bachelor’s degree in Computer Science, supplemented with certifications in data engineering and Microsoft SQL technologies. Equivalent hands-on experience across enterprise-level government and private sector projects further strengthens qualifications.
M2 – IM/IT Experience (7+ Years)
Senior IT professional with 8+ years of experience in data engineering, database development, and enterprise data migration projects.
Example Engagements:
- Government Sector Client (Jan 2021 – Present | 5+ years)
- Worked on large-scale ERP data migration initiatives
- Delivered high-performance ETL pipelines
- Improved data processing efficiency by 35%
- Financial Services Organization (Jun 2017 – Dec 2020 | 3.5 years)
- Developed complex data integration workflows
- Supported regulatory reporting systems
Extensive experience in Extract, Transform, Load (ETL) processes:
- Designed ETL pipelines migrating legacy data into modern ERP systems
- Performed data cleansing, validation, and transformation
- Ensured data integrity across multiple source systems
- Delivered secure and scalable migration solutions aligned with enterprise standards
- Strong verbal and written communication skills
- Experience working with:
- Business stakeholders
- Technical architects
- Cross-functional teams
- Regular participation in:
- Design discussions
- Defect triage meetings
- Status reporting
- Resume structured within 5-page limit
- Focused on:
- Scored Requirements
- Deliverables (ETL, SSIS, ERP support)
- Clearly mapped experience to requirements
S1 – SSIS Design, Development, Testing & Deployment (5+ Years)
Experience Summary:
- 6+ years hands-on experience in SSIS package lifecycle
- Designed and deployed 100+ SSIS packages for HR, Finance, Procurement data
- Built reusable ETL frameworks
- Implemented logging, error handling, and performance tuning
- Managed large datasets (>10M records)
- Reduced data load time by 40%
- Ensured high data accuracy and audit compliance
Experience Summary:
- Advanced SQL expertise (T-SQL, stored procedures, views)
- Developed complex queries for reporting and analytics
- Optimized query performance (reduced execution time by 50%)
- Designed data models and indexing strategies
Experience Summary:
- 5+ years working across multiple methodologies
- Participated in sprint planning, stand-ups, retrospectives
- Delivered incremental ETL components
- Adapted to hybrid Agile-Waterfall environments
Experience Summary:
- Proven ability to manage multiple priorities under tight deadlines
- Worked across concurrent data migration streams
- Coordinated with business and technical teams
- Delivered milestones within strict timelines
- Maintained 100% on-time delivery across releases
Experience Summary:
- Strong alignment with enterprise development standards
- Followed coding, version control, and deployment standards
- Introduced automation for ETL validation
- Suggested improvements to data quality processes
- Improved team efficiency through standardized SSIS templates
Experience Summary:
- Extensive collaboration with external vendors and partners
- Worked alongside vendors (e.g., system integrators, consultants)
- Coordinated integration activities across teams
- Ensured alignment between business requirements and technical delivery
- Liaison between internal teams and vendors
- Participate in joint design sessions
- Support integration testing and deployment
- Analyze technical and functional requirements to implement business logic
- Design, develop, and maintain SSIS packages for ETL processes
- Support data migration, cleansing, and transformation activities
- Develop and maintain data repositories and views
- Collaborate with architects, SMEs, and vendors
- Participate in defect triage and troubleshooting
- Ensure adherence to development standards and guiding principles
- Contribute to continuous improvement and process optimization
- Support ERP implementation and data strategy execution
This candidate brings:
- Strong technical expertise in SSIS & SQL
- Proven success in large-scale ERP data migration projects
- Ability to thrive in complex, multi-vendor government environments
- A track record of delivering high-quality, scalable data solutions