Data Engineer - ETL/SQL

Key Responsibilities :

- Develop, test, and maintain ETL SQL code including stored procedures and views.

- Build and schedule jobs in Autosys to orchestrate data workflows.

- Design, implement, and enhance EDF jobs that move data through modules such as Data Processing Pipeline (D2P), Data Control and Anomaly Detection Framework (DCAF), and GeneralPurpose Data Reconciliation (GPR).

- Extract data from flat files and REST APIs, transform it per business rules, and load it into target platforms (Data Lake or Snowflake).

- Collaborate with source system owners and data consumers to ensure data quality, reliability, and performance.

- Provide documentation and support for production issues and ongoing pipeline improvements.

Required Skills :

- Strong SQL coding expertise; experience with DBeaver or similar SQL client tools.

- Handson experience with Autosys job scheduling.

- Proficiency in building and maintaining ETL processes (stored procedures, views).

- Ability to work with flat file formats and consume data via REST APIs.

- Familiarity with data lake concepts and Snowflake cloud data warehouse.