o9 SSIS integration Consultant

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.

RequirementsExperience 5-6 YearsMust Have:

• O9 is Manadatory
• 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