Thoucentric - SSIS Integration Architect - O9 Platform

Description : At Thoucentric, we work on various problem statements.

- 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

- 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 : What a Consulting role at Thoucentric will offer you?

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.