SQL SSIS Consultant

Desired Skill sets

SQL, SSIS, ETL

Job Description

• The most popular ones are -
  
  • Building capabilities that address a market need, basis our ongoing research efforts
    
  • Solving a specific use case for a current or potential client based on challenges on-ground
    
  • Developing new systems that help be a better employer and a better partner to clients
    
• All of these need the best of minds to work on them day-to-day; and we do exactly that!
  
• Your contribution to organization development is as important as outward facing consulting.
  
• We are invested in both, employee growth and client success!
  

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

Must Have:

• 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
  
• Basic Unix knowledge
  
• Exposure to at least one Data Visualization tool Tableau/Qlik etc
  
• Familiarity with workflows in programming concepts
  
• Experience using columnar databases
  
• Experience working directly with customers and presenting your ideas
  
• Excellent communication and presentation skills
  

Good to Have:

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