Data Warehouse Engineer

Company: Thome India Pvt. Ltd.
Location: India

Responsibilities

  • Responsible for architecting and designing integration solutions including API and ESB/Middleware based solutions that meet business requirements
  • Perform requirement gathering and feasible study with user/customer.
  • Propose a solution design based on user/customer’s
  • Collect and analyze data from various sources
  • Build and deploy data tools, ETL/ELT pipelines into the data warehouses & data marts, dashboards for end stakeholders to view and explore the
  • Strong working knowledge/experience in designing, implementing, and supporting web, middleware, and third-party
  • Provide inputs to management and customer during proof-of-concept reviews (technical and non-technical)
  • Provide big data analysis consultancy and advisory to customers in the areas of cyber security, application monitoring, networking monitoring, infrastructure monitoring or business
  • Able to work well in a team, collaborating with application developers, customers, project managers and requirements
  • Software programming and development, utilizing XML, Javascript, HTML, regular expressions, SQL, Shell Scripting, Python and etc.
  • Build scalable and reliable ETL pipelines and processes to handle data from a large number and variety of data sources
  • Identify and recommend different ways to constantly improve data reliability and quality

Education and Qualification

  • Bachelor’s Degree   in   Computer  Engineering/Information  Technology/Computer Science or equivalent
  • 5 years’ experience as Data Warehouse Engineer
  • Solid knowledge on metadata, data structures, ETL (extract, transformation, loading), algorithms, database design (conceptual, logical, physical data model design)
  • Strong knowledge/exposure in SQL, PL/SQL, Stored Procedure, Data Analytics, Data Mining, Python/R and Machine Learning
  • Familiarity with common enterprise infrastructure architecture will be an advantage
  • Knowledge of business application and networking fundamentals will be an advantage
  • Ability to quickly adapt to new technology and go deep into new areas
  • Great communication
  • Experience in metadata, data structure, ETL (extract transform loading) from MS SQL database (as data source), algorithms, database design (conceptual, logical, physical data model design) data warehouse
  • Experience in Microsoft Azure (ADF, Synapse, ADL, Databricks) is preferrable, with strong knowledge in all Azure service components (dedicated SQL pool, storage, SQL hosted, Azure hosted, Data flows)
  • Solid knowledge in SQL, PL/SQL, stored procedure, data analytics, data mining, Python/R and Machine Learning.
  • Experience with BI tool. Power BI will be advantage
  • Minimum of 5 years’ related experience as Data Warehouse Engineer

Share:

Share on facebook
Share on twitter
Share on linkedin

Apply now and be part of Thome Group big family.