JD of Senior Developer(.net, ETL)

POSITION:    Senior Developer (.net, ETL)

LOCATION:    Shanghai/Nanjing, China

JOB TYPE:     Senior Software Engineer

COMPANY:     A global data-driven, technology-enabled performance marketing agency

 

Position Summary:

The Senior Developer candidate must be a dynamic contributor, passionate about software development and committed to making a difference in an organization filled with smart, creative people. The incumbent will be part of a team responsible for the development and support of various SaaS (Software as a Service) integration solutions (Salesforce, Workday, Concur), traditional back-office systems (HRIS, Finance, etc.), and strategic data warehouses and reporting tools. We seek a candidate experienced in SSIS-based data transformations, query / database optimization and consuming web services in .NET applications. Candidate must be technically proficient and possess good interpersonal, troubleshooting, and documentation skills. Must be comfortable working in a small team setting and possess an unrelenting focus on quality and scalability.

Position Responsibilities:

  • Review Business Requirements to identify ETL requirements and design, develop and test complex SSIS solutions
  • Create stored procedures, triggers and views
  • Monitor and optimize database objects and SQL Server databases (2008 R2, 2014, 2016) using industry-standard tools and practices (SQL Profiler, Analyzer, Query Plans)
  • Reverse engineer and understand complex integrations
  • Design and develop .NET applications to consume web services from our cloud systems
  • Develop and maintain data mappings between source and destination data stores
  • Document project specific processes and data flows, data dependencies, data definitions and relevant business rules. Establish data dictionaries to support the buildout of a data governance infrastructure
  • Must demonstrate strong problem solving ability, logic and analytical skills
  • Participate in data modeling initiatives
  • Perform quality assurance and testing at the unit level
  • Ability to manage multiple projects in a fast paced environment
  • Ability to work independently and collaborative with other team members
  • Troubleshoots production issues, identifying root cause and implementing sound technical resolutions in a timely manner

QUALIFICATIONS:

 

  • 3+ years experience as a ETL Developer
  • Hands on experience with SQL Server SSIS and ETL processes
  • Experience in consuming REST and SOAP web services using Microsoft .NET
  • Familiarity with designing and implementing ETL in large databases and data warehouses utilizing both relational and dimensional design concepts
  • Familiarity with agile development techniques and objectives
  • Demonstrable development skills – packages, triggers, views, queries, etc.
  • Experience in other ETL tools is a plus
  • Experience in SSAS and SSRS is a plus
  • Degree in a technical field or commensurate experience
  |  10 years working experience in IT practice executive search industry, strong in business development, execution and team management. Focus on Software, Internet and IT Services sector. Filled positions in field like R&D, IT Sales and function position like HR, Finance, Marketing etc.  |  more
              
A Leader in Technology Recruitment
Geeker QR Code
Geeker Consulting Blog in Chinese   Geeker Consulting on LinkedIn   Following Geeker Consulting on Facebook   Geeker Consulting on Google Plus  
Work in Beijing
Work in Shanghai
Work in Guangzhou
Work in Nanjing
Work in Hangzhou
Work in Shenzhen