ETL Developer
-
Role Overview:
- Validate ETL processes and author detailed ETL specifications.
- Provide guidance and mentorship to technical staff while shaping product vision and supporting various internal and external initiatives.
- Participate in MI report testing within an Agile framework.
- Perform other assigned duties.
- Test multiple modules of MI reporting systems.
- Actively engage in Agile ceremonies, including daily stand-ups, sprint planning, backlog grooming, and retrospective meetings.
Qualifications and Requirements:
-
Basic Requirements
- Bachelor s degree in Computer Science, Mathematics, Engineering, or a related field, with at least 8 years of relevant experience in a training-related field. A Master s or Doctorate degree may substitute for some experience.
- Ability to secure and maintain a Public Trust clearance (contract requirement)
-
Preferred Skills
- Expertise in writing and testing ETL specifications.
- Strong background in validating ETL processes and database integration.
- Proficiency in SQL, DB2, Oracle 19c, PostgreSQL, and flat file data extraction.
- Skilled in testing ETL applications and writing scripts using Oracle PL/SQL, PostgreSQL, and Linux.
- Experience scripting in Linux to automate ETL workflows and data migrations.
- Solid understanding of when to use plain SQL versus PL/SQL.
- Capability to design and develop test strategies based on Business Requirement Documents (BRDs).
- Strong communication and teamwork skills.