Senior ETL Testing, Data Engineer
Posted 4hrs ago
Employment Information
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



















