ETL Solutions Specialist

2 days ago


Pasco, Washington, United States 9th Way Solutions Full time
About the Team

Our team is responsible for managing and enhancing the Veterans Benefits Administration (VBA) Enterprise Data Warehouse (EDW), which resides on one Oracle M8 Supercluster database and thirteen application servers.

Job Description

The Senior ETL Developer will work collaboratively with the team to design, develop, and implement complex ETL processes using Informatica to support data warehousing and business intelligence applications.

Key Responsibilities
  • Design, develop, and implement ETL processes using Informatica to extract, transform, and load data from OLTP systems to OLAP systems.
  • Develop and maintain complex SQL queries in Oracle relational database to support data warehousing and business intelligence applications.
  • Collaborate with data modelers to design and implement data warehouse schema using KPIs, fact, dimensions, physical, logical, alias, and extension tables.
Requirements
  • Bachelor's degree in computer science, electronic engineering, or other engineering technical discipline (8 years of additional relevant experience may be substituted for degree).
  • 5+ years' experience in ETL tools, especially Informatica, and data warehousing applications.
  • 5+ years' experience developing and tuning complex SQL queries in Oracle relational database.
  • Able to obtain and maintain the required security clearance.
What We Offer

Competitive salary range $94,990 - $99,000 USD per year, comprehensive benefits package, and opportunities for career growth and professional development.



  • Pasco, Washington, United States 9th Way Solutions Full time

    About the JobThe Senior ETL Developer will be responsible for designing, developing, and implementing complex ETL processes using Informatica to support data warehousing and business intelligence applications.Key Skills and QualificationsStrong knowledge of ETL tools, especially Informatica, and data warehousing applications.Experience with data modeling,...


  • Pasco, Washington, United States 9th Way Solutions Full time

    Job OverviewWe are seeking a highly skilled Senior ETL Developer to join our team in Washington DC. The ideal candidate will have 5+ years of experience in ETL tools, especially Informatica, and data warehousing applications.About the RoleThis is a challenging opportunity for a seasoned ETL professional to lead the development and implementation of complex...


  • Pasco, Washington, United States Diverse Lynx Full time

    Diverse Lynx LLC is seeking a skilled ETL Solutions Developer to join their team. With a base salary of $115,000 - $130,000 per year, this role offers a competitive compensation package.About the RoleThis position involves designing and developing ETL jobs and data pipelines, as well as supporting enterprise data warehouse solutions leveraging Teradata and...


  • Pasco, Washington, United States Remitly Full time

    Data Analytics for Global ImpactRemitly is a leader in international payments and remittances, with a mission to transform the lives of immigrants and their families. As a Senior Analytics Engineer, you will play a critical role in building a data-driven culture that fuels our growth and success.About the Role:This position requires a seasoned professional...


  • Pasco, Washington, United States Snapchat Full time

    Transformative OpportunitySnap Inc. is a leading technology company that leverages the power of augmented reality to enhance human communication and expression. Our mission revolves around empowering people to live in the moment, learn about the world, and connect with others through innovative products like Snapchat, Lens Studio, and Spectacles.About the...


  • Pasco, Washington, United States The Pew Charitable Trusts Full time

    Job SummaryPew Charitable Trusts seeks a skilled Business Analyst, IT Solutions Specialist to collaborate with stakeholders and drive technology-driven solutions that align with business objectives. This role involves analyzing business needs, developing requirements, evaluating potential solutions, and supporting the implementation of new systems and data...


  • Pasco, Washington, United States Potomac Healthcare Solutions Full time

    Certified Strength and Conditioning SpecialistWe are seeking a highly qualified professional to establish effective strength and conditioning protocols for maximizing physical performance of personnel.As a key member of our team, you will work closely with operators' medical support staff to resolve problem areas and design tailored physical training...


  • Pasco, Washington, United States Potomac Healthcare Solutions Full time

    About the RoleWe are seeking a highly skilled and experienced Professional Human Performance Specialist to join our team at Potomac Healthcare Solutions.


  • Pasco, Washington, United States Elevate Government Solutions Full time

    Job Title: Federal Database SpecialistWe are seeking a highly motivated and experienced Federal Database Specialistto join our team at Elevate Government Solutions. The ideal candidate will have a minimum of 2-5 years of experience in database administration, with expertise in both Oracle and Postgres RDS. Experience with cloud-based databases, particularly...


  • Pasco, Washington, United States LIS Solutions Full time

    As a Language Specialist in HLT Data Management, you will be working closely with the HLT team at LIS Solutions to analyze and manipulate data that drives business growth. Your primary responsibilities will include conducting research and targeting activities, interacting with various personalities, extracting, transforming, loading, and cleaning data, and...


  • Pasco, Washington, United States Potomac Healthcare Solutions Full time

    Job OverviewPotomac Healthcare Solutions is a dynamic and rapidly growing healthcare services company providing world-class health services for government and commercial organizations.We are seeking a skilled Strength and Conditioning Specialist to support our program base and supported healthcare facilities.About the RoleThis is a challenging opportunity...


  • Pasco, Washington, United States Ardent Services Full time

    Ardent Services offers a lucrative salary package for the position of Senior Business Systems Analyst - IT Solutions Specialist in the Washington, DC area. The estimated annual compensation is $**118,000**.Job DescriptionWe are seeking an exceptional individual to fill this hybrid/remote role, responsible for analyzing IT systems and business applications,...


  • Pasco, Washington, United States ASP Web Solutions Full time

    **Job Title:** Technical Systems Specialist**Location:** Washington DC or Remote**Duration:** Full time**Job Summary:We are seeking an experienced Technical Systems Specialist to join our team at ASP Web Solutions. The ideal candidate will have a strong background in system administration, cloud infrastructure, and technical...


  • Pasco, Washington, United States Tekfortune Inc Full time

    Tekfortune Inc is seeking a highly skilled Data Visualization Expert to lead our HR Analytics and Development team. As a key member of our team, you will be responsible for designing and implementing data visualization solutions using Power BI.Job DescriptionDesign and implement data visualization solutions using Power BICollaborate with data scientists and...


  • Pasco, Washington, United States Contact Government Services, LLC Full time

    About the JobThis role is focused on providing enterprise backup solutions for a large-scale federal government enterprise environment. The ideal candidate will have experience with Commvault data protection application and possess a strong understanding of related technologies.Key ResponsibilitiesDesign and implement backup and recovery solutions using...

  • Nurse Specialist

    3 weeks ago


    Pasco, Washington, United States Medical Solutions Full time

    About the Role:We are seeking a skilled Nurse Specialist to join our team on a 12-hour night shift in Pasco, Washington.Competitive Salary and Benefits Package:The successful candidate will be rewarded with an estimated $104,000 per year salary, making it an attractive opportunity for experienced professionals.Key Responsibilities:Provide high-quality...


  • Pasco, Washington, United States CyberTec Full time

    Job DescriptionAt CyberTec, we are seeking a highly skilled Azure Infrastructure and Management Consultant to join our team. This role will involve designing and implementing Azure infrastructure and management solutions with 2+ years of technical proficiency in Microsoft Azure.Key Responsibilities:* Design and implement private, public, and hybrid cloud...


  • Pasco, Washington, United States Elevate Government Solutions Full time

    Cloud Database Developer Position: We are seeking a skilled Cloud Database Developer to join our team at Elevate Government Solutions. In this role, you will design and implement database systems that meet the needs of our Federal clients, while maintaining the security and integrity of the database and its users. Key Responsibilities:Design and implement...


  • Pasco, Washington, United States Scout Solutions Inc Defunct Full time

    Job Description:We are seeking a skilled Cybersecurity Operations Specialist to join our team at Scout Solutions Inc. as a Tier II SOC Analyst. The ideal candidate will provide support to our client in Washington D.C., ensuring the security and integrity of our network infrastructure.**Estimated Salary:** $80,000 - $110,000 per yearResponsibilities:Analyze...


  • Pasco, Washington, United States Remitly Full time

    Transforming Financial Services with DataRemitly is on a mission to revolutionize the way people send and receive money across the globe. As a Senior Analytics Engineer, you will play a critical role in building a data-driven culture that fuels our growth and success.About the Role:This position requires a seasoned professional with expertise in data mart...