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:, 12:00 p.M. Max submission: 1 (one) 5 days onsite Please refer to Requirements and Skills in description #J-18808-Ljbffr

📌 Software Developer – Etl (Rq11713) Central Agencies Cluster (Toronto)
🏢 Softline Technology
📍 Toronto