Senior SSIS Developer

This is a remote position.

SeniorSSISDeveloper–JobDescription

Experience:7–9YearsPrimarySkill:SSIS(SQLServerIntegrationServices)Role:SeniorSSISDeveloper/TechnicalConsultant

KeyResponsibilities

• Design,develop,test,deploy,andmaintainSSISpackagesforenterpriseETLanddataintegration.

• DevelopETLsolutionstoextract,transform,andloaddatafrommultiplesourcesystems.

• SupportandenhanceexistingSSISinterfacesandintegrations.

• TroubleshootSSISpackagefailures,dataissues,andproductionincidents.

• DevelopandoptimizecomplexSQLqueries,storedprocedures,functions,views,anddatabaseobjects.

• IntegratedatafromSQLServer,Oracle,flatfiles,CSV/Excelfiles,andSFTPlocations.

• Implementerrorhandling,logging,auditing,notifications,andrestart/recoverymechanisms.

• ScheduleandmonitorSSISjobsusingSQLServerAgent.

• PerformSSISpackageandSQLqueryperformancetuningforhigh-volumedataprocessing.

• Conductimpactanalysis,effortestimation,codereviews,andtechnicaldocumentation.

• Supportdeploymentsacrossdevelopment,UAT,andproductionenvironments.

• ProvideL2/L3productionsupport,root-causeanalysis,andpermanentfixesforrecurringissues.

• Collaboratewithfunctionalteams,applicationteams,DBAs,andbusinessstakeholders.

• Mentorjuniordevelopersandprovidetechnicalguidancewhenrequired.

MandatoryTechnicalSkills

• 7–9yearsofoverallITexperiencewithstronghands-onexpertiseinSSISandSQLServer.

• StrongexperienceinETLdevelopment,dataintegration,anddatamigration.

• AdvancedknowledgeofT-SQLandMicrosoftSQLServer.

• Experiencewithstoredprocedures,functions,views,joins,indexing,queryoptimization,andperformancetuning.

• Hands-onexperiencewithSSIScomponents:

  • DataFlowTasksandControlFlowTasks

  • Lookup,Merge,andConditionalSplit

  • DerivedColumnandExecuteSQLTask

  • ScriptTaskandFileSystemTask

• KnowledgeofSSISconfigurations,parameters,variables,connectionmanagers,anddeploymentmodels.

• Experienceimplementinglogging,exceptionhandling,auditcontrols,andfailure/restartmechanisms.

• ExperiencewithSQLServerAgentjobsandscheduling.

• Strongtroubleshooting,root-causeanalysis,andproductionsupportexperience.

PreferredSkills

• SSISintegrationwithOracleandheterogeneousdatasources.

• SFTPandautomatedfile-basedintegrations.

• Git,AzureDevOps,orothersource-controlandCI/CDtools.

• ExposuretoAzureDataFactory(ADF).

• Agile/Scrumdeliveryexperience.

• KnowledgeofITILprocesses,includingIncident,Problem,andChangeManagement.

SoftSkills

• Stronganalyticalandproblem-solvingskills.

• Goodverbalandwrittencommunication.

• Abilitytoindependentlyresolvecomplextechnicalandproductionissues.

• Effectivecoordinationwithtechnical,functional,business,andclientteams.

• Strongownershipandaccountability.

Originally posted on Himalayas