Job Description :

Job Title: SSIS Developer/ETL
Location: Pleasanton, CA, United States


Job Description:

  • Design, develop, and support complex integration processes/ SSIS Processes (including interfaces) using SQL Server technology, stored procedures and SQL program code
  • Must be able connect to API and AWS storage locations/API endpoints using ZappySys plugin
  • Consult with the business to determine alignment of ETL with business requirements
  • Participate code reviews, analyze execution plans, and re-factor inefficient code Follow data standards, resolve data issues, complete unit testing and system documentation for ETL processes Define and capture metadata and rules associated with ETL processes Provide support and fix issues in the packages Translate business requirements into technical designs to map and load data from source systems to data warehouses, downstream applications, and trading partners.
  • Should be willing to do Quality Assurance testing for SSIS packages and requirements

Must have skills SSIS Development

  • ZappySys
  • SQL Development
  • ETL Process/ Framework
  • CRUD operations on APIs (SOAP, REST and OData APIs)
  • API security and different kinds of authentication
             

Similar Jobs you may be interested in ..