SSIS Technical Architect-UK/EU

at  Thoucentric

ABOUT US

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.

JOB DESCRIPTION:

We are looking for Senior Technical ETL Architects who will lead a team of Data Engineers on collecting, storing, processing, and analyzing huge datasets. The primary focus will be on choosing the optimal data technology to use for these purposes and designing an ETL solution in a highly demanding environment and providing hands on guidance to other team members, where needed. You will also be responsible for interacting with a diverse set of business stakeholders to understand the technical requirements and consulting them on technology architecture selection.

REQUIRED SKILLSETS:

• 10+ years of experience in Data Warehousing and ETL space, with 5+ years of experience as a Data / ETL Architect
• Experience in working on large data integration projects using diverse databases (DW Appliance /RDBMS), ETL tools like SSIS visualization tools like Tableau/Power BI
• Strong knowledge of the software development lifecycle and agile development methodology
• Experience with Big Data platforms and software like Hadoop, Apache Spark, HDFS, Hive.
• Expertise in building communication channels between structured and unstructured database systems.
• Solid understanding of ETL architectures, data movement technologies and database concepts like Partitioning, Performance optimization.
• Hands-on experience with large-scale data environments, performance tuning, and monitoring
• Proficiency in architecting and delivering BI/EDW solutions.
• Strong analytical & programming skills as well as deep understanding of major RDBMS systems like SQL Server.
• Must be able to thrive in a fast-paced, rapidly evolving environment with varying priorities, based on a team building culture.

• Design, solution and implement data architecture and ETL for a niche data platform
• Bring in-depth understanding on Relational, Big Data, with extensive experience of applying them to large scale client implementations.
• Lead and work with colleagues and clients through the in-depth discovery phase on new projects that identifies their technological needs and translate those into a solution architecture
• Partner with stakeholders (Project Manager, Business Sponsors, Asset Owner, IT Leaders, technical resources) to review, clarify and refine the documentation corresponding to defined business requirements and need(s)
• Bring in thought and organizational leadership in Data Management and ETL domain
• Engage with cross-functional teams to implement solutions as a Technical Architect
• Design modern architectures involving traditional and big data technologies
• Implement the solutions you design through a team of data engineers
• Analyze source systems and design data extraction methodologies and guide the team in profiling and analyzing such data.