Base Career helps you apply smarter for this job.
Key skills for this role
A data engineer role in the Specialty Data team should be able to analyze data from multiple source system and design/model Data Marts based on business requirements.
Therefore, strong data analytics and technical skills are a must.
He or She should be able to create data models, STTMs and other technical documents.
The Engineer should have strong communication skills and the ability to understand design requirement and existing business processes to lead in the design, development, and implementation of data products in partnership with business partners and data scientists.
In addition, the Engineer should have the following knowledge:
Intermediate expertise in Data Vault 2.0 Modeling to be able to support and use the Specialty data vault.
Advance Expertise in SQL.
The Engineer will be writing complex SQL statements.
The Engineer should be able to use DBT as an ELT tool to load the data mart tables.
Advance expertise in Snowflake database.
Some knowledge of Mainframe, Mainframe SAS and Distributed DB2.
Mainframe is a source system of the mart.
Fivetran is used as an Orchestrating tool of the DBT code.
Hands-on experience with multiple cloud platforms including AWS and Azure is preferred.
Informatica development skills.
Good understanding of Medallion Data Architecture
Total Experience- 05 to 07 years
Relevant Experience 05 to 07 years
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
, IND
Capgemini is seeking a Workforce Insights Consultant to analyze HR and workforce data, develop reports and predictive models, and translate findings into business insights. The role requires at least three years of analy
Hyderabad, IND
The employer is seeking a Workforce Insights Consultant to analyze HR and workforce data, produce reporting, support predictive modeling, and improve data-driven business decisions. The role requires at least three years
Vancouver, CAN
Capgemini is seeking an AEM Tower Lead to own the architecture, governance, development, and delivery of Adobe Experience Manager solutions. The hands-on role requires deep AEM expertise, Java-based development, enterpri
Vancouver, CAN
Capgemini is seeking an AEM Tower Lead to own the strategy, governance, architecture, development, and delivery of Adobe Experience Manager solutions. The hands-on leadership role requires deep AEM expertise, Java-based
Toronto, CAN
Capgemini is seeking an experienced Insurance Business Analyst to manage requirements, analyze insurance processes and data, and coordinate delivery across business and technical teams. The role requires 6+ years of busi
Toronto, CAN
Capgemini is seeking an experienced Insurance Business Analyst to manage requirements, analyze insurance processes and data, and support application delivery. The role requires 6+ years of business analysis experience, i
Toronto, CAN
Capgemini is seeking a senior Business Analyst with insurance-domain expertise to manage requirements, analyze data, support testing, and coordinate business and technical stakeholders. The role requires 6+ years of busi
, IND
, IND
Hyderabad, IND
Vancouver, CAN
Vancouver, CAN
Toronto, CAN
Toronto, CAN
Toronto, CAN
Provides global IT consulting and digital transformation services.
Full-time
Mid · 5+ years experience
Hybrid
Apply faster on company sites with our extension.