• Collect the data from the core and distributed branches.
• Collect business requirement documents from business site.
• Collect system requirement for data warehouse.
• Document current process and solution workflows for both current and proposed state for existing and future reporting requirements.
• Document detailed security requirements for accessing data.
• Document the infrastructure requirements, hardware and software.
• Document user requirements for ad-hoc reporting and analysis.
• Analyze the source data and transactional data.
• Make sure all source data is available and can be collected.
• Select database system.
• Select server and its operating system.
• Design conceptual and solution architecture to support the data warehouse.
• Design technical specifications for the staging area, data warehouse, metadata, data mart base on the requirements.
• Design logical and physical data models, schema and data structure.
• Analyze performance of system and database server tuning.
• Analyze frequency of data loading.
• Establish interfaces to source systems and data transfer.
• Build up data mart from diverse sources and is designed to support query and analysis.
Development & Implementation
• Develop extraction, transformation and loading data from the source data.
• Analyze and determine missing data.
• Create physical structure of staging area, data warehouse and data marts.
• Perform data loads of new mappings into new structure.
• Analyze new data structure to ensure all necessary levels of reporting, analysis and business requirements are met.
• Establish data mapping, programs, scripts to perform ETL work of new data contents, formats, and descriptions.
• Analyze data loading at various intervals to ensure appropriate loading.
• Design and develop require reports.
• Develop test cases, test plan and test execution timeline.
• Design test scenarios for business requirements.
• Establish unit testing, functional testing, and UAT testing environment.
• Transition to end users and generate the required business reports.
• Analyze and validate the reports.
• Projection on reports and support decision making.
Bu iş için 29 freelancer ortalamada $5493 teklif veriyor
Hi There, We are an ISO 9001:2008 certified company with strength of 50+ software professionals. We have a legacy of 10 years of excellence behind us and we were recently among the very few companies selected by Bri Daha Fazla
Hello, I am working with a MNC based company in a DWH project since last 4 years. This project is pure DWH project which comprised of DWH concept,Informatica as ETL tool and Business Object & Qlikview as report Daha Fazla
Hi sir, i am interested in your project. We can do this for sure.I have a team of developers, we can start your project right away. You will be completely satisfied with our work and speed. I can assure you quality wor Daha Fazla
I am a data scientist/quantitative developer with over 5 years of experience doing analysis. My interest and expertise in using MS Access,R , Matlab ,weka and Database Development.
Hello, We have gone through your project description and we can help you out. We are having a team of expert professionals which can cater you with desired solution. With more than a decade of experience in IT, we ca Daha Fazla
Hi, We have read your requirements and would like to discuss further as we have strong hands in web, desktop & mobile application development & have extensive experience in data warehousing and completed over 150 pr Daha Fazla
Hi We are quite confident that we can accomplish the project as per your requirement. You are requested to go through our Profile to know our domain knowledge and our Services. We read your requirement and you sh Daha Fazla
I have a team in US who are very specialized in data warehousing project and My team also has offshore counter parts for round a clock operations. We are startup organization, however our team's collective experienc Daha Fazla
I have 4 years of experience in ETL development projects wherein I worked on Oracle, SQL server, DB2, unix. I have experience in end to end design of the overall architecture, development from the scratch, deployment Daha Fazla
I am working as a Senior Software Engineer expertise DWH and BI practices like Informatica with sound knowledge of SQL, total experience of 4 years. I would like to know more about requirement, on which delivery time Daha Fazla
Hello Good Day, I have high experience in data architectures and business intelligence in as Major companies such as Millicom Tigo, British American Tobacco Mexico, I'm new as Free lance and i am interested in this pr Daha Fazla
I am having two years of industrial experience in ab-initio. Worked on the Allstate projects. Having good knowledge on ETL process. Independently supported the UAT and production. I have knowledge on running graphs th Daha Fazla
Hello, I am a part of firm which is into Data Warehousing. Please visit [login to view URL] for more details you can ping me.
I have 12 years of experience in various areas of SAP applications and data integration, involving different sap and non sap systems through SAP Portal and through ETL Data migration tool - SAP Business Object Data Se Daha Fazla
Have an extensive experience in ETL world and build a system from start to end. Provided an ultimate performance based solutions to clients. In database world, each and every record is very important. Came with an e Daha Fazla
I have more than 20 years of experience in IT handling highly complex major projects for global clients like Citi Bank, RBS,AIG to name few. I have played roles like DBA,Dimension Modeler, Technical Architect with cap Daha Fazla