9th Way Insignia
Expert ETL Developer
Washington, District of Columbia, United StatesFrom $150kmidAdded 2 days 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
Opens the official application on the employer’s site. No login required.