Senior Data Engineer Job at Techgene Solutions, Alpharetta, GA

bDRYRjA1cTcvWWpxeU1Ta08zOXp3VUE0Unc9PQ==
  • 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

Carondelet Medical Group

Outpatient Neurology Opportunity in Tucson, Arizona! Job at Carondelet Medical Group

 ...Arizonas most comprehensive and collaborative neuroscience teams. Youll work closely with specialists in stroke medicine, functional neurology, epilepsy, and a fully staffed spine, brain, and vascular neurosurgery practiceproviding exceptional continuity of care from... 

AlphaGraphics of Madison-US470

Part time Delivery Driver Job at AlphaGraphics of Madison-US470

 ...immediate hire, AlphaGraphics-Madison is seeking a responsible delivery driver with some bindery assistance needed. Primary...  ...as well as income. Full health and dental benefits for full time employees Are you a high-energy team player? Then we are looking... 

ALife Hospitality Group

Line Cook Job at ALife Hospitality Group

 ...nightlife concepts. Were passionate about great food, memorable experiences, and building...  ...ideal candidate has experience working in fast-paced restaurant environments, takes pride...  ...Strong attention to detail and time management Team-oriented with a positive... 

Total Quality Logistics

Entry Level Recruiter Job at Total Quality Logistics

 ...needs of your dedicated on-site hiring manager. We pride ourselves on our sense of urgency and our ability to drive results. No experience necessary; we will set you up for success with our best-in-class paid training program. Whats in it for you: ~$45,000 per... 

Direct Counsel

Civil  Litigation Associate Attorney Job at Direct Counsel

 ...Litigation Associate Attorney (2-7 Years Experience) Venice Beach, California Direct Counsel is seeking a Litigation Associate Attorney to join a growing and well-regarded litigation firm in Venice, California. This is an excellent opportunity for driven attorneys...