onsite
Senior Software Developer - Data Engineering Consultant - Guidehouse
Software Engineer
Senior data engineering consultant designing and extending ETL pipelines with Informatica, Java, and AWS/Databricks lakehouse solutions to deliver high‑quality, analytics‑ready datasets and robust data services.
About the role
Key Responsibilities
- Design, develop, and maintain scalable data ingestion, transformation, and curation pipelines using Informatica and complementary ETL tools.
- Extend legacy ETL workflows into AWS and Databricks lakehouse environments, supporting batch and near‑real‑time ingestion patterns.
- Build and support Java‑based data services, APIs, and integration layers that expose curated data to downstream analytics and reporting.
- Collaborate with data architects and stakeholders to ensure data quality, governance, and performance across the platform.
- Document pipeline logic, data models, and operational procedures for maintainability and compliance.
Requirements
- 5+ years of experience in data engineering, with a strong focus on ETL development.