Description:
RemoteOur 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. Due to client requirements, applicants must be willing and able to work on a w2 basis. For our w2 consultants, we offer a great benefits package that includes Medical, Dental, and Vision benefits, 401k with company matching, and life insurance.
Rate: $65.00 to $80.00/hr. w2JN -092026-108628
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 related field.
