SSIS Integration Architect (o9 Platform)
Thoucentric · thoucentric.com
MumbaiLead / Manager
The job in short
SSIS integration architecture.
SQLWarehouse
Details
- Found
- 22 d ago · posted 2025-05-08
- Location as listed
- Mumbai, Karnataka, India
- Role
- Solutions / Software Architect
- Source
- The company’s own careers site
Full 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
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.
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!
Solutions / Software Architect jobs in Mumbai · Solutions / Software Architect jobs in India · All Thoucentric jobs