Jr Data Engineer jobs in United States
cer-icon
Apply on Employer Site
company-logo

Halvik ยท 5 hours ago

Jr Data Engineer

positionWashington, DC
timeFull-time
remoteOnsite
seniorityNew Grad, Entry Level
money$100K/yr - $110K/yr

Halvik Corp delivers a wide range of services to various executive and independent agencies, specializing in Digital Services and Advanced Analytics. They are seeking a Junior Data Engineer to analyze workflows, convert mappings into Databricks pipelines, and support data migration efforts.

DevOpsInformation ServicesSoftware
check
H1B Sponsor Likelynote

Responsibilities

Analyze Informatica workflows and mappings to understand source-to-target logic, transformations, dependencies, and scheduling order
Convert Informatica mappings into Databricks pipelines using PySpark / Spark SQL
Implement data ingestion from on-prem and cloud sources into Databricks (landing bronze silver)
Adapt existing ETL logic to align with a new enterprise data model, identifying gaps and required transformation changes
Support unit testing, reconciliation, and data validation between legacy and modern pipelines
Document migration logic, assumptions, and deviations from legacy behavior
Collaborate with senior engineers, data architects, and QA teams during iterative migration cycles

Qualification

Informatica PowerCenterDatabricksSQLETL / ELT conceptsData ModelingAttention to detailCollaborationProblem-solvingCommunication

Required

Working knowledge of Informatica PowerCenter: Mappings, workflows, sessions
Common transformations (Source Qualifier, Expression, Lookup, Joiner, Aggregator, Router, Filter)
Basic to intermediate experience with Databricks: PySpark, Spark, SQL, Notebooks and jobs
Strong SQL fundamentals (joins, aggregations, window functions)
Understanding of ETL / ELT concepts, data warehousing, and batch processing Data Modeling Analysis Skills
Interpret legacy data models and mapping documents
Identify how legacy fields map (or do not map) to a new target data model
Flag missing logic, derived fields, or transformation gaps early
Strong attention to detail when validating row counts, aggregates, and business rules

Preferred

Exposure to Informatica-to-Databricks migration or similar modernization efforts
Familiarity with Delta Lake, medallion architecture (Bronze / Silver / Gold)
Basic understanding of AWS (S3, IAM concepts)
Experience reading or generating code from Informatica XML exports
Bachelor's Degree in a related area or equivalent experience

Benefits

Company-supported medical, dental, vision, life, STD, and LTD insurance
11 federal holidays and PTO
Eligible employees may receive performance-based incentives in recognition of individual and/or team achievements.
401(k) with company matching
Flexible Spending Accounts for commuter, medical, and dependent care expenses
Tuition Assistance
Charitable Contribution matching

Company

Halvik

twittertwitter
company-logo
Halvik provides full end-to-end software and management solutions.
dateFounded in 2007
location
Vienna, Virginia, USA
people-size201-500 employees
web-link
http://www.halvik.com/

H1B Sponsorship

Halvik has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (10)
2024 (7)
2023 (7)
2022 (5)
2021 (5)
2020 (11)

Funding

Current Stage
Growth Stage

Leadership Team

leader-logo
Madhavi Bathula
Chief Executive Officer
linkedin
Company data provided by crunchbase