RDBMS Teradata SQL Unix Shell Scripting OLTP Modeler (Jobs in Tulsa, OK)   Requirement id 75240 Job title Modeler Job location in Tulsa, OK Skills required RDBMS, Teradata, Data Warehouse, SQL Unix Shell Scripting OLTP Open Date 08-Nov-2018 Close Date Job type Contract Duration 12 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Modeler: RDBMS, Teradata, Data Warehouse, SQL Unix Shell Scripting OLTP Candidate must be our own W2 Employee Job Description : Duties: Design and develop the logical and physical data models and databases for organizations operational data stores (ODS), enterprise data warehouse (EDW) and data marts using the industry standard modeling tools Embarcadero ER Studio Data Architect Serve as a data modeling expert working on organizations complex business processes and requirements and provide optimal solutions by performing data feasibility analysis and in-depth evaluation of factors. Provide technical leadership on data architecture, data optimization, Database reverse engineering, metadata management and entity relationship diagram. Perform business analysis, event modeling, data access analysis, archive and recovery strategy, and load strategy design and security. Work with the data modeling team on requirement analysis, design and implementation of logical and physical modeling by coordinating with business, infrastructure and architecture team, data analyst team and ETL development team. Participate in application development and enhancement projects to evolve the database architecture and design. Provide professional business analysis and apply analytical skills to assist in the overall Master Data Management (MDM) and Data Integration and to define delimitations and Testing. Design and implement transformation logic necessary for the migration, conversion and integration of data across platforms and lines of business. Enforce data integrity, research and document data mapping from source to target systems, and work closely with business, Project Management, Data Architects, and the ETL Development Team to design and implement the requirements for the Enterprise Data Warehouse. Work with the data modeling team on streamline the data warehouse standards, processes and tools to promote and facilitate quality deliverable from data management team. Review the business requirement document, logical and physical models and integration mapping document and take necessary action to align with industry best practices and enterprise standards. Collaborate and coordinate with offshore based vendor team for periodic review on data modeling deliveries and ensures on-time and quality deliverables by leveraging the onshore-offshore model experience. Collaborate with project management team on streamline the data modeling delivery processes and bring continuous improvement on documentations to enable efficient project tracking and build knowledge repository for future references. Minimum Requirements: Bachelors degree in Computer Science, Computer Information System, or Information Technology Management plus at least 5 years of data modeling experience and demonstrated experience in: Industry best practice data dimensional modeling techniques using Star Schema, Snowflake Schema and Fact Constellations. Relational database normalization techniques using 1NF, 2NF & 3NF and de-normalization techniques. RDBMS including Teradata, Oracle, and SQL Server. Writing scripts for Data Extraction, Transformation and Loading of data from legacy systems to target data warehouse using BTEQ, FastLoad, MultiLoad, and Tpump. Perform tuning and optimization of complex SQL queries using Teradata Explain and Run stats. SQL and UNIX shell scripting technical knowledge to be able to perform effective analysis and impact assessment for the modeling work in development and enhancement projects. Online Transaction Process (OLTP) for effective collaboration with Database Architect and Data Integration team. Support and maintenance projects for effectively managing the expectation of shared service data management work stream. Agile Iterative methodology and RALLY a   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 75240 while calling.   Other jobs in OK: Bartlesville (4), Oklahoma City (1),    RDBMS job openings in other states Jobs List Database Administrator DBA - 135549 Create date: 03-Oct-2024 No of Submissions: 1 Start date : 11/1/2024 End date : 12/31/2029 Submission deadline : 10/9/2024 3:00:00 PM Client info: PERS Description: Support of a Custom PeopleSoft Pension Retirement System • Must have prior expert level technical experience with People soft a.... (This job is for - RDBMS MS SQL Server Jobs in MS Jackson Administrator - (in Jackson, MS)) Business Intel Technical Lead I -130769 Create date: 21-May-2024 Bid Limit Per Vendor : 1 Start date : 07/01/2024 End Date : 06/30/2025 Submission deadline : 5/23 at 4:00PM CST. Client Info : UW - System Administration Note : * Interview Process: Video conference * Duration: 1 year, with possibility of extension * R.... (This job is for - RDBMS Database Admin Oracle Jobs in WI Madison TechLead - (in Madison, WI)) Data Warehouse Developer III -128591 Create date: 25-Mar-2024 Start date : 05/06/2024 End Date : 06/30/2024 Submission deadline : 3/27/2024 at 4:00PM CST. Client Info : ETF Note : * Interview Process: 1-2 rounds via Microsoft Teams. Camera and audio required. * Duration: 6/30/2024, likely to extend. * Onsite or Remote? Candidates .... (This job is for - RDBMS Tableau Jobs in WI Madison Developer - (in Madison, WI)) VDOT GIS Developer 4 (730869) Create date: 13-Mar-2024 Hybrid start date :04/01/2024 End date :06/30/2024 submission deadline : 3/18/2024 client info : VDOT Description : *Ideal/preferred candidate will be able to work onsite once a week in Richmond, VA *If requested by hiring manager, .... (This job is for - RDBMS JSON Jobs in VA Richmond Developer - (in Richmond, VA)) GA DPH - Informatics Data Analyst II (707145) Create date: 23-Mar-2023 Hybrid Start date :04/17/2023 End Date :06/30/2024 Submission deadline :03/31/2023 Client Info :DPH Description : ------------------------------------------------------ *Please do NOT submit candidates previously submitted to #694141* *Must be committed to being onsite from.... (This job is for - Business Intelligence RDBMS Jobs in GA Atlanta Analyst - (in Atlanta, GA))     (Modeler: RDBMS, Teradata, Data Warehouse, SQL Unix Shell Scripting OLTP in Tulsa, OK)

Featured Jobs Budgeting Office Consultant (Jobs in Harrisburg, Pennsylvania) PMP Manager (Jobs in Atlanta, Georgia) Javascript Developer (Jobs in Tucker, Georgia) Architecture - - Specialist (Jobs in Raleigh, North Carolina) Typography Power Consultant (Jobs in Nashville, Tennessee) - Consultant (Jobs in Bismarck, North Dakota) SSIS JAVA Analyst (Jobs in Richmond, Virginia) TSOISPF Specialist (Jobs in Columbus, Ohio) Integration IT Specialist (Jobs in Columbus, Ohio) API CI Developer (Jobs in Richmond, Virginia)