ETL / DWH with BODS / SQL experience resource required
Location: PA, PA, us
Company Description
System Canada 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
Required Qualifications
7+ years Information Technology
5+ years Data Warehousing
2+ years Data Modeling
5+ years SQL
2+ years ETL
5+ Years of relational DB technology
Experience required:
Minimum 5 years of relevant work experience.
Proven data architecture skills, especially in relational and dimensional data modeling and physical database design of decision support systems. Some exposure to data modeling tools such as ERWIN.
Experience designing, implementing and managing metadata solutions. Meta data definition and repository experience a plus.
Understanding of data warehouse project management methodologies and tools such as ETL tools, reporting tools (Business Objects), BI tools.
Exposure to relational database technology such as Oracle, SQL Server and DB2 AS400 is needed. Proficient in SQL query tuning, and complex joins to ensure performance of star schema queries are optimal.
Responsible for the analysis and development of logical and physical data models for a full-functioning data warehouse/data mart environment. Duties include but are not limited to: subject area interviews, metadata documentation, development of logical models, and translation of logical model to a physical data model, dimensional modeling skills. In this role you will be involved in development and implementation. The ideal candidate should have hands on experience in ETL development preferably BODS (SAP ETL tool).
Ensures that delivered products meet agreed upon user requirements and security requirements, and that EDW and organizational development and documentation standards are met. Responsible for analysis, design, and testing throughout the data warehouse implementation. Frequently interacts with the ETL and analytics requirements, arrange design reviews, and perform testing. Also have some experience in implementing DW on oracle databases.
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