- Develops, implements, refines, and supports a data warehouse used for analytics and reporting, optimizing ETL processes while working closely with Business Analysts, Business Managers, Project Managers, and internal customers.
- Designs, codes, runs tests, and implements complex programs and scripts, and performs source-to-target data mapping.
- Reviews and implements project plans and business rules via stored procedures, middleware, or other technologies.
- Backs up the Senior ETL developer with providing rotational after-hours support.The ETL Developer may be required to work evenings or weekends.
- Be available on government site in Washington DC Monday Friday during normal working hours and support after-hours remotely when needed.
- 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. Environment or higher: OBIEE 12c, BI Apps.9.6.3, Web Logic Server, Informatica 9.0.1, Oracle , SQL, PL/SQL, DAC 7.8.4, TOAD, SQL* Plus, Unix, Windows XP.
- 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 & 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.
- Bachelors Degree in technical discipline, 8 additional years of experience considered in lieu of degree.
- 5+ years experience in ETL tools, especially Informatica and data warehousing applications.
- 5+ years experience developing and tuning complex SQL queries in Oracle relational database. Ability to work collaboratively with cross-functional teams and adapt to changing requirements.
- Prior experience in a federal data warehouse and understanding of government procedures and regulations is preferred.
- Must be authorized to work for any employer in the U.S.
- Must be able to obtain and maintain the required security clearance.
-
Etl Developer
1 week ago
ARFA Solutions, LLC Ashburn, United States**Responsibilities**: · - Design, develop, and maintain scalable ETL processes using Snowflake, Azure Data Factory, and other technologies · - Collaborate with cross-functional teams to gather and analyze business requirements · - Perform data profiling and develop data quality r ...
-
ETL Developer
4 days ago
SynOpt LLC Washington, United StatesJob Description · Job DescriptionThe right candidate will apply their technical knowledge in designing, implementing and maintaining Extract Transform Load (ETL) solutions. Responsibilities may include converting specifications into design and converting design into deliverables; ...
-
ETL Developer
1 week ago
iQuasar Washington, United StatesJob Description · Job DescriptionWe are seeking to fill the ETL Developer role for our customer in Washington DC. We strive to provide the next generation of cutting-edge technologies. Our growth means exciting career opportunities for talented professionals in engineering, softw ...
-
ETL Developer
1 week ago
Syms Strategic Group, LLC (SSG) Washington, United StatesJob Description · Job DescriptionSyms Strategic Group (SSG) is seeking a talented Extract, Transform, and Load (ETL) Developer · Department: Veterans Affairs · Location: On-site, Washington, DC · Type: Full Time · Min. Experience: Experienced · Security Clearance Level: Public T ...
-
ETL Developer
4 days ago
Amida Technology Solutions Washington, United StatesJob Description · Job DescriptionAmida Technology Solutions is a DC-based software services company focused on the most difficult problems in data interoperability, exchange, governance, and security. We design, develop, and deploy software solutions that collect, reconcile, and ...
-
ETL Developer
3 days ago
Syms Strategic Group, LLC (SSG) Washington, United StatesJob Description · Job DescriptionSyms Strategic Group (SSG) is seeking a talented Extract, Transform, and Load (ETL) Developer · Department: Veterans Affairs · Location: On-site, Washington, DC · Type: Full Time · Min. Experience: Experienced · Security Clearance Level: Public T ...
-
ETL Developer
3 days ago
Syms Strategic Group, LLC (SSG) Arlington, United StatesJob Description · Job DescriptionSyms Strategic Group (SSG) is seeking a talented Extract, Transform, and Load (ETL) Developer · Department: Veterans Affairs · Location: On-site, Washington, DC · Type: Full Time · Min. Experience: Experienced · Security Clearance Level: Public T ...
-
ETL Developer
1 week ago
Syms Strategic Group, LLC (SSG) Arlington, United StatesJob Description · Job DescriptionSyms Strategic Group (SSG) is seeking a talented Extract, Transform, and Load (ETL) Developer · Department: Veterans Affairs · Location: On-site, Washington, DC · Type: Full Time · Min. Experience: Experienced · Security Clearance Level: Public T ...
-
AWS and ETL Developer
6 days ago
RICEFW Technologies Washington, DC, United StatesJoin our Data Cloud team in DC and embark on an exciting journey as an AWS and ETL Developer We're seeking a skilled individual with expertise in Amazon Web Services (AWS) and Extract, Transform, Load (ETL) processes. Your role will involve crafting and maintaining ETL pipelines, ...
-
Etl Developer Iii
1 day ago
SoHo Dragon Vienna, United StatesSoHo Dragon is looking to hire an ETL Developer III (Cloud Developer) to work in Vienna, VA office. Visa sponsorship is not available. · This is a 100% onsite opportunity. · **Responsibilities**: · - Analyzes, defines, and documents requirements for data, workflow, logical proces ...
-
Sr. ETL Developer
6 days ago
Onyx Government Services,LLC Washington, United StatesJob Description · Job DescriptionOnyx Government Services, LLC., is a Service-Disable Veteran-Owned Small Business (SDVOSB), headquartered in Fairfax, Virginia. We specialize in data management, integration, and analysis solutions to provide decision-ready information to Command ...
-
Sr. ETL Developer
4 days ago
Outland Recruiting Washington, United StatesJob Description · Job DescriptionJoin our dynamic team at the Office of Performance Analysis and Integrity, where we manage and enhance the Veterans Benefits Administration (VBA) Enterprise Data Warehouse (EDW) and associated applications. Our responsibilities span Project Manage ...
-
9WAY5 ETL Developer
6 days ago
Warriors Recruiting Washington, United StatesJob Description · Job DescriptionETL Developer · Location: DC, On-site · Our client is a service-disabled, veteran-owned small business bringing transformative technology to our government customers so they can achieve their missions. Our specialties include cybersecurity, cloud ...
-
Lead ETL Developer
3 days ago
Universal Service Administrative Company Washington, United StatesJob Description · Job DescriptionUSAC's target compensation range for a new hire into this position is $105,000 - $145,000 USD per year. Actual salary may vary depending on job-related factors based on knowledge, skills, and experience, as evaluated throughout the interview proce ...
-
ETL Developer
3 days ago
General Dynamics Information Technology West Bethesda, United StatesSeize your opportunity to make a personal impact as an ETL Developer supporting customer activities. GDIT is your place to make meaningful contributions to challenging projects and grow a rewarding career. · At GDIT, people are our differentiator. As an ETL Developer, you will he ...
-
ETL Developer
3 days ago
Syms Strategic Group, LLC (SSG) Alexandria, United StatesJob Description · Job DescriptionSyms Strategic Group (SSG) is seeking a talented Extract, Transform, and Load (ETL) Developer · Department: Veterans Affairs · Location: On-site, Washington, DC · Type: Full Time · Min. Experience: Experienced · Security Clearance Level: Public T ...
-
ETL Developer
1 week ago
Syms Strategic Group, LLC (SSG) Alexandria, United StatesJob Description · Job DescriptionSyms Strategic Group (SSG) is seeking a talented Extract, Transform, and Load (ETL) Developer · Department: Veterans Affairs · Location: On-site, Washington, DC · Type: Full Time · Min. Experience: Experienced · Security Clearance Level: Public T ...
-
ETL Developer
2 days ago
General Dynamics Information Technology Bethesda, United StatesSeize your opportunity to make a personal impact as an ETL Developer supporting customer activities. GDIT is your place to make meaningful contributions to challenging projects and grow a rewarding career.At GDIT, people are our differentiator. As an ETL Developer, you will help ...
-
ETL Developer
3 days ago
General Dynamics Bethesda, United StatesResponsibilities for this Position Location: USA MD Bethesda - Customer Proprietary (MDC240)Full Part/Time: Full timeJob Req: RQ171188 Type of Requisition: RegularClearance Level Must Currently Possess: Top Secret SCI + PolygraphClearance Level Must Be Able to Obtain: Top Secret ...
-
ETL Developer
3 days ago
Syms Strategic Group, LLC (SSG) Silver Spring, United StatesJob Description · Job DescriptionSyms Strategic Group (SSG) is seeking a talented Extract, Transform, and Load (ETL) Developer · Department: Veterans Affairs · Location: On-site, Washington, DC · Type: Full Time · Min. Experience: Experienced · Security Clearance Level: Public T ...
ETL Developer - Washington, United States - Outland Recruiting
Description
Job Description
Job DescriptionJoin our dynamic team at the Office of Performance Analysis and Integrity, where we manage and enhance the Veterans Benefits Administration (VBA) Enterprise Data Warehouse (EDW) and associated applications. Our responsibilities span Project Management, Data Warehouse Management, Advanced Analytics, Tableau Server Administration, Technical Collaboration Support, and more.
Responsibilities:
Requirements: