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