Previous Job
Previous
SSIS Data Integration Architect
Ref No.: 18-00264
Location: Sunnyvale, California
Position Type:Contract
Title: SSIS Data Integration Architect
Location: Sunnyvale, CA
Type: Contract

Summary:
Data Integration lead with very good experience with SSIS , C#, VB (VB.net) and SQL Server Database. Also experience with Java and API development would be helpful. The integration Lead is responsible for the design, development, testing, and deployment of real-time and Batch integrations utilizing SSIS , C# , Java and open source tech stack. Nice to have experience with Microsoft Tech stack and UI development skill set.  The candidate will be working independently from requirements gathering, interface design, development, testing and go-live in accordance with client's SDLC process.

Responsibilities:
  • To work on development and implementation of Data Warehouse applications.
  • Extract, Transform and Load (ETL) using SSIS and various tools including Bulk insert, BCP, Import Export data, DTS packages and SQL Server Integration Analyzed.
  • To design and develop various Data Warehousing and Data Migrations project.
  • To work on Data modeling (Dimensional & Relational) like Star-Schema Modeling, and fact and dimension tables in SSAS.
  • Create Cubes/ Dimensions, deploying, processing Cubes using SQL Server Analysis Services (SSAS).
  • To build Data Integration, Workflow Solutions and Extract, Transform and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS).
  • Provide appropriate solutions based on the requirements and client the integrating systems
  • Create Architecture and Integration Design documents for real-time integrations
  • Build integration incorporating best practices and client integration standards
  • Document and resolve defects
  • Create test plans and execute unit/component, integrated, and end-to-end testing
Skills, Knowledge and Abilities:
  • 11+  years of professional experience in SQL development skills including writing Stored Procedures, Triggers, Views & User Defined functions.
  • Hands-on experience in development and implementation of Data Warehouse applications. Also hands on experience with C#
  • Experience working with MSBI (SSIS, SSAS and SSRS) and T-SQL using SQL Server 2014/2012/2008R2/2005
  • Experience in creating, maintaining and tuning Views, Stored Procedures, Functions and Triggers and strong RDBMS concepts using T-SQL (DDL, DML and DCL).
  • Expertise in Extract, Transform and Load (ETL) using SSIS and various tools including Bulk insert, BCP, Import Export data, DTS packages and SQL Server Integration Analyzed, designed and developed for a Data Warehousing and Data Migrations.
  • Experience in Data modeling (Dimensional & Relational) like Star-Schema Modeling, and fact and dimension tables in SSAS.
  • Some exposure to AWS
  • Knowledge in query optimization & performance tuning, Using SQL Server Profiler, Execution Plan, Performance Monitor, DMVs and DBCC Commands
  • Experience in SSIS projects with sound knowledge on the features such as Error logging, Checkpoints, Auditing
Preferred:
  • Good knowledge in Security concepts.
  • Experience with servers/runtime (IIS, weblogic, Tomcat, Jetty, Node.js etc)
  • Expertise in common protocols and technologies such as XML, SOAP, REST, XSLT, HTTP, XQuery
  • Development of JAVA web services / Integrations 
  • Excellent oral and written communication skills
  • High degree of understanding of Relational Database concepts