GCP Database Developer

  • Pune
  • Exl
Experience - 6-10 Years Location - Pune (Hybrid) We are looking for a GCP Developer who can design, develop, test and deploy a series of new data pipelines, data models and optimized reporting views aggregated into various time and organization ‘buckets’ Responsibilities: Design, build, test and deploy Google Cloud data models and transformations in BigQuery, Data fusion environment (e.g. SQL, stored procedures, indexes, clusters, partitions, triggers, etc.) Optimize data views for specific visualization use cases making use of schema design partitions, indexes, down-sampling, archiving, etc. to manage trade-offs such as performance and flexibility. Protect the solution with appropriate Authorization and Authentication models, data encryption and other security components. Review and refine, interpret and implement business and technical requirements Ensure you are part of the on-going productivity and priorities by refining User Stories, Epics and Backlogs in Jira Manage code artefacts and CI/CD using tools like Git, Jenkins, Google Secrets Manager, etc. Estimate, commit and deliver requirements to scope, quality, and time expectations Deliver non-functional requirements, IT standards and developer and support tools to ensure our applications are a secure, compliant, scalable, reliable and cost effective Write well-commented, maintainable and self-documenting code Fix defects and provide enhancements during the development period and hand-over knowledge, expertise, code and support responsibilities to support team Must-Have Skills: Expert in database design - both relational and dimensional data models (and preferably Data Vault) in Google BigQuery or similar Cloud technology. Proven recent experience developing, refactoring, optimization of SQL/T-SQL. Expertise in Administration and Development of On-prem or Cloud Databases, Warehouses and Lakes. Data preparation, wrangling and refactoring skills, for example as part of a Data Science pipelines Expert in the preparation, usage, visualization and editing of data in web, dashboard or other user interfaces (3-tier architecture, CRUD procedures, etc.) Excellent understanding of GCP Architecting and solution design. Excellent knowledge of devops tools like Ansible, Jenkins, Github ,Puppet, Chef etc. IT methodology/procedural knowledge; Agile/Scrum, DevOps and ITIL principles. BS/MS degree in Computer Science, Engineering or a related subject. Excellent communication and interpersonal skills in English. Proficiency in verbal, listening and written English is crucial. Enthusiastic willingness to rapidly and independently learn and develop technical and soft skills as needs require. Strong organizational and multi-tasking skills. Good team player who embraces teamwork and mutual support. Interested in working in a fast-paced environment. Good to Have Skills: Experience with application monitoring & Production Support. Broad experience with IT development and collaboration tools. An understanding of IT Security and Application Development best practice. Understanding of and interest in various investment products and life cycle and the nature of the investment banking business. Working in a global team with different cultures.