Senior ETL Developer

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. 

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