ETL Developer

3 weeks 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 projects based on specifications or drawings, and collaborating with teams of other engineers. Typically performs multiple engineering-related tasks in various assignments within the project and firm. An Engineer, 1 has strong technical skills and background, a knack for learning new technologies, and a blend of good problem-solving and innovation needed to resolve a wide variety of technical production challenges.

Functional Job (LCAT) Information:

  • 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

    2 weeks ago

    Washington, United States Incept Data Solutions, Inc Full time

    **ETL Developer** **Work Location: Veterans Affairs facilities located in the Washington, District Columbia (DC) region (onsite)** **Must be US Citizen.** **Responsibilities**: - Perform data warehousing, data modeling, data integration, data migration, and ETL process development to support organizational needs. - Install, configure, develop, support,...

  • ETL Developer

    3 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

    1 month 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,...

  • ETL Developer

    1 month 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,...

  • ETL Developer

    7 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

    1 month 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 months 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

    7 hours 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

    1 month 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,...

  • ETL Developer

    1 month 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,...

  • ETL Developer

    4 hours 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,...

  • ETL Developer

    3 days ago

    Washington, United States Analytica Full time

    Job DescriptionJob DescriptionAnalytica is seeking a remote ETL Developer to support a federal government client.  The ideal candidate is able to work in a consultative approach with clients, has solid experience in ETL development experience. The ETL Developer will be loading data on a weekly basis in a large Compliance Data...

  • ETL Developer

    4 hours ago

    Washington, United States Analytica Full time

    Job DescriptionJob DescriptionAnalytica is seeking a remote ETL Developer to support a federal government client.  The ideal candidate is able to work in a consultative approach with clients, has solid experience in ETL development experience. The ETL Developer will be loading data on a weekly basis in a large Compliance Data...

  • Sr. ETL Developer

    1 month 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

    5 hours 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

    1 month 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...

  • Sr. ETL Developer

    5 days 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...

  • Sr. ETL Developer

    7 hours 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

    1 month 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

    3 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...