Supply Chain Ssis Architect

**About us**:
Thoucentric is a niche management consulting firm focused on helping organizations overcome business challenges, maximize growth & overall performance through effective problem solving, efficient people, process and technology solutioning, end to end execution and management.

We have been certified
**Great Place to Work **by AIM
** **and have been ranked as
**"50 Best Firms for Data Scientists to Work For"**

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.

We are a group of seasoned professionals having diverse industry, solution and product experience thereby making us effective business liaisons.
**We are 400+ consultants strong coming with strong diverse background fueling our growth story in India and across four other global locations viz. US, UK, Singapore and Australia.**

**Desired Skill sets**:
SQL, SSIS, Supply Chain

**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**
- Work with Solution Architects to understand Data Integration requirements and build interfaces using SSIS between ERP systems and Supply chain planning platforms like o9, Kinaxis and vice versa
- Analyze and understand business problems/requirements to propose effective technical solutions
- Participate in the technical design, data requirements gathering and make recommendations on best practices
- Develop functional/ technical specifications and have them successfully implemented.
- Own the entire development and implementation workflow
- Design, build and deploy effective SSIS packages to validate, synthesize, transform customer data for integrated business planning and analytics
- Develop data processing scripts using SQL and optimize complex sequences of SQL Queries
- 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.
- Build data extractors to extract data from customers' data sources using available ETL platforms, and troubleshoot issues faced during data loading & processing
- Conduct Unit testing, System testing and End User Testing
- Help support the current implementation and resolve critical issues

**Requirements**:
**Must Have Skills**:

- Integration projects experience using SSIS in Supply Chain
- Experience of working as an Integration consultant or Integration architect in implementation projects of supply chain planning packaged solutions like o9, Kinaxis, SAP APO, SAP IBP, Blue Yonder etc
- Strong Proficiency and hands-on experience in SSIS
- One implementation experience in Supply Chain planning or ERP integration projects using SSIS or other Integration tools
- Hands-on experience in SQL, PL/SQL, Interfaces, Integration, and report development experience.
- Debugging skills with the integrations of custom tools.
- Very strong hands-on experience working in ETL (Extract/Transform/Load) processes
- Exposure to at least one Data Visualization tool - Power BI/Tableau/Qlik etc
- Familiarity with workflows in programming concepts
- Experience working directly with customers and presenting your ideas

**Good to Have**:

- Applied Python programming
- Applied Java programming
- Applied ML skills. R programming experience
- Experience working with JSON and XML files
- Experience using APIs
- Knowledge of SAP

**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

Practice Name

Business Applications (SC)

Industry

Consulting

Work Experience

4-8 Years

Corporate Office

The HIVE, 4th Floor, VR MALL, The WAVERLEY, 60/2, ITPL Main Rd,B Narayanapura, Mahadevapura, Bengaluru, K