Data Modeler

THIS IS A TRUE DATA MODELER POSITION WITH A LITTLE PL/SQL. THE PL/SQL DEVELOPERS WE SUBMITTED WERE PASSED. THEY WANT A STRONG OLTP RESOURCE WITH TRUE DATA MODELING EXPERIENCE. SEE BELOW:

*** THIS IS NOT A PL/SQL DEVELOPER POSITION SO PLEASE DO NOT SEND ME PL/SQL DEVELOPERS. IT IS A DATA MODELING POSITION AND CANDIDATES SHOULD HAVE THAT TITLE.

• Will be responsible to change maintain the data models and be able to work closely with the business team to understand the requirements and provide guidance on the design to the development team. Should be able to assist both developers and testers to ensure that data processing is accurate efficient and complete.
• Must be proficient in OLTP/3NF (Online transaction processing 3rd normal form) as well as dimensional/data mart modeling (star schema snowflake) Minimum of 5 years
• Experiences in Data modeling in Snowflake Database Oracle Database and in Salesforc

*** We need: A senior Oracle Data Modeler Hands on experience in performance tuning Oracle database and SQL and understanding of ETL tools (Data Stage and IICS Informatica preferred) and business intelligence reporting with some exposure to Cognos and PowerBI. **Candidates must have Long Projects/Good Tenure Excellent communication skills and a State issued ID (Not Bills) showing they are Local.

Required Location: Hybrid/Midtown New York City or TROY MI / 3 days a week.

Contract status: CC preferred or W2 Referral.

Interview Required: Video

Candidate Visas Accepted: No Opt.

Candidates must be LOCAL to the NEW YORK or NEW JERSEY or TROY MI area and COMMUTE into the office THREE TIMES A WEEK. NO RELOCATION CONSIDERED. ***

*** PLEASE Only send me candidates in the NY/NJ or TROY MI area Open to Hybrid.

*** Please make sure that each submittal includes:

1. Drivers license or State ID
2. Link to the candidates LinkedIn account.
3. Below submittal Format

*** Candidate Must Haves on a resume and for submittal:

1. How many years working with: Oracle Data Modeling

2. How many years working with: OLTP

3. How many years working with: Hands on experience in performance tuning Oracle database and SQL

4. How many years working with: ETL

5. How many years working with:

*** Please provide all the below Submittal Format details with each submittal. It is required for the client Management system.

• Full Name:
• Rate:
• Location:
• Availability to Interview: One Days notice
• Availability to Start:
• Email Address:
• Phone Number:
• Visa Status:
• Education College/Year of graduation:
• Link to LinkedIn
• Certifications (Please list)

Job Description:

Data Modeler Some basic skillset requirements we are looking for

Must be proficient in Oracle and SQL coding (with recent experience) Minimum of 5 years Must be proficient in OLTP/3NF (Online transaction processing 3rd normal form) as well as dimensional/data mart modeling (star schema snowflake) Minimum of 5 years

Must be proficient in data analysis and SQL skills Minimum of 5 years

Experience with SDLC / Scaled agile delivery frameworks for data warehouse projects minimum of 7 years

PL/SQL programming of at least 2 years is preferred.

Experiences in Data modeling in Snowflake Database Oracle Database and in Salesforce

Good communication skills

Complete understanding of ETL tools (Data Stage and IICS Informatica preferred) and business intelligence reporting with some exposure to Cognos and PowerBI.

Hands on experience in performance tuning Oracle database and SQL.

Some experiences in Snowflake database administration Job involves profiling creating advising and reviewing data models for our data warehouse atomic as well as data mart areas. Should be able to provide design of the table structures with proper data analysis and mapping capabilities. Will be responsible to change maintain the data models and be able to work closely with the business team to understand the requirements and provide guidance on the design to the development team. Should be able to assist both developers and testers to ensure that data processing is accurate efficient and complete. Should be able to prioritize work activities to meet the timelines.