Senior ETL Developer

International Logic Systems - Washington, DC

Full-time - Mid Level

Washington, DC

Professional, Scientific, and Technical Services

About the position

The Senior ETL Developer will be responsible for designing and implementing enterprise-level solutions for multi-dimensional databases, focusing on business intelligence (BI) solutions. This role involves executing strategies for database backup, providing documentation, and ensuring quality assurance throughout the project lifecycle.

Responsibilities

• Understand database design, programming concepts, data modeling, and framework management
• Design, develop, and test advanced complex ETL/ELT solutions
• Automate robust data loading processes with exception handling and notification
• Support the project team throughout the design, development, and testing process
• Identify and reuse ETL components and services to avoid duplicative implementations
• Communicate ideas to both technical and non-technical people at all levels of the organization
• Knowledge of ETL architecture
• Strong knowledge of Oracle database, SQL, and analytical skills
• Create/maintain reports using Oracle Analytics Server (OAS)
• Sound knowledge of data warehousing principles (dimensional and normalized modeling concepts) and problem solving
• Desirable knowledge of ODI architecture and development in medium to large scale data warehouse environments
• Knowledge of performance tuning of SQL queries
• Analyze functional business applications and design specifications for functional areas such as finance, accounting, personnel, manpower, logistics, and contracts
• Develop block diagrams and logic flow charts
• Prepare required documentation, including both program-level and user-level documentation
• Enhance ELT/ELT process to reduce operating time or improve efficiency

Requirements

• 8 years of experience, with at least 3 years of specialized experience
• Experience as a data warehouse/database developer in medium to large-scale data warehouse environments
• Knowledge of data warehouse methodologies and ability to develop complex ETL/ELT code to satisfy design objectives
• Strong SQL/PL-SQL knowledge
• Demonstrated ability to work independently or under general direction
• Experience using Oracle database (12c/19c)
• Logical/Physical Data Modeling
• Enterprise Data Warehouse Reports and Dashboard (OBIEE+/OAS)
• ETL/ELT tools like ODI, Informatica, and reporting tools (PowerBI)
• Master Data Management (MDM)
• A Bachelor's degree in Computer Science, Information Systems, Engineering, Business, or other related scientific or technical discipline

Nice-to-haves

• Desirable knowledge of ODI architecture and development in medium to large scale data warehouse environments