9th Way Insignia
Washington, District of Columbia, United States
9th Way Insignia is a service-disabled, veteran-owned small business bringing transformative technology to our government customers so they can achieve their missions. Our specialties include cybersecurity, cloud modernization, software development, data analytics, enterprise architecture, enterprise IT, analytics, process automation, and artificial intelligence. Learn more about 9th Way Insignia at https://9thwayinsignia.com/.
Overview
9th Way Insignia is looking for a Senior ETL Developer to join the Office of Performance Analysis and Integrity team, which manages and enhances the Veterans Benefits Administration (VBA) Enterprise Data Warehouse (EDW) and related BI capabilities. Responsibilities
Data warehousing, data modeling, data integration, data migration, ETL processes and Business Intelligence Data modeling design, analysis and implementation — conceptual, logical, and physical data modeling, data conversion, data integration and data mining in the area of Data Warehouse and Business Intelligence Installing, configuring, developing, supporting and maintaining BI applications Developing ETLs using Informatica to extract, transform, and load data from OLTP systems to OLAP systems Designing schema using KPIs, facts, dimensions, physical/logical models, alias and extension tables Building data models and establishing relationships and keys between tables Creating LDAP authentication to enable single sign-on for development environment analytics repository Using Informatica Mapping Designer to create/update mappings with required transformations Providing recommendations and identifying critical issues and processing faults related to data modeling, ETLs and Informatica Other responsibilities as assigned Qualifications / Requirements
Master's degree in computer science or other technical discipline (an additional 10 years of experience can substitute for a degree) 15+ years of experience in ETL tools, especially Informatica and data warehousing applications 10+ years’ experience developing and tuning complex SQL queries in Oracle Must be authorized to work for any employer in the U.S. Must be able to obtain and maintain the required security clearance Location
On site in Washington DC. Salary
$118,737 - $150,000 USD Clearance / Background Investigation
Applicants selected will be subject to a security investigation and may need to meet eligibility requirements for access to classified information. Benefits
Eligible employees will have access to our comprehensive benefits package including Medical, Dental, Vision, Voluntary Life Insurance, 401(k), Basic Life A&D, STD, LTD, PTO, Telehealth, paid holidays, FSA, HSA. Additional resources include our Employee Assistance Program (EAP) and Traveling Assistance. Legal
We’re an equal employment opportunity employer that does not discriminate on the basis of protected status under applicable law.
#J-18808-Ljbffr
9th Way Insignia is looking for a Senior ETL Developer to join the Office of Performance Analysis and Integrity team, which manages and enhances the Veterans Benefits Administration (VBA) Enterprise Data Warehouse (EDW) and related BI capabilities. Responsibilities
Data warehousing, data modeling, data integration, data migration, ETL processes and Business Intelligence Data modeling design, analysis and implementation — conceptual, logical, and physical data modeling, data conversion, data integration and data mining in the area of Data Warehouse and Business Intelligence Installing, configuring, developing, supporting and maintaining BI applications Developing ETLs using Informatica to extract, transform, and load data from OLTP systems to OLAP systems Designing schema using KPIs, facts, dimensions, physical/logical models, alias and extension tables Building data models and establishing relationships and keys between tables Creating LDAP authentication to enable single sign-on for development environment analytics repository Using Informatica Mapping Designer to create/update mappings with required transformations Providing recommendations and identifying critical issues and processing faults related to data modeling, ETLs and Informatica Other responsibilities as assigned Qualifications / Requirements
Master's degree in computer science or other technical discipline (an additional 10 years of experience can substitute for a degree) 15+ years of experience in ETL tools, especially Informatica and data warehousing applications 10+ years’ experience developing and tuning complex SQL queries in Oracle Must be authorized to work for any employer in the U.S. Must be able to obtain and maintain the required security clearance Location
On site in Washington DC. Salary
$118,737 - $150,000 USD Clearance / Background Investigation
Applicants selected will be subject to a security investigation and may need to meet eligibility requirements for access to classified information. Benefits
Eligible employees will have access to our comprehensive benefits package including Medical, Dental, Vision, Voluntary Life Insurance, 401(k), Basic Life A&D, STD, LTD, PTO, Telehealth, paid holidays, FSA, HSA. Additional resources include our Employee Assistance Program (EAP) and Traveling Assistance. Legal
We’re an equal employment opportunity employer that does not discriminate on the basis of protected status under applicable law.
#J-18808-Ljbffr