ETL / DWH with BODS / SQL experience resource required
System Canada Technologies · PA, PA, us ·
- Experience
- 2+ years
- Company size
- 1000+
System Canada Technologies · PA, PA, us ·
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.