Senior ETL Developer
About The Position
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
Requirements
- 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
Nice To Haves
- Previous experience supporting a U.S. Federal Government agency.
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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
