GCP Platform Engineer - Python/SQL

<p><p><b>Key Responsibilities : </b></p><p><br/></p><p>- Design, build, and maintain scalable data pipelines and platform solutions on Google Cloud Platform.<br/><br/></p><p>- Develop and manage workflows using Cloud Composer (Apache Airflow).<br/><br/></p><p>- Manage and optimize datasets in BigQuery using complex SQL and PL/SQL logic.<br/><br/></p><p>- Work with Cloud Storage for data ingestion, staging, and archival processes.<br/><br/></p><p>- Create and maintain tables, views, materialized views, and other database objects.<br/><br/></p><p>- Develop and optimize stored procedures and functions for application support.<br/><br/></p><p>- Ensure data quality, integrity, and consistency across systems.<br/><br/></p><p>- Perform query performance tuning using execution plans and best practices.<br/><br/></p><p>- Troubleshoot and resolve database performance issues.<br/><br/></p><p>- Write clean, maintainable, and well-documented Python scripts for automation and orchestration.<br/><br/></p><p>- Collaborate with developers, analysts, and stakeholders to define and deliver robust platform solutions.<br/><br/></p><p>- Document build processes and support materials for deployment and maintenance.<br/><br/></p><p>- Create test/sample data and perform bug fixes as needed.<br/><br/></p><p>- Follow and implement best practices for platform development, data design, and Skills : </b></p><p><br/></p>- 5+ years of hands-on experience with GCP (BigQuery, Cloud Composer, Cloud Storage)<br/><br/></p><p>- Strong SQL/PLSQL skills including : <br/><br/></p><p>- Advanced joins, inline views, correlated queries<br/><br/></p><p>- Use of analytical and arithmetic functions<br/><br/></p><p>- Solid understanding of data warehousing concepts and ETL fundamentals<br/><br/></p><p>- Proficiency in Python programming<br/><br/></p><p>- Ability to read and optimize query execution plans<br/><br/></p><p>- Experience with database performance tuning<br/><br/></p><p>- Good documentation practices for build and deployment processes<br/><br/></p><p>- Strong problem-solving, analytical thinking, and debugging skills</p><p><b><br/></b></p><p><b>Good to Have : <br/></b><br/></p><p>- Experience with Google Dataflow<br/><br/></p><p>- Exposure to CI/CD pipelines<br/><br/></p><p>- Familiarity with data modeling and data governance<br/><br/></p><p>- Prior work in agile environments or DevOps cultures</p><p><br/></p><br/></p> (ref:hirist.tech)