Senior ETL Developer at International Logic Systems, Inc.

Washington, District of Columbia, United States -

Full Time

Start Date

Immediate

Expiry Date

27 Jan, 26

Salary

0.0

Posted On

29 Oct, 25

Experience

10 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

ETL, ELT, Oracle Database, SQL, Data Modeling, Data Warehousing, Performance Tuning, Informatica, PowerBI, Master Data Management, Oracle Analytics Server, Problem Solving, Documentation, Data Loading, Business Applications, Exception Handling

Industry

IT Services and IT Consulting

Description

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. Qualifications 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.

Responsibilities

The Senior ETL Developer will design Enterprise-level solutions for multi-dimensional databases and execute strategies for database backup. They will also support the project team throughout the design, development, and testing process.