We are seeking a talented PL/SQL Developer with a passion for database development, ETL processes, and reporting applications. In this role, you will work closely with business partners to deliver efficient data processing solutions, optimize database performance, and ensure data integrity and security.
Experience. 6+ years
Key Responsibilities
- Database Development & Optimization. Plan, coordinate, and implement security measures to ensure data integrity while maximizing database performance. Define and manage table indexes, schemas, and conversion of MSSQL table schemas to XSD format.
- ETL Processes & Data Warehousing. Develop and maintain data processing and ETL components for distributed database systems. Manage and enhance ETL processes for updating data warehouses, ensuring smooth data integration.
- Database Design & Reporting. Design and develop both logical and physical databases, understanding the impact of changes on physical storage. Create application schemas to support business intelligence applications and develop reporting applications.
- Scripting & Production Support. Develop scripts to support production operations and troubleshoot data processing applications. Implement and manage Java web applications and services when necessary.
- Technology Research & Innovation. Participate in research, proof-of-concept testing, and technology roadmap development. Propose innovative solutions to enhance technology efficiency.
Desired Skills & Expertise
- PL/SQL & SQL Expertise. Advanced proficiency in PL/SQL, including writing complex SQL queries, scripting, and optimization. Ability to perform performance tuning of database applications.
- ETL Tools. Experience with ETL tools like Informatica, SSIS, Talend, or DataStage. A deep understanding of data processing workflows is essential.
- Data Warehousing & Modeling. Strong knowledge of data warehousing concepts, data modeling, and how to ensure accurate data flow through the system.
- Data Quality & Profiling. Expertise in data profiling, analysis, and quality assurance to maintain high standards of data integrity and accuracy.
- Java Knowledge. Familiarity with core Java or other 4GL languages like Powerhouse is an added advantage. Experience in developing Java-based applications is a plus.
- Problem-Solving & Analytical Skills. Strong critical thinking and analytical abilities to troubleshoot complex database issues.
- Communication & Collaboration. Excellent communication skills and the ability to work effectively in a team-oriented environment.
Nice to Have
- Power BI Experience. Exposure to Power BI and the ability to design basic reports and dashboards. This includes.
- Report & Dashboard Design. Assist in creating visually appealing and informative reports and dashboards.
- Data Visualization. Select the best visualizations for data clarity and aesthetics.
- Data Integration & Validation. Integrate data from multiple sources and validate it against business rules for consistency and accuracy.
- Documentation. Maintain thorough documentation for reports, data sources, and transformation processes.
If you are an innovative and results-driven PL/SQL Developer with a strong focus on ETL, database optimization, and reporting applications, we would love to hear from you. Join us in an exciting and challenging role in a fast-paced environment!