AWC Software - Snowflake Developer - Data Warehousing

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)

Location: in, IN

Posted Date: 4/4/2025