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

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

3 weeks ago

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:

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.

RXVkgZXaSk

ETL Developer with Pyspark

2 weeks ago

Excelon Solutions McLean, United States

Job Description · Job DescriptionJob Description · Your expertise in Python, PySpark, ETL processes and experience with both streaming and batch workflows will be essential in ensuring the efficient flow and processing of data to support our clients. · Collaborate with cross-fun ...
Etl Developer

1 week ago

Syms Strategic Group, LLC (SSG) McLean, 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) ...
Etl Developer

3 weeks 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 ...
Etl Developer

1 week ago

Seven Hills Group Technologies inc. McLean, United States

Mandatory skills: · 8+ years of Strong ETL & Data warehousing concepts · Strong Attunity experience · DB2 and MongoDB database working experience. · AWS service utilization experience with services like EC2, EMR, S3, Step Functions Glue and Dynamo · Control M experience · Atlassi ...
Senior ETL Developer

3 days ago

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

Job Description · Job DescriptionSyms Strategic Group (SSG) is seeking a talented Senior Extract, Transform, and Load (ETL) Developer · Department: Veterans Affairs · Location: On-site, Washington, DC · Type: Full Time · Min. Experience: Experienced · Security Clearance Level: P ...
Etl Snowflake Developer

3 weeks ago

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 ...
Etl Snowflake Developer

3 days ago

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 ...
Developer-ETL/Informatica Senior

3 weeks ago

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 ...
ETL Informatica/ IICS Developer

1 week ago

Visionary Innovative Technology Solutions LLC McLean, United States

Position: ETL Informatica/ IICS Developer · Location: Mclean, VA (Onsite) · Duration: 6 to 24 Month · Job Description: · 8+ years of Strong ETL Informatica · Strong IICS experience (Informatica Intelligent Cloud Services) · ...
Immediate Interview Etl Developer Attunity Mclean

1 week ago

TMV LLC McLean, United States

Immediate Interview || ETL Developer Attunity || Mclean, Virginia (Hybrid) · Role: ETL Developer Attunity · Implementation: Hexaware · Client: Freddie Mac · Location: McLean, VA (Local). · Mandatory skills: · 8+ years of Strong ETL & Data warehousing concepts · Strong Attunity ex ...
Snowflake Admin

4 days ago

Dexian McLean, United States

Title: Snowflake Admin · Duration: 7 Months + Possible extensions · Location: Mclean VA · Responsibilities: · Develop data filtering, transformational and loading requirements · Define and execute ETLs using Apache Sparks on Hadoop among other Data technologies · Determine approp ...
Data Engineer

5 days ago

GDIT McLean, United States Full time

Job Description: · The Data Engineer will manipulate data and data flows for both existing and new systems. Additionally, they will provide support in the areas of data extraction, transformation and load (ETL), data mapping, analytics, operations, databases, and maintenance of d ...
Systems Engineer

3 weeks ago

B4Corp McLean, United States

Description: · Position Requires a Top Secret (TS/SCI) Clearance with a Polygraph. · The Customer is seeking support for the DevOps operations that include migration of legacy data, development of new system capabilities, extension and maintenance of bulk data pipeline and enhan ...
Systems Engineer STAR2265

4 weeks ago

Sabree Software Services McLean, United States Full time

Job Description · The Sponsor is seeking support for the DevOps operations that include migration of legacy data, development of new system capabilities, extension and maintenance of bulk data pipeline and enhancements for multiple mission applications in the Sponsor's cloud comp ...
Systems Engineer

1 week ago

00100 LEIDOS, INC. McLean, United States Full time

Join us at Leidos, where your most important work is ahead · At Leidos, everything we do is built on our commitment to do the right thing for our customers, our employees, and our communities. Our mission is to make the world safer, healthier, and more efficient through informat ...
Elasticsearch Engineer

2 weeks ago

Leading Path McLean, United States

The Software Engineer will design, develop, configure, support, and maintain Elasticsearch clusters and support the · development teams around that ecosystem. The ideal candidate is a hands-on platform builder with significant · experience in developing scalable data platforms, w ...
Data Engineer

2 weeks ago

ManTech Mclean, United States Paid Work

Secure our Nation, Ignite your Future · Can you protect and defend the most coveted targets in the world and ensure the safety of information systems assets and protect systems from intentional or inadvertent access or destruction? Join ManTech and help protect our national secur ...
Systems Engineer

1 week ago

B4Corp McLean, United States

Description: · Position Requires a Top Secret (TS/SCI) Clearance with a Polygraph. · The Customer's organization provides technical solutions and capabilities that enable a cadre of analysts to make critical assessments, including a platform to conduct enterprise search, digital ...
Software Developer

2 weeks ago

General Dynamics Information Technology McLean, United States Full time

Ensure the safety and security of our nation as a Software Developer at GDIT. You'll apply the latest technology and provide operational support to deliver actionable intelligence for the Intelligence Community. Here, your work will have meaning and impact as you deliver your bes ...
Application Development Support

2 weeks ago

Armison Tech McLean, United States

Armison Tech is a minority owned small business, established in 2012, located in the Northern Virginia area. We're a company predominantly focused on cyber security for our government customers yet our expertise in other areas include big data analytics, instructional design, inf ...