Senior ETL Developer

Syms Strategic Group (SSG) – Senior ETL Developer

Location: 100% on-site, downtown Washington DC

Position: Full Time (100% on-site). Remote or telework is not authorized.

Department: Veterans Affairs (VA)

Type: Full Time

Minimum Experience: Experienced

Security Clearance Level: Public Trust (MBI)

Veterans encouraged to apply!

• 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 the BI APPS
• Developing ETLs using Informatica to facilitate Extraction, Transformation and load from OLTP systems to OLAP systems
• Designing schema using KPIs, Fact, Dimensions, Physical, Logical, Alias and Extension tables
• Building business model and establishing 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

• 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+ years 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)

• 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

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.