Job Role: Snowflake With PostgreSQL Professionals
Location: Hyderabad/Noida/Gurgaon
- Years of Experience: 8 12 Years
- MustHave: The candidate should have 5 years of relevant experience in Snowflake with PostgreSQL
- Projectspecific Prerequisite skills: Snowflake PostgreSQL DBT ETL
Detailed JD:
We are looking for professionals with expert knowledge in databases like PostgreSQL preferably cloudhosted in any one or more cloud offerings such as AWS Azure or GCP. The ideal candidate should have strong programming experience in SQL DBT competence in data preparation and/or ETL tools to build and maintain data pipelines and flows. Deep knowledge of database stored procedures optimizations of huge data indepth knowledge of ingestion techniques data cleaning dedupe master data management understanding of index design and performance tuning techniques familiarity with SQL security techniques such as data encryption at the column level Transparent Data Encryption (TDE) signed stored procedures and assignment of user permissions. Experience in understanding the source data from various platforms and mapping them into Entity Relationship Models (ER) for data integration and reporting. Exposure to source control like GIT Azure DevOps understanding of Agile methodologies (Scrum Kanban) experience with automated testing and coverage tools and experience with CICD automation tools desirable. Programming language experience in Golang is desirable.
Requirements
- 5 years of relevant experience
- Expert knowledge in PostgreSQL Snowflake DBT and ETL
- Competence in data preparation and/or ETL tools
- Strong programming experience in SQL
- Familiarity with cloud offerings such as AWS Azure or GCP
- Experience with Agile methodologies
- Exposure to source control like GIT Azure DevOps
- Experience with automated testing and coverage tools
Job Role: Snowflake With PostgreSQL Professionals Location: Hyderabad/Noida/Gurgaon Years of Experience: 8 - 12 Years Must-Have: The candidate should have 5 years of relevant experience in Snowflake with PostgreSQL Project-specific Prerequisite skills: Snowflake, PostgreSQL, DBT, ETL Detailed JD: We are looking for professionals with expert knowledge in databases like PostgreSQL, preferably cloud-hosted in any one or more cloud offerings such as AWS, Azure, or GCP. The ideal candidate should have strong programming experience in SQL, DBT, competence in data preparation and/or ETL tools to build and maintain data pipelines and flows. Deep knowledge of database stored procedures optimizations of huge data, in-depth knowledge of ingestion techniques, data cleaning, dedupe, master data management, understanding of index design and performance tuning techniques, familiarity with SQL security techniques, such as data encryption at the column level, Transparent Data Encryption (TDE), signed stored procedures, and assignment of user permissions. Experience in understanding the source data from various platforms and mapping them into Entity Relationship Models (ER) for data integration and reporting. Exposure to source control like GIT, Azure DevOps, understanding of Agile methodologies (Scrum, Kanban), experience with automated testing and coverage tools, and experience with CICD automation tools desirable. Programming language experience in Golang is desirable. Requirements Requirements: 5+ years of relevant experience Expert knowledge in PostgreSQL, Snowflake, DBT, and ETL Competence in data preparation and/or ETL tools Strong programming experience in SQL Familiarity with cloud offerings such as AWS, Azure, or GCP Experience with Agile methodologies Exposure to source control like GIT, Azure DevOps Experience with automated testing and coverage tools
Education
10+2