We are seeking a seasoned ETL Engineer to support the design, development, and maintenance of robust data pipelines that drive large-scale 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 long-term 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 Databricks-compatible code.
• Collaborate with analysts, data engineers, and stakeholders to ensure clean, reliable, and scalable data flows.

Required Qualifications:

• 6+ years of hands-on experience in ETL development.
• Demonstrated success supporting at least two large-scale 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.
• Bachelor's degree in IT, Computer Science, Engineering, or a related field.

Technical Environment You'll Work In:

You will work within a complex hybrid data architecture that includes both cloud-based and on-premise technologies, such as:

• Cloud & Databases: AWS RDS (Postgres), AWS Redshift, Databricks, MongoDB, DynamoDB, exploring AWS Aurora
• ETL & Integration: On-premise 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 in-person 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, company-paid life and short/long-term disability insurance, and paid leave. We also provide an environment that supports everyone's professional development and growth.