First seen by Alion on Oct 19, 2026.
Experience:7–9YearsPrimarySkill:SSIS(SQLServerIntegrationServices)Role:SeniorSSISDeveloper/TechnicalConsultant
KeyResponsibilitiesDesign,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.
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.
SSISintegrationwithOracleandheterogeneousdatasources.
- SFTPandautomatedfile-basedintegrations.
Git,AzureDevOps,orothersource-controlandCI/CDtools.
- ExposuretoAzureDataFactory(ADF).
- Agile/Scrumdeliveryexperience.
KnowledgeofITILprocesses,includingIncident,Problem,andChangeManagement.
Stronganalyticalandproblem-solvingskills.
- Goodverbalandwrittencommunication.
Abilitytoindependentlyresolvecomplextechnicalandproductionissues.
Effectivecoordinationwithtechnical,functional,business,andclientteams.
- Strongownershipandaccountability.
Originally posted on Himalayas

