Data Architect / ETL
Working with Functional and Technical Reporting team to gather Functional design, Technical design, and defining joins, mappings, queries, and sharing right information with Reporting team within defined time. Data Mapping, Join validations – Validation and addressing/fixing data queries raised by Reporting team in a timely manner Support reporting development utilizing Cognos.
Skills and Experience
Mandatory: Strong knowledge and experience with CC&B data model (version 2.4 or higher). Must be able to do data mapping, Data querying, SQL, and manipulation of data Expert knowledge of Oracle SQL Sound understanding of functional and technical workings of Oracle Utilities Customer Care and Billing (CC&B) Know how to research, discover and assess the product for alignment with client requirements. Know how to utilize the system and its installed resources in order to design solutions and make recommendations. Be able to work independently but within the framework of the team and product. Be able to work well within a team setting Collaborate with cross functional teams. Understanding of database/schema architecture.
Desired: Cognos Reporting Knowledge of Oracle utility product MWM and database model Understanding of utilities/ previous utility experience 5+ years of IT and data analysis, data management experience, enterprise architecture and enterprise data architecture, enterprise data management, data models Experience with a data modeling tools such as ER-Win or TOAD Modeler Worked in a data warehouse environment, which includes data design, database architecture, metadata and repository creation.