Senior Data Engineer Job at Techgene Solutions, Alpharetta, GA

MGV1RkJtdnRWMHR0eWxBSGN1ZGkrVWpTVUE9PQ==
  • Techgene Solutions
  • Alpharetta, GA

Job Description

Position: Senior Data Engineer (PySpark + Databricks + Oracle/PostgreSQL Migration)

Location: 5800 Windward Parkway, Alpharetta, GA 3000 (Only Locals) 3 Days onsite

Job type: Contract

Exp Level: Min 9+ Years

  • Expert-level proficiency in PySpark and Databricks.
  • Primary Skill Focus: PySpark, Databricks (Hands-on coding test expected)

Skills Required:

1. RDBMS Expertise:

  • Strong hands-on experience with Oracle and PostgreSQL databases.
  • Deep understanding of database architecture, design, indexing, and performance tuning.
  • Expert-level SQL skills: queries, stored procedures, functions, triggers, and views.

2. Database Migration

  • Proven experience in end-to-end database migration projects (preferred: Oracle → PostgreSQL).
  • Strong ability to perform data mapping, transformation, validation, and reconciliation.
  • Experience using migration tools, scripts, and automation frameworks.

3. Data Engineering & Analysis

  • Advanced proficiency in Databricks for large-scale data processing.
  • Expert in PySpark and Python for data transformation and analytics.
  • Ability to build, enhance, and optimize complex ETL/ELT data pipelines.

4. Job Scheduling & Automation

  • Experience creating and maintaining Databricks jobs for scheduled reporting.
  • Familiarity with workflow orchestration tools (Airflow, ADF, Step Functions, etc.).

5. Performance Optimization

  • Strong background in performance tuning for Oracle and PostgreSQL.
  • Experience with index strategies, query optimization, execution plan analysis, and caching.

6. Cloud Platforms

  • Good understanding of AWS Cloud, including RDS, S3, EMR, Lambda, Glue, or similar services.

Job Tags

Contract work, Local area,

Similar Jobs

Hays

Project Manager - Custom Homes Job at Hays

I am working with a multiple award-winning Custom Homes GC who has been setting the standard in luxury homebuilding for 50 years. They build jaw-dropping projects in San Diego, LA, Orange County, Las Vegas, and Palm Desert and collaborate with the areas most elite ...

Blue Chip Casino Hotel Spa

Signature Bartender Job at Blue Chip Casino Hotel Spa

Company Description Boyd Gaming Corporation has been successful in gaming jurisdiction in which we operate in the United States and is one of the premier casino entertainment companies in the United States. Never content to rest upon our successes, we will continue to...

RPC Company

Outside Sales Representative Job at RPC Company

&##128680; Were Hiring: Outside Sales Representative | Construction Access Solutions &##128679;&##128205; San Francisco| &##128338; Full-Time | Are you a driven, solutions-focused sales professional with experience in the construction industry? We're looking for a high... 

Pyramid Consulting, Inc

Registered Nurse (RN) - Acute Care Job at Pyramid Consulting, Inc

 ...Immediate need for a talented Registered Nurse (RN) Acute Care. This is a Full Time...  ...Responsibilities; Deliver safe, high-quality acute care using the nursing process and...  ...patient safety initiatives, quality improvement, and compliance standards Participate... 

Edri Construction San Francisco

Kitchen and bathroom showroom assistant Job at Edri Construction San Francisco

Showroom 707 San Francisco, CA Job Opening: Kitchen & Bath Showroom assistant Pay Range: $28.00 $40.00 per hour (DOE) Schedule: Monday Friday, 10:00 AM 3:00 PM Job Type: Part-Time | In-Person About Showroom 707 Showroom 707 is a boutique kitchen...