ETL DeveloperNew

9th Way Insignia • Washington, DC

378d • $94,990 - $99,000

About The Position

The Senior ETL Developer at 9th Way Insignia will be responsible for developing, implementing, and supporting a data warehouse used for analytics and reporting. This role involves optimizing ETL processes and collaborating with various stakeholders to ensure effective data integration and management within the Veterans Benefits Administration's Enterprise Data Warehouse.

Requirements

• 5+ years' experience in ETL tools, especially Informatica and data warehousing applications.
• 5+ years' experience developing and tuning complex SQL queries in Oracle relational databases.
• 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.

Nice To Haves

• Experience with cloud migration and advanced analytics.
• Familiarity with Tableau Server Administration and Tableau Desktop Administration.

Responsibilities

• Develop, implement, refine, and support a data warehouse for analytics and reporting.
• Optimize ETL processes while collaborating with Business Analysts, Business Managers, and Project Managers.
• Design, code, run tests, and implement complex programs and scripts, performing source-to-target data mapping.
• Review and implement project plans and business rules via stored procedures and middleware technologies.
• Engage in data warehousing, data modeling, data integration, data migration, and business intelligence activities.
• Install, configure, develop, support, and maintain BI applications including OBIEE and Informatica.
• Develop ETL processes using Informatica to facilitate data extraction, transformation, and loading from OLTP to OLAP systems.
• Design schemas using KPIs, Fact, Dimensions, and establish relationships between tables.
• Create LDAP authentication for Single-Sign-On in the development environment.
• Provide recommendations and identify critical issues related to data modeling and ETL processes.

Benefits

• Medical insurance
• Dental insurance
• Vision insurance
• Voluntary life insurance
• 401(k) plan
• Basic life and accidental death & dismemberment insurance
• Short-term disability (STD)
• Long-term disability (LTD)
• Paid time off (PTO)
• Telehealth services
• Paid holidays
• Flexible spending account (FSA)
• Health savings account (HSA)
• Employee Assistance Program (EAP)
• Traveling assistance.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed