Crystal Reports Developer in Toronto at APEX Systems

Date Posted: 7/13/2018

Job Snapshot

  • Employee Type:
  • Location:
  • Job Type:
  • Experience:
    Not Specified
  • Date Posted:

Job Description

Job #:  863919

Crustal Reports Developer:
Linux- Crystal.

SAP Reports
Not administration- develop and review code

Needs SQL
Nice to Have: Jr java experience 1-2 years

Crystal reports developer:

Heavy crystal reports exp – creating designing developing crystal reports SAP tool

SAP universe

This data is used for operations, and different LOB, all the reports are hosted on SAP.

2 flavours – 1. Hands on SAP crystal reports exp. SAP Webi exp, SAP universe. All correlated – wants hands on exp with design to create – to open existing reports to troubleshoot – to review other developers design (offshore reports). Over see these reports, if there are any issues, if the report is failing – this person will dive in and help to trouble shoot.

Data is on Oracle database 12c. Heavily linked with SQL so SQL is required.

Writing a well performing SQL query is required.

Data is coming from various ETL sources, then its brought to Oracle 12c database.

Dimensional type of schema for some sources – its beneficial if the candidate has some exp w. dimensional modeling database tables ( NTH, but really good)

Once the report is developed, it needs to be deployed on SAP business objects.

There is a SAP framework upgrade every 2-3 years, if the person comes in with SAP management (installation of application framework that is great) (if not we will train the person)

At a high level – deploy on IBM WebSphere this is how the group works.

Candidate must provide production support every 2 months for 1 week (paid) – they will carry a pager for production support

Since its running on a Linux server, it is beneficial to have scripting knowledge

ETL tools exp is NTH since they are running ETL
Spring ( they will be sourcing from Oracle)
Batch framework


Nice to have:

Core Java, spring. Java code is deployed on IBM websphere.
Also very beneficial to have PLSQL for stored procedures. Out of 10, needs a good 7/8 working knowledge.
Oracle Goldengate- Really nice to have. They are currently running on Oracle 12c but they are looking into Oracle goldengate as it seems to be able to expedite the process. Oracle goldengate will be used for transformation from passing JSON from the Source to the Target


Group has moved into Dev-ops they are not doing Sprints every 2-4 weeks, but the Candidate joining their team should be familiar with automation tools. What is Jira, what is confluence, the candidate should be equipped with this knowledge

Communication skills  are very important as they will be communicating and working with various lines of business and operations. Group is made of 30 people on and off shore so the Candidate will be collecting data from various sources

Crystal Reports Developer:
Crystal Reports, Webi, Universe Development
Crystal Reports Experience
SAP Universe is nice to have
Troubleshoot existing reports
Oracle Database Back-end (SQL)
Good Knowledge of SQL is required (Good Performing Queries are important)
ETL data is brought into Oracle 12c
Both normalized and Dimensional table schema exist (Having the experience in this area is very beneficial but not mandatory)
SAP BOBJ Reports deployment
Framework (BOE) upgrade is done. CMC and or administration is great. (Will teach)
BOE 4.1 on Linux
Setting up jar files on IBM Web Sphere (Deployment)
Production Support
Working knowledge of Linux is required