Jobs
>
Dinan

    ETL Developer - McLean, United States - Syms Strategic Group, LLC

    Syms Strategic Group, LLC
    Syms Strategic Group, LLC McLean, United States

    3 days 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)

    Military Veterans are highly encouraged to apply
    Essential Duties and Responsibilities

    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.

    #J-18808-Ljbffr

  • TWO95 International

    ETL Developer

    6 days ago


    TWO95 International McLean, United States

    Job Title: ETL Developer · Job Location: Tysons, Virginia · Job Type: Full-time · Salary range: 85K to 125K · Requirements · Job Description: · Design, implement, and support ETL processes from embedded sources to data warehouse · Design and support ETL processes for data clean ...

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

  • Syms Strategic Group, LLC (SSG)

    ETL Developer

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


  • Arthur Grand Technologies McLean, United States

    Company Description · Arthur Grand Technologies ) is in the business of providing staffing and technology consulting services. We have doubled our revenue year over year for the past 5 years. This speaks to the long-lasting relationship and customer satisfaction that we have bui ...


  • Trident Consulting McLean, United States

    Trident Consulting is seeking a "SENIOR ETL Developer " for one of our clients in "Mclean - VA - 5 days onsite " A global leader in business and technology services. · Role: SENIOR ETL Developer · Location: Mclean - VA - 5 days onsite · Duration: Contract · Qualifications: · We ...


  • Pyramid Consulting McLean, United States

    Immediate need for a talented Database ETL Developer. This is a Fulltime opportunity with long-term potential and is located in U.S.(Remote). Please review the job description below and contact me ASAP if you are interested.Job ID: Pay Range: $120k - $130k/annum. Employee benefit ...


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


  • ApTask McLean, United States

    About Client: · Client is an information technology and business process outsourcing company. It provides a range of IT services and solutions to clients worldwide, including application development and maintenance, digital transformation, cloud services, automation and artifici ...


  • US Tech Solutions McLean, United States

    Senior ETL/Informatica IICS Developer · Location: Mclean, VA (3 Days/Week Onsite from start of assignment) · Duration: 6 Months · Must Haves: Informatica IDMC, previous informatica PowerCenter, databases specifically snowflakes and data marks. · Preferred: MicroStrategy or Tab ...


  • Diverse Lynx McLean, United States

    Hope you doing well, if you are interested please share updated resume. · Role-ETL Developer with IICS, AWS and PySpark · Location- McLean, VA (Onsite from day 1) · Duration- Full time(No Sponsorship/$No Visa Sponsership$/$No Visa Sponsership$) · Job Description : · Skill: ET ...


  • Arthur Grand Technologies McLean, United States Full time

    Job Description · Arthur Grand Technologies is currently seeking a highly motivated and skilled · Snowflake Developer · for one of our clients. · Role: Snowflake Developer · Location: McLean, VA (Onsite Hybrid) · Duration: FTE · JD: · Data Engineer with good knowledge of ...


  • Arthur Grand Technologies McLean, United States Full time

    Company 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 customers in the areas of enter ...

  • Infinitive

    Data Engineer

    5 days ago


    Infinitive McLean, United States

    *Candidates must be local to the Washington D.C. metro area. · 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 techno ...

  • Hummingbirds Innovations

    SAS Developer

    1 week ago


    Hummingbirds Innovations McLean, United States

    We are looking for Candidates with below skill sets. · Source data from multiple data sets · Will be working on data dictionary changes and also will be resolving data issues. · Hands-on with SAS, Shell Scripting, AutoSys, DB2/Sybase · SAS is used for reporting purpose, but c ...

  • InfoGravity

    Snowflake Developer

    5 days ago


    InfoGravity McLean, United States

    Role: Snowflake Developer · Location: McLean, VA · Duration: FTE/W2 · Client: Hexaware/PenFed · Experience: Years · Job Description: · Data Engineer with good knowledge of Snowflake cloud platform, and architecture. · Experience with various data ingestion methods (snow pipe & ot ...


  • The MITRE Corporation McLean, United States

    Why choose between doing meaningful work and having a fulfilling life? At MITRE, you can have both. That's because MITRE people are committed to tackling our nation's toughest challenges—and we're committed to the long-term well-being of our employees. MITRE is different from mos ...


  • Hexaware Technologies McLean, United States

    Role: Snowflake Developer · Location: McLean, VA · Duration: FTE/C2C · Client: Hexaware · JD: · Responsibility · Build and maintain robust and scalable ETL/ELT pipelines to integrate data from multiple systems across the enterprise · Build complex data models to perform business ...

  • Indotronix International Corporation

    Attunity/ETL DEV

    4 days ago


    Indotronix International Corporation McLean, United States

    Pay Rate:- · W2 Rate $ 59.70 · -MUST have attunity experience · -MUST be on your direct w2 (visa transfers ok) · -hybrid schedule in McLean, VA · -1 step interview process · -We have made many placements with this team. · Title: ETL/Attunity Developer · Location: McLean, VA · ...


  • Zillion Technologies McLean, United States

    Must be local to DMV area · Senior Informatica Developer · Duration: 6 months. Opportunity for extension. · Location: Onsite (Hybrid) in McLean, VA on Tuesday, Wednesday and Thursday · Work Authorization: H1B USC GC · Years of experience: 6+ · Must Haves: Informatica IDMC, previo ...


  • ApTask McLean, United States

    About Client: · Client is an information technology and business process outsourcing company. It provides a range of IT services and solutions to clients worldwide, including application development and maintenance, digital transformation, cloud services, automation and artifici ...