Senior ETL Developer

Syms Strategic Group (SSG) is seeking a talented Senior ETL Developer

Location : 100% on-site downtown Washington DC

This is an on-site position located in downtown Washington DC. Remote or telework is not authorized. There are no exceptions.

Department : Veterans Affairs (VA)

Type : Full Time

Min. Experience : Experienced

Security Clearance Level : Public Trust (MBI)

Military Veterans are highly encouraged to apply!

Essential Duties and Responsibilities

• Data warehousing data modeling data integration data Migration ETL process and Business Intelligence
• Data Modeling design analysis and implementation - conceptual logical and physical data modeling data conversion data integration and data mining specialization in the area of Data Warehouse and Business Intelligence
• Installing configuring developing supporting and maintaining of the BI APPS
• Developing ETLs using Informatica to facilitate Extraction Transformation and data load from OLTP systems to OLAP systems
• Designing schema using KPIs Fact Dimensions Physical Logical Alias and Extension tables
• Building business model and established relationships and foreign keys (physical & logical) between tables
• Creating LDAP authentication to enable single-sign on for users in development environment leveraging analytics repository
• Using Informatica Mapping Designer to create / update mapping using different transformations required to move data into data warehouse
• Providing recommendations and identifying critical issues and processing faults as it pertains to data modeling ETLs and Informatica
• Other responsibilities as assigned

Required Skills and Experience

Professional Certifications

None required

Years of Professional Experience

15 years of ETL experience

Desired experience

Previous experience supporting a U.S. Federal Government agency.

Formal Education

Masters degree in computer science or other technical disciplines (an additional 10 years of experience after bachelors can substitute for a Masters degree).

Citizenship Requirement

U.S. Citizenship required for this specific opportunity

Security Clearance Requirements

Must possess or qualify for a Public Trust (MBI)

CRITICAL NOTES :

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.

Required Experience :

Senior IC

Key Skills

SQL,Pentaho,PL / SQL,Microsoft SQL Server,SSIS,Informatica,Shell Scripting,T Sql,Teradata,Data Modeling,Data Warehouse,Oracle

Employment Type : Full-Time

Experience : years

Vacancy : 1