Senior Oracle Developer

Responsibilities

• Key Skills: Oracle Database, Stored Procedures, SQL Optimization, Data Analysis
• -
• Understanding the business requirements
• -
• Writing code and implementing the proposed solutions
• -
• Debugging, root cause analysis…
• -
• Creating data pipelines, versioning and change management
• -
• Manage the complexity inherent in versioned data pipelines
• -
• Develop ETL/ELT processes to help extract and manipulate data from multiple sources.
• -
• Design, build and maintain batch or real-time data pipelines in production.
• -
• Automate data workflows such as data ingestion, aggregation, and ETL processing.

• Ensure data accuracy, integrity, privacy, security, and compliance through quality control procedures.

• -
• Train and mentor junior engineers.

Qualifications

• -
• Expert with Oracle Database, Stored Procedures, SQL Optimization, Data Analysis

• Debugging, Root Cause Analysis
• Advanced Oracle SQL skills and experience with relational databases and database design.

• -
• Experience working with cloud-based platform of data lakehouse and ETL such as Databricks..
• -
• Strong Python skills with hands-on experience on Pandas, NumPy and other data related libraries
• -
• Experience with data visualization tools like Tableau, PowerBI, AWS QuickSight etc
• -
• Very good exposure of working on Data Lakes & Data Warehouses solutions
• -
• Excellent problem-solving, communication, and organizational skills.

Desired

• -
• Experience with the AWS/Azure/GCP data engineering services
• -
• Knowledge of AWS services viz., S3, Lambda, EMR, GLUE ETL, Athena, RDS, Redshift, EC2, IAM
• -

OR

• -
• Knowledge of Azure services viz., ADF, Azure Synapse Analytics, ADLS Gen2, Azure SQL DB
• -
• Experience with Big Data technologies like Spark, Map Reduce, Hadoop, Hive
• What is it like working for 3Pillar Global?
• At 3Pillar, we create an environment where people can do their best work while maintaining a healthy work-life balance.

• Flexibility & Well-being – Our remote-first approach gives you the flexibility to work where you perform best, while prioritizing your well-being and personal commitments.
• Global Community – Collaborate with talented colleagues across the globe in a culture built on connection, support, and shared success.
• Your Voice Matters – We foster open communication and multiple feedback channels, ensuring every employee has the opportunity to be heard and make an impact.
• Growth & Development – Gain exposure to diverse clients, industries, and challenges that accelerate learning and career growth.

Our culture is guided by four core values: Collaboration, Outperform, Respect, and Evolve —the principles that shape how we work, grow, and succeed together.