Loading job…
Senior SSIS Developer at Elfonze Technologies · web2uaApply on the original site
Companies in this catalog do not charge applicants. Never send money to apply.
- 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.MandatoryTechnicalSkills7–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