AWC Software

AWC Software - Snowflake Developer - Data Warehousing

Bengaluru East, Karnataka, India

about 1 month ago
Save Job

Summary

Job Description

  • Architect, develop, and deploy a wide range of data management solutions on premises and on cloud
  • Create ETL pipelines to process large amounts of unstructured, semi-structured, and structured data
  • Model different datasets, obtain data extracts, and define secure data exchange approaches
  • Acquire, ingest, and process data from multiple sources and systems into large-scale data platforms
  • Design, maintain, and tune large data warehouse sets
  • Take responsibility for data modeling and technical designing
  • Analyze and translate functional specifications / user stories into technical specifications
  • Work closely with business partners and analysts to understand data needs, document requirements, and develop detailed solutions
  • Analyze source systems and conduct hands-on data analysis

What We're Looking For

  • Over 4 years of experience in SnapLogic and Snowflake development and experience in creating pipelines, handling errors, scheduling tasks and alerts, etc.
  • Experience in 2-3 end-to-end implementations in SnapLogic (develop / test / implement)
  • Experience in using JDBC, Oracle, REST, and SOAP
  • Experience in working with third-party / external vendors across all modules and providing solutions for SnapLogic designs
  • Knowledge of building complex mappings with JSON path expressions
  • Knowledge of PL / SQL and enterprise application integration
  • Strong analytical, problem-solving, written, and verbal communication skills
  • Ability to work independently and effectively under pressure with constantly changing priorities and deadlines
  • Familiarity with project management and systems development lifecycle processes, tools, concepts, and methodologies.
  • Graduate / post-graduate in computer science / engineering from a reputed university
  • Over 8 years of experience in data warehousing and management.

Required Skills

  • Possess a deep understanding of Snowflake and related technologies and proficiency in various data engineering technologies, including Strong programming knowledge using Snowflake, SnowSQL.
  • Good Knowledge of Dbt to build the models in data warehouse, programming knowledge of Spark/Scala and Python.
  • Snowflake, Datastage, AWS, requirement gathering, analysis, architectural design, component and interface development, implementation of Data warehousing and Datamart solutions using Snowflake and DataStage.
  • Strong programming knowledge using Snowflake, SnowSQL and Snowpipe is a must.
  • Must have good knowledge of RDBMS databases like SQL, Oracle etc and should have working experience on ETL/ELT concepts.
  • Good knowledge of Dbt to build the models in data warehouse.
  • Nice to have knowledge of Azure and Bitbucket.
  • Strong in SQL and Analytical SQL
  • Should be able to work in a team or independently.
  • Work with the client on getting the requirements and develop them accordingly.
  • Good understanding on Agile based delivery process
  • Nice to have programming knowledge of Spark/Scala and Python

(ref:hirist.tech)

How strong is your resume?

Upload your resume and get feedback from our expert to help land this job