Senior Oracle PL/SQL Developer | Remote Data Warehouse Specialist

We're seeking an accomplished Oracle PL/SQL Developer to join our progressive team building sophisticated data warehouse solutions for the financial sector. In this remote position, you'll harness your expertise in Oracle database technologies, ETL processes, and data integration to architect and implement robust data systems that drive business intelligence and strategic decision-making across our global financial operations.

About the Role

As a Senior Oracle PL/SQL Developer, you'll operate at the core of our data infrastructure, creating efficient data pipelines and warehouse solutions that transform complex datasets into actionable business insights. You'll collaborate with a distributed team of database specialists, business analysts, and IT professionals to deliver high-performance, scalable database solutions meeting the intricate requirements of modern financial institutions.

Key Responsibilities

- Design, develop, and optimize complex PL/SQL stored procedures, functions, packages, and triggers for enterprise-grade data warehouse implementations.

- Implement and maintain sophisticated ETL processes using Oracle ODI, Informatica, or equivalent tools to ensure data quality and integrity across disparate systems.

- Create efficient data models and database schemas aligned with business requirements and stringent performance standards.

- Troubleshoot and resolve database performance bottlenecks, optimizing queries and database structures for maximum efficiency.

- Collaborate with cross-functional teams to translate business requirements into precise technical specifications.

- Document database designs, data flows, and technical processes according to organizational standards.

- Participate in code reviews and implement industry best practices for database development.

- Contribute to the continuous evolution of data warehouse architecture and processes.

- Monitor database performance metrics and implement proactive maintenance procedures.

- Ensure data security and compliance with financial industry regulations (including GDPR, PCI DSS, and SOX).

Required Skills & Experience

- At least 2 years of demonstrable experience as a Data Warehouse Developer or Architect.

- Strong proficiency in Oracle PL/SQL development (Oracle Database 19c or newer).

- Hands-on experience with ETL tools, particularly Oracle ODI and Informatica PowerCenter.

- Working knowledge of CASE-tools for database modeling and design.

- Previous experience in banking or finance sector projects is essential.

- Experience with data migration, transformation, and integration in enterprise environments.

- Familiarity with dimensional modeling concepts (star and snowflake schemas).

- Solid understanding of database performance tuning and query optimization techniques.

- Experience with version control systems and database change management processes.

- Ability to write efficient SQL queries and interpret execution plans.

Nice to Have

- Experience with Oracle Autonomous Database or Oracle Cloud Infrastructure.

- Knowledge of data visualization tools like Tableau, Power BI, or Oracle Analytics.

- Experience with big data technologies (Hadoop, Spark) or NoSQL databases.

- Understanding of agile development methodologies and JIRA workflows.

- Experience with CI/CD pipelines for database development.

- Additional certifications such as Oracle Certified Professional (OCP) or similar.

- Experience with real-time data integration solutions.

- Knowledge of data governance frameworks and practices.

- Exposure to machine learning or advanced analytics applications.

- Understanding of financial data models and banking processes.

- Experience with JSON, XML, and other semi-structured data formats.

- Familiarity with microservice architectures and API integrations.

Why Join Our Team

Join a forward-thinking organization that values technical excellence and innovation. As a remote team member, you'll enjoy the flexibility of working from anywhere while contributing to mission-critical financial systems. We offer competitive compensation, professional development opportunities, and the chance to work with cutting-edge database technologies in a collaborative environment focused on continuous learning and growth.

Our team embraces a culture of knowledge sharing and continuous improvement. You'll have opportunities to expand your skill set, work alongside experienced professionals across various domains, and make a significant impact on systems that power essential financial operations. We value work-life balance, provide flexible working hours, and foster an inclusive environment where diverse perspectives are welcomed and appreciated.