Snowflake and DW Developer-Reading, PA-Hire Type: Longterm Contract

Overview

On Site
$0,00/-
Accepts corp to corp applications
Contract - W2
Contract - to 12/31/2026

Skills

Data and Intelligence-Data Warehouse-Snowflake

Job Details

TECHNOGEN, Inc. is a Proven Leader in providing full IT Services, Software Development and Solutions for 15 years.

TECHNOGEN is a Small & Woman Owned Minority Business with GSA Advantage Certification. We have offices in VA; MD & Offshore development centers in India. We have successfully executed 100+ projects for clients ranging from small business and non-profits to Fortune 50 companies and federal, state and local agencies.


Hello, I am Kishore Mandaloju from TechnoGen Inc., we are collaborated with US based Clients and working for different positions from past many years and placed many of the consultants. I am currently looking for Snowflake and DW Developer for one of our clients. Below is the job description for your review Please let me know if you would be interested and please attach your updated resume at kishore.m

Role: Snowflake and DW Developer

Location: Reading, PA (Onsite hybrid working with 3 days in office)

Hire Type: Longterm Contract


Must have strong background in Datawarehouse, snowflake and airflow.
Job Description:
Design, implement, and optimize efficient ETL processes to transform raw data into actionable insights.
Develop and maintain robust data warehouse solutions, including the implementation of star and snowflake schemas. Establish and manage reliable data pipelines to ensure timely data availability.
Create modular, maintainable, and scalable dbt workflows for advanced data transformations.
Leverage dbt testing, documentation, snapshotting, and Change Data Capture (CDC) for incremental data refresh.
Implement and manage Type 2 data modelling techniques for historical data.
Develop reusable macros and packages using Python libraries and dbt packages.
Optimize complex SQL queries and leverage Snowflake's performance-enhancing features like Streams, Time Travel, partitioning, and clustering.
Orchestrate data pipelines for both batch and near real-time data refresh scenarios.
Write and optimize Snowflake SQL queries and stored procedures for seamless data transformation and integration.
Ensure compliance with data governance policies and implement security controls for sensitive data.

What we need from you:
Bachelor's degree in computer science, Information Systems, or a related field.
3-5 years of experience in data warehouse development and ETL tools (e.g., dbt, SSIS, Informatica, or Azure Data Factory).
1 2 years of experience with dbt and Snowflake.
Proficiency in SQL/PL-SQL for data querying and optimization.
Familiarity with Python for enhancing dbt pipelines.
Strong analytical, problem-solving, and communication skills.

Additional knowledge and/or experience desired:
Hands-on experience with ETL tools such as DBT, SSIS, Informatica, or Azure Data Factory.
Knowledge of Snowflake, including query writing and data integration.
Familiarity with cloud platforms like Azure Synapse, AWS Redshift, or Snowflake.
Experience with Agile methodologies.
Experience with CI/CD tools like Jenkins, Docker, or Terraform.

Thanks & Best Regards,
Kishore Mandaloju

TechnoGen Inc.,

kishore.m

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.