Skip to main content

9th Way Insignia

Expert ETL Developer

Washington, District of Columbia, United StatesFrom $150kmidAdded 1 month ago

About this role

9th Way Insignia seeks an experienced ETL Developer to support the Veterans Benefits Administration's Enterprise Data Warehouse on Oracle infrastructure. This Engineer 3 role involves designing and maintaining complex data integration pipelines, performing data modeling, and ensuring business intelligence capabilities across government systems.

What you'll do

  • Design and develop ETL processes using Informatica to extract, transform, and load data from OLTP to OLAP systems
  • Perform conceptual, logical, and physical data modeling with schema design using facts, dimensions, and KPIs
  • Develop and optimize complex SQL queries in Oracle databases for data warehousing applications
  • Install, configure, and maintain Business Intelligence applications and analytics repository components
  • Identify and resolve critical issues related to data modeling, ETL processes, and Informatica implementations
  • Configure LDAP authentication and implement security controls for analytics environments

What they're looking for

  • Informatica ETL tool expertise
  • Oracle SQL development and optimization
  • Data modeling and warehouse design
  • Data integration and migration
  • Business Intelligence applications
  • Schema design and database architecture
  • Problem-solving and technical troubleshooting
  • LDAP and authentication systems
Apply with Autofill

Opens the application — the Jobs AI extension fills it for you. Set up autofill

Opens the official application on the employer’s site. No login required.

9th Way Insignia

9th Way Insignia builds secure, modernized software applications and data solutions for government clients, specializing in full-stack development, cloud architecture, and enterprise analytics. The company is hiring software developers, ETL developers, and Power BI developers to design and maintain applications, data pipelines, and reporting systems using Agile practices and modern technologies.

View all jobs at 9th Way Insignia

Likely interview questions

  • Walk us through your experience designing and implementing ETL processes using Informatica. What were some of the most complex transformations you've built, and how did you optimize them?
  • Describe your approach to data modeling for a data warehouse. How do you design fact tables, dimensions, and handle slowly changing dimensions?
Unlock all 7 questions free — and practice them live →