Proficient in SQL with extensive expertise in handling structured semistructured and unstructured data.
Strong familiarity with data modeling techniques including Star Schema Snowflake Data Vault and Domainbased data models. Comprehensive understanding of data normalization and denormalization principles.
Experience utilizing data modeling tools such as Erwin ER/Toad Studio or equivalent software.
Demonstrated knowledge of data lakes and handson experience in cloud migration projects particularly with AWS Azure or GCP.
Preferred experience in NoSQL databases Spark SQL leveraging AWS Glue and columnar data stores.
Understanding of data security features such as data masking encryption rolebased access control and finegrained access control mechanisms.
Familiarity with Business Intelligence (BI) tools and their integration with enterprisewide Curated Data Mart and Data Lake environments.
aws glue,data security features,data modeling,erwin,azure,er/toad studio,data de-normalization,sql,nosql databases,sql developer data modeler,data normalization,gcp,spark sql,business intelligence (bi),aws