SQL - Ssis Consultant - Harrow, United Kingdom - Thoucentric

Description

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 daytoday; 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 handson 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.

-