{"schemaVersion":"jobsearcher.job.v1","id":"f03779e645cf63e25db345b7","url":"https://jobsearcher.com/jobs/f03779e645cf63e25db345b7","canonicalUrl":"https://jobsearcher.com/jobs/f03779e645cf63e25db345b7","title":"Jr Data Engineer","description":"Halvik Corp delivers a wide range of services to 13 executive agencies and 15 independent agencies. Halvik is a highly successful WOB business with more than 50 prime contracts and 500+ professionals delivering Digital Services, Advanced Analytics, Artificial Intelligence/Machine Learning, Cyber Security and Cutting-Edge Technology across the US Government. Be a part of something special!Role And ResponsibilitiesAnalyze Informatica workflows and mappings to understand source-to-target logic, transformations, dependencies, and scheduling order.Convert Informatica mappings into Databricks pipelines using PySpark / Spark SQLImplement 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 changesSupport unit testing, reconciliation, and data validation between legacy and modern pipelinesDocument migration logic, assumptions, and deviations from legacy behaviorCollaborate with senior engineers, data architects, and QA teams during iterative migration cyclesRequired SkillsWorking 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 jobsStrong SQL fundamentals (joins, aggregations, window functions)Understanding of ETL / ELT concepts, data warehousing, and batch processing Data Modeling & Analysis SkillsUnderstand of report development. Data Modeling & Analysis SkillsInterpret legacy data models and mapping documents.Identify how legacy fields map (or do not map) to a new target data modelFlag missing logic, derived fields, or transformation gaps earlyStrong attention to detail when validating row counts, aggregates, and business rulesPreferred SkillsExposure 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 exportsBachelor's Degree in a related area or equivalent experience.Halvik Offers a Competitive Full Benefits Package IncludingCompany-supported medical, dental, vision, life, STD, and LTD insuranceBenefits include 11 federal holidays and PTOEligible employees may receive performance-based incentives in recognition of individual and/or team achievements.401(k) with company matchingFlexible Spending Accounts for commuter, medical, and dependent care expensesTuition AssistanceCharitable Contribution matchingHalvik Corp is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status.Halvik's pay range for this job level is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.","company":"Halvik","rawCompany":"halvik","city":"Oakton","state":"VA","isRemote":false,"isActive":false,"createdAt":"2026-04-15T08:35:02.036Z","occupations":[{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"},{"code":"15-2051.00","title":"Data Scientists","slug":"data-scientists"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"518210","title":"Computing Infrastructure Providers, Data Processing, Web Hosting, and Related Services","slug":"computing-infrastructure-providers-data-processing-web-hosting-and-related-services"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Jr Data Engineer","description":"Halvik Corp delivers a wide range of services to 13 executive agencies and 15 independent agencies. Halvik is a highly successful WOB business with more than 50 prime contracts and 500+ professionals delivering Digital Services, Advanced Analytics, Artificial Intelligence/Machine Learning, Cyber Security and Cutting-Edge Technology across the US Government. Be a part of something special!Role And ResponsibilitiesAnalyze Informatica workflows and mappings to understand source-to-target logic, transformations, dependencies, and scheduling order.Convert Informatica mappings into Databricks pipelines using PySpark / Spark SQLImplement 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 changesSupport unit testing, reconciliation, and data validation between legacy and modern pipelinesDocument migration logic, assumptions, and deviations from legacy behaviorCollaborate with senior engineers, data architects, and QA teams during iterative migration cyclesRequired SkillsWorking 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 jobsStrong SQL fundamentals (joins, aggregations, window functions)Understanding of ETL / ELT concepts, data warehousing, and batch processing Data Modeling & Analysis SkillsUnderstand of report development. Data Modeling & Analysis SkillsInterpret legacy data models and mapping documents.Identify how legacy fields map (or do not map) to a new target data modelFlag missing logic, derived fields, or transformation gaps earlyStrong attention to detail when validating row counts, aggregates, and business rulesPreferred SkillsExposure 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 exportsBachelor's Degree in a related area or equivalent experience.Halvik Offers a Competitive Full Benefits Package IncludingCompany-supported medical, dental, vision, life, STD, and LTD insuranceBenefits include 11 federal holidays and PTOEligible employees may receive performance-based incentives in recognition of individual and/or team achievements.401(k) with company matchingFlexible Spending Accounts for commuter, medical, and dependent care expensesTuition AssistanceCharitable Contribution matchingHalvik Corp is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status.Halvik's pay range for this job level is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.","datePosted":"2026-04-15T08:35:02.036Z","dateModified":"2026-04-15T08:35:02.036Z","hiringOrganization":{"@type":"Organization","name":"Halvik","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Oakton","addressRegion":"VA","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"f03779e645cf63e25db345b7"},"url":"https://jobsearcher.com/jobs/f03779e645cf63e25db345b7"}}