Strong understanding of best practices in data warehousing and ETL concepts.
Strong understanding of RDBMS concepts, Entity and Relationships, able to define all SCD types & have an implementation approach towards it.
Ability to do orchestration within Snowflake by using Tasks/Streams/Identify CDCs.
Ability to fine-tune code and do performance tuning in PL/SQL.
Experience loading and processing structured and semi-structured data in Snowflake.
Strong understanding of various kinds of SQL JOINs, stored procedures, UDFs, and CTEs.
Experience with building nested views in Snowflake.
Best Regards, Saud Ahmad Account Manager| SYSMIND, LLC
Direct:lt;/p> Phone: x 4019 Email: Website: sysmind.com Address: 38 Washington Road, Princeton Junction, NJ 08550
SYSMIND LLC is an Equal Employment Opportunity employer. All qualified applicants will receive consideration for employment without any discrimination. We promote and support a diverse workforce at all levels in the company. All job offers are contingent upon completion of a satisfactory background check and reference checks. Additionally passing the drug test may also be required. All contractors intending to work on SYSMIND's W2 are "at will" employees.