Mid-Level Databricks/Informatica Data Engineer

Eliassen Group is recruiting for an unnamed client seeking a Mid-Level Databricks/Informatica Data Engineer. The role supports enterprise data modernization, cloud migration, analytics, and integration by building scalable data pipelines, developing ETL/ELT solutions, and supporting cloud-based data platforms.

Responsibilities

• Design, develop, and maintain enterprise ETL/ELT pipelines using Informatica PowerCenter and/or Informatica Intelligent Cloud Services (IICS)
• Build and optimize Databricks notebooks, workflows, and data pipelines for large-scale data processing
• Develop and support data ingestion frameworks from structured and unstructured data sources
• Implement data transformations, cleansing, enrichment, and validation processes
• Create scalable solutions using PySpark, Spark SQL, and Delta Lake
• Collaborate with business stakeholders, data architects, analysts, and application teams to define data requirements
• Troubleshoot and resolve data integration, performance, and data quality issues
• Support migration from legacy data warehouses and ETL platforms to modern cloud-based architectures
• Develop and maintain technical documentation, data mappings, and operational runbooks
• Participate in Agile development activities including sprint planning, code reviews, and deployments

Preferred

• Snowflake, Microsoft Fabric, Azure Synapse, or Redshift
• Experience in AWS, Azure, or Google Cloud environments
• Knowledge of Delta Lake, Medallion Architecture, and Data Lakehouse concepts
• Informatica and/or Databricks certifications
• CI/CD pipelines, Git, Azure DevOps, or GitHub
• Experience supporting Federal Government, DoD, DHS, or other regulated environments
• Active Public Trust or Security Clearance preferred
• 5-8 years of overall IT experience and experience designing end-to-end enterprise data platforms
• Experience supporting reporting, analytics, AI/ML, and business intelligence workloads
• 5-8 years of overall IT experience and experience designing end-to-end enterprise data platforms.
• Snowflake
• Microsoft Fabric
• Azure Synapse
• Amazon Redshift
• AWS
• Microsoft Azure
• Google Cloud
• Delta Lake
• Medallion Architecture
• Data Lakehouse
• Informatica
• CI/CD Pipelines
• Git
• Azure DevOps
• GitHub
• Federal Government Experience
• Regulated Environment Experience
• Enterprise Data Platform Design
• Reporting Workloads
• Analytics Workloads
• AI/ML Workloads
• Business Intelligence Workloads

Benefits

• Remote work
• Medical benefits
• Dental benefits
• Vision benefits
• 401k with company matching
• Life insurance

Company

• Strategic consulting in technology, business advisory, and life sciences.
• North Reading, Massachusetts, USA
• http://www.eliassen.com/
• Founded in 1989
• 1001-5000 employees

Qualifications

• applicants must be willing and able to work on a w2 basis
• 5+ years of experience in data engineering, ETL development, or data warehousing
• 3+ years of experience with Databricks, Apache Spark, or cloud-based analytics platforms
• 3+ years of experience with Informatica PowerCenter, Informatica IICS, or Informatica Cloud
• Strong SQL development and performance tuning experience
• Experience designing and implementing enterprise-scale data integration solutions
• Understanding of dimensional modeling, data warehousing, and master data management concepts
• Strong analytical, troubleshooting, and communication skills
• Bachelor's degree in Computer Science, Information Systems, Engineering, or related field
• Applicants must be willing and able to work on a w2 basis
• Snowflake, Microsoft Fabric, Azure Synapse, or Redshift
• Experience in AWS, Azure, or Google Cloud environments
• Knowledge of Delta Lake, Medallion Architecture, and Data Lakehouse concepts
• Informatica and/or Databricks certifications
• CI/CD pipelines, Git, Azure DevOps, or GitHub
• Experience supporting Federal Government, DoD, DHS, or other regulated environments
• Active Public Trust or Security Clearance preferred
• 5-8 years of overall IT experience and experience designing end-to-end enterprise data platforms
• Experience supporting reporting, analytics, AI/ML, and business intelligence workloads
• 5+ years of experience in data engineering, ETL development, or data warehousing.
• 3+ years of experience with Databricks, Apache Spark, or cloud-based analytics platforms.
• 3+ years of experience with Informatica PowerCenter, Informatica IICS, or Informatica Cloud.

Required skills

• Apache Spark, Cloud Platforms AWS, Cloud Platforms Azure, Cloud Platforms Google Cloud, Data Warehousing, Databricks, Delta Lake, Dimensional Modeling, ETL Development, Enterprise Data Integration, Informatica Intelligent Cloud Services (IICS), Informatica PowerCenter, Master Data Management, SQL

Preferred skills

• Active Public Trust or Security Clearance preferred, CI/CD pipelines, Git, Azure DevOps, or GitHub, Experience in AWS, Azure, or Google Cloud environments, Informatica and/or Databricks certifications, Snowflake, Microsoft Fabric, Azure Synapse, or Redshift

Experience

• 5+ years