SSIS Integration Consultant

About Us

At Thoucentric, we offer end-to-end consulting solutions designed to address the most pressing business challenges across industries. Leveraging deep domain expertise, cutting-edge technology, and a results-driven approach, we help organizations streamline operations, enhance decision-making, and accelerate growth. We are headquartered in Bangalore with presence across multiple locations in India, US, UK, Singapore & Australia Globally.

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. Our unique consulting framework allows us to focus on execution rather than pure advisory. We are working closely with marquee names in the global consumer & packaged goods (CPG) industry, new age tech and start-up ecosystem.

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 have an experienced consulting team of over 500+ world-class business and technology consultants based across six global locations, supporting clients through their expert insights, entrepreneurial approach and focus on delivery excellence. We have also built point solutions and products through Thoucentric labs using AI/ML in the supply chain space.

Job Description

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

Requirements

Must Have

o9 Platform exp is Mandatory.

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

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

Benefits

Opportunity to define your career path and not as enforced by a manager

A great consulting environment with a chance to work with Fortune 500 companies and startups alike.

A dynamic but relaxed and supportive working environment that encourages personal development.

Be part of One Extended Family. We bond beyond work - sports, get-togethers, common interests etc. Work in a very enriching environment with Open Culture, Flat Organization and Excellent Peer Group.

Be part of the exciting Growth Story of Thoucentric!