Senior ETL Developer - International Logic Systems, Inc.
Washington, DC 20571
About the Job
Overview:
ILS is looking for Senior ETL Developer to support one of our projects in Washington, DC. This resource will be responsible for designing Enterprise-level solutions for multi-dimensional databases, will design and plan BI solutions, execute strategies for database backup, and provide documentation implementation and quality assurance.
Responsibilities:- Understand database design, programming concepts, data modeling, and framework management
- Design, develop, and test advanced complex ETL/ELT solutions
- Automate a robust data loading processes with exception handling and notification.
- Support the project team throughout the design, development and testing process.
- Identify and reuse of ETL components and services to avoid duplicative implementations.
- Communicate ideas to both technical and non-technical people in 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 on Data warehousing principles (dimensional and normalized modeling concepts) and Problem solving
- Desirable knowledge on 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.
- Prepares required documentation, including both program-level and user-level documentation.
- Enhance ELT/ELT process to reduce operating time or improve efficiency.
- 8 years of experience, of which at least 3 years must be “specialized”
- Specialized experience includes:
- Experience as a data warehouse/database developer on 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 only general direction
Experience in using:
- Oracle database (12c/19c)
- Logical/Physical Data Modeling
- Enterprise Data Warehouse Reports and Dashboard (OBIEE+/OAS)
- ETL/ELT tools like ODI, Informatica, any reporting tools (PowerBI)
- Master Data Management (MDM)
- SQL and PL/SQL
- A Bachelor’s degree in Computer Science, Information Systems, Engineering, Business, or other related scientific or technical discipline is required.
Source : International Logic Systems, Inc.