Senior SSIS Developer at Elfonze Technologies

Senior SSIS Developer at Elfonze TechnologiesElfonze Technologies

Workplace: Remote

This is a remote position.SeniorSSISDeveloper–JobDescriptionExperience:7–9YearsPrimarySkill:SSIS(SQLServerIntegrationServices)Role:SeniorSSISDeveloper/TechnicalConsultantKeyResponsibilities 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,andproductionsupport…Sign in to see the original postingBrowse more developer jobs on RoleBurst