Home       |     Overview      |     Candidate Login      |     Post Resume       |     Contact us
 
  
     
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
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

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))

NJ Transit - Business Intelligence Architect (700367)
Create date: 12-Dec-2022
Hybrid

Start date :01/03/2023

End Date :08/31/2023

Submission deadline :12/14/2022

Client Info :TRANSIT

Description :
---------------------------------------------

15+ years of IT experience and 10+ years of experience in the Business Intelligence field and expertise in data dri.... (This job is for - RDBMS Jobs in NJ Newark Architect - (in Newark, NJ))

Senior Database Administrator - 10629-1
Create date: 09-Nov-2022
start date: 12/08/2022

End date: 12+ Months from the start date

submission deadline: 11/16/2022

client info : Department of Social Services

Note :

* INTERVIEW PROCESS (who will conduct i/v, phone or in-person, how many rounds of i/vs)?

- Interview will be by skype and will be cond.... (This job is for - RDBMS SQL Jobs in SC Columbia Administrator - (in Columbia, SC))
 
 
(Modeler: RDBMS, Teradata, Data Warehouse, SQL Unix Shell Scripting OLTP in Tulsa, OK)
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     

    About Us     Services    Privacy policy    Legal     Contact us