Role: Data Warehouse Developer
Location: Reading PA (Hybrid)
Type: Contract
Job Duties:
- Work with business owners to define and understand business requirements related to changes and enhancements of the existing enterprise data warehouse.
- Understand the companys transactional system and data sources and identify gaps in business processes and data accuracy in the projects early life cycle.
- Should be able to be involved in data modeling based on the Dimensional Fact Model (DFM) principle
- Involved in managing the design of the companys data extraction staging and loading to data warehouse processes to ensure that data is as consistent clean and accurate as possible
- Involved in the technical aspects of customer requirements analysis understand technical specifications for completeness and should be able to be involved in any phase of the project.
- Develop technical documentation including requirements documents process overviews data models and data flow.
- Should be involved in Data Engineering PL/SQL UNIX development and implementation wherever required.
Minimum Skills Required:
- Bachelors degree in computer science or related field
- 10 years of experience with the development and implementation of enterpriselevel data warehousing and supporting business intelligence initiatives mainly focused Start Schema Data Modelling
- Broad expertise spanning various technologies business process integration enterprise data warehousing business intelligence and advanced analytics
- 7 years of experience designing developing and implementing largescale data warehousing initiatives
- 5 years of experience understanding complex data warehousing performance management.
- 10 years of strong experience in any industry standard tools. (Talend Big Data Platform SAP BODS PySpark Python AWS Glue Athena and other Big Data technologies)
- Experience with Data Modelling tools like Erwin is preferred.
- 7 years of experience with database programming and design including mastery of complex report queries and SQL optimization
- 7 years of experience with enterpriseclass RDBMS preferably Oracle
- Strong grasp of advanced SQL writing and query tuning/optimization
- Strong written / oral communication and organizational skills
- Ability to selfmanage and multitask on multiple projects