Job description:
Proficient on SQL, PL/SQL scripts: stored procedures, functions, views etc to implement the business logic.
Well versed in Enterprise Data Modelling (Dimension & Relational) with a strong understanding of the Data modelling concept like Star-Schema Modelling, Snowflake’s modelling, and fact and dimension tables modelling of data.
Hands-on Experience in data models for relational schema (OLTP) and dimensional schema (OLAP) with proper normalization and de-normalization techniques.
Extensive exposure in Data Modelling, EDA, ETL/ELT, SQL programming, Descriptive Analytics process automation; change data capture (CDC), slowly changing dimension (SCD), Reporting, and performance tuning.
Experience in ETL tool like Talend
Experienced in LINUX work environment, file transfers, job scheduling and process flow control.
Knowledge of distributed computing system like Elastic search, Kafka, and Pyspark.
Experience level: Engineering graduate with 1-3 years of relevant experience. .
]]>
