OFSAA Developer

OFSAA Developer

Required Skills

• Bachelor s degree in Computer Science Information Technology or a related field (or equivalent practical experience).
• Minimum 5 years of experience in the design development and support of data-driven applications covering all phases of the SDLC in highly scalable multi-tier distributed environments.
• Financial services and/or enterprise-level experience is required.
• Strong experience with SQL and PL/SQL including development of packages procedures functions and other database objects.
• Strong hands-on experience with Data Warehousing concepts including dimensional modeling (star/snowflake schemas) fact and dimension tables metadata and performance tuning.
• Solid experience with ETL and Data Integration principles including extracting transforming and loading data from multiple source systems.
• Hands-on experience using Python for data processing ETL automation analysis and scripting including database and API integrations.
• Strong experience with Business Intelligence (BI) reporting including development support and optimization of reports and dashboards for business and regulatory users.
• Working knowledge of Java and/or REST APIs.
• Experience with Unix/Linux environments and shell scripting.
• Experience with enterprise job scheduling tools such as BMC Control M and/or AutoSys.
• Willingness to occasionally work non-standard shifts including nights weekends and on-call rotations.
• Excellent written and verbal communication skills with the ability to collaborate effectively with business and technical stakeholders.

Preferred Skills

• Experience with Oracle Financial Services Analytical Applications (OFSAA).
• Experience with Microsoft Azure DevOps including CI/CD pipelines and work tracking.
• Experience with regulatory and risk reporting particularly CECL and CCAR.
• Advanced experience with Business Intelligence tools and reporting platforms.
• Data Governance experience including:
  • Data Quality (DQ) rules validations profiling and issue remediation
  • Data Lineage documentation (technical and business lineage)
  • Metadata management and data cataloging
  • Data controls reconciliation and audit support for regulatory compliance
• Exposure to cloud-based data platforms data warehouses or BI solutions is a plus.

Pi-square technologies is a Michigan (USA) Headquartered Automotive Embedded Engineering Services company Synergy Partner for major OEMs and Tier 1s and their implementation partners in Automotive Embedded Product Development Projects Requirements Analysis Software Design Software Implementation Efficient Build Release Process and turnkey software V & V Services. We have more than 20 years of industry expertise with specialization in the latest cutting-edge automotive technologies such as Infotainment connected vehicles Cyber security OTA and Advanced Safety/ Body electronics.