StPaulRecruiter Since 2001
the smart solution for St. Paul jobs

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!

I'm looking for
in category
within


Other Other Jobs


Truck 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

Log In or Create An Account

Get the latest Minnesota jobs by following @recnetMN on Twitter!

St. Paul RSS job feeds