SAP Crystal Reports Developer

Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision!; Brampton; Hybrid; CAD 85,000 - 120,000; Full time

Job summary

Astra-North Infoteck Inc. in Brampton, ON, is seeking a SAP Crystal Reports Developer for hybrid work (4 days in office). You will migrate and optimize Crystal Reports across Oracle and SAP HANA, validate data, and design efficient reports for business needs.

Ideal candidates have 6+ years of experience, strong SQL and data modeling skills, and a proven track record in Crystal Reports migration projects. The role emphasizes collaboration with stakeholders and documentation of migration efforts.

Qualifications

• Strong hands-on experience with SAP Crystal Reports development and maintenance.
• Solid understanding of Data Models, Data Sets, relational databases, and reporting architecture.
• Proven experience in Crystal Reports Migration projects.
• Experience performing Data Validation, Data Reconciliation, Performance Testing, and UAT support.

Responsibilities

• Execute end-to-end migration testing, including data validation and Analyze, design, develop, and maintain Crystal Reports solutions for business reporting needs.
• Review existing Crystal Reports developed on Oracle databases and migrate them to SAP HANA environments.
• Understand and interpret complex data models, relationships, schemas, and datasets.
• Redesign and optimize report queries for HANA performance standards.
• Perform report conversion, validation, reconciliation, and deployment activities.
• Execute end-to-end migration testing, including data validation and report comparison.
• Conduct performance testing and tuning of reports to ensure optimal execution times.
• Troubleshoot reporting issues, data discrepancies, and performance bottlenecks.
• Collaborate with business stakeholders, data architects, and database teams to gather requirements and validate outputs.
• Develop migration documentation, technical specifications, and support materials.
• Ensure reporting consistency, accuracy, and compliance with organizational standards.

Skills

SAP Crystal Reports

Data modeling

SQL querying

Migration projects

Performance tuning

Data validation

UAT support

Oracle to SAP HANA migration

Tools

Oracle Database

SAP HANA

Job description

SAP Crystal Reports Developer

Brampton, ON - Hybrid (4 Days WFO)

Skills:

SAP Crystal Reports

Experience Required:

6+

Role Descriptions:

• Execute end-to-end migration testing, including data validation and Analyze, design, develop, and maintain Crystal Reports solutions for business reporting needs.
• Review existing Crystal Reports developed on Oracle databases and migrate them to SAP HANA environments.
• Understand and interpret complex data models, relationships, schemas, and datasets.
• Redesign and optimize report queries for HANA performance standards.
• Perform report conversion, validation, reconciliation, and deployment activities.
• Execute end-to-end migration testing, including data validation and report comparison.
• Conduct performance testing and tuning of reports to ensure optimal execution times.
• Troubleshoot reporting issues, data discrepancies, and performance bottlenecks.
• Collaborate with business stakeholders, data architects, and database teams to gather requirements and validate outputs.
• Develop migration documentation, technical specifications, and support materials.
• Ensure reporting consistency, accuracy, and compliance with organizational standards.

Required Skills & Experience:

• Strong hands-on experience with SAP Crystal Reports development and maintenance.
• Solid understanding of Data Models, Data Sets, relational databases, and reporting architecture.
• Proven experience in Crystal Reports Migration projects.
• Experience performing:
  • Data Validation
  • Data Reconciliation
  • Performance Testing
  • User Acceptance Testing (UAT) support
• Strong SQL querying and database analysis skills.
• Experience identifying and resolving report performance issues.
• Ability to validate data accuracy between source and target environments.
• Strong analytical, troubleshooting, and problem-solving skills.

Preferred / Good-to-Have Skills:

• Experience with Crystal Reports on Oracle Database.
• Experience with Crystal Reports on SAP HANA.
• Familiarity with ETL processes and data migration methodologies. Hands-on experience with Oracle to SAP HANA migration projects.
• Understanding of SAP BusinessObjects reporting environment.
• Knowledge of HANA calculation views, analytical views, and performance optimization techniques.