Data Warehouse Architect
Company: Business Integra
Location: Saint Paul
Posted on: February 21, 2021
|
|
Job Description:
Data Warehouse Developer/CDC Lead Richfield MN with some remote
12 months + Project Details: Install and configure IBM InfoSphere
CDC (Change Data Capture) Would also like to have scheduled data
analytics reporting if not real-time, then at least daily or 3
times a day. Also would like to store the data as OLTP (90 days),
OLAP (historical data), and add Hadoop to keep 7 years of data. Day
to Day: There are no DBAs on is team, so this role will manage the
IBM InfoSphere CDC application assist the Cognos team with the OLTP
transactional database and with OLAP database side. Assist with
running replication jobs to move the between the databases and then
do the reporting. Tech Stack: DB2 OLTP (Transactional Database)
plus a second DB2 OLAP (Analytical Database) via Replication jobs
between the 2 databases. Cognos Data Modeler creates the OLAP
dimensional data modeling and mappings. Not using ETL, but may look
into IBM DataStage. 1400 tables in the OLTP, but 300 designated for
the reporting OLAP database for the developer to utilize for
reporting. They have a scripted run tool that builds the SQL
(Hive?) queries. Delimiters can be changed. Using Bash/Unix shell
scripting also. Must Have: Advanced SQL IBM CDC (Change Data
Capture) - need to be comfortable working in an environment where
it isn't already set up. Strong Plus: DB2 Hadoop AIX/Linux/Unix
Scripting IBM DataStage ETL or similar ETL Required Skills :
Advanced SQL IBM CDC (Change Data Capture) - need to be comfortable
working in an environment where it isn't already set up. Basic
Qualification : Additional Skills : Background Check :Yes Notes :
Selling points for candidate : Project Verification Info :
Candidate must be your W2 Employee :No Exclusive to Apex :No Face
to face interview required :No Candidate must be local :No
Candidate must be authorized to work without sponsorship ::No
Interview times set :Yes Type of project :Architecture/Design
Master Job Title :Data Analyst Branch Code :Minneapolis - provided
by Dice
Keywords: Business Integra, St. Paul , Data Warehouse Architect, Other , Saint Paul, Minnesota
Click
here to apply!
|
Didn't find what you're looking for? Search again!
Other Other JobsTruck Driver CDL A - Dedicated- Hogan Description: Now Hiring CDL-A Drivers for Dedicated Midwest Regional Runs Hogan offers our Dedicated Regional CDL-A Truck Drivers: ul li 10,000 Sign-On Bonus for Experienced Drivers li 0.58- 0.63 CPM Starting Company: Hogan Transportation Location: Minnetonka Posted on: 03/4/2021 Urgent Hiring - Grocery Shopper Description: Shipt is a membership-based marketplace that helps people get the things they need, like fresh produce and household essentials, from stores they trust. Help people save time and have fun while you're (more...) Company: Shipt Location: Minnetonka Posted on: 03/4/2021 Cook (Full Time) Description: Overview: Are you looking for an opportunityto work in your community that allows you to build relationships and make a difference Our Beacon Hill community is seeking part time Cooks to join their team.If (more...) Company: Presbyterian Homes & Services Location: Minnetonka Posted on: 03/4/2021 Concierge Description: Overview br It makes me feel good knowing that we make the residents' lives better. We laugh with them, cry with them, sing and dance with them - we brighten their day. Working here is an unbelievable (more...) Company: Sunrise Senior Living Location: Minnetonka Posted on: 03/4/2021 Cook (Part Time) Description: Overview: Are you looking for an opportunityto work in your community that allows you to build relationships and make a difference Our Beacon Hill community is seeking part time Cooks to join their team.If (more...) Company: Presbyterian Homes & Services Location: Minnetonka Posted on: 03/4/2021 Oracle HCM Cloud Experienced Associate Description: A career within PwC's Oracle Services Practice, will provide you with the opportunity to help organizations use enterprise technology to achieve their digital technology goals and capitalize on business (more...) Company: PwC Location: Minnetonka Posted on: 03/4/2021 Restaurant Team Member - Crew Description: Restaurant Team Member Company: Chipotle Mexican Grill Location: Minnetonka Posted on: 03/4/2021 Sr Financial Auditor Description: br Radisson Hotel Group, is one of the world's largest hotel groups with seven distinctive hotel brands, with more than 1,400 hotels, 95,000 global team members in destinations around the world. The (more...) Company: Radisson Hotel Group Headquarters Location: Minnetonka Posted on: 03/4/2021 CNA Description: Overview: Weare seeking Part Time Nursing Assistants NAR / Home Health Aides HHA to join our team at our Beacon Hill community. These positions mayinclude working every other weekend and scheduled (more...) Company: Presbyterian Homes & Services Location: Minnetonka Posted on: 03/4/2021 Package Sorter - Amazon Description: Location: 5825 11th Ave E, Shakopee, MN 55379 - MSP5 Sortation Center Hourly Pay Rate: 15.75- 16.75Shifts: 3am-7am, 830am-1230pm, 2pm-6pm, 830pm-1230am, 11pm-3am. - Shift end time may be extended up (more...) Company: Amazon Workforce Staffing Location: Minnetonka Posted on: 03/4/2021 |