Data Engineer - ETL/Data Warehousing (4-20 yrs)

Job Summary :

We are looking for a skilled Data Engineer with expertise in Snowflake to join our team. As a Data Engineer, you will be responsible for building and managing scalable data pipelines, integrating data from various sources, and optimizing our data warehouse infrastructure.

Skills Required :

- Data Engineering : Snowflake, SQL, ETL

- Data Modelling : Dimensional Modelling, Data Warehousing concepts

- Data Management : Data quality, data security practices

- Cloud Platforms : AWS, Azure, or Google Cloud Platform

- Experience with data integration tools and techniques

- Strong problem-solving and analytical skills

- Effective communication and collaboration abilities

Key Responsibilities :

- 8+ years of strong working knowledge of databases (Snowflake,- MS-SQL, SAP HANA).

- 5+ years- building scalable ETL pipelines with data processing and/or developing applications and data sources.

- Thorough understanding of the back-end models for Teamcenter.

- Experience with the back-end data structures, tables, relationships, E-R relationship of

Teamcenter and translating them to data warehouse constructs.

- Ability to define & build hierarchical relationships of Product Lifecycle Management like BOM, etc. in data warehouse like Snowflake.

- Familiarity with the integration of Teamcenter & SAP as related to data warehousing solutions

- Understanding of Data Engineering/processing, Business Intelligence and Advanced analytics using Teamcenter data

- Communicate effectively with stakeholders regarding all facets of data warehousing solutions pertaining to PLM Teamcenter.

- Ability to architect & develop solutions pertaining to attributes, relationships for master data including slowly changing dimensions.

- Ability to architect & develop data-warehousing solutions for extended Product Lifecycle Management encompassing production cycle definitions of products, equipment, facilities, etc. Various phases of Unit, Integration & User Acceptance testing

- Familiarity with software architecture (data structures, data schemas, etc.)

- Software development skills and knowledge in Cloud based data engineering.

- CI/CD pipelines including ADO repos