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.
•
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
•
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
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.