7-15 years
AWC Software - Snowflake Developer - Data Warehousing (7-15 yrs)
AWC Software
posted 22d ago
Flexible timing
Key skills for the job
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
Functional Areas: Other
Read full job descriptionPrepare for Snowflake Developer roles with real interview advice
8-16 Yrs
5-9 Yrs
6-15 Yrs
6-15 Yrs