Principal Consultant - Data Engineer (Snowflake & DBT)

• Experience in IT industry
• Working experience in the IT industry, with a focus on building productionized data ingestion and processing data pipelines in Snowflake.
• In-depth knowledge of data warehousing concepts and experience in working with Snowflake, including a deep understanding of its features and integration with other data processing technologies.
• Proficiency in creating data pipelines for ETL using Snowflake or DBT (Data Build Tool).
• Hands-on experience in configuring, troubleshooting, testing, and managing data platforms, both on-premises and in the cloud.
• Familiarity with data visualization tools and methodologies.
• Ability to work independently on business problems and generate meaningful insights from data.
• Snowflake SnowPro Core Certification is good to have.
• Excellent presentation and communication skills, both written and verbal.
• Strong problem-solving skills and ability to architect solutions in an environment with unclear requirements.

• Able to work on requirement gathering, analysis, designing, development, and deployment.
• Writing SQL queries against Snowflake, developing scripts to do Extract, Load, and Transform data.
• Good understanding on Data Warehouse concepts and Snowflake Architecture
• Hands-on experience with Snowflake utilities such as SnowSQL, SnowPipe, bulk copy, Snowpark, tables, Tasks, Streams, Time travel, Cloning, Optimizer, Metadata Manager, data sharing, stored procedures and UDFs, Snowsight.
• Have experience with Snowflake AWS data services (S3, Glue,lambda) or Azure data services (blob storage container, ADLS, ADF) etc
• Strong experience in integrating DBT (Data Build Tool) with Snowflake and cloud platforms such as AWS or Azure.
• Extensive knowledge of leveraging DBT to build and manage efficient data transformation pipelines in Snowflake.
• Experience in designing and developing efficient and scalable data models using DBT, including the creation of tables, views, and macros.
• Knowledge of SQL and ability to write complex queries and transformations using DBT's templating language.
• Proficiency in using DBT's testing and documentation features to ensure the accuracy and reliability of data transformations.
• Understanding of data lineage and metadata management concepts, and ability to track and document data transformations using DBT's lineage capabilities.
• Understanding of software engineering best practices and ability to apply these principles to DBT development, including version control, code reviews, and automated testing.
• Should have experience building data ingestion pipeline.
• Should have good experience in implementing CDC or SCD type 2
• Proficiency in working with Airflow or other workflow management tools for scheduling and managing ETL jobs.
• Good to have experience in repository tools like Github/Gitlab, Azure repo

JobPrincipal Consultant

Primary LocationIndia-Noida

ScheduleFull-time

Education LevelBachelor's / Graduation / Equivalent

Job PostingFeb 10, 2025, 12:45:06 PM

Unposting DateMar 13, 2025, 1:29:00 PM

Master Skills ListDigital

Job CategoryFull Time