ETL Developer

2 weeks ago

Washington, United States Outland Recruiting Full time
Job DescriptionJob Description

Join our dynamic team at the Office of Performance Analysis and Integrity, where we manage and enhance the Veterans Benefits Administration (VBA) Enterprise Data Warehouse (EDW) and associated applications. Our responsibilities span Project Management, Data Warehouse Management, Advanced Analytics, Tableau Server Administration, Technical Collaboration Support, and more.


  • Develops, implements, refines, and supports a data warehouse used for analytics and reporting, optimizing ETL processes while working closely with Business Analysts, Business Managers, Project Managers, and internal customers.
  • Designs, codes, runs tests, and implements complex programs and scripts, and performs source-to-target data mapping.
  • Reviews and implements project plans and business rules via stored procedures, middleware, or other technologies.
  • Backs up the Senior ETL developer with providing rotational after-hours support.The ETL Developer may be required to work evenings or weekends.

Responsibilities:

  • Be available on government site in Washington DC Monday Friday during normal working hours and support after-hours remotely when needed.
  • 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. Environment or higher: OBIEE 12c, BI Apps.9.6.3, Web Logic Server, Informatica 9.0.1, Oracle 11.2.0.2, SQL, PL/SQL, DAC 7.8.4, TOAD, SQL* Plus, Unix, Windows XP.
  • Developing ETLs 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 & 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.


Requirements:

  • Bachelors Degree in technical discipline, 8 additional years of experience considered in lieu of 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. Ability to work collaboratively with cross-functional teams and adapt to changing requirements.
  • Prior experience in a federal data warehouse and understanding of government procedures and regulations is preferred.
  • Must be authorized to work for any employer in the U.S.
  • Must be able to obtain and maintain the required security clearance.


  • ETL Developer

    3 days ago

    Washington, United States iTCO Solutions Full time

    100% onsite location - 1800 G St, NW Washington, DC 20006. Does not want SQL ETL developers Want only Oracle ETL Developers Requires Bachelors degree Professional Level Information: As an Engineer 1, your duties may include assisting in the design, development, and testing project components, identifying problems and discovering solutions, working on ongoing...

  • ETL Developer

    6 days ago

    Washington, United States ITCO Solutions, Inc. Full time

    100% onsite location - 1800 G St, NW Washington, DC 20006.Does not want SQL ETL developersWant only Oracle ETL DevelopersRequires Bachelors degreeProfessional Level Information:As an Engineer 1, your duties may include assisting in the design, development, and testing project components, identifying problems and discovering solutions, working on ongoing...

  • ETL Developer

    5 days ago

    Washington, United States ITCO Solutions, Inc. Full time

    100% onsite location - 1800 G St, NW Washington, DC 20006.Does not want SQL ETL developersWant only Oracle ETL DevelopersRequires Bachelors degreeProfessional Level Information:As an Engineer 1, your duties may include assisting in the design, development, and testing project components, identifying problems and discovering solutions, working on ongoing...

  • ETL Developer

    2 days ago

    Washington, United States Amida Technology Solutions Full time

    Amida Technology Solutions is a DC-based software services company focused on the most difficult problems in data interoperability, exchange, governance, and security. We design, develop, and deploy software solutions that collect, reconcile, and transform data for business intelligence, predictive analytics, and decision support. We specialize in taking...

  • Etl Developer

    4 weeks ago

    Washington, United States Amida Technology Solutions Full time

    Amida Technology Solutions is a DC-based software services company focused on the most difficult problems in data interoperability, exchange, governance, and security. We design, develop, and deploy software solutions that collect, reconcile, and transform data for business intelligence, predictive analytics, and decision support. We specialize in taking...

  • ETL Developer

    2 weeks ago

    Washington, United States Amida Technology Solutions Full time

    Amida Technology Solutions is a DC-based software services company focused on the most difficult problems in data interoperability, exchange, governance, and security. We design, develop, and deploy software solutions that collect, reconcile, and transform data for business intelligence, predictive analytics, and decision support. We specialize in taking...

  • ETL Developer

    2 weeks ago

    Washington, United States Amida Technology Solutions Full time

    Job DescriptionJob DescriptionAmida Technology Solutions is a DC-based software services company focused on the most difficult problems in data interoperability, exchange, governance, and security. We design, develop, and deploy software solutions that collect, reconcile, and transform data for business intelligence, predictive analytics, and decision...

  • ETL Developer

    2 weeks ago

    Washington, United States SynOpt LLC Full time

    Job DescriptionJob DescriptionThe right candidate will apply their technical knowledge in designing, implementing and maintaining Extract Transform Load (ETL) solutions. Responsibilities may include converting specifications into design and converting design into deliverables; design, documentation, development, modification, testing, installation,...

  • Sr. ETL Developer

    2 weeks ago

    Washington, United States Outland Recruiting Full time

    Job DescriptionJob DescriptionJoin our dynamic team at the Office of Performance Analysis and Integrity, where we manage and enhance the Veterans Benefits Administration (VBA) Enterprise Data Warehouse (EDW) and associated applications. Our responsibilities span Project Management, Data Warehouse Management, Advanced Analytics, Tableau Server Administration,...

  • Sr. ETL Developer

    2 weeks ago

    Washington, United States Onyx Government Services,LLC Full time

    Onyx Government Services, LLC., is a Service-Disable Veteran-Owned Small Business (SDVOSB), headquartered in Fairfax, Virginia. We specialize in data management, integration, and analysis solutions to provide decision-ready information to Command and Control (C2) and Decision Support Systems.  We have demonstrated expertise in the field of Information...

  • Sr. ETL Developer

    2 weeks ago

    Washington, United States Onyx Government Services,LLC Full time

    Job DescriptionJob DescriptionOnyx Government Services, LLC., is a Service-Disable Veteran-Owned Small Business (SDVOSB), headquartered in Fairfax, Virginia. We specialize in data management, integration, and analysis solutions to provide decision-ready information to Command and Control (C2) and Decision Support Systems.  We have demonstrated expertise in...

  • AWS and ETL Developer

    2 weeks ago

    Washington, DC, United States RICEFW Technologies Full time

    Join our Data Cloud team in DC and embark on an exciting journey as an AWS and ETL Developer! We're seeking a skilled individual with expertise in Amazon Web Services (AWS) and Extract, Transform, Load (ETL) processes. Your role will involve crafting and maintaining ETL pipelines, implementing data integration solutions on AWS cloud services, and fine-tuning...

  • ETL Informatica Developer

    2 weeks ago

    Washington, United States ViedTech Full time

    Company Description Incorporated in 2006; Headquartered in Chantilly, VA. Viedtech has established itself globally with its services and solution excellence. Viedtech offers fast, reliable, cost effective and value added IT and Staffing Services. We constantly strive hard to refine our quality, expand our capabilities, increase our efficiency, and elevate...

  • ETL Informatica Developer

    3 days ago

    Washington, United States ViedTech Full time

    Company Description Incorporated in 2006; Headquartered in Chantilly, VA. Viedtech has established itself globally with its services and solution excellence. Viedtech offers fast, reliable, cost effective and value added IT and Staffing Services. We constantly strive hard to refine our quality, expand our capabilities, increase our efficiency, and elevate...

  • Senior Developer

    3 weeks ago

    Washington, United States Missing Link Security Full time

    - Senior Developer with expertise with Extract, Transform, Load ( ETL ) We are seeking a skilled Senior Developer to provide essential support for the ongoing operations of the VBA Enterprise Data Warehouse (EDW). The successful candidate will play a crucial role in ensuring the reliability, performance, and security of the EDW, as well as collaborating...

  • Data Integration Engineer-ETL

    2 weeks ago

    Washington, United States Educology Solutions Full time

    ESI is seeking a Data Integration Engineer to support one of our customers. Under general direction, the engineer will be responsible for designing and developing processes that translate data from various sources to destinations and presents findings to appropriate team members, clients and vendors. Escalate concerns to management and follows team...

  • Data Integration Engineer-ETL

    3 days ago

    Washington, United States Educology Solutions Full time

    ESI is seeking a Data Integration Engineer to support one of our customers. Under general direction, the engineer will be responsible for designing and developing processes that translate data from various sources to destinations and presents findings to appropriate team members, clients and vendors. Escalate concerns to management and follows team...

  • Data Integration Engineer-ETL

    2 weeks ago

    Washington, United States Educology Solutions Full time

    Job DescriptionJob DescriptionSalary: ESI is seeking a Data Integration Engineer to support one of our customers. Under general direction, the engineer will be responsible for designing and developing processes that translate data from various sources to destinations and presents findings to appropriate team members, clients and vendors.  Escalate concerns...

  • ETL Data Engineer

    2 weeks ago

    Washington, United States Go intellects Inc Full time

    Job DescriptionJob DescriptionBenefits:Competitive salary The Enterprise Data team at Client requires an ETL data engineer to support data operations for its Cloud Data Exchange. The resource will utilize native Azure tools to perform ETL, data loading and data transformation tasks.Complete Description:The ETL data engineer will support the Client Enterprise...

  • Senior Data Solutions Architect-ETL

    2 weeks ago

    Washington, United States Educology Solutions Full time

    Job DescriptionJob DescriptionSalary: ESI is seeking a Senior Data Solutions Architect  to support one of our customers. Under general direction from the customer, the Senior Data Solutions Architect will be responsible for designing and developing processes that translate data from various sources to destinations and presents findings to appropriate team...