Looking for local to TX || AWS Data Engineer (Snowflake, Kafka & Data Lake) (12+ years) || Genpact || Dallas, TX (Onsite) || Contract

[Deepak Singh]

Greetings,

Hope you are doing well!

We are looking for an AWS Data Engineer. Below is the job description for your reference, please have a look and share the best level of your interest.

Role: AWS Data Engineer (Snowflake, Kafka & Data Lake) (12+ years)

Client: Genpact

End Client: Goldman Sachs

Location: Dallas, TX (Onsite)

Type: Contract

Job Description:

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:

• Pipeline Migration Logic & Scheduling: Refactoring and migrating extraction logic and job scheduling from legacy frameworks to the new Lakehouse environment.
• Data Transfer: Executing the physical migration of underlying datasets while ensuring data integrity.
• 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.

1. Consumption Pattern Migration
2. Code Conversion: Translating and optimizing legacy SQL and Spark-based consumption patterns (raw and modeled) for compatibility with Snowflake and Iceberg.
3. Usage analysis: Understand usage patterns to deliver the required data products.
4. 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.
5. Data Reconciliation & Quality - 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 Skills:

• Basic Qualifications Education: Bachelor’s or Masters in Computer Science, Applied Mathematics, Engineering, or a related quantitative field.
• Experience: Minimum of 3-5 years of professional "hands-on-keyboard" coding experience in a collaborative, team-based environment. Ability to trouble shoot (SQL) and basic scripting experience.
• Languages: Professional proficiency in Python or Java.
• Methodology: Deep familiarity with the full Software Development Life Cycle (SDLC) and CI/CD best practices & K8s deployment experience
• Core Data Engineering Competencies: Candidates must demonstrate a sophisticated understanding of the following modeling concepts to ensure data correctness during reconciliation: Temporal Data Modeling: Managing state changes over time (e.g., SCD Type 2).
• Schema Management: Expertise in Schema Evolution (Ref: Iceberg Apache) and enforcement strategies.
• Performance Optimization: Advanced knowledge of data partitioning and clustering.
• Architectural Theory: Balancing Normalization vs. Denormalization and the strategic use of Natural vs. Surrogate Keys.
• 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

Core Competencies:

• Demonstrates strong integrity and consistently models good conduct and ethical decision-making.
• Acts as a trusted team player who collaborates effectively across multiple teams and functions.
• Communicates with clarity and confidence - concise written updates, structured verbal briefings, and proactive stakeholder management.
• Works effectively with global teams across time zones and cultures; builds alignment and resolves issues constructively.
• Delivery-focused with a strong sense of ownership; drives work to closure and meets commitments.
• Brings high energy and urgency to achieve targets while maintaining quality and professionalism.
• Shows intellectual curiosity; asks thoughtful questions, surfaces risks early, and seeks feedback to continuously improve.

--

Regards,

Deepak Singh

Technical Team Lead

Email: Dsr.itr...@gmail.com

LinkedIn: www.linkedin.com/in/deepak-singh-rajput-8a7b6a21a/

221 River St 9^th floor Hoboken, NJ 07030