International Logic Systems, Inc.
Senior ETL Developer
International Logic Systems, Inc., Washington, District of Columbia, us, 20022
Join to apply for the
Senior ETL Developer
role at
International Logic Systems, Inc.
ILS is looking for a Senior ETL Developer to support projects in Washington, DC. The candidate will be responsible for designing enterprise‑level solutions for multi‑dimensional databases, planning BI solutions, executing database backup strategies, and providing documentation and quality assurance.
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 program‑level and user‑level documentation.
Enhance ELT/ELT process to reduce operating time or improve efficiency.
Qualifications
8+ years of experience, with at least 3 years specialized in ETL/database development on medium to large‑scale data warehouse environments.
Experience designing complex ETL/ELT code to satisfy design objectives, with strong SQL/PL‑SQL knowledge.
Professional ability to work independently or under minimal direction.
Experience with Oracle database (12c/19c), logical/physical data modeling, enterprise data warehouse reporting (OBIEE+/OAS), ETL/ELT tools such as ODI, Informatica, PowerBI, MDM, and SQL/PL‑SQL development.
Bachelor’s degree in Computer Science, Information Systems, Engineering, Business, or related discipline.
#J-18808-Ljbffr
Senior ETL Developer
role at
International Logic Systems, Inc.
ILS is looking for a Senior ETL Developer to support projects in Washington, DC. The candidate will be responsible for designing enterprise‑level solutions for multi‑dimensional databases, planning BI solutions, executing database backup strategies, and providing documentation and quality assurance.
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 program‑level and user‑level documentation.
Enhance ELT/ELT process to reduce operating time or improve efficiency.
Qualifications
8+ years of experience, with at least 3 years specialized in ETL/database development on medium to large‑scale data warehouse environments.
Experience designing complex ETL/ELT code to satisfy design objectives, with strong SQL/PL‑SQL knowledge.
Professional ability to work independently or under minimal direction.
Experience with Oracle database (12c/19c), logical/physical data modeling, enterprise data warehouse reporting (OBIEE+/OAS), ETL/ELT tools such as ODI, Informatica, PowerBI, MDM, and SQL/PL‑SQL development.
Bachelor’s degree in Computer Science, Information Systems, Engineering, Business, or related discipline.
#J-18808-Ljbffr