Database Architect/Oracle
Location: Toronto, ca
Company Description
SCT resources have a broad range of skills in different technologies. The large skill-set has been made possible by a conscious focus on strengthening our skills base. Every person selected for our team brings something new, something that adds to our offerings. We learn continuously, both on the job and through formal training programs.
Job Description
Responsibilities:
-Lead, participate in gathering business requirements, analysis of source systems, define underlying data sources and transformation requirements, design suitable data model, and develop metadata for the Datawarehouse/Analytical Reporting.
-Prepare Technical Design/Specifications; develop routines for data extraction and loading.
-This is a highly technical role requiring critical thinking, hands on development, and attention to detail from analysis through implementation and post-production QA/oncall. Provide technical/user documentation and training; perform peer reviews of work items produced at various stages of the project.
-Effectively communicate with various teams and stakeholders, escalate technical and managerial issues at the right time and resolve conflicts.
-Demonstrate passion for quality and productivity by use of efficient development techniques, standards and guidelines.
-Analyze and determine the impact of technology capabilities and limitations, translate high level design to detailed design specifications, develop, test and deploy code/application in various environments.
-Perform effort estimation for various Datawarehouse activities; meet project deliverables as per requirements, on time within budgets.
Qualifications
-Strong Computer science background required. A Bachelor's degree or higher in computer science is required with a minimum of 5+ years of industry experience.
-4+ years in working with large data sets and analysing data to identify patterns.
-5+ years in data warehousing projects with at least 4 years of full life cycle experience in implementation and support of DW Solutions on Oracle Platform.
-Must have extensive knowledge in ETL, Oracle 9i/10g/11g and SQL & PL/SQL.
-Must have extensive knowledge in Datawarehouse designing techniques like Star Schema/Snowflake.
-Extensive design and coding skills in Perl, Shell script, XML on Unix Platforms.
-Knowledge of tuning and scaling in a Datawarehouse environment is highly desired.
Additional Preferred Qualifications:
-Hands-on experience with OBIEE 11g.
-Should have very good technical expertise and strong business skills, as he/she will lead the team in delivering Business Intelligence solutions.
-Must be aware of testing process and DW implementation methodologies.
-Knowledge of Hyperion, Discoverer 10g etc will be an added advantage.
-Strong customer focus, ownership, urgency and drive.
-Excellent communication skills and the ability to work well in a team.
-Effective analytical, troubleshooting and problem-solving skills.
-Experience in Erwin Datamodelling and Data Quality tool.
There are more than 50,000 engineering jobs:
Subscribe to membership and unlock all jobs
Engineering Jobs
60,000+ jobs from 4,500+ well-funded companies
Updated Daily
New jobs are added every day as companies post them
Refined Search
Use filters like skill, location, etc to narrow results
Become a member
🥳🥳🥳 452 happy customers and counting...
Overall, over 80% of customers chose to renew their subscriptions after the initial sign-up.
To try it out
For active job seekers
For those who are passive looking
Cancel anytime
Frequently Asked Questions
- We prioritize job seekers as our customers, unlike bigger job sites, by charging a small fee to provide them with curated access to the best companies and up-to-date jobs. This focus allows us to deliver a more personalized and effective job search experience.
- We've got over 200,000 jobs from 15,000+ vetted companies. No fake or sleazy jobs here!
- We aggregate jobs from 15,000+ companies' career pages, so you can be sure that you're getting the most up-to-date and relevant jobs.
- We're the only job board *for* software engineers, *by* software engineers… in case you needed a reminder! We add thousands of new jobs daily and offer powerful search filters just for you. 🛠️
- Every single hour! We add 2,000-3,000 new jobs daily, so you'll always have fresh opportunities. 🚀
- Typically, job searches take 3-6 months. EchoJobs helps you spend more time applying and less time hunting. 🎯
- Check daily! We're always updating with new jobs. Set up job alerts for even quicker access. 📅
What Fellow Engineers Say