Job Role :- ETL Data Governance Developer
Work Location: TCS – Seattle, WA -Boise, ID – Onsite
Role Description:
- Build and maintain data models and data/solution pipelines to cater to analytical applications
- Work in a technical team through development, deployment, and application of applied, predictive and prescriptive analytics using data engineering, machine learning engineering and artificial intelligence.
- Design and optimize data structures in data management systems (Snowflake, GCP, HANA) to enable reporting analytics using Tableau/Power BI as well as AI/ML solutions.
- Determine transformation requirements and develop processes to bring structured and unstructured data from the source to a new physical Data Model
Competencies: Digital : Data Governance, Digital : Snowflake, EIS : Teamcenter Product (PLM)
Experience (Years): 8-10
Essential Skills:
- Technical Degree required. B.S or M.S in Computer Science, Business Analytics, Engineering
- Understanding of Data Engineering/processing, Business Intelligence and Advanced analytics using Teamcenter data
- Thorough understanding of the back-end models for Teamcenter8+ 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.
- 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.
- 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.
- Familiarity with the integration of Teamcenter & SAP as related to data warehousing solutions.
- 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
- Experience with various frameworks and processes, such as Agile (Scrum, Kanban, etc.)
- Outstanding analytical thinking, interpersonal, oral, and written communication skills.
- Proficiency in the Microsoft Office suite Ability to prioritize and meet critical project timelines in a fast-paced environment.
- Self-motivated and team-oriented
Desirable Skills:
- Strong business domain knowledge in Product Lifecycle Management.
- Experience with 3NF data modeling
- Experience with transformation & development of data models in Snowflake.
- Experience with Coalesce
Keywords: Snowflake, Data warehousing, Developer
From:
AJAy,
KK Software Associates
ajay.e@kksoftwareassociates.com
Reply to: ajay.e@kksoftwareassociates.com