Job Seekers, Please send resumes to resumes@hireitpeople.com
Complete Description:
***Strong possibility that this agency may create a permenant opening in approximately 6 months that this contractor could apply to***
* Local Candidates PREFERRED
** Candidates MUST be eligible for direct hire by the agency, without sponsorship. No exceptions
*** In Person Interviews Only - No exceptions
SENIOR DATA WAREHOUSE AND BUSINESS INTELLEGENCE DEVELOPER
Responsibilities:
• Creating dimensional (star/snowflake schema) data models,
• Maintaining responsibility for global data definitions used in the Data Warehouse
• Performing ETLs and validating results with business representatives,
• Integrate data from multiple source systems into Data Warehouse
• Cleansing data,
• Transforming and loading data in Oracle 11G environment.
• Building ROLAP/MOLAP solutions
• Adhering to standards for the Data Warehouse, including security, archiving, backup and recovery
• Participating in architectural decisions for data transitions from source to staging to ODS to EDW
• Supporting implemented BI solutions by: monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance and communicating functional and technical issues.
Knowledge/Skills Required:
• Experience with Unix /Linux platform and SQL, PL/SQL programming (Data Staging running on Linux platform)
• Experience with Unix scripting preferred (Korn shell, chron tab scheduler)
• Extensive experience in complete life cycle of DW projects and able to provide end to end solutions
• Able to work closely with supporting teams to develop integrated solutions (Legacy Systems, Web Methods, FTP, DBA’s, etc)
• Experience and understanding with Data Modeling (powerdesigner/ERWIN tool preferred) and Dimensional Modeling
• Experience with Data Warehouse ROLAP/MOLAP and reporting technologies ( Business Objects, OBIEE, Crystal)
• Working knowledge of Kimball framework and Methodologies
• Familiarity with unstructured data warehousing
Preferred Qualifications:
• 5+ years of experience in a Decision Support/Data Warehousing/Business Intelligence environment
• College degree or higher ( Bachelors Degree in Computer Science, Engineering or a related technical discipline, or the equivalent combination of education and technical training)
• Familiarity with Agile Software development
• Working knowledge of OBIEE and/or SAP BO
• Working knowledge of OWB
Skills:
Skill |
Required / Desired |
Amount |
of Experience |
Experience with Unix /Linux platform |
Required |
5 |
Years |
Experience with SQL, PL/SQL programming (Data Staging running on Linux platform) |
Required |
5 |
Years |
Experience with Unix scripting preferred (Korn shell, chron tab scheduler) |
Required |
5 |
Years |
Extensive experience in complete life cycle of Data Warehousing projects providing end to end solutions |
Required |
5 |
Years |
Experience working closely with supporting teams to develop integrated solutions for Legacy Systems, Web Methods, FTP, etc. |
Required |
5 |
Years |
Experience and understanding with Data Modeling (Power Designer/ERWIN tool preferred) |
Required |
5 |
Years |
Experience with Dimensional Modeling with Data Warehouse ROLAP/MOLAP and reporting technologies ( Business Objects, OBIEE, Crystal) |
Required |
5 |
Years |
Working knowledge of Kimball framework and Methodologies |
Required |
5 |
Years |
Experience in a Decision Support/Data Warehousing/Business Intelligence environment |
Required |
5 |
Years |
Familiarity with Agile Software development |
Highly desired |
2 |
Years |
Working knowledge of OBIEE and/or SAP BO |
Required |
5 |
Years |
Working knowledge of OWB |
Required |
5 |
Years |