Senior ETL Developer at Syms Strategic Group LLC SSG

Severna Park, Maryland, United States -

Full Time

Start Date

Immediate

Expiry Date

09 May, 26

Salary

0.0

Posted On

09 Feb, 26

Experience

10 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

ETL, Informatica, Data Warehousing, Data Modeling, SQL, Data Integration, Data Migration, Business Intelligence, Data Mining, Schema Design, LDAP Authentication, Mapping Designer, Data Conversion, KPI, Fact Tables, Dimension Tables, Foreign Keys

Industry

IT Services and IT Consulting

Description

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 ETL’s 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 Master's degree in computer science or other technical disciplines (an additional 10 years of experience after bachelor’s can substitute for a Master’s 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 Master's degree in computer science or other technical disciplines (an additional 10 years of experience after bachelor’s can substitute for a Master’s 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.

Responsibilities

The Senior ETL Developer will be responsible for data warehousing, data modeling, data integration, and ETL processes. They will also develop ETLs using Informatica and design schemas for data management.