Senior Oracle Developer in Canada Creek, Nova Scotia at 3Pillar Global
Explore Related Opportunities
Job Description
Accomplished Tech Visionary:
Embark on an exciting journey into the realm of software development with 3Pillar! We extend an invitation for you to join our team and gear up for a thrilling adventure. At 3Pillar, our focus is on leveraging cutting-edge technologies that revolutionize industries by enabling data driven decision making. As a Senior Data Engineer, you will hold a crucial position within our dynamic team, actively contributing to thrilling projects that reshape data analytics for our clients, providing them with a competitive advantage in their respective industries.
If your passion for data analytics solutions that make a real-world impact, consider this your pass to the captivating world of Data Science and Engineering!
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.