Software Developer – ETL (RQ11713) Central Agencies Cluster

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