Senior SSIS Integration Consultant

About Us

At Thoucentric, we offer end -to -end consulting solutions
designed to address the most pressing business challenges across
industries. We are headquartered in Bangalore with presence across multiple
locations in India, US, UK, Singapore & Australia Globally.

We have been certified as "Great Place to
Work" by AIM and have been ranked as "50 Best Firms for Data
Scientists to Work For".

We help clients with Business Consulting, Program &
Project Management, Digital Transformation, Product Management, Process &
Technology Solutioning and Execution including Analytics & Emerging Tech
areas cutting across functional areas such as Supply Chain, Finance & HR,
Sales & Distribution across US, UK, Singapore and Australia. We have an
experienced consulting team of over 500+ world -class business and technology
consultants based across six global locations. We have also built point
solutions and products through Thoucentric labs using AI/ML in the supply chain
space.

Role:

SSIS Consultant

Roles
& Responsibilities:

Job Description:

​

• Build
  data crawlers to extract data from customers' data sources using available
  ETL platforms, and troubleshoot the issues faced during data loading &
  processing
  
• Design
  and build data warehouse models in columnar databases
  
• Develop
  data processing scripts using SQL and be able to optimize complex
  sequences of SQL Queries
  
• Design,
  build and deploy effective SSIS packages to validate, synthesize,
  transform customer data for integrated business planning and analytics
  
• Work
  with Solution Architects to understand customers' business requirements
  and implement them
  
• Perform
  data analysis for complex use cases using SQL document technical
  specification for
  
• the
  cognitive applications that we are creating for the customers
  
• Own
  the entire development and implementation workflow
  
• Participate
  in the technical design, data requirements gathering and making
  recommendations on best practices, in case of inaccurate or missing data
  
• Design
  and automate the data loading and insights generation process with
  intelligent checks and balances for sustained value delivery. Create and
  execute test plans, document issues and track progress at resolving
  issues.
  

Requirements

Mandatory Skills:

·       O9 is Manadatory

• Very
  strong hands -on experience working in ETL (Extract/Transform/Load)
  processes
  
• Proficiency
  in databases (SQL Server, MySQL) and skills in one or more languages like
  SQL, MDX, T -SQL with knowledge of DDL, DML, stored procedures, triggers
  and performance tuning is a MUST
  
• Familiarity
  with workflows in programming concepts
  
• Experience
  using columnar databases
  
• Experience
  working directly with customers and presenting your ideas
  
• Excellent
  communication and presentation skills
  

Desirable Skills:

• Applied
  Python programming
  
• Experience
  working with JSON and XML files
  
• Experience
  using APIs
  
• Knowledge
  of SAP
  
• Knowledge
  of supply chain fundamentals and terminology
  

Educational Qualifications & institutes
to hire from:

Strong educational background from reputed engineering
and management school

Benefits