DynamoDB PostgreSQL Data Management Equivalent Technical Study Modeler (Jobs in   Requirement id 131205 Job title Modeler Job location in Trenton, NJ Skills required DB2 Experience, RedShift As A Cloud Solution, DynamoDB, PostgreSQL Data Management Equivalent Te Open Date 07-Jan-2022 Close Date Job type Contract Duration 6 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Modeler: DB2 Experience, RedShift As A Cloud Solution, DynamoDB, PostgreSQL Data Management Equivalent Te Start Date :12/12/2021 End Date :06/10/2022 Submison Deadline :01/11/2022 Client Info: Judiciary Note : * Agency Interview Type: iLinc Web Cam Interview Only Description : Note: Contractor will work remotely with the expectation that they will come into the office to work On-Site a few times per month or more frequently if policies change. As such, Contractor needs to live locally. This SDM position is for designing and implementing modern data modeling solutions using relational, dimensional, snowflake, star, data lake that meet Judiciary needs using conceptual, logical, and physical data models. The SDM should be capable of modelling for various data bases like AWS Redshift, S3, Dynamo DB , DB2, Postgress. Complete Description Senior Data Modeler (SDM) Specialist will be responsible for the design, develop & implementation of Data Warehouse database structures and Analytical Database structures. SDM will work with Business groups and Application Teams during pre & post assessment periods. The SDM reports to Supervisor/Team Lead. DSM should be able to write complex SQLs ,write and execute Stored Procedures for analysis for data . SDM should understand the needs of the Business team and BI team for building proper Data Warehouse and DataMart. Should be capable of developing structured and unstructured data model for BI and Analytics. Tasks: • Understand and translate business needs into data models supporting long-term solutions for different Judiciary systems. • Work with the Application Development teams (ex: Pega Applications) to implement data strategies, build data flows and develop conceptual data models. • Create logical and physical data models using best practices to ensure high data quality and reduced redundancy. • Optimize and update logical and physical data models to support Data Initiative project for different phases of implementation. • Develop best practices for standard naming conventions and coding practices to ensure consistency of data models. • Recommend opportunities for reuse of data models in new environments. • Perform reverse engineering of physical data models from databases like DB2 and SQL scripts. • Evaluate data models and physical databases for variances and discrepancies across the different source systems in Judiciary. • Analyze data-related system integration challenges and propose appropriate solutions and develop the model according to Judiciary Standards. • Work with all IT teams like System Analysts, Engineers, Programmers, BI and others on project limitations and capabilities, performance requirements and interfaces. • Review modifications to existing software to improve efficiency and performance. Qualifications: • Candidate should have over all 8+ years of Data Modelling experience. • Minimum 4 years of overall experience and 3 years into Bigdata Technologies • Strong work experience in Data modeling and usage of data modeling tools. • Exposure with Snowflakes Cloud Data Warehouse, if possible • He/she should be well versed in understanding relational data, dimensional data, unstructured data, and master data. • Should have recent data management trend skills such as developing data lake model along with traditional modelling practices like snowflake and star. • They should know modeling techniques latest that are adapted for data warehousing and analytical structures. • Able to build logical data model and translate logical model into physical database. • They must be able to compare actual project procedures to the specified standards and procedures. • They should be able to demonstrate expertise with the most recent and relevant technologies in the data modelling implementation. • They must have excellent communica   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 131205 while calling.   Other jobs in NJ: Edison (2), Englewood Cliffs (1), Ewing (2), Franklin Lakes (7), Hamilton (3), Hightstown (7), Hopewell (2), Jersey City (3), Little Falls (1), Maplewood (1), Mercer County (3), Mount Laurel (11), Mt Laurel (4), New Brunswick (1), Newark (1), Princeton (4), Somerset (9), Trenton (123), Unknown (2), Warren (7), Wayne (1), DB2 Experience job openings in Trenton, NJ Jobs List Senior Consultant 1 Mid-Level Data Analyst (644774) Create date: 24-Mar-2021 Start Date :02/14/2021 End Date :08/13/2021 Submission Deadline :03/30/2021 Client Info : Judiciary Note : * Agency Interview Type : iLinc Web Cam Interview Only Description : This Data Analyst position is to work with Business Teams and bridge the gap bet.... (This job is for - job Jobs in NJ Trenton Analyst - (in Trenton, NJ)) NJATCSU Data Warehouse Analyst (643043) Create date: 12-Jan-2021 Start Date :01/04/2021 End Date :10/29/2021 Submission Deadline :01/18/2021 Client Info : Judiciary Note : * Agency Interview Type : iLinc Web Cam Interview Only Description : Short Description in full: Responsible for eliciting ETL requirement.... (This job is for - Reporting Jobs in NJ Trenton Analyst - (in Trenton, NJ))    DB2 Experience job openings in other states Jobs List ApplicationDeveloper Level 4 -Architect Developer SalesForce Create date: 26-Aug-2022 start date:07/01/2022 End date:12/31/2022 submission deadline:08/26/2022 client info : CT DSS Note: * Position Location: Hybrid * Local candidates preferred Description: Looking for an expert Sales Force Architect.... (This job is for - CSS Jobs in CT Hartford Developer - (in Hartford, CT)) NCDOT - Technical Specialist - Senior (676714) Create date: 25-Feb-2022 Start Date :02/7/2022 End Date :11/11/2022 Submission Deadline: :03/3/2022 Client Info: NCDOT Note : * Agency Interview Type: Webcam Interview Only Description: ***The candidate will be allowed to work remotely until all staff return to site. At that.... (This job is for - Cobol CICS Jobs in NC Raleigh Specialist - (in Raleigh, NC)) NCDOT - Technical Specialist - Senior - Normal (669112) Create date: 22-Nov-2021 Start Date :01/1/2022 End Date :12/31/2022 Submison Deadline :11/30/2021 Client Info: NCDOT Note : * Agency Interview Type: Either Webcam Interview or In Person Description : ***The candidate will be allowed to work remotely until all staff return to site.... (This job is for - CICSJCL Jobs in NC Raleigh Specialist - (in Raleigh, NC)) SYSTEM SOFTWARE PROGRAMMER - 10131-1 Create date: 19-Oct-2021 Start Date :11/3/2021 Submission Deadline :10/26/2021 Client Info : Health & Environmental Control Department Note : * INTERVIEW PROCESS (who will conduct i/v, phone or in-person, how many rounds of i/vs)? One initial round of phone interview will be scheduled for the top 3 can.... (This job is for - SQL ASPNet Jobs in SC COLUMBIA Consultant - (in Columbia, SC)) GA DOL - Quality Assurance Analyst (657672) Create date: 16-Jul-2021 Start Date :08/2/2021 End Date :06/30/2022 Submission Deadline :07/23/2021 Client Info : GDOL Note : * Agency Interview Type:Either Web Cam or In Person Description : **LOCAL METRO ATLANTA CANDIDATES** 3-2-1 plan for in-person training and days .... (This job is for - job Jobs in GA Atlanta Analyst - (in Atlanta, GA))     (Modeler: DB2 Experience, RedShift As A Cloud Solution, DynamoDB, PostgreSQL Data Management Equivalent Te in Trenton, NJ)

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)