Job description

Project description

We are looking to hire skilled professionals to help build out an enterprise-grade data quality profiling solution. A working Proof of Concept (PoC) has already been implemented over Avaloq using the existing Oracle APEX infrastructure. The next phase is focused on industrialising the solution and scaling it for broader use.

Responsibilities

Enhance and productionise the existing data quality profiling PoC using Oracle APEX

Collaborate with SMEs and technical stakeholders to capture and refine business and technical requirements

Translate high-level discussions into structured documentation and user stories

Work closely with DBAs and architects to optimise performance and scalability

Ensure alignment with industry-standard data quality profiling frameworks and dimensions (e.g., completeness, accuracy, consistency)

Support solution testing and deployment in both development and production environments

Skills

Must have

Expertise in Oracle APEXProven experience developing complex, data-centric applications

Strong Business Analysis (BA) capabilitiesSelf-starter with the ability to independently engage SMEs and document requirements

Oracle PL/SQLSolid coding and troubleshooting skills; performance tuning and DBA knowledge is a strong advantage

Experience with AvaloqFamiliarity with Avaloq's physical data layer is essential

Knowledge of data quality frameworksUnderstanding of profiling dimensions and industry-standard approaches (e.g., DQ checks, data validation rules)

Nice to have

Experience with Avaloq Reporting & Data Extracts (ARD, ADF, SmartView)

Familiarity with Avaloq-specific data export or reporting mechanisms would help accelerate development.

Knowledge of Oracle Database Tuning / Performance Diagnostics

In-depth understanding of execution plans, indexes, and session performance tools.

Experience with Data Quality Tools or Frameworks

Exposure to tools like Informatica DQ, Talend DQ, Collibra, or custom-built DQ engines.

Familiarity with Data Governance Practices

Understanding of data stewardship, lineage, and regulatory reporting requirements (e.g., BCBS 239, GDPR).

Experience in Financial Services / Core Banking Systems

Previous experience in banking, especially wealth or private banking, adds strong domain value.

Exposure to Agile / Scrum Delivery Methodologies

Ability to work in iterative delivery cycles, contribute to sprint planning, and maintain documentation in JIRA/Confluence.

Front-End/UI Experience within APEX

Skills in designing intuitive dashboards or user interfaces, particularly for DQ dashboards or exception reporting.

Data Visualisation & Reporting Tools

Experience with tools like Power BI, Oracle BI Publisher, or Tableau for representing data profiling results.

Scripting/Automation

Ability to automate DQ checks using Shell, Python, or other scripting tools is a plus.

Understanding of Metadata Management Concepts

Helps in building reusable and sustainable DQ frameworks across different domains.

Location - pune,mumbai,chennai,Bengaluru

Role: Data warehouse Developer

Industry Type: Legal

Department: Engineering - Software & QA

Employment Type: Full Time, Permanent

Role Category: DBA / Data warehousing