Database Developer
Role details
Job location
Tech stack
Requirements
Expertise in developing highly optimized Oracle SQL and PL/SQL code for large-scale data processing.
Extensive hands-on experience with relational and dimensional data modeling, including Star and Snowflake schemas.
Strong proficiency with Informatica (PowerCenter and IDMC) along with Linux/Unix scripting.
Deep understanding of Oracle database architecture and core database internals.
Advanced query and application performance tuning capabilities, especially in high-volume environments.
Ability to design, model, and optimize database schemas for scalability and performance.
Hadoop, Tableau and Power B, 15+ year work experience in application development
- Expertise in developing highly optimized Oracle SQL and PL/SQL code for large-scale data processing.
- Extensive hands-on experience with relational and dimensional data modeling , including Star and Snowflake schemas.
- Strong proficiency with Informatica (PowerCenter and IDMC) along with Linux/Unix scripting .
- Deep understanding of Oracle database architecture and core database internals.
- Advanced query and application performance tuning capabilities, especially in high-volume environments.
- Ability to design, model, and optimize database schemas for scalability and performance.
- Hadoop, Tableau and Power B
qualifications:
Proven experience managing and processing large datasets efficiently
Experience integrating Data Warehouse solutions with Business Intelligence platforms.
Strong proficiency in Tableau development and dashboard visualization.
Familiarity with Delta Lake and Lakehouse architectures.
Experience working with containers and cloud platforms (e.g., Docker, Kubernetes, AWS, Azure, Google Cloud Platform).
Exposure to APIs, Spring, Java, Kafka, MQ, YAML.
Distributed systems experience
Problem-solver
Effective communication skills
Self-direction
Must be able to drive
Adaptability/flexibility
Financial Crimes, Economic Sanctions, Banking, Financial Services, Sanctions screening, PEP Negative News, Agile Delivery, JIRA, Java Developer