Senior SSIS Developer
职位：高级 SSIS 开发人员工作描述经验：79年初级技能：SSIS（SQL 服务器集成服务）角色：高级 SSis 开发者/技术顾问关键责任 ·设计，发展，测试，部署和维护 SSIS 包用于企业 ETLand 数据集成。·开发解决方案以从多个系统中提取，转换和加载数据。·支持现有 ISIS 界面和集成。•纠纷 SSSIS 包错误，数据库，生产等问题。·开发和完善 SQL 问题，事件，功能，视图，数据库和数据库.Vatma,CSTP 文件，软件，文件，文件，信息和位置。·执行 SSIS 包和 SQL 查询，并为高量处理提供性能调整。·进行数据分析，努力估计，代码审查和技术文档。·支持跨开发，UAT 和生产环境的部署。·提供 L2/L3产品支持，根源原因分析和常规问题报告。·与 SSLS 团队，应用程序管理者，DBAs 和利益相关者合作。·辅导员及技术人员提供技术培训。•具有7年经验；·ETL 开发，数据集成和数据迁移的强大经验。·T-SQL 和 MicrosoftSQLServer 的先进知识。·SystemSystems 程序，功能，观点，加入，索引，查询优化和性能调整的经验。•SSIS 组件的实践经验：·DataFlow 任务与控制流程任务·搜索，并和条件问题 Split ·衍生列表和执行 SQLT ·Script 问题和文件系统 T ·SSIS 配置，参数，变量，连接管理者和部署模型的经验；·SMSU 实现，处理，控制，失败/复制工作。·Audit 服务器和机关操作。·强大的问题解决，根源分析和产品支持经验。优先技能·SSIS 与 Oracle 和异质数据来源的集成。·SFTP 自动基于文件的集成；·Git,AzureDevOps 或其他资源控制和 CI/CD 工具。·接触 AzureDataFactory (ADF). ·敏捷/化交付经验。·ITIL 流程知识，包括事件，问题和变更管理。软技能 ·战略和解决问题的技能。·好语言和书面通信。
查看英文原文
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