SQL - Ssis Consultant

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

**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, ETL**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**
- 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
- 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
- Basic Unix knowledge
- Exposure to at least one Data Visualization tool - Tableau/Qlik etc
- 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**:
**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.
-