3Pillar - Senior Oracle Developer

• 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. • 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. • Experience with the AWS/Azure/GCP data engineering services • Knowledge of AWS services viz., S3, Lambda, EMR, GLUE ETL, Athena, RDS, Redshift, EC2, IAM • 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.