Jobs
>
Saint-Brieuc

    ETL Developer - Falls Church, United States - Syms Strategic Group, LLC

    Syms Strategic Group, LLC
    Syms Strategic Group, LLC Falls Church, United States

    3 weeks ago

    Default job background
    Description
    Syms Strategic Group (SSG)

    is seeking a talented

    Extract, Transform, and Load (ETL) Developer

    Department:
    Veterans Affairs

    Location:
    On-site, Washington, DC

    Type:
    Full Time
    Min


    Experience:
    Experienced

    Security Clearance Level:
    Public Trust (MBI)

    Salary Range:
    $75,995 - $89,000

    Military Veterans are highly encouraged to apply
    Essential Duties and Responsibilities

    This is an on-site, customer facing position in downtown Washington DC supporting a federal government client. Remote work is not available.
    Provide Data warehousing, Data modeling, Data integration, Data migration, ETL processes, and Business Intelligence support.
    Design, analyze, and implement Data Modeling.

    Provide data modeling design, analysis, and implementation, including conceptual, logical, and physical Data modeling, Data conversion, Data integration, and Data mining specialization in Data Warehouse and Business Intelligence.

    Install, configure, develop, support, and maintain the BI Apps, including the following environments or higher: OBIEE 12c, BI Apps.9.6.3, Web Logic Server, Informatica 9.0.1, Oracle , SQL, PL/SQL, DAC 7.8.4, TOAD, SQL Plus, Unix, and Windows XP.

    Develop ETLs using Informatica to facilitate Extraction Transformation and Data Load from Online Transaction Processing (OLTP) systems to Online Analytical Processing (OLAP) systems.

    Design schema using Key Performance Indicators (KPIs), Fact, Dimensions, Physical, Logical, Alias, and Extension tables.
    Build the Business Model(s) and establish relationships and Foreign Keys (Physical and Logical) between tables.
    Create Lightweight Directory Access Protocol (LDAP) authentication to enable Single-Sign on for Users in Development environment leveraging Analytics Repository.
    Use Informatica Mapping Designer to create/update mapping using different transformations required to move data into data warehouse.
    Provide recommendations and identifying critical issues and process faults as they pertain to data modeling, ETLs, and Informatica.
    Required Skills and Experience

    An ability to work collaboratively with cross-functional teams and adapt to changing requirements.
    Professional Certifications

    n/a

    Years of Professional Experience

    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.

    Desired experience


    Availability on government site in Washington, DC Monday – Friday during normal working hours and support after-hours remotely when needed.

    Prior experience in a federal data warehouse and understanding of government procedures and regulations.

    Formal Education

    Bachelor's degree in technical discipline or 8 years of additional relevant experience

    Citizenship Requirement

    U.S. Citizenship required for this specific opportunity

    Security Clearance Requirements

    Must possess or qualify for a Public Trust (MBI)


    CRITICAL NOTES:
    SSG will not make assumptions regarding your qualifications. Your answers to the mandatory screening questions

    must

    be supported by the information on your resume. Applications with inconsistencies will not be considered.
    Recruiters or Third parties

    will not

    be considered.
    This is an onsite position located in Washington, DC. Remote work is not available for this position.

    U.S Citizenship is required for this specific opportunity

    . Applicants selected will be subject to a government security investigation and must meet eligibility requirements for access to classified information and be able to obtain a government-granted security clearance. Individuals may also be subject to a background investigation including, but not limited to criminal history, employment and education verification, drug testing, and creditworthiness.

    Syms Strategic Group, LLC is an Equal Opportunity Employer.

    Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, marital status, disability, veteran status, sexual orientation, or genetic information.


    NOTE:
    DO NOT submit multiple applications. Multiple applications will be deleted and not considered.
    This is an On-site, customer facing position located in Washington, DC for a federal government customer. Remote work is not available.
    Do you currently live within a reasonable commuting distance to downtown Washington DC?
    Do you have at least five (5) years of experience in Extract, Transform, Load (ETL) tools, especially Informatica and data warehousing applications?
    Do you have at least five (5) years of experience developing and tuning complex SQL queries in the Oracle relational database?
    Do you have at least three (3) years of prior experience in a federal data warehouse and an understanding of government procedures and regulations?
    Do you either possess a Bachelor's degree in a technical discipline or an additional 8 years of experience in lieu of a degree?
    Are you currently a U.S. citizen?
    Do you possess a Public Trust or DOD issued security clearance?

    #J-18808-Ljbffr
  • INTERNATIONAL LOGIC SYSTEMS, INC.

    Senior ODI ETL Developer

    1 week ago

    INTERNATIONAL LOGIC SYSTEMS, INC. Fairfax, United States

    Overview: · ILS is looking for a Sr. ETL (ODI) Developer to support one of our projects in Washington, DC. This resource will be responsible for designing Enterprise-level solutions for multi-dimensional databases, will design and plan BI solutions, execute strategies for databa ...

  • Alignity

    Senior ETL Developer

    3 weeks ago

    Alignity Falls Church, United States

    Job DescriptionDo you love a career where you Experience, Grow & Contribute at the same time, while earning at least 10% above the market? If so, we are excited to have bumped onto you.Learn how we are redefining the meaning of work, and be a part of the team raved by Clients, Jo ...

  • Alignity

    Senior ETL Developer

    3 weeks ago

    Alignity Falls Church, United States

    Job Description · Do you love a career where you Experience, Grow & Contribute at the same time, while earning at least 10% above the market? If so, we are excited to have bumped onto you. · Learn how we are redefining the meaning of work, and be a part of the team raved by Cli ...

  • CGI Group, Inc.

    Elastic Developer

    2 weeks ago

    CGI Group, Inc. Fairfax, United States Full time

    Elastic Developer (Mid) - U.S. Citizenship Required · Position Description · CGI is one of the top 5 largest global IT companies spread across 40 countries with endless opportunities to expand and grow. As a CGI Federal Member, you have the opportunity to be a shareholder at CG ...

  • CGI Group, Inc.

    AWS Data Engineer

    2 weeks ago

    CGI Group, Inc. Fairfax, United States Full time

    AWS Data Engineer · Position Description · CGI is in the top 5 largest global IT companies spread across 40 countries with endless opportunities to expand and grow. As a CGI Member, you have the opportunity to be a shareholder at CGI and join a family of over 90,000 members str ...

  • General Dynamics Information Technology

    Extract, Transform and Load

    2 weeks ago

    General Dynamics Information Technology Fairfax, United States

    Req ID: · RQ176625 · Type of Requisition: · Regular · Clearance Level Must Be Able to Obtain: · None · Public Trust/Other Required: · Other · Job Family: · Data Analysis · Skills: · Business Analysis,Data Automation,Data Modeling,Information Systems,Software Developmen ...

  • CMCI

    Data Engineer

    4 days ago

    CMCI Fairfax, United States

    Job Description · Data Engineer · Location: Fairfax, VA · Why CMCI? · CMCI provides management consulting and IT services that empower enterprises to achieve their business goals in today's highly competitive market. Our goal is to seamlessly integrate into each customer's or ...

  • Seneca Resources, LLC

    AWS Cloud Architect with Security Clearance

    1 day ago

    Seneca Resources, LLC San Francisco, United States Permanent

    Location: Falls Church, VA (Must work 2 days per month onsite) · Contract Type: 6-month contract to hire · Citizenship: US Citizenship required · Clearance: Eligibility for DHS Public Trust (US Citizenship is Required) Job Description: We are seeking a highly skilled AWS Cloud Ar ...

  • CGI Technologies and Solutions, Inc.

    Data Engineer

    4 days ago

    CGI Technologies and Solutions, Inc. Fairfax, United States

    **Data Engineer (Sr.) - U.S. Citizenship Required** · **Category:** Cyber Security · **Main location:** United States, Virginia, Fairfax · **Position ID:** J · **Employment Type:** Full Time · **Position Description:** · CGI is one of the top 5 largest global IT companies s ...

  • CGI Group, Inc.

    Elastic Developer

    4 days ago

    CGI Group, Inc. Fairfax, United States

    Elastic Developer (Sr.) - U.S. Citizenship Required Position Description CGI is one of the top 5 largest global IT companies spread across 40 countries with endless opportunities to expand and grow. As a CGI Federal Member, you have the opportunity to be a shareholder at CGI and ...

  • International Logic Systems, Inc.

    Business Intelligence

    1 week ago

    International Logic Systems, Inc. Fairfax, United States

    International Logic Systems, Inc. (ILS), located in Fairfax, Virginia, has an opening for a Business Intelligence (BI) Program Manager that will be responsible for overseeing the planning, execution, and delivery of BI projects. The ideal candidate will have a solid understanding ...

  • BAE Systems USA

    Senior Analyst, Talent Acquisition Reporting and Analytics

    1 day ago

    BAE Systems USA Falls Church, United States

    **Job Description** · Are you passionate about data engineering, data visualization, governance, security and information delivery that help identify patterns, trends and exceptions? If so, this role might be the next step in your career. · We are looking for an experienced, se ...

  • CGI Technologies and Solutions, Inc.

    Data Integration Developer

    5 days ago

    CGI Technologies and Solutions, Inc. Fairfax, United States

    Data Integration Developer (Sr.) - U.S. Citizenship Required · Category: Business Consulting, Strategy and Digital Transformation · Main location: United States, Virginia, Fairfax · Position ID: J · Employment Type: Full Time · Position Description: · CGI is one of the top 5 lar ...

  • CGI Group, Inc.

    Elastic Developer SME

    5 days ago

    CGI Group, Inc. Fairfax, United States

    Elastic Developer SME - U.S. Citizenship Required · Position Description · CGI is one of the top 5 largest global IT companies spread across 40 countries with endless opportunities to expand and grow. As a CGI Federal Member, you have the opportunity to be a shareholder at CGI an ...

  • Perficient

    DBT Data Engineer

    4 days ago

    Perficient Fairfax, United States

    Job Description · We currently have a career opportunity for a DBT Data Engineer to join our Data Solutions team. · Job Overview: · The Technical Architect provides technology direction, ensures project implementation compliance, and utilizes technology research to innovate, i ...

  • CGI

    Data Quality Engineer

    5 days ago

    CGI Fairfax, United States

    Data Quality Engineer (Sr.) - U.S. Citizenship Required · Category: Cyber Security · Main location: United States, Virginia, Fairfax · Position ID:J · Employment Type: Full Time · Position Description: · CGI is one of the top 5 largest global IT companies spread across 40 cou ...

  • CGI Group, Inc.

    Data Engineer

    2 weeks ago

    CGI Group, Inc. Fairfax, United States Full time

    Data Engineer (Sr.) - U.S. Citizenship Required · Position Description · CGI is one of the top 5 largest global IT companies spread across 40 countries with endless opportunities to expand and grow. As a CGI Federal Member, you have the opportunity to be a shareholder at CGI an ...

  • Quevera

    Database Developer

    1 week ago

    Quevera Fairfax, United States

    Job Description: · Quevera is seeking a Database Developer to join an exciting, collaborative and innovative team. A place where you are positioned for More than Just a Job. Where leadership partners with you, seek to cultivate and support career development, encouraging growth ...

  • CGI Group, Inc.

    Data Engineer

    4 days ago

    CGI Group, Inc. Fairfax, United States

    Data Engineer (Sr.) - U.S. Citizenship Required Position Description CGI is one of the top 5 largest global IT companies spread across 40 countries with endless opportunities to expand and grow. As a CGI Federal Member, you have the opportunity to be a shareholder at CGI and join ...

  • Quevera LLC

    Database Developer 2340

    3 weeks ago

    Quevera LLC Fairfax, United States

    Job Description · Job DescriptionJob Description: · Quevera is seeking a Database Developer to join an exciting, collaborative and innovative team. A place where you are positioned for More than Just a Job. Where leadership partners with you, seek to cultivate and support career ...