We are seeking a seasoned ETL Engineer to support the design development and maintenance of robust data pipelines that drive largescale federal data initiatives. This role supports remote work but requires attendance at periodic onsite meetings in Washington D.C.
Key Responsibilities:
- Develop and maintain ETL pipelines to transform and load data into Databricks.
- Provide longterm support and enhancement of data pipelines across both data domain stores and a universal data hub.
- Convert existing PL/SQL stored procedures from platforms such as Greenplum and Oracle into Databrickscompatible code.
- Collaborate with analysts data engineers and stakeholders to ensure clean reliable and scalable data flows.
Required Qualifications:
- 6 years of handson experience in ETL development.
- Demonstrated success supporting at least two largescale ETL projects involving Databricks.
- Strong PL/SQL experience particularly with legacy systems like Greenplum Oracle or similar.
- Experience working on data projects for the government preferably for the IRS.
- Bachelors degree in IT Computer Science Engineering or a related field.
Technical Environment Youll Work In:
You will work within a complex hybrid data architecture that includes both cloudbased and onpremise technologies such as:
- Cloud & Databases: AWS RDS (Postgres) AWS Redshift Databricks MongoDB DynamoDB exploring AWS Aurora
- ETL & Integration: Onpremise Informatica Databricks ETL EFTU Informatica Metadata (EDC Axon)
- Data Governance: Immuta
- Analytics & BI Tools: Advanced Analytics Platform (AAP) with AI/ML services Tableau Business Objects (BOE) and Power BI Integration
- Modeling & Development: IBM Rational Suite IBM Data Architect
- Legacy Systems: JCL COBOL for z/OS DB2
Familiarity with any of these technologies is a strong plus.
Work Flexibility:
- Remote work option available.
- Must be able to attend inperson meetings in Washington D.C. as required.
Synectics is an Equal Opportunity Employer. We offer a competitive salary and an impressive full benefits package that includes medical and dental 401k w/company matching companypaid life and short/longterm disability insurance and paid leave. We also provide an environment that supports everyones professional development and growth.