南京 [切换城市] 南京招聘南京计算机软件招聘南京高级软件工程师招聘

SSIS Data Engineer

高知特信息技术(上海)有限公司 Cognizant Technology Solutions

  • 公司规模:1000-5000人
  • 公司性质:外资(欧美)
  • 公司行业:计算机软件

职位信息

  • 发布日期:2019-07-14
  • 工作地点:上海-杨浦区
  • 招聘人数:若干人
  • 工作经验:3-4年经验
  • 学历要求:本科
  • 职位月薪:1.5-2.5万/月
  • 职位类别:高级软件工程师  软件工程师

职位描述

Role responsibilities:

  • Experience in creating complex stored procedures in SQL Server and User Define scalar Functions in SSIS packages and SQL scripts.

  •  Experience in Design and implement of Data Integration and ETL processes with SSIS packages to make data available for reporting purpose within a data warehouse.
  • SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.

  • Performance tuning of Stored Procedures and T-SQL Queries.
  •  Collaborate with other teams within the organization and be able to devise the technical solution as it relates to the business & technical requirements, Maintain documentation for all processes implemented
  •  Adhere to and suggest improvements to coding standards, best practices, and contribute to the improvement of these best practices

  •  Solid knowledge on Data Warehouse concept, like Star schema, snow flake schema, Data Vault2.0, Dimension and Fact Table, Cube and so on.

 

The following qualifications and technical skills will position you well for this role:

·         3 ~ 7 years (senior developer ) or 1 ~ 3 years (junior developer) of hands-on experiences on SSIS;

·         Solid knowledge on SQL language and database (e.g. SQL Server, Oracle & Teradata).

·         Strong understanding of data warehousing concepts (fact, dimension, data model, star schema etc.).

·          Familiarly with software development life cycle.

·          Capability on drafting the requirement/design document.

·          Professional team player with good communication skill.

·         Cognos/Tableau experience is plus

·         Knowledge on Python/Spark/Azure is plus.

·         Experience with performance and scalability tuning

·         Ability to influence and communicate effectively, both verbally and written, with team members and business stakeholders

·         Interest in and ability to quickly pick up new languages, technologies, and frameworks

·         Experience in Agile/Scrum application development


公司介绍

ABOUT COGNIZANT
Cognizant (NASDAQ-100: CTSH) is one of the world’s leading professional services companies, transforming clients’ business, operating and technology models for the digital era. Our unique industry-based, consultative approach helps clients envision, build and run more innovative and efficient businesses. Headquartered in the U.S., Cognizant is ranked 195 on the Fortune 500 and is consistently listed among the most admired companies in the world. Learn how Cognizant helps clients lead with digital or follow us @Cognizant.

高知特 —— Cognizant(NASDAQ-100:CTSH),是全球领先的信息技术专业服务公司,致力于帮助客户在数字时代打造新的商业模式、运营模式和技术模式。通过我们植根于不同行业、专业独到的咨询式服务,我们将帮助客户构想(Envision)和建造(Build)未来愿景,成就(Run)创新和高效的企业。高知特(Cognizant)总部位于美国,“财富” 美国500强企业中名列第195位,被评为全球最受赞赏的公司之一。欢迎访问公司主页了解更多有关高知特(Cognizant)的数字服务。

联系方式

  • Email:yiruo@google.com
  • 公司地址:前海深港创新中心a-2楼