Spruce Infotech
Spruce InfoTech is a leading service provider in project management, architecture design, installation, implementation, and administration of EPM and BI projects. Our team offers proven industry solutions to help clients better understand their business and support decision-making. We provide services that enable clients to manage, control, and transform their businesses using cost-effective and productive technology solutions. Our team has extensive experience with enterprise solutions such as Oracle Enterprise Performance Management (Hyperion), OBIEE, and TIBCO.
Job Description
Title:
Data Modeler (mid-level) Duration:
1 year + Interview mode:
phone then F2F Description: Required Skills: Minimum 3-5+ years experience modeling complex databases using tools like ERWin 9.2. Experience designing and building large financial data warehouses with strong data analysis skills. Good knowledge of ER/Dimensional modeling and experience in developing logical and physical data models in complex environments. 3-5+ years of experience in data management, data warehousing, data transformation, metadata, and BI tools. 3+ years of experience with advanced SQL queries using TOAD, SQL Navigator; basic UNIX knowledge is a plus. Experience as an Oracle DBA for large databases is a plus. Understanding of leading third-party products like Datastage, Business Objects, Microstrategy. Experience with SDLC processes. Responsibilities: Capture business requirements, design logical models, and create documentation to support, communicate, and validate data models. Design, build, and maintain logical and physical data models supporting business needs. Map data elements from sources into domain models. Maintain documentation of data models, relationships, constraints, and metadata. Conduct model reviews with business and technical teams. Review database design changes for impact analysis. Coordinate with development teams to improve model implementation. Participate in performance tuning activities like indexing and SQL optimization. Architect for high performance, scalability, and availability. Qualifications
Must be local to Willington, Delaware (DE). #J-18808-Ljbffr
Title:
Data Modeler (mid-level) Duration:
1 year + Interview mode:
phone then F2F Description: Required Skills: Minimum 3-5+ years experience modeling complex databases using tools like ERWin 9.2. Experience designing and building large financial data warehouses with strong data analysis skills. Good knowledge of ER/Dimensional modeling and experience in developing logical and physical data models in complex environments. 3-5+ years of experience in data management, data warehousing, data transformation, metadata, and BI tools. 3+ years of experience with advanced SQL queries using TOAD, SQL Navigator; basic UNIX knowledge is a plus. Experience as an Oracle DBA for large databases is a plus. Understanding of leading third-party products like Datastage, Business Objects, Microstrategy. Experience with SDLC processes. Responsibilities: Capture business requirements, design logical models, and create documentation to support, communicate, and validate data models. Design, build, and maintain logical and physical data models supporting business needs. Map data elements from sources into domain models. Maintain documentation of data models, relationships, constraints, and metadata. Conduct model reviews with business and technical teams. Review database design changes for impact analysis. Coordinate with development teams to improve model implementation. Participate in performance tuning activities like indexing and SQL optimization. Architect for high performance, scalability, and availability. Qualifications
Must be local to Willington, Delaware (DE). #J-18808-Ljbffr