Mid-Level Databricks/Informatica Data Engineer

Remote. Our client seeks a Mid‑Level Databricks/Informatica Data Engineer to support enterprise data modernization, cloud migration, analytics, and integration initiatives. The role involves building scalable data pipelines in Databricks, developing ETL/ELT solutions with Informatica, and supporting cloud‑based data platforms that enable business intelligence, reporting, and advanced analytics. Applicants must be willing and able to work on a W‑2 basis.

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.

Experience Requirements

• 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.
• Preferred: Snowflake, Microsoft Fabric, Azure Synapse, or Redshift.
• Preferred: Experience in AWS, Azure, or Google Cloud environments.
• Preferred: Knowledge of Delta Lake, Medallion Architecture, and Data Lakehouse concepts.
• Preferred: Informatica and/or Databricks certifications.
• Preferred: CI/CD pipelines, Git, Azure DevOps, or GitHub.
• Preferred: Experience supporting Federal Government, DoD, DHS, or other regulated environments; active Public Trust or Security Clearance preferred.
• Desired: 5‑8 years of overall IT experience and experience designing end‑to‑end enterprise data platforms.
• Desired: Experience supporting reporting, analytics, AI/ML, and business intelligence workloads.

Education Requirements

Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field.

Benefits

• Medical, Dental, and Vision coverage
• 401(k) with company matching
• Life insurance

Pay

Rate: $65.00 to $80.00 per hour (W‑2).