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