Job
Description
Project description
DXC - a Fortune 500 global IT services leader. At DXC Technology we deliver the mission-critical IT services that move the world. Every day we use the power of technology to build better futures for our customers, colleagues, environment, and communities across the globe.We are flexible - we provide everything you need to comfortably work from home, but we also keep our offices open for collaboration, meetings, and building a strong team spirit. We tailor everyone's development path to their individual interests through training and additional certifications. Responsibilities
Design, develop, and maintain DBT models, transformations, and SQL code to build efficient data pipelines for analytics and reporting.
Design, develop, and maintain ETL/ELT pipelines using DBT and pulling datafrom Snowflake.
Define and implement data modelling best practices, including data warehousing, ETL processes, and data transformations using DBT.
Build complex SQL queries within DBT to build incremental models, enhancing data processing efficiency.
Establish data governance practices and ensure data accuracy, quality, and consistency within the data transformation process.
Collaborate with data engineers, data analysts, and other stakeholders to understand and meet data requirements for various business units.
Identify and address performance bottlenecks in data transformation processes and optimize DBT models for faster query performance.
Maintain thorough documentation of DBT models, transformations, and data dictionaries to ensure transparency and accessibility to team members.
Implement data security measures to protect sensitive information and comply with data privacy regulations.
Stay updated on industry best practices and new features in DBT, and continuously improve the data transformation processes.
Provide training and support to other team members in using DBT effectively.
Implement data quality checks and validation processes to ensure data accuracy and consistency. Skills
Must have
8+ years of experience in DBT.
Hands-on experience in implementing data governance, data quality rules and validation mechanisms within Collibra is added plus.
Knowledge of workflow orchestration tools like Tidal.
Experience with Python or other scripting languages is a plus.
Familiarity with Azure cloud platforms.
Exposure to DevOps practices and CI/CD pipelines for data engineering. Nice to have
Certification
Location - pune,mumbai,chennai,banagalore