Healthcare Domain
* Total industry experience between 10+ years
* Experience in building engineering pipelines
* Demonstrate Strong PL/SQL skills/snowflake SQL implementing complex stored procedures and best practices with data warehouse and ETL concepts
1. Building engineering pipelines.
2. Strong understanding of RDBMS concepts, Entity and Relationships, Able to define all SCD type & have an implementation approach towards it.
3. Ability to do orchestration within Snowflake by using Tasks/Streams/Identify CDCs.
4. PL/SQL strong understanding of various kind of JOINs, stored procedures, UDFs, CTEs.
5. Concepts of building nested views in PL/SQL.
6. Ability to fine tune a code & do performance improvement in PL/SQL.
7. Understanding of Snowflake architecture/objects(including new ones which they have introduced).
8. In Snowflake concepts of processing of structured/semi structured data should be clear.