Job Description
The day-to-day development activities will need knowledge of the below concepts:
•Good working knowledge of Snowflake — table types (Permanent, Transient, Temporary),
stages, file formats, Snowpipe, and basic Snowflake query mechanics.
•Solid SQL skills — joins, subqueries, aggregations, window functions, and ability to write
clean, effective queries for data transformation use cases.
•Good understanding of ETL/ELT concepts and exposure to at least one data pipeline tool
(ADF, Airflow, dbt, Matillion, or equivalent).
•Basic understanding of dimensional data modelling — Star Schema, Facts and Dimensions,
and data warehouse layering concepts.
•Should have worked on at least 1 end-to-end data engineering project involving Snowflake or
a comparable cloud data warehouse.
•Ability to write and execute test cases to validate pipeline outputs and data accuracy.
•Positive understanding of SDLC basics — source control usage, ticket-driven development, and
documentation practices.
•Ability to work within a team, communicate progress clearly, and raise blockers proactively.
Requirements
Key Skills: Snowflake, SQL, ETL Concepts, Data Modeling
Secondary Skills:
•Exposure to dbt Core for transformation layer development is a bonus.
•Knowledge of Python scripting for data processing tasks is a plus.
•Familiarity with any BI tool (Power BI, Tableau, Looker) that consumes Snowflake data is
good to have.
•Knowledge of Azure Dev Ops or Git Hub for source control is good to have.
Benefits• At Psiog, we believe people grow when opportunities do. You’ll be part of an ecosystem that encourages curiosity, innovation, and ownership.
• Work with global clients, and enterprise environments, enabling exposure beyond conventional delivery models.
• Accelerated career tracks with a faster roadmap to leadership for those who demonstrate capability and initiative.
• Opportunity to explore diverse technologies, projects, learning opportunities and domains, allowing you to shape your own growth path.
• An organization that celebrates passion alongside profession, encouraging creativity, art, and individuality.
Requirements
Key Skills: Snowflake, SQL, ETL Concepts, Data Modeling Secondary Skills: •Exposure to dbt Core for transformation layer development is a bonus. •Knowledge of Python scripting for data processing tasks is a plus. •Familiarity with any BI tool (Power BI, Tableau, Looker) that consumes Snowflake data is good to have. •Knowledge of Azure Dev Ops or Git Hub for source control is good to have.
📌 Software Engineer- Snowflake (India)
🏢 Psiog
📍 India