Senior ETL Testing, Data Engineer

Posted 4hrs ago

Employment Information

Education
Salary
Experience
Job Type

Report this job

Job expired or something wrong with this job?

Job Description

Senior ETL/Data Engineer building and testing scalable GCP data pipelines. Developing cloud data warehouses, automation, and CI/CD integrations for an IT services organization.

Responsibilities:

  • Design and implement scalable ETL and ELT processes utilizing GCP services such as BigQuery, Cloud Dataflow, and Cloud Data Fusion
  • Manage and orchestrate data workflows using Cloud Composer (Apache Airflow) to ensure seamless data movement and processing
  • Develop and maintain data warehousing solutions across Snowflake, Oracle, Teradata, and various SQL databases
  • Write efficient, high-performance code in Java and Python to handle complex data transformations and logic
  • Construct advanced SQL queries involving window functions, CTEs, and complex joins to extract and manipulate data
  • Establish and enforce testing protocols, including source-to-target reconciliation, schema validation, and regression testing
  • Integrate data pipelines into CI/CD workflows using Jenkins, Git, and GCP Cloud Build to streamline deployment and version control
  • Collaborate within an Agile environment using Jira and Confluence to track progress, manage defects, and document technical specifications
  • Utilize Informatica PowerCenter and Talend for enterprise-level data integration tasks

Requirements:

  • 5 to 10 years of professional experience in data engineering, ETL testing, or related fields
  • Proven proficiency with Google Cloud Platform (GCP) services, specifically BigQuery, Cloud Storage, and Cloud Composer
  • Strong command of relational and NoSQL databases, including PostgreSQL, MySQL, Cloud SQL, Cloud Spanner, Oracle, and Snowflake
  • Advanced skills in Java (JDBC, Apache Beam SDK) and Python (Pandas, PyTest)
  • Expert-level knowledge of SQL, including complex joins, window functions, and PL/SQL
  • Hands-on experience with testing frameworks like TestNG, JUnit, and BDD Cucumber, along with data-driven testing methodologies
  • Familiarity with CI/CD pipelines, Git, GitHub, Maven, and defect tracking systems like Jira and HP ALM
  • Must be available for remote work