Job Title - | FSORC | HSBC | Big Query, DBT, Python, Production Support
Total Exp - 5-8 yearsRelevant Exp - 5-8 yearsWork Location - Pune, Hyderabad Hybrid
Key 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.
