SSIS Integration Consultant

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.

Thoucentric is the Consulting arm of Xoriant, a prominent digital engineering services company with 5000+ employees. We are headquartered in Bangalore with presence across multiple locations in India, US, UK, Singapore & Australia Globally. As the Consulting business of Xoriant, 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 across US, UK, Singapore and Australia. Our unique consulting framework allows us to focus on execution rather than pure advisory. We are working closely with marquee names in the global consumer & packaged goods (CPG) industry, new age tech and start-up ecosystem. Xoriant (Parent entity) started in 1990 and is a Sunnyvale, CA headquartered digital engineering firm with offices in the USA, Europe, and Asia. Xoriant is backed by ChrysCapital, a leading private equity firm. Our strengths are now combined with Xoriant's capabilities in AI & Data, cloud, security and operations services proven for 30 years. We have been certified as "Great Place to Work" by AIM and have been ranked as "50 Best Firms for Data Scientists to Work For". We have an experienced consulting team of over 450+ world-class business and technology consultants based across six global locations, supporting clients through their expert insights, entrepreneurial approach and focus on delivery excellence. We have also built point solutions and products through Thoucentric labs using AI/ML in the supply chain space.