ETL / DWH with BODS / SQL experience resource required

systemcanadatechnologies· USA
Apply Now ↗
📍 PA📍 PA, PA, United States📍 usContract

About this role

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. 

Qualifications

Additional Information

Frequently Asked Questions

Is the salary disclosed for the ETL / DWH with BODS / SQL experience resource required position at systemcanadatechnologies?
The salary for this ETL / DWH with BODS / SQL experience resource required role at systemcanadatechnologies is not publicly listed. Click "Apply Now" to learn more about the compensation package on their official careers page.
Where is the ETL / DWH with BODS / SQL experience resource required position at systemcanadatechnologies located?
This ETL / DWH with BODS / SQL experience resource required role at systemcanadatechnologies is based in PA, PA, PA, United States, us. The position is listed as on-site or hybrid. Check the full job description or apply directly to confirm the work arrangement.
Is the ETL / DWH with BODS / SQL experience resource required role at systemcanadatechnologies full-time or part-time?
This is listed as a Contract position. It is posted as a ETL / DWH with BODS / SQL experience resource required role in the USA department at systemcanadatechnologies.
Which team or department does the ETL / DWH with BODS / SQL experience resource required at systemcanadatechnologies belong to?
This ETL / DWH with BODS / SQL experience resource required position is part of the USA department at systemcanadatechnologies. See the full job description for more information about the team structure and responsibilities.
How do I apply for the ETL / DWH with BODS / SQL experience resource required position at systemcanadatechnologies?
Click the "Apply Now" button on this page. You will be redirected to systemcanadatechnologies's official application portal hosted on smartrecruiters where you can submit your application directly.
When was the ETL / DWH with BODS / SQL experience resource required job at systemcanadatechnologies posted?
This ETL / DWH with BODS / SQL experience resource required position at systemcanadatechnologies was posted on Jun 6, 2013. Apply as soon as possible — early applications are often reviewed first.
ETL / DWH with BODS / SQL experience resource required
systemcanadatechnologies
Apply for this role ↗

You'll be redirected to systemcanadatechnologies's official application page on SmartRecruiters.