Data Engineer
IDP01 - DGS-Campus Ph1, India
DXC Technology
DXC Technology helps global companies run their mission-critical systems and operations while modernizing IT, optimizing data architectures, and ensuring security and scalability across public, private and hybrid clouds.Job Description:
Sr. Snowflake, DBT, SQL Developer:
We are looking for an experienced senior Backend developer (Snowflake, DBT and SQL) The person should have proven hands-on experience in Snowflake, DBT and SQL. Azure and DBT is always an added advantage as Nestle is using DBT for Transformation.
• The overall experience of 7+ years in SQL and with minimum 3-5 years of experience in Snowflake.
• Experience with SnowFlake data warehouse
• Experience with Data Ingestion into SnowFlake such as Snowpipe and DBT
• DBT Development: Design, develop, and maintain DBT models, transformations, and SQL code to build efficient data pipelines for analytics and reporting.
• Good understanding of SnowFlake architecture and processing
• Hands-on experience in Snowflake Cloud Development
• Experience in writing complicated SQLs, analyzing query performance, query tuning, database indexes partitions, and stored procedure development.
• Implementing ETL pipelines within and outside of a data warehouse using Python and Snowflakes Snow SQL
• Querying Snowflake using SQL
• good knowledge of SQL language and data warehousing concepts,
o Experience with technologies such as SQL Server 2008, as well as with newer ones like SSIS and stored procedures
o Designing database tables and structures.
o Creating views, functions, and stored procedures.
o Writing optimized SQL queries for integration with other applications.
o Creating database triggers for use in automation.
o Maintaining data quality and overseeing database security.
o Exceptional experience developing codes, testing for quality assurance, administering RDBMS, and monitoring of database
o Strong knowledge and experience with relational databases and database administration (indexes, optimization, etc.)
o Querying Snowflake using SQL, Experience with SQL and PLSQL, SQL query tuning, database performance tuning and data warehousing concepts, Knowledge of DBT and Azure (ADF) is desirable.
Recruitment fraud is a scheme in which fictitious job opportunities are offered to job seekers typically through online services, such as false websites, or through unsolicited emails claiming to be from the company. These emails may request recipients to provide personal information or to make payments as part of their illegitimate recruiting process. DXC does not make offers of employment via social media networks and DXC never asks for any money or payments from applicants at any point in the recruitment process, nor ask a job seeker to purchase IT or other equipment on our behalf. More information on employment scams is available here.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Architecture Azure Data pipelines Data quality Data warehouse Data Warehousing dbt ETL Pipelines Python RDBMS Security Snowflake SQL SSIS Testing
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.