Description

  • Snowflake SQL Writing SQL queries against Snowflake Developing scripts Unix, Python, etc. to do Extract, Load, and Transform data.
  • Hands on experience with Snowflake utilities such as SnowSQL, SnowPipe, Python, Tasks, Streams, Time travel, Optimizer, Metadata Manager, data sharing, and stored procedures.
  • Daily responsibilities are data migration using flat files, collecting information related to ingestion process, understanding the logic and implement the same. Data validation to ensure unit testing. 
  • Supporting job scheduling, monitoring activities and reconciliation process. ETL tool DBT, Advanced SQL along with good Python scripting skill Familiar with Agile delivery process.
  • Experience and familiarity with data models and artefacts (entity relationship diagrams, conceptual models, logical models, star schemas, third normal form).
  • Experience in writing complex SQL queries.
  • Good knowledge in any RDBMS like AWS Redshift Postgres Oracle SQL Server.
  • Excellent communication skills both verbal and written. Primary Skills Must have Understanding of data model, ETL architecture.
  • Excellent in Data Warehouse concepts. Excellent in writing complex SQL queries with performance tuned to be run in a tool. GITHUB, Jenkins

Key Skills
Education

Any Graduate

Back To Jobs