9th Way Insignia is looking to enhance the Veterans Benefits Administration (VBA) Enterprise Data Warehouse (EDW) by hiring a Senior ETL Developer to manage and improve its data warehousing, data modeling, data integration, and ETL processes.
Requirements
- 15+ experience in ETL tools, especially Informatica and data warehousing applications
- 10+ years’ experience developing and tuning complex SQL queries in Oracle relational database
Responsibilities
- Data warehousing, data modeling, data integration, data Migration, ETL process and Business Intelligence
- Data Modeling design, analysis and implementation - conceptual, logical, and physical data modeling, data conversion, data integration and data mining specialization in the area of Data Warehouse and Business Intelligence
- Installing, configuring, developing, supporting and maintaining of the BI APPS
- Developing ETL’s using Informatica to facilitate Extraction Transformation and data load from OLTP systems to OLAP systems
- Designing schema using KPIs, Fact, Dimensions, Physical, Logical, Alias and Extension tables
- Building business model and established relationships and foreign keys (physical & logical) between tables
- Using Informatica Mapping Designer to create/update mapping using different transformations required to move data into data warehouse
Other
- Master's degree in computer science or other technical disciplines (an additional 10 years of experience can substitute for a degree).
- Must be authorized to work for any employer in the U.S
- Must be able to obtain and maintain the required security clearance
- On site in Washington DC.
