Google Cloud Platform Data Engineer

Required Skills - Google Cloud Platform Services

Nice to have skills - Hive, Impala, Hadoop Administration, BigQuery, Big Data

Job summary

• Data Management -BigQuery big data hive Google Cloud Platform components
• In this role, you will be part of Trane Technologies' Data Engineering team, providing solutions and data to enable Trane Technologies to achieve premier performance.
• As part of a global team, this role provides development expertise in the areas of Extract, Transform and Load (ETL), along with database development on a global data warehouse and reporting environment, including technologies like Big Query, Cloud Composer, Cloudera

Roles & Responsibilities

• Develop ETL and database components independently following specifications, standards, and global best practices
• Develop ETL and database components following standard software development lifecycle.
• Support existing ETLs though break fix and enhancements
• Participate in code reviews to ensure that ETL and database components conform to global standards.
• Effectively communicate issues and manage the issues to resolution
• Work as part of global development team developing ETLs and database components
• Follow standard Software development Lifecycle practices in development of ETL and database objects

Technical Skills

• Experience with Google Cloud Platform (Google Cloud Platform) based Data Analytics tools (Ex: Big Query, Cloud Composer, Data Fusion)
• In-depth knowledge of SQL (plSQL, Hive, Impala, Oracle) and databases
• Experience with Big Data processing frameworks and tools (Cloudera, Sqoop, Hive, Impala, Spark)
• Experience with Informatica and OBIEE
• Experience software development on a team using Agile methodology
• Experience with DevOps tools and techniques (Ex: CI/CD, GitHub, Terraform, Jenkins, etc.)
• Oracle PL/SQL (Required) [ 3 years of Exp]
• Apache Spark (Nice to have) [1 years of Exp]
• Understanding on Business Intelligence Dimensional Modelling, Star Schemas, Slowly Changing Dimensions
• Understanding of ETL process and development
• Develop ETL and database components independently following specifications, standards, and global best practices
• Develop ETL and database components following standard software development lifecycle.
• Support existing ETLs though break fix and enhancements
• Participate in code reviews to ensure that ETL and database components conform to global standards.
• Effectively communicate issues and manage the issues to resolution
• Work as part of global development team developing ETLs and database components
• Follow standard Software development Lifecycle practices in development of ETL and database