Data Engineer (Hadoop + Snowflake)Job Description-
Data Engineer
Engineer will be part of the datastore-migration Factory team that will be responsible to perform for the end-to end datastore migration from on-prem DataLake to AWS hosted LakeHouse. This is a high visibility and crucial project for Goldman Sachs.
Responsibilities of the Engineer include:
1. Pipeline Migration
a. Logic & Scheduling: Refactoring and migrating extraction logic and job scheduling from legacy frameworks to the new Lakehouse environment.
b. Data Transfer: Executing the physical migration of underlying datasets while ensuring data integrity.
c. Stakeholder Engagement: Acting as a technical liaison to internal clients, facilitating "hand-off and sign-off" conversations with data owners to ensure migrated assets meet business requirements.
2. Consumption Pattern Migration
a. Code Conversion: Translating and optimizing legacy SQL and Spark-based consumption patterns (raw and modeled) for compatibility with Snowflake and Iceberg.
b. Usage analysis: Understand usage patterns to deliver the required data products.
c. Stakeholder Engagement: Acting as a technical liaison to internal clients, facilitating "hand-off and sign-off" conversations with data owners to ensure migrated assets meet business requirements.
d. Data Reconciliation & Quality
3. A rigorous approach to data validation is required. Candidates must work with reconciliation frameworks to build confidence that migrated data is functionally equivalent to that already used within production flows.
Engineer will also need to work with internal data management platforms team and must have an aptitude for learning new workflows and language constructs as necessary.
Technical Stack Requirements: While candidates are not expected to be experts in every tool, the collective team must cover the following technologies:
Extraction & Logic: Kafka, ANSI SQL, FTP, Apache Spark
Data Formats: JSON, Avro, Parquet
Platforms: Hadoop (HDFS/Hive), Snowflake, Apache Iceberg, Sybase IQ
Share your resume over Aa***********a@Co****e.Com

Keyskills: Snowflake Hadoop SQL Parquet Kafka Sybase IQ JSON Apache iceberg AVRO Apache Spark Ansi Sql