DIRECT CLIENT // Data Warehouse Analyst
I have a very urgent DIRECT CLIENT requirement for *Data Warehouse Analyst* in *Olympia, WA*. Please Let Me Know If you have available candidate, please reply with their word resume, location, rate and contact number. Please send the resumes at pe...@cncconsulting.com Job Title: Data Warehouse Analyst Location: Olympia, WA Duration: 2 Months+ *F2F interview* The Washington State Department of Transportation (WSDOT), Office of Information Technology (OIT) requires one (1) senior level Data Warehouse Analyst to develop and implement extract, transform, and load processes needed to support WSDOT’s data warehouse The contractor shall perform the technical tasks required to set up, maintain, enhance performance, and troubleshoot extraction, transformation and load (ETL) routines that move data from transactional databases and flat files to the data warehouse. The contractor shall provide support to report analysts and customers to ensure accurate and timely performance of reports utilizing information from the data warehouse. The data warehouse operating environment is SQL Server 2012 and 2016 on Windows 10 and our ETL tool is Informatica Power Center 10.1. Specific duties include: Using client requirements and database design specifications, the contactor shall: Determine how the data sources identified can provide the required data. Test data structures to verify that the target databases will work as designed. Set up ETL routines: write the code using Informatica mappings that move data from the specified sources; transform it as required and write it into the data mart. The outcome of this task shall be error-free ETL routines that meet requirements and design specifications, and are regularly scheduled within the Department’s Data Warehouse loading process. Provide technical assistance to staff in writing complex data-mart queries, based on the detailed knowledge gained during the construction of ETL routines. The outcome of this task shall be the Washington State Department of Washington State Department of Transportation ITPS Work Request – WR 2016 1129 TS3 provision of technical information and ideas to support staff and query-tools experts who are assisting users with advanced, complex data-mart queries. Mandatory : Minimum 5 years of experience in creating and maintaining Extract, Transform, and Load (ETL) processes using SQL Server Integration Services (SSIS) and / or Informatica Power Center. Minimum 5 years of experience writing complex queries using Transact SQL for reporting and data validation purposes. Minimum 5 years of experience using Microsoft SQL Server 2000, 2005, and 2008 r2 software tools to administer and/or manage SQL Server databases. Minimum 5 years of experience working with large organizations (over 1000 employees). Minimum 5 years of experience employing data warehouse principles and theories, including knowledge of the various tactical approaches to data warehouse development. Desirable Knowledge: Understanding of database modeling and design principles and ability to use a data model diagram. Experience using PowerExchange for Mainframe ADABAS. Thanks Peter Smith Email ID: pe...@cncconsulting.com -- You received this message because you are subscribed to the Google Groups "SAP BASIS" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-basis+unsubscr...@googlegroups.com. To post to this group, send email to sap-basis@googlegroups.com. Visit this group at https://groups.google.com/group/sap-basis. For more options, visit https://groups.google.com/d/optout.
DIRECT CLIENT // Data Warehouse Analyst
-- I have a very urgent DIRECT CLIENT requirement for *Data Warehouse Analyst* in *Olympia, WA*. Please Let Me Know If you have available candidate, please reply with their word resume, location, rate and contact number. Please send the resumes at alb...@cncconsulting.com Job Title: Data Warehouse Analyst Location: Olympia, WA Duration: 2 mths+ Client: State of WA In person interview Need 3 reference The Washington State Department of Transportation (WSDOT), Office of Information Technology (OIT) requires one (1) senior level Data Warehouse Analyst to develop and implement extract, transform, and load processes needed to support WSDOT’s data warehouse The contractor shall perform the technical tasks required to set up, maintain, enhance performance, and troubleshoot extraction, transformation and load (ETL) routines that move data from transactional databases and flat files to the data warehouse. The contractor shall provide support to report analysts and customers to ensure accurate and timely performance of reports utilizing information from the data warehouse. The data warehouse operating environment is SQL Server 2012 and 2016 on Windows 10 and our ETL tool is Informatica Power Center 10.1. Specific duties include: Using client requirements and database design specifications, the contactor shall: • Determine how the data sources identified can provide the required data. • Test data structures to verify that the target databases will work as designed. • Set up ETL routines: write the code using Informatica mappings that move data from the specified sources; transform it as required and write it into the data mart. The outcome of this task shall be error-free ETL routines that meet requirements and design specifications, and are regularly scheduled within the Department’s Data Warehouse loading process. • Provide technical assistance to staff in writing complex data-mart queries, based on the detailed knowledge gained during the construction of ETL routines. The outcome of this task shall be the Washington State Department of Washington State Department of Transportation ITPS Work Request – WR 2016 1129 TS 3 provision of technical information and ideas to support staff and query-tools experts who are assisting users with advanced, complex data-mart queries. Mandatory : Minimum 5 years of experience in creating and maintaining Extract, Transform, and Load (ETL) processes using SQL Server Integration Services (SSIS) and / or Informatica Power Center. Minimum 5 years of experience writing complex queries using Transact SQL for reporting and data validation purposes. Minimum 5 years of experience using Microsoft SQL Server 2000, 2005, and 2008 r2 software tools to administer and/or manage SQL Server databases. Minimum 5 years of experience working with large organizations (over 1000 employees). Minimum 5 years of experience employing data warehouse principles and theories, including knowledge of the various tactical approaches to data warehouse development. Desirable Knowledge: Understanding of database modeling and design principles and ability to use a data model diagram. Experience using PowerExchange for Mainframe ADABAS. Very Truly, Albert Smith CNC Consulting, Inc The enterprise resource for staff augmentation 201-588-9137 P 201-541-9128 F alb...@cncconsulting.com www.cncconsulting.com -- You received this message because you are subscribed to the Google Groups "SAP BASIS" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-basis+unsubscr...@googlegroups.com. To post to this group, send email to sap-basis@googlegroups.com. Visit this group at https://groups.google.com/group/sap-basis. For more options, visit https://groups.google.com/d/optout.
DIRECT CLIENT // Data Warehouse Analyst
Very urgent DIRECT CLIENT Opening. Please send the resumes at su...@cncconsulting.com Job Title: Data Warehouse Analyst Location: Olympia, WA Duration: 2+ Months 3 references F2F The Washington State Department of Transportation (WSDOT), Office of Information Technology (OIT) requires one (1) senior level Data Warehouse Analyst to develop and implement extract, transform, and load processes needed to support WSDOT’s data warehouse The contractor shall perform the technical tasks required to set up, maintain, enhance performance, and troubleshoot extraction, transformation and load (ETL) routines that move data from transactional databases and flat files to the data warehouse. The contractor shall provide support to report analysts and customers to ensure accurate and timely performance of reports utilizing information from the data warehouse. The data warehouse operating environment is SQL Server 2012 and 2016 on Windows 10 and our ETL tool is Informatica Power Center 10.1. Specific duties include: Using client requirements and database design specifications, the contactor shall: Determine how the data sources identified can provide the required data. Test data structures to verify that the target databases will work as designed. Set up ETL routines: write the code using Informatica mappings that move data from the specified sources; transform it as required and write it into the data mart. The outcome of this task shall be error-free ETL routines that meet requirements and design specifications, and are regularly scheduled within the Department’s Data Warehouse loading process. Provide technical assistance to staff in writing complex data-mart queries, based on the detailed knowledge gained during the construction of ETL routines. The outcome of this task shall be the Washington State Department of Washington State Department of Transportation ITPS Work Request – WR 2016 1129 TS 3 provision of technical information and ideas to support staff and query-tools experts who are assisting users with advanced, complex data-mart queries. Mandatory : Minimum 5 years of experience in creating and maintaining Extract, Transform, and Load (ETL) processes using SQL Server Integration Services (SSIS) and / or Informatica Power Center. Minimum 5 years of experience writing complex queries using Transact SQL for reporting and data validation purposes. Minimum 5 years of experience using Microsoft SQL Server 2000, 2005, and 2008 r2 software tools to administer and/or manage SQL Server databases. Minimum 5 years of experience working with large organizations (over 1000 employees). Minimum 5 years of experience employing data warehouse principles and theories, including knowledge of the various tactical approaches to data warehouse development. Desirable Knowledge: Understanding of database modeling and design principles and ability to use a data model diagram. Experience using PowerExchange for Mainframe ADABAS. Thanks, Sunny Roy su...@cncconsulting.com -- You received this message because you are subscribed to the Google Groups "SAP BASIS" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-basis+unsubscr...@googlegroups.com. To post to this group, send email to sap-basis@googlegroups.com. Visit this group at https://groups.google.com/group/sap-basis. For more options, visit https://groups.google.com/d/optout.
DIRECT CLIENT // Data Warehouse Analyst
I have a very urgent DIRECT CLIENT requirement for Data Warehouse Analyst in Madison, WI. Please Let Me Know If you have available candidate, please reply with their word resume, location, rate and contact number. Please send the resumes at kiran.go...@ngtechinc.com Role: Data Warehouse Analyst Location: Madison, WI Location: 2+ Years Contract DW BI Knowledge areas: 1. Data warehouse/data marts using Kimball Inmon methodologies 2. Informatica PowerCenter ETL 3. SAP Business Objects universe and report design/development 4. Xcelcius Dashboard design and development 5. Crystal reports 6. Oracle, DB2 and SQL Server 7. Dimensional Data Modeling 8. Slowly Changing Dimensions 9. Infoburst 10. Requirements gathering 11. Project development life cycle process (i.e., planning, analysis, design, coding, testing, implementation, support 12. Excellent written and oral communications 13. Independent worker Informatica PowerCenter - ETL (5+years experience): • Data warehouse design • Data warehouse development Business Objects (5+ years experience): • SAP Business Objects Universe design and development • SAP Business Objects report design and development • Xcelsius dashboards Database Knowledge (5+years experience): • ORACLE • SQL Server • DB2 • Complex SQL statements Thanks, Kiran Gorak 872-213-9163 Phone kiran.go...@ngtechinc.com -- You received this message because you are subscribed to the Google Groups SAP BASIS group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-basis+unsubscr...@googlegroups.com. To post to this group, send email to sap-basis@googlegroups.com. Visit this group at http://groups.google.com/group/sap-basis. For more options, visit https://groups.google.com/d/optout.
DIRECT CLIENT // Data Warehouse Analyst
I have a very urgent DIRECT CLIENT requirement for Data Warehouse Analyst in Madison, WI. Please Let Me Know If you have available candidate, please reply with their word resume, location, rate and contact number. Please send the resumes at kiran.go...@ngtechinc.com Role: Data Warehouse Analyst Location: Madison, WI Location: 2+ Years Contract DW BI Knowledge areas: 1. Data warehouse/data marts using Kimball Inmon methodologies 2. Informatica PowerCenter ETL 3. SAP Business Objects universe and report design/development 4. Xcelcius Dashboard design and development 5. Crystal reports 6. Oracle, DB2 and SQL Server 7. Dimensional Data Modeling 8. Slowly Changing Dimensions 9. Infoburst 10. Requirements gathering 11. Project development life cycle process (i.e., planning, analysis, design, coding, testing, implementation, support 12. Excellent written and oral communications 13. Independent worker Informatica PowerCenter - ETL (5+years experience): • Data warehouse design • Data warehouse development Business Objects (5+ years experience): • SAP Business Objects Universe design and development • SAP Business Objects report design and development • Xcelsius dashboards Database Knowledge (5+years experience): • ORACLE • SQL Server • DB2 • Complex SQL statements Thanks, Kiran Gorak 872-213-9163 Phone kiran.go...@ngtechinc.com -- You received this message because you are subscribed to the Google Groups SAP BASIS group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-basis+unsubscr...@googlegroups.com. To post to this group, send email to sap-basis@googlegroups.com. Visit this group at http://groups.google.com/group/sap-basis. For more options, visit https://groups.google.com/d/optout.
DIRECT CLIENT // Data Warehouse Analyst
I have a very urgent DIRECT CLIENT requirement for Data Warehouse Analyst in Madison, WI. Please Let Me Know If you have available candidate, please reply with their word resume, location, rate and contact number. Please send the resumes at kiran.go...@ngtechinc.com Role: Data Warehouse Analyst Location: Madison, WI - (Local WI candidates or IL Candidates Only) Location: 2+ Years Contract DW BI Knowledge areas: 1. Data warehouse/data marts using Kimball Inmon methodologies 2. Informatica PowerCenter ETL 3. SAP Business Objects universe and report design/development 4. Xcelcius Dashboard design and development 5. Crystal reports 6. Oracle, DB2 and SQL Server 7. Dimensional Data Modeling 8. Slowly Changing Dimensions 9. Infoburst 10. Requirements gathering 11. Project development life cycle process (i.e., planning, analysis, design, coding, testing, implementation, support 12. Excellent written and oral communications 13. Independent worker Informatica PowerCenter - ETL (5+years experience): • Data warehouse design • Data warehouse development Business Objects (5+ years experience): • SAP Business Objects Universe design and development • SAP Business Objects report design and development • Xcelsius dashboards Database Knowledge (5+years experience): • ORACLE • SQL Server • DB2 • Complex SQL statements Thanks, Kiran Gorak 872-213-9163 Phone kiran.go...@ngtechinc.com -- You received this message because you are subscribed to the Google Groups SAP BASIS group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-basis+unsubscr...@googlegroups.com. To post to this group, send email to sap-basis@googlegroups.com. Visit this group at http://groups.google.com/group/sap-basis. For more options, visit https://groups.google.com/d/optout.
DIRECT CLIENT // Data Warehouse Analyst
I have a very urgent DIRECT CLIENT requirement for Data Warehouse Analyst in Madison, WI. Please Let Me Know If you have available candidate, please reply with their word resume, location, rate and contact number. Please send the resumes at kiran.go...@ngtechinc.com Role: Data Warehouse Analyst (2 positions) Location: Madison, Wisconsin Duration: 3+ Years In person Interview required The cleint is looking for an experienced Business Analyst to represent the customer’s requirements in a large, multi-program Business Intelligence effort. Candidates must have excellent communication skills, the ability to lead requirements-gathering sessions, and the ability to transform customer needs into requirements for the build of a new Data Warehouse. The individual will be a lead Business Analyst and is expected to mentor other Business Analysts in the department. Preference will be given to candidates with training and/or CBAP certification. The individual in this position will: • Be responsible for leading and facilitating the communication with IT staff, business customers and other stakeholders. They will provide support services to assist in the development and implementation of business intelligence. • Understand business goals, objectives and problems. They will manage the balance between business requirements and user expectations. • Use extensive experience as a liaison between users and technologists to drive requirements into design and construction. • Analyze user requirements, procedures, and problems to automate processing or to improve existing processes. Consult with business units to analyze current business procedures, identify issues, and learn specific business requirements. This includes understanding how data is to be summarized and formatted for reports. • Work with the team lead and manager to determine a detailed and prioritized list of objectives and activities for current and future projects. Experience with Human Services business intelligence is desirable. • Troubleshoot and resolve issues efficiently. Assist in the creation and maintenance of test plans. Participate in special projects as required. • Business Analyst with 5 or more years of experience, relies on experience and judgment to plan and accomplish goals, independently performs a variety of complicated tasks. Thanks, Kiran Gorak 872-213-9163 Phone kiran.go...@ngtechinc.com -- You received this message because you are subscribed to the Google Groups SAP BASIS group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-basis+unsubscr...@googlegroups.com. To post to this group, send email to sap-basis@googlegroups.com. Visit this group at http://groups.google.com/group/sap-basis. For more options, visit https://groups.google.com/d/optout.
DIRECT CLIENT // Data Warehouse Analyst
I have a very urgent DIRECT CLIENT requirement for Data Warehouse Analyst in Madison, WI. Please Let Me Know If you have available candidate, please reply with their word resume, location, rate and contact number. Please send the resumes at kiran.go...@ngtechinc.com Job title: Data Warehouse Analyst Location: Madison, Wisconsin Duration: 3+ Years In person Interview required The individual in this position will: Be responsible for leading and facilitating the communication with IT staff, business customers and other stakeholders. They will provide support services to assist in the development and implementation of business intelligence. Understand business goals, objectives and problems. They will manage the balance between business requirements and user expectations. Use extensive experience as a liaison between users and technologists to drive requirements into design and construction. Analyze user requirements, procedures, and problems to automate processing or to improve existing processes. Consult with business units to analyze current business procedures, identify issues, and learn specific business requirements. This includes understanding how data is to be summarized and formatted for reports. Work with the team lead and manager to determine a detailed and prioritized list of objectives and activities for current and future projects. Experience with Human Services business intelligence is desirable. Troubleshoot and resolve issues efficiently. Assist in the creation and maintenance of test plans. Participate in special projects as required. Business Analyst with 5 or more years of experience, relies on experience and judgment to plan and accomplish goals, independently performs a variety of complicated tasks. Thanks, Kiran Gorak 872-213-9163 Phone kiran.go...@ngtechinc.com -- You received this message because you are subscribed to the Google Groups SAP BASIS group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-basis+unsubscr...@googlegroups.com. To post to this group, send email to sap-basis@googlegroups.com. Visit this group at http://groups.google.com/group/sap-basis. For more options, visit https://groups.google.com/d/optout.
DIRECT CLIENT // Data Warehouse Analyst -(Informatica with Business Object)
I have a very urgent DIRECT CLIENT requirement for Data Warehouse Analyst in Madison, Wisconsin. Please Let Me Know If you have available candidate, please reply with their word resume, location, rate and contact number. Please send the resumes at kiran.go...@ngtechinc.com Title: Data Warehouse Analyst -(Informatica with Business Object) Location: Madison, Wisconsin Duration: 3+ years DOT is looking for a candidate that can help us re-build our Data Warehouse BI practice related to the STAR initiative. The candidate will be working on Data Warehouse BI projects, gathering documenting requirements, designing solutions, developing ETL using Informatica PowerCenter, developing universes and reports using Business Objects, testing, and implementing solutions. They will be responsible for both ETL and business intelligence report design, development, testing, maintenance, metadata, and implementation of data warehouse initiatives. Understand user requirements, and implement solutions that ensure requirements can be achieved through high quality deliverables. Develop ETL mapping specifications for loading information into the data warehouse and for ensuring reliability of information loaded. Seek continuous improvement in performance tuning of data warehouse and ensure security of data. Perform analysis and testing of relational databases and investigate any data load failures or data retrieval issues. Proven methodology experience for complex systems integration projects and demonstrated ability to achieve deliverables on time and on budget. Works with other IT technical teams and Business users to understand requirements, and recommend implement solutions. Works with moderate supervision with some latitude for independent judgment performing a variety of complex tasks. Requires advanced skill sets and developing proficiency within discipline. Typically requires 5 - 7 years experience or equivalent education. Ideal candidate will have experience designing Data Warehouse and BI solutions, and development experience with both Informatica PowerCenter and Business Objects. DW BI Knowledge areas: 1. Data warehouse/data marts using Kimball Inmon methodologies 2. Informatica PowerCenter ETL 3. SAP Business Objects universe and report design/development 4. Xcelcius Dashboard design and development 5. Crystal reports 6. Oracle, DB2 and SQL Server 7. Dimensional Data Modeling 8. Slowly Changing Dimensions 9. Infoburst 10. Requirements gathering 11. Project development life cycle process (i.e., planning, analysis, design, coding, testing, implementation, support 12. Excellent written and oral communications 13. Independent worker Informatica PowerCenter - ETL (5+years experience): •Data warehouse design •Data warehouse development Business Objects (5+ years experience): •SAP Business Objects Universe design and development •SAP Business Objects report design and development •Xcelsius dashboards Database Knowledge (5+years experience): •ORACLE •SQL Server •DB2 •Complex SQL statements Thanks, Kiran Gorak 872-213-9163 Phone kiran.go...@ngtechinc.com -- You received this message because you are subscribed to the Google Groups SAP BASIS group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-basis+unsubscr...@googlegroups.com. To post to this group, send email to sap-basis@googlegroups.com. Visit this group at http://groups.google.com/group/sap-basis. For more options, visit https://groups.google.com/d/optout.
DIRECT CLIENT // Data Warehouse Analyst -(Informatica with Business Object)
I have a very urgent DIRECT CLIENT requirement for Data Warehouse Analyst -(Informatica with Business Object) in Madison, Wisconsin. Please Let Me Know If you have available candidate, please reply with their word resume, location, rate and contact number. Please send the resumes at kiran.go...@ngtechinc.com Title: Data Warehouse Analyst -(Informatica with Business Object) Location: Madison, Wisconsin Duration: 3+ years Ideal candidate will have experience designing Data Warehouse and BI solutions, and development experience with both Informatica PowerCenter and Business Objects. DW BI Knowledge areas: Data warehouse/data marts using Kimball Inmon methodologies Informatica PowerCenter ETL SAP Business Objects universe and report design/development Xcelcius Dashboard design and development Crystal reports Oracle, DB2 and SQL Server Dimensional Data Modeling Slowly Changing Dimensions Infoburst Requirements gathering Project development life cycle process (i.e., planning, analysis, design, coding, testing, implementation, support Excellent written and oral communications Independent worker Informatica PowerCenter - ETL (5+years experience): Data warehouse design Data warehouse development Business Objects (5+ years experience): SAP Business Objects Universe design and development SAP Business Objects report design and development Xcelsius dashboards Database Knowledge (5+years experience): ORACLE SQL Server DB2 Complex SQL statements Thanks, Kiran Gorak 872-213-9163 Phone kiran.go...@ngtechinc.com -- You received this message because you are subscribed to the Google Groups SAP BASIS group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-basis+unsubscr...@googlegroups.com. To post to this group, send email to sap-basis@googlegroups.com. Visit this group at http://groups.google.com/group/sap-basis. For more options, visit https://groups.google.com/d/optout.
