SSIS Integration Architect (o9 Platform)

Thoucentric Technology Private Limited; Mumbai; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Thoucentric Technology Private Limited is seeking an SSIS Integration Architect (o9 Platform) in Mumbai. The role focuses on building data crawlers, designing data warehouses, and creating data processing scripts to support integrated business planning and analytics for enterprise clients.

You will work with Solution Architects to translate customer requirements into robust ETL solutions and SSIS packages, owning the end-to-end development lifecycle.

Qualifications

• Must have strong hands-on experience with ETL (Extract/Transform/Load) processes.
• Proficiency with databases (SQL Server, MySQL) and SQL dialects (SQL, MDX, T-SQL) including DDL/DML, stored procedures and triggers.
• Familiarity with programming concepts/workflows and ability to work directly with customers.
• Excellent communication and presentation skills.

Responsibilities

• Build data crawlers to extract data from customers' sources and troubleshoot loading/processing issues.
• Design and develop data warehouse models.
• Develop data processing scripts using SQL and optimize complex queries.
• Design, build and deploy SSIS packages for data validation, synthesis, and analytics.
• Collaborate with Solution Architects to capture business requirements and implement them.
• Own development and implementation workflow end-to-end.
• Contribute to technical design and data requirements, advising on data quality.

Skills

ETL processes

Customer interaction

Communication

Presentation

Tools

SQL Server

MySQL

SQL

MDX

T-SQL

DDL

DML

Stored procedures

Triggers

Job description

SSIS Integration Architect (o9 Platform)

At Thoucentric, we offer end-to-end consulting solutions designed to address the most pressing business challengesacross industries. Leveraging deep domain expertise, cutting-edge technology, and a results-driven approach, wehelp 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 Placeto 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

At Thoucentric, we work on various problem statements.

• The most popularones are-
  
• Buildingcapabilitiesthat address amarket need,basis our ongoingresearch efforts
  
• Solvinga specific use casefor a current or potential clientbased on challengeson-ground
  
• Developingnew systemsthat helpbe a better employer and a better partnerto clients
  
• All of theseneed thebest of minds to work on them day-to-day; andwe doexactly that!
  
• Yourcontributionto organization development is as importantasoutward facingconsulting.
  
• We are investedin both, employee growth and client success!
  

Job Description:

• Builddata crawlers to extract data from customers' data sources using availableETL platforms, and troubleshoot the issues faced during data loading &processing
  
• Designand build data warehouse models in columnar databases
  
• Developdata processing scripts using SQL and be able to optimize complexsequences of SQL Queries
  
• Design,build and deploy effective SSIS packages to validate, synthesize,transform customer data for integrated business planning and analytics
  
• Workwith Solution Architects to understand customers' business requirementsand implementthem
  
• Performdata analysis for complex use cases using SQL document technicalspecification for
  
• thecognitive applications that we are creating for the customers
  
• Ownthe entire development and implementation workflow
  
• Participatein the technical design, data requirements gathering and makingrecommendations on best practices, in case of inaccurate or missing data
  
• Designand automate the data loading and insights generation process withintelligent checks and balances for sustained value delivery
  
• Createand execute test plans, document issues and track progress at resolvingissues.
  

Requirements

Requirements

Must Have:

• Verystrong hands-on experience working in ETL (Extract/Transform/Load)processes
  
• Proficiencyin databases (SQL Server, MySQL) and skills in one or more languages likeSQL, MDX, T-SQL with knowledge of DDL, DML, stored procedures, triggersand performance tuning is a MUST
  
• Familiaritywith workflows in programming concepts
  
• Experienceworking directly with customers and presenting your ideas
  
• Excellentcommunication and presentation skills
  

Good to Have:

• AppliedPython programming
  
• Experienceworking with JSON and XML files
  
• Experienceusing APIs
  
• Knowledgeof SAP
  
• Knowledgeof supply chain fundamentals and terminology
  

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.

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!