Source description
About the role
Detailed JD (Roles and Responsibilities) Created Analytical layer on the top of operational layer as per business requirement. Created Data pipeline by analyzing operational layer. Performed end to end deployment of the code components using GitHub. Designed and implemented tables, stored procedures and history loads. SQL queries, stored procedures and views. Optimized SQL queries and optimized Bigquery jobs to improve performance and reduced processing costs Experience in data modelling using Erwin data modeler tool. Experience in creating DDL, ERD, Data Dictionary Technologies: Bigquery, GCS, SQL, Data modeling, Github, IAM, Erwin data modeler Created landing layer and flattened layer on the basis of JSON structured data as per business requirement. Designed and implemented tables, stored procedures and history loads. SQL queries, stored procedures and views. Experienced working in agile teams and working independently. Created DDL, ERD, Data dictionary as per business requirements. Designed and optimized complex SQL queries and data models in Bigquery, improving query performance and cost efficiency for large-scale analytics. Total Experience 5-8 Years Mandatory skills BigQuery, DBT, Python, Production Support Domain (Industry) OSS Work Location Pune, Hyderabad Background Check (Before onboarding / After onboarding) Before Onboarding Mode of Interview- Face to Face/Video Interview Face To Face WFO / WFH / Hybrid Hybrid
More at CLIFYX INC