Syms Strategic Group, LLC (SSG) · 2 hours ago
Senior ETL Developer
Washington, DC
Full-time
Onsite
Senior Level, Lead/Staff
15+ years expSyms Strategic Group (SSG) is seeking a talented Senior ETL Developer. The role involves responsibilities such as data warehousing, data modeling, and developing ETLs using Informatica to facilitate data extraction and transformation.
Business DevelopmentDevOpsInformation TechnologyProfessional Services
No H1B
Security Clearance RequiredU.S. Citizen Only
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
Qualification
Required
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
U.S. Citizenship required for this specific opportunity
Must possess or qualify for a Public Trust (MBI)
Preferred
Previous experience supporting a U.S. Federal Government agency
Company
Syms Strategic Group, LLC (SSG)
Syms Strategic Group, LLC (SSG) is a Small Disabled Veteran Owned Small Business (SDVOSB) located in Ashburn, VA supporting multiple federal agencies including the Department of Veterans Affairs (VA) and the Department of Defense (DOD).
11-50 employees
Funding
Current Stage
Early StageLeadership Team
Edward J. Syms
CEO/President
Company data provided by crunchbase