Senior ETL Developer

Washington, AR - USA

Monthly Salary: Not Disclosed

Posted on: 16 hours ago

Vacancies: 1 Vacancy

Job Summary

Syms Strategic Group (SSG)is seeking a talented Senior ETL Developer
Location: 100% on-site downtown Washington DC
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
Masters degree in computer science or other technical disciplines (an additional 10 years of experience after bachelors can substitute for a Masters degree). 15 experience in ETL tools especially Informatica and data warehousing applications 10 years experience developing and tuning complex SQL queries in Oracle relational database Must be able to obtain and maintain the required security clearance
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:	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 a 100% on-site position. No exceptions and remote or telework is not available. This can be either a 1099 or W2 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.

Required Experience:

Senior IC

Syms Strategic Group (SSG)is seeking a talented Senior ETL Developer Location: 100% on-site downtown Washington DCDepartment: Veterans Affairs (VA)Type:Full TimeMin. Experience:ExperiencedSecurity Clearance Level:Public Trust (MBI)Military Veterans are highly encouraged to apply!Essential Duties and...

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
Masters degree in computer science or other technical disciplines (an additional 10 years of experience after bachelors can substitute for a Masters degree). 15 experience in ETL tools especially Informatica and data warehousing applications 10 years experience developing and tuning complex SQL queries in Oracle relational database Must be able to obtain and maintain the required security clearance
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:	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 a 100% on-site position. No exceptions and remote or telework is not available. This can be either a 1099 or W2 position.