Software Developer jobs in United Kingdom
Senior Java/ ETL Software Developer (Java, ETL, SQL, PL/SQL, Power BI)
Source Code
Discover more opportunities than anywhere else. Find more jobs now
Connect with headhunters to apply for similar jobsSenior Software Developer
Firstbase
Senior Java / ETL Software Developer (Java, ETL, SQL, PL/SQL, Power BI)
Job summary
A technology services company is seeking a Senior Java/ETL Software Developer to design and develop data warehousing and BI applications. Candidates should have 5+ years of Java and ETL experience, including data Warehouse design and reporting. The role also requires strong SQL, PL/SQL, and Informatica skills, with responsibilities ranging from analysis and design to unit testing and defect fixing. This position is based in Toronto, Ontario, and offers opportunities in a dynamic work environment.
Qualifications
- 5+ years of experience in Java-based software development.
- 5+ years of ETL experience including data warehouse design.
- 3+ years of experience with SQL and PL/SQL.
- 3+ years of experience in Informatica.
Responsibilities
- Develop data warehousing and BI applications.
- Perform analysis, design, and testing in Oracle PL/SQL.
- Translate technical specifications into applications.
Skills
Tools
Job Openings Senior Java/ ETL Software Developer (Java, ETL, SQL, PL/SQL, Power BI)
Employment Ontario is one of the major programs delivered by the Employment and Training Division of the Ontario Ministry of Training, Colleges and Universities. Employment Ontario helps the citizens of Ontario gain the training, skills and experience to achieve their goals.
The Employment Ontario Information Systems (EOIS) is the major IT system that supports the administration of these programs. Application subsystems under EOIS include CaMS (Case Management System), Service Provider lifeCycle (SPL), EO Self Service (EOSS), APPR (Apprenticeship), COJG (Canada Ontario Job Grant), and APPR AOL (Apply OnLine).
The operating Environment includes J2EE, CURAM, Crystal Reports, Oracle SQL/PL SQL, Power BI, Oracle Database, Business Objects Universe and Dashboarding, WebI, and Bursting technologies, and Informatica ETL.
This request is for strong developers to help in designing and developing data warehousing, BI, reporting and analytics.
Perform analysis, design, developing, unit testing, defect fixing and other necessary tasks in a data warehousing and BI environment in Oracle PL/SQL
Design, develop and test Informatica mappings
- ETL scripts to transfer and transform data from OLTP database to Data Warehouse and Data marts.
- Nice to have skills in Crystal reports, Power BI, and BOE reporting
Required to translate technical systems specifications into working, tested applications. This includes:
- Developing detailed programming specifications
- writing and/or generating code
- Compiling data-driven programs, maintaining, and conducting unit tests
- Resolves and troubleshoots technical problems which arise during the use and operation of software packages, including technical assistance in implementation, conversion, and migrations.
- 5 yr+ Demonstrated experience in JAVA-based software development.
- 5+ years of ETL experienceincluding data Warehouse design, Reporting and ETL concepts.
- 3+ years experience with analysis, design, developing, unit testing, defect fixing and other necessary tasks in data warehousing, BI environmentdesigning and developing data warehousing, BI, reporting and analytics
- 3+ years Experience in Designing, developing and testing SQL and PL/SQL.
- 3+ years Experience in Designing, developing and testing in Informatica.
- Experience in RDBMS design concepts.
- Experience with Data Warehouse architecture, design, dimensional modeling, development and deployment of business intelligence systems.
- Crystal reports, Power BI, and BOE reporting
* The salary benchmark is based on the target salaries of market leaders in their relevant sectors. It is intended to serve as a guide to help Premium Members assess open positions and to help in salary negotiations. The salary benchmark is not provided directly by the company, which could be significantly higher or lower.