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

Syms Strategic Group, LLC (SSG) Falls Church, United States

1 week ago

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.

ETL Developer

2 days ago

Syms Strategic Group, LLC Falls Church, United States

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) · ...
Senior ETL Developer

1 day 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 ...
Senior ETL Developer

1 week ago

HarmonyTech Fairfax, United States

Job Description · Job Description · HarmonyTech is currently seeking a Senior ETL (Extract, Transform, Load) developer to support and handle data management work. The candidate should have strong SAS Coding, SQL Server knowledge, Scripting (Python, Bash, SAS, and Perl) experien ...
Data Engineer-Remote

1 week ago

Shuvel Digital Fairfax, United States

Clearance Requirement: Must be US Citizen and should be able to obtain DHS FEMA clearance. · Primary Responsibilities Take responsibility for the delivery of Data Migration for multiple systems: analysis, design, implementation, testing, validation, and acceptance. · Assembling ...
Mid-Level Pega CDH Data Engineer

2 weeks ago

TanviIT Inc Fairfax, United States

Mid-Level Pega CDH Data Engineer II · Merrifield, VA (Hybrid) · 6++ Months · Note: Location: Hybrid ONLY to HQ, GPO and San Diego, CA offices. · Description: · Top 3 Required Skills: · Hands-on experience creating automated data pipelines using Pega DataFlow and other moder ...
Mid-level Software Developer-Remote

2 days ago

Shuvel Digital Fairfax, United States

Clearance Requirement: Must be US Citizen and should be able to obtain DHS FEMA clearance. · Job Description · Primary Responsibilities Collaborate with multiple teams for the delivery of Data Migration for multiple systems: analysis, design, implementation, testing, validation, ...
Sr Database Developer-Remote

1 week ago

Shuvel Digital Fairfax, United States

Required Skills · 10+ years of experience as a MS SQL Server Developer or similar role with strong experience in · Database design and development. · BS/MS degree in Computer Science, Engineering, or a related subject · 5-7 years of experience with SQL Server PowerBI · Experienc ...
Data Engineering Architect

2 weeks ago

Inova Health System Fairfax, United States

The Data Engineering Architect assesses client requirements, details their current data needs, and designs a data strategy for developing and implementing data intake, refresh and governance processes. Responsible for proper designing and creating necessary data architecture desi ...
Power BI Developer

1 week ago

Plateau Software, Inc. Fairfax, United States

· Plateau GRP is a growing company that values your skills, training and ideas. At Plateau, you are our greatest asset. We provide a path to keep growing your career. We strive to foster an environment that's welcoming, diverse, respectful, and inclusive. · Plateau Group is see ...
Data Engineer

1 week ago

General Dynamics Information Technology Fairfax, United States Paid Work

Req ID: RQ174972 · Type of Requisition: Regular · Clearance Level Must Be Able to Obtain: Secret · Job Family: Database Analysis/Design · Skills: · Database Architecture,ETL Processing,Oracle Database Migration,Structured Query Language (SQL) · Certifications: · Security + - Comp ...
Data Engineer

1 week 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 spread across 40 countries wit ...
Jr SAP BODS Developer

2 days ago

Shuvel Digital Fairfax, United States

Job Description: · Teams up to design, develop, analyze, and implement software operating systems and software application programs. Supports research on emerging technologies to determine impacts on application execution. Assists and potentially performs systems modeling. Suppor ...
Data Integration Developer

1 week 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 ...
Systems Engineer with Security Clearance

1 day ago

Torin Consulting Inc. Fairfax, United States

CLEARANCE: Active TS/SCI with Polygraph required to apply Torin is seeking experienced System Engineers to join our team COMPANY OVERVIEW: Torin Consulting, Inc. prides itself in developing and delivering exceptional results in a high-speed, results driven environment since 2014 ...
Cloud Developer

1 week ago

Leidos Falls Church, United States

Description · Cloud Developer · Are you looking for an opportunity to make an impact? · At Leidos, we deliver innovative solutions through the efforts of our diverse and talented people who are dedicated to our customers' success. We empower our teams, contribute to our communi ...
Oracle HCM Cloud Technical Developer

2 weeks ago

TechWish Fairfax, United States

Oracle HCM Cloud Technical Developer & Data Conversion · Location: Onsite 5 days a week at client site in Fairfax, VA (Not Remote) · Contract: Contract Position - 12 months · Responsibilities: · Design, develop, and implement integrations between Oracle HCM Cloud and other enter ...
Data Engineer

2 weeks 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 ...
Data Integration Developer

2 weeks ago

CGI Technologies and Solutions, Inc. Fairfax, United States

**Data Integration Developer (Mid) - 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:** ...
Data Integration Developer SME

1 week ago

CGI Technologies and Solutions, Inc. Fairfax, United States

**Data Integration Developer SME - 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:** · ...
Lead Data SDET

2 days ago

ASCENDING LLC Fairfax, United States

Location: Remote anywhere in the continental US (lower 48 states). Cannot work outside of the U.S. · Contract to Hire, Long term Contract · Job Description: · We are supporting a Senior Director in the Quality Assurance space, who is looking for a talented, Lead Data SDET. · ...