SQL Developer - WebFOCUS - Banking*
Posted 1 week ago by GIOS Technology
Negotiable
Undetermined
Hybrid
London Area, United Kingdom
Summary: The SQL Developer role involves designing, developing, and maintaining database systems while optimizing SQL queries to ensure data integrity and security. The position also includes responsibilities as a WebFOCUS developer, focusing on creating and managing reporting and business intelligence applications. Collaboration with stakeholders and other developers is essential to integrate database solutions into applications that meet business requirements. The role is based in London and operates in a hybrid working arrangement.
Key Responsibilities:
- Designing database structures, tables, views, stored procedures, and functions.
- Writing and optimizing SQL queries for data manipulation and retrieval.
- Ensuring database stability, reliability, and performance.
- Implementing measures to protect data from unauthorized access and ensuring data accuracy.
- Collaborating with other developers to integrate database solutions into applications.
- Creating and modifying WebFOCUS reports based on user specifications.
- Understanding and structuring data for reporting purposes in WebFOCUS.
- Creating and maintaining data definitions and mappings within WebFOCUS.
- Implementing security measures and user access controls in WebFOCUS.
- Identifying and resolving data discrepancies and report errors.
Key Skills:
- Proficiency in SQL and T-SQL.
- Experience with MS SQL database systems.
- Knowledge of database design and development.
- Ability to write and optimize SQL queries.
- Experience with WebFOCUS platform for reporting and BI applications.
- Strong analytical and troubleshooting skills.
- Collaboration and communication skills.
- Understanding of data integrity and security measures.
Salary (Rate): undetermined
City: London
Country: United Kingdom
Working Arrangements: hybrid
IR35 Status: undetermined
Seniority Level: undetermined
Industry: IT
Role: SQL Developer
Location: London, UK(Hybrid)
As SQL Developer - Can design, develop, implement, and maintain database systems, creating and optimizing SQL queries, and ensuring data integrity and security. Work with various SQL database systems, including MS SQL and T-SQL, to build, manage, and enhance database solutions. Collaborate with other developers and stakeholders to integrate database solutions into applications and meet business requirements.
As Webfocus developer, can create and maintain reporting, dashboarding, and business intelligence (BI) applications using the WebFOCUS platform. Responsible for developing reports, analyzing data, designing metadata, and managing security within the WebFOCUS environment. Work closely with business users to understand their needs and deliver tailored solutions.
SQL Developer:
- Database Design and Development: Designing database structures, tables, views, stored procedures, and functions
- SQL Querying: Writing and optimizing SQL queries for data manipulation and retrieval.
- Database Maintenance: Ensuring database stability, reliability, and performance.
- Data Integrity and Security: Implementing measures to protect data from unauthorized access and ensuring data accuracy.
- Collaboration: Working with other developers to integrate database solutions into applications.
Webfocus developer:
- Developing WebFOCUS reports: Creating and modifying reports based on user specifications, including advanced reports with drill-downs.
- Analyzing and designing WebFOCUS metadata: Understanding and structuring data for reporting purposes.
- Building and managing WebFOCUS metadata: Creating and maintaining data definitions and mappings within WebFOCUS.
- Designing WebFOCUS security and sign-ons: Implementing security measures and user access controls.
- Data analysis and troubleshooting: Identifying and resolving data discrepancies and report errors.