Azure datawarehouse Business Requirements ETL Python Tableau Architect (Jobs in   Requirement id 74331 Job title Architect Job location in Kansas City, MO Skills required Informatica, SQL, Data Modelling, Azure datawarehouse Business Requirement Open Date 12-Oct-2018 Close Date Job type Contract Duration 6 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Architect: Informatica, SQL, Data Modelling, Azure datawarehouse Business Requirement Candidate must be our own W2 Employee Job Description : Accountability Typical Duties or Tasks Design data models and data architecture, data governance Strong skills in SQL and data modeling Must be a creative thinker and self-starter, able to identify solutions and quickly prototype proof of concept. Expected to quickly understand and embrace new technologies Build deep expertise in the data and its meaning as it applies to business processes Strong inclination towards managing data with outlook on how to improve data quality, metadata management and data velocity Design and architect data solutions with Business intelligence and reporting in mind Architect DW/data-marts with industry best practices Analyze source data both from a technical and business perspective Architect Information Systems and data delivery processes Build strong knowledge of business data flow and data distribution Develop logical data flow maps required for business analytics Evaluate and recommend best practices for data collection, quality and distribution Design and develop end to end information delivery process Understand business data needs and convert to technical specifications In-depth understanding of all critical business applications and its underlying data model/distribution Ability to recommend Business Value Drivers and KPIs needed by various business units for strategic, operational and predictive use cases Design and architect system integration process needed for business analytics Define optimum joins between tables based on the functional requirement Design and architect information solution Strong knowledge of SQL and SQL queries: Hands on experience with complex SQL and high-volume Relational databases and SQL Query performance Experience in replication, data warehouse and scalability – load balancing Experience to setup database alerts, maintenance plans and scripts Working knowledge on AZURE Databases including SQL AZURE, AZURE Data Warehouse, AZURE Data lake Ability to design data models based on functional data/business requirements Convert business requirement to end-to-end data flow, data model as part of the high level design Apply sufficient business process knowledge to source system data to bring them into the logical datawarehosuse Built optimal data model with ease of access and heaving performance in mind Strong knowledge on various data modelling strategies Working closely with Business stakeholders to gather pain points build and/or extend the data model. Supervise Data and Information test cases, resolve defects within BI tools Strong knowledge of Informatica PowerCenter ETL tool Perform unit testing of ETLs and related components and document test results. Experience with reading and loading high-volume Type 2 dimensions (Slowly Changing Dimensions) in Multi-Dimensional Datamarts (Star Schema) Create Unit Test Documentation (Test Cases, Test Scripts and Test Results) Experience working as a hands-on MS SQL Server 2005/2008/2012/2014 Database Administrator. DB and Oracle Determine and recommend enhancements to the BIDW for performance improvement Experience with advising and working with BI and advanced analytics technologies Experience with the best of breed traditional enterprise Business Intelligence tools such as BusinessObjects Cognos Microsoft Reporting Services Experience with best of breed high performance analytics tools suc   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 74331 while calling.   Other jobs in MO: Clayton (1), Kansas City (6), Morrisville (1), Saint Louis (3), St Louis (15), Informatica job openings in Kansas City, MO Jobs List Informatica Cloud Developer - 40176 Create date: 05-Nov-2018 Job Description : Informatica Cloud Developer Candidate must have experience in the Cloud ICS version. Informatica Cloud (ICS & IICS) development. Primary Responsibilities: Design, develop and test ETL processes per business requirements, following development standards and best practices. Ca.... (This job is for - job Jobs in MO KansasCity Developer - (in Kansas City, MO)) Integration Architect - 38816 Create date: 25-Sep-2018 Candidate must be our own W2 Employee We should submit only GC,GC - EAD, L2-EAD,H4-EAD and Citizens Required Skills : Mulesoft development, mulesoft architecture, app-to-app API/ messaging, ETL architecture, very strong communication skills Mulesoft certified, informatica architecture, RabbitMQ job Jobs in MO KansasCity Architect - (in Kansas City, MO))    Informatica job openings in other states Jobs List Data Warehouse Developer III -130622 Create date: 21-May-2024 Bid Limit Per Vendor : 1 Start date : 07/01/2024 End Date : 06/30/2025 Submission deadline : 5/22 @ 4pm CST Client Info : DCF Note : INTERVIEW NOTES: • Phone and web based interviews will be acceptable. • However, an in--person interview may be required. • In.... (This job is for - job Jobs in WI Madison Developer - (in Madison, WI)) MNSITE-2619 Middleware/Product - System Administrator -SP Create date: 16-Mar-2023 Bid URL: https://solutions.sciquest.com/apps/Router/SourcingResponseSummary?ResponseId=2925654&tmstmp=1678973766228 Note: Online Submission Submission Deadline: 3/30/2023 2:00 PM CDT Start Date: 4/19/2023 End Date: 4/18/2024 Client: Department of Human Services (DHS) Description: Scop.... (This job is for - job Jobs in MN StreetPaul Administrator - (in Street Paul, MN)) Senior IICS Software Developer - 90077 Create date: 16-Feb-2023 Start date : 3/6/2023 End Date : 12 months from the start date. Submission deadline : 2/23/2023 Note : * On-site/Remote : On-site * Interview : Phone or video call Description : --------------------------------------------- Responsibilities Peer Reviews of .... (This job is for - job Jobs in TX Houston Developer - (in Houston, TX)) Data Base Programmer/Analyst - 23-1000-ETL BU Create date: 27-Jan-2023 Start Date : 02/20/2023 End Date : 06/30/2023 Submission Deadline : 02/09/2023 Client Info : CO CDE Note: * Position Location Remote Description : The Colorado Department of Education (“CDE” or “the Department”) has been awarded a grant which .... (This job is for - ETL Jobs in CO Denver Consultant - (in Denver, CO)) Data Warehouse Developer III -112520-SP Create date: 14-Dec-2022 Start date : 01/03/2023 End Date : 06/30/2023 Submission deadline :12/16/2022 at 4:00PM CST Client Info : Note : * Interview Process: Online * Duration of the Contract: 6/30/2023, likely to extend * Onsite or Remote? 100% remote. Not required to be located in Wisconsin. D.... (This job is for - Data Warehousing Jobs in WI Madison Developer - (in Madison, WI))    Informatica job openings in MO Jobs List ETL Production Support - 54423 Create date: 21-Oct-2019 Candidate must be our W2 Employee We should submit only GC,GC - EAD, L2-EAD,H4-EAD and Citizens Notes : This is not a traditional Database Administrator position but instead non-prod support analyst that will help troubleshoot non-prod batch failures, DVO job failures, and create substantial documentation for the o.... (This job is for - job Jobs in MO StLouis Consultant - (in St Louis, MO)) Senior ETL Developer - 43234 Create date: 07-Feb-2019 Candidate must be your W2 Employee. Job Description : Position Overview It is looking for results oriented, Senior Data Warehouse Developer to independently design, develop, test, implement, document, and support data warehouses, including ETL, database, and scheduling technologies and processes. In this senior role, the .... (This job is for - ETL Oracle Jobs in MO Chesterfield Developer - (in Chesterfield, MO)) Data Services Management (ETL) And Scripting Create date: 21-Apr-2015 [NOTE : START DATE: 07-01-2015 END DATE : 06-30-2015 NOTE : SUBMISSION DEADLINE : 05-04-2015 2:00 PM on Monday] Description: PROJECT APPROACH AND SCOPE OF WORK: The Offeror must provide a detailed description and firm, fixed price for each deliverable. The description must specify the task.... (This job is for - job Jobs in MO JeffersonCity Administrator - (in Jefferson City, MO)) SENIOR Level ETL Developer Create date: 15-Jun-2011 [Note :] Required: 3+ years experience with an ETL toolset (Informatica, DataStage, Oracle Data Integrator, SAP BO Data Services, SSIS, etc)5+ years IT experience Oracle TOAD Strong SQL Adaptable to ramp up quickly and independently Experience with complex source systems and data sources Experie.... (This job is for - ETLOracle Jobs in MO StLouis Developer - (in St Louis, MO)) Sr. Informatica Developers Create date: 11-Mar-2011 [Note:Candidates should be well rounded with strong Database Design skills. Communication is extremely important as developers in this group interact directly with customers through JAD sessions. We are looking for candidates that have a stable work history and a legitimate reference from a prior supervisor.] Candidates must be capable o.... (This job is for - ETL SDLC Jobs in MO StLouis Developer - (in St Louis, MO)) (Architect: Informatica, SQL, Data Modelling, Azure datawarehouse Business Requirement in Kansas City, MO)

Featured Jobs Troubleshooting Engineer (Jobs in Des Moines, Iowa) Application Developer (Jobs in Richmond, Virginia) Business Analyst Business Analyst (Jobs in Richmond, Virginia) Consultant (Jobs in Murfreesboro, Tennessee) TFS Automation Analyst (Jobs in Dimondale, Michigan) Cloud Architect (Jobs in Lansing, Michigan) GitHub Consultant (Jobs in Lansing, Michigan) IT Developer (Jobs in Atlanta, Georgia) Microsoft Consultant (Jobs in ANDERSON, South Carolina) Business Analyst JAD SQL Analyst (Jobs in Lansing, Michigan)