Jobs
>
Bloomington

    ETL Developer - McLean, United States - Syms Strategic Group, LLC (SSG)

    Default job background
    Description

    Job Description

    Job DescriptionSyms 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 ResponsibilitiesThis 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 Certificationsn/aYears of Professional Experience5+ 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 experienceAvailability 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 EducationBachelor's degree in technical discipline or 8 years of additional relevant experienceCitizenship RequirementU.S. Citizenship required for this specific opportunitySecurity Clearance RequirementsMust possess or qualify for a Public Trust (MBI)CRITICAL NOTES:
    1. 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.
    2. Recruiters or Third parties will not be considered.
    3. 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.

    Powered by JazzHR

    8KwFJS4VP1


  • FourteenPosts

    Etl Developer

    2 days ago


    FourteenPosts McLean, United States

    Job Summary: · We are seeking an experienced ETL Developer to join our team. As an ETL Developer, you will be responsible for designing, developing, and implementing data integration solutions. You will work closely with cross-functional teams to analyze business requirements and ...


  • Arthur Grand Technologies Inc McLean, United States

    **Company Description** · We are a minority owned staff augmentation and technology consulting company · To keep our valued employees, we need to keep them engaged in challenging, interesting work, offer market-relevant benefits and provide continued opportunities for professiona ...


  • Arthur Grand Technologies Inc McLean, United States

    Arthur Grand Technologies is currently seeking a highly motivated and skilled **Senior/Mid-level Snowflake Developer** for one of our clients. · **Role: Senior/Mid-level Snowflake Developer** · **Location: McLean, VA (Onsite)** · **Employment: Fulltime** · **JD**: · - Data Engine ...

  • Procession Systems

    ETL Developer

    2 weeks ago


    Procession Systems McLean, United States

    Procession Systems is seeking a Top Secret Cleared ETL Engineer to join our program in McLean, Virginia. As part of our dynamic team, you will play a pivotal role in designing, implementing, and maintaining cutting-edge solutions tailored to meet the unique needs of our clients w ...

  • Syms Strategic Group, LLC (SSG)

    ETL Developer

    3 days ago


    Syms Strategic Group, LLC (SSG) McLean, United States

    Job Description · Job DescriptionSyms 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 T ...


  • Apex Systems McLean, United States

    Location: Must be on-site in McLean, VA | Tuesday – Thursday no exceptions · Assignment Type: 6 months, possible extension · Work Authorization: · Pay Rate: $58-$65 doe · MUST HAVE · Informatica IICS/IDMC, previous Informatica PowerCenter, databases specifically snowflakes and d ...


  • Randstad Bloomington, United States

    informatica/etl powercenter developer. · + bloomington , illinois (remote) · + posted 1 day ago · **job details** · summary · + $50 - $61.50 per hour · + contract · + bachelor degree · + category computer and mathematical occupations · + reference1050415 · job details · job summa ...


  • Randstad Bloomington, United States

    informatica/etl powercenter developer. · bloomington , illinois (remote) · posted 6 days ago · job details · summary · $50 - $61.50 per hour · contract · bachelor degree · category computer and mathematical occupations · reference · job details · job summary: · We are seek ...


  • Randstad Bloomington, United States

    informatica/etl powercenter developer. · + bloomington , illinois (remote) · + posted 2 days ago · **job details** · summary · + $50 - $61.50 per hour · + contract · + bachelor degree · + category computer and mathematical occupations · + reference1050415 · job details · job summ ...


  • Randstad Bloomington, United States

    informatica/etl powercenter developer. · + bloomington , illinois (remote) · + posted 3 days ago · **job details** · summary · + $50 - $61.50 per hour · + contract · + bachelor degree · + category computer and mathematical occupations · + reference1050415 · job details · job summ ...


  • Randstad North America, Inc. Bloomington, United States

    We are seeking a highly skilled Informatica Developer to join our Application Development Integration Tools team. The team focuses on integrating on-premise and cloud-based systems which are the core of operations. This senior developer role will act Developer, Power, Operations, ...


  • Arthur Grand Technologies Inc McLean, United States Full time

    Job Description · Job DescriptionCompany Description · Arthur Grand (AG) is an IT services firm specializing in Digital Transformation initiatives for Federal, Commercial, State & local customers. Since 2012, AG has (been) successfully supporting and delivering IT services to our ...


  • Steampunk McLean, United States

    Overview: · As a **Steampunk **Integration** **Developer,** you will design, develop, evaluate, and modify system interfaces and integrations. You will participate in the testing process through test execution, test script development, test review, and analysis. You should have e ...


  • Infinitive Inc McLean, United States

    **About Infinitive**: · Infinitive is a data and AI consultancy that enables its clients to modernize, monetize and operationalize their data to create lasting and substantial value.. We possess deep industry and technology expertise to drive and sustain adoption of new capabilit ...

  • Pendulum LLC

    Data Scientist

    6 days ago


    Pendulum LLC McLean, United States

    **JOB DESCRIPTION** · **Clearance Level: Top Secret/SCI with Full Scope Polygraph** · **Skill Level(s): Expert** · **REQUIRED SKILLS** · - Clearance Level: Top Secret/SCI with Full Scope Polygraph- Skill Level(s): Expert- · - generating ideas for revolutionary technologies suppor ...


  • TalentBurst Bloomington, United States

    Title: Informatica Developer · Location: REMOTE · Duration: 7 months plus extensions · Description: · We are seeking a highly skilled Informatica Developer to join our Application Development Integration Tools team. The team focuses on integrating on-premise and cloud-based sy ...

  • Metric5

    Data Engineer

    3 days ago


    Metric5 McLean, United States

    Job Description · Job DescriptionData Engineer · Description · Metric5 is currently seeking a Data Engineer to work within a team providing Data Warehouse and Business Intelligence services to our government customer using Agile processes. As a Data Engineer, you will work with v ...


  • Hexaware Technologies McLean, United States

    Hexaware is hiring Business Analyst with Data Background, candidates need to work onsite at McLean, VA (Hybrid Model). · Business Analyst with Data Background · Job Type: Fulltime/Contract · Job Location: McLean, VA · Need candidates who are Local to McLean OR willing to relocate ...

  • American Unit, Inc

    Data Analyst

    1 week ago


    American Unit, Inc McLean, United States

    Job-title: Senior Data Analyst · Location: McLean, VA/Hybrid · Duration: 6 months and possible extension · Description: · Must Haves: · Must have a minimum of three years of hands-on programming experience using Python & SQL - Preference for SAS. · Must have hands-on experience w ...

  • AE Strategies

    Data Engineer

    5 days ago


    AE Strategies McLean, United States

    About Us · AE Strategies is a Virginia-based professional services firm founded in 2003, providing federal clients with human capital, data analytics, and management consulting. We are a proven small business with an established reputation and a track record of supporting critica ...