9th Way Insignia · 4 weeks ago
Senior ETL Developer
Washington, District of Columbia, United States
Full-time
Onsite
Senior Level, Lead/Staff
$119K/yr - $150K/yr
15+ years exp9th Way Insignia is a service-disabled, veteran-owned small business focused on providing transformative technology for government customers. The Senior ETL Developer will be responsible for data warehousing, data integration, and developing ETL processes using Informatica to support the Veterans Benefits Administration's Enterprise Data Warehouse.
AnalyticsInformation TechnologySoftware
No H1B
Security Clearance RequiredU.S. Citizen Only
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
Creating LDAP authentication to enable single-sign on for users in development environment leveraging analytics repository
Using Informatica Mapping Designer to create/update mapping using different transformations required to move data into data warehouse
Providing recommendations and identifying critical issues and processing faults as it pertains to data modeling, ETLs and Informatica
Other responsibilities as assigned
Qualification
Required
Master's degree in computer science or other technical disciplines (an additional 10 years of experience can substitute for a degree)
15+ experience in ETL tools, especially Informatica and data warehousing applications
10+ years' experience developing and tuning complex SQL queries in Oracle relational database
Must be authorized to work for any employer in the U.S
Must be able to obtain and maintain the required security clearance
Benefits
Medical
Dental
Vision
Voluntary Life Insurance
401(k)
Basic Life A&D
STD
LTD
PTO
Telehealth
Paid holidays
FSA
HSA
Employee Assistance Program (EAP)
Traveling Assistance
Company
9th Way Insignia
9th Way Insignia is a service-disabled veteran-owned small business (SDVOSB) that provides results-oriented technical solutions to the federal government.
51-200 employees
Funding
Current Stage
Growth StageLeadership Team
Steve Ikirt
Chief Executive Officer
Philip Vincenzes
Chief Technology Officer
Company data provided by crunchbase