Description

Akkodis is seeking an experienced Senior ETL - Software Developer with strong expertise in data warehousing, ETL development, Oracle SQL/PL/SQL, Informatica, Crystal Reports, Power BI, and BusinessObjects Enterprise (BOE).

The successful consultant will be responsible for analyzing, designing, developing, testing, troubleshooting, and enhancing enterprise data warehouse and business intelligence solutions. The role requires hands-on expertise in ETL development, dimensional modelling, database development, BI reporting, data transformation, and enterprise reporting environments.

The consultant will collaborate with technical teams, business stakeholders, subject matter experts, and project leadership throughout the Software Development Life Cycle (SDLC).

Scope

Develop and maintain ETL processes using Informatica.

Design, develop, and optimize Oracle SQL and PL/SQL components.

Develop ETL scripts to extract, transform, and load data from transactional databases into enterprise Data Warehouses and Data Marts.

Design and develop reports using Crystal Reports, Power BI, and BusinessObjects Enterprise (BOE).

Assignment Deliverables

ETL solution designs and technical specifications.

Informatica mappings, workflows, and ETL processes.

Oracle SQL and PL/SQL scripts and database components.

Data Warehouse and Data Mart solutions.

Dimensional data models.

Expertise Required

Must Have:

5+ years of experience performing analysis, design, development, unit testing, defect resolution, and related development activities within data warehousing and BI environments.

5+ years of experience designing and developing Crystal Reports, Power BI, and BOE reports.

5+ years of experience designing, developing, and testing Oracle SQL and PL/SQL.

5+ years of experience designing, developing, and testing solutions using Informatica.

Strong experience with enterprise technology solutions and software development methodologies.

Experience analyzing and designing changes to existing web-based software solutions.

Strong knowledge of Software Development Life Cycle (SDLC) methodologies, including Agile development.

Strong experience with Data Warehouse design, reporting, and ETL concepts.

Experience with Data Warehouse architecture, dimensional modelling, development, and deployment of business intelligence solutions.

Nice to Have:

Experience developing reports, dashboards, and analytical solutions using Microsoft Power BI.

Knowledge of BusinessObjects Universe, Web Intelligence/WebI, dashboarding, and reporting technologies

Key Skills

Education

Any Graduate