Job closed
Ref: HP094-2115
Job description / Role
The main responsibilities are ETL design and development for the Data Warehouse and Business Intelligence Solutions.
• Handle areas related to Metadata/Repository creation and management, Internal database administrator (DBA), Technical/Data architecture, Oracle Business Intelligence, BI client/servers related configuration.
• Reports to DWH/BI Technical Lead, interacts with Modeler, QA, IT, Data Analysis, BI Developer, and DWH/BI technical lead and all members of DWH/BI technical and functional teams.
• Design ETL processes; Develop default strategies for extracting data, archiving extracted data, policing data quality, dimension change management.
• Design strategy to meet availability requirements, Design data auditing subsystem, Design the structure of the ETL staging area.
• Develop plan for maintaining dimension hierarchies.
• Build dimension table surrogate key management system and the Audit system.
• Develop ETL subsystems as architected.
• Test historic load and primary dataset for incremental load.
• Conduct live tests with real data.
• Test all over process, system integration and month-end or unusual conditions.
• Inventory metadata elements, locations and relationships.
• Educate team on metadata situation and responsibilities.
• Identify key elements to manage.
• Create systems to capture additional metadata.
• Create tools to synchronize metadata.
• Design and implement metadata delivery system and Document metadata strategy.
• Ongoing metadata management and monitoring.
• Inventory metadata elements, locations and relationships.
• Populate BI tool metadata; Create business metadata.
• Test BI tools, Setup user security and report process metadata system.
• Test monitor and tune query performance.
Requirements
• Candidates should hold B. Sc. Degree in Computer Science, IT, or Computer Engineering.
• 7+ years of solid experience in field of Data Warehouse ETL Architect and ETL Development.
• Involved in various projects related to reflecting repositories from data modeling and dimensional design, Star Schema.
• Linux, Windows, Microsoft SQL Server, Oracle BI technologies, SQL, and PL/SQL.
• Dimensional modeling extensive background. ODI (Oracle data integrator) and BI Administrator RPD.
• 4+ years of solid relevant experience in the field of data warehouse metadata implementation and management.
• Database Administrator experience and previous experience in manual ETL/ELT.
• Integration and transformation professionalism.
• Advance logical, reasoning and conceptual capacity, multi-tasking and overload tolerance.
About the Company
Parsons is a leader in many diverse markets such as infrastructure, transportation, water, telecommunications, aviation, commercial, environmental, planning, industrial manufacturing, education, healthcare, life sciences and homeland security.
Parsons provides technical and management solutions to federal, regional and local government agencies as well as private industries worldwide.