OnsiteWorkRequirement: Thesuccessfulcandidateisexpectedtoworkonsitefivedaysperweek,for7.25hourspercalendarday,betweenthestandardworkinghoursof8:00AMto5:00PM(excludinglunchbreaks),MondaytoFridayinclusive,attheidentifiedOPSofficelocation.
Responsibilities:
Design,implement,andcontinuouslyexpanddatapipelinesbyperformingextraction,transformation,andloadingactivities.
Requiredtotranslatetechnicalsystemsspecificationsintoworkingtestedapplications.
Thisincludesdevelopingdetailedprogrammingspecifications,writingand/orgeneratingcode,compilingdata-drivenprograms,maintaining,andconductingunittests.Resolvesandtroubleshootstechnicalproblemswhichariseduringtheuseandoperationofsoftwarepackages,includingtechnicalassistanceinimplementation,conversionandmigrations.GeneralSkills:Experienceinprogrammingandanalysis;specializedsoftwarepackagesupportatthespecifiedexperiencelevelAbilitytocollaboratewithITProfessionalsthroughouttheSoftwareDevelopmentLifeCycleExperienceinstructuredmethodologiesforthedevelopment,design,implementationandmaintenanceofapplicationsExperienceindesign,code,test,debuganddocumentapplicationsExperienceintheuseofobjectand/orthirdgenerationlanguagedevelopmenttoolsExperienceinoneormoreprogramminglanguagesExperienceinapplicationdesign,latestdesignpatters,deploymentandtroubleshootingExperiencewithrelationalandhierarchicaldatabasetechnologiesExperienceintheuseofinformationretrievalpackagesusingquerylanguagesExperiencewithoneormorecommunicationsprotocolsExperienceinstructuredmethodologiesforthedesign,development,implementationandmaintenanceofapplicationsExperienceelicitinganddocumentinginformationfromdiversebusinessareastakeholdersandsubjectmatterexpertsExcellentanalytical,problem-solvinganddecision-makingskills;verbalandwrittencommunicationskills;interpersonalandnegotiationskillsAteamplayerwithatrackrecordformeetingdeadlinesETLSkillsKnowledgeandexperienceingatheringrequirementsandbusinessprocessknowledgeinordertotransformthedatainawaythat?sgearedtowardstheneedsofendusersKnowledgeandexperiencemaintainingandimprovingalreadyexistingprocesses.KnowledgeandexperienceensuringthatthedataarchitectureisscalableandmaintainableKnowledgeandexperienceworkingwiththebusinessindesigninganddeliveringcorrect,highqualitydataExperienceinvestigatingdatatoidentifypotentialissueswithinETLpipelines,notifyend-usersandproposeadequatesolutionsExperiencepreparingdetaileddocumentationforfurtherreference.




DesirableSkills :KnowledgeandexperiencewithprogrammingInternet-readyapplicationsKnowledgeandexperienceinrapidapplicationdevelopment(RAD)methodologiesKnowledgeandunderstandingofInformationManagementprinciples,concepts,policiesandpracticesExperiencewithmiddlewareandgatewaysExperiencereviewing,analyzing,andmodifyingproductinstallationscriptsincludingencoding,testing,debuggingAbilitytoprovidepost-implementationsupportandresolveanypost-implementationtechnicalissuesExperienceconductingdesignwalkthroughsessionswithprojectteamKnowledgeandunderstandingofAccessibilityfor OntarianswithDisabilityAct(AODA)andrelatedregulationsandstandardsAbilitytoprovideuserandsystemdocumentationasrequired
Experience Requirements OnsiteWorkRequirement: Thesuccessfulcandidateisexpectedtoworkonsitefivedaysperweek,for7.25hourspercalendarday,betweenthestandardworkinghoursof8:00AMto5:00PM(excludinglunchbreaks),MondaytoFridayinclusive,attheidentifiedOPSofficelocation.
Responsibilities/AssignmentDeliverables – SeniorETLDeveloper
Designs,develops,andmaintainsdatabasebackendandETLapplicationsforDataWarehouseandBusinessIntelligencesolutions.
UsesknowledgeofETLlanguagesanddevelopmenttechniquestobuildandexpandapplicationfunctionalitybywritinghighqualitycodeusingappropriatepatterns.Ensuresapplicationsremainsscalablewhilecomplyingtostandardsandfollowingbestpractices.
Testsanddebugsapplicationsandensuresthatsoftwareisproperlydocumented.Collaboratesclearlyandprofessionallyaspartofadevelopmentteamandcommunicateswithclients.
MandatorySkills ExperiencewiththeMicrosoftsuiteoftechnologyincluding:AzureDataFactory,AzureSQLDatabase,AzureDataLake,andPowerBI
ExperiencewithDatabricksPlatform
ExperiencewiththeAmazonWebServices(AWS)suiteoftechnologyincluding:AmazonAurora,AmazonRelationalDatabaseSearch,Glue,OpenSearch,etc.
Experiencewithdevelopingdataextraction,transformation,andloadprograms(dailyandinitialload)functionalityonawiderangeofdatarepositories(structuredandsemi-structuredfiles,relationalandmulti-dimensionaldatastores)
Experiencewithdeveloping,implementing,andmaintainingschedule/dependencylogicforExtractTransformLoad(ETL)scripts
Experiencewithdataintegration,datacleansing,anddataanalytics
Experiencewithdatamodelinganddesignprinciplesfordatamartsanddatawarehouses
Experienceindatabasemanagementandadministration
ExperienceinconstructingcomplexSQLqueriesandperformancetuning
ExperiencewithGitandknowledgeofsourcecontrolstrategies
ExperiencecreatingtechnicaldocumentationincludingETLsource-to-targetmappings,datamodeldiagrams,architectureartifacts,detaileddesigndocuments,etc.
Experienceineliciting,documenting,andvalidatingbusinessrequirements




ExperienceinsoftwaredevelopmentlifecyclefromDevelopment,toTestingand QualityAssurance,toDelivery
Solidcommunicationsskills:theabilitytounderstand,comprehend,andfollowinstructionsandrequirementstocommunicateclearlyandeffectivelybothverballyandinwriting.
Nicetohaveskills KnowledgeandunderstandingofAccessibilityfor OntarianswithDisabilityAct(AODA)andrelatedregulationsandstandards
ExperiencedesigningvisualdashboardstohighlighttrendsandKeyPerformanceIndicators(KPIs),anddevelopingcannedreports(scheduledandad-hoc)
ExperiencewithprogramminglanguagessuchasC#,developingapplicationcodesuchasAPIs,Functions,etc.
ExperiencewritingscriptswithPowerShellandotherscriptinglanguages
SoftwareDeveloper–Senior–EvaluationCriteria CoreTechnicalSkills (50%)
ExperiencewiththeMicrosoftsuiteoftechnologyincluding:AzureDataFactory,AzureSQLDatabase,AzureDataLake,andPowerBI
ExperiencewiththeAmazonWebServices(AWS)suiteoftechnologyincluding:AmazonAurora,AmazonRelationalDatabaseSearch,Glue,OpenSearch,etc.
Experiencewithdevelopingdataextraction,transformation,andloadprograms(dailyandinitialload)functionalityonawiderangeofdatarepositories(structuredandsemi-structuredfiles,relationalandmulti-dimensionaldatastores)
Experiencewithdeveloping,implementing,andmaintainingschedule/dependencylogicforExtractTransformLoad(ETL)scripts
Experiencewithdataintegration,datacleansing,anddataanalytics
Experiencewithdatamodelinganddesignprinciplesfordatamartsanddatawarehouses
Experienceindatabasemanagementandadministration
ExperienceinconstructingcomplexSQLqueriesandperformancetuning
ExperiencecreatingtechnicaldocumentationincludingETLsource-to-targetmappings,datamodeldiagrams,architectureartifacts,detaileddesigndocuments,etc.
OtherTechnicalSkills (35%)
ExperiencedesigningvisualdashboardstohighlighttrendsandKeyPerformanceIndicators(KPIs),anddevelopingcannedreports(scheduledandad-hoc)
ExperiencewithprogramminglanguagessuchasC#,developingapplicationcodesuchasAPIs,Functions,etc.
ExperiencewritingscriptswithPowerShellandotherscriptinglanguages
ExperiencewithGitandknowledgeofsourcecontrolstrategies
ExperienceinsoftwaredevelopmentlifecyclefromDevelopment,toTestingand QualityAssurance,toDelivery
CommunicationsSkills (10%)
Experienceineliciting,documenting,andvalidatingbusinessrequirements
Solidcommunicationsskills:theabilitytounderstand,comprehend,andfollowinstructionsandrequirementstocommunicateclearlyandeffectivelybothverballyandinwriting.
StandardsandBestPractices (5%)
KnowledgeandunderstandingofAccessibilityfor OntarianswithDisabilityAct(AODA)andrelatedregulationsandstandards
Supplier Comments Closing Date/Time: 2026-10-14, 12:00 p.m.
Max submission: 1 (one)
5 days onsite
Please refer to Requirements and Skills in description

#J-18808-Ljbffr

📌 Software Developer – ETLCentral Agencies Cluster (Ontario)
🏢 Softline Technology
📍 Ontario