JD:

Mandate skill:SQL, PL/SQL, AWS S3, AWS glue, AWS Lambda, snowflake, DBT, ETL

Relevant experience 2 to 3 years

Strong SQL and related skills. Ability to develop and implement complex procedures and packages using PL/SQL

Strong knowledge of SQL, Relational Database Management Systems like Oracle, DB2 and SQL Server

Designing and implementing Informatica PowerCenter mappings

Proficient in SQL and familiar with ETL processes

Experience with data modeling and cloud computing environments

Knowledge in Snowflake features like Time Travel and Zero-Copy Cloning

Fair understanding of data migration and optimization within Snowflake

Proven ability to work creatively and analytically in a problem-solving environment

Understand automated processes for building, testing (integration, SIT & UAT Support), documenting, and deploying at scale

Design, develop, and maintain scalable data models and transformations using DBT in conjunction with Snowflake, ensure the effective transformation and load data from diverse sources into data warehouse or data lake

Implement and manage data models in DBT, guarantee accurate data transformation and alignment with business needs.