ETL DBMS Informatica ERwin Architect (Jobs in Des Moines, IA)   Requirement id 90736 Job title Architect Job location in Des Moines, IA Skills required SQL, ETL, DBMS, Informatica ERwin Open Date 03-Apr-2019 Close Date Job type Contract to Hire Duration 9 Months Compensation DOE Status requirement --- Job interview type Face to Face interview    Email Recruiter: coolsoft Job Description Architect: SQL, ETL, DBMS, Informatica ERwin Candidate must be your W2 Employee. Job Description : Data Architect It is seeking a Data Architect to work with a leader in the Life Insurance and Annuities field. Essential duties include the following: Hands on technical lead in the development of logical/physical models for relational and dimensional schema to enable data driven business decision making Integrate disparate data into logical business data models, normalize data normalization for reporting and decision making Assist in Master Data Management guidelines, procedures and definitions for business data domains Design data structures and design highly available, highly scalable data services Design develop, and implement Business Data Domain models, information architecture in Life Insurance and Annuities business Ensure high data quality and limit risk of business process interruptions, while improving process and system effectiveness. Lead the data architecture for the decision support systems including rules, policies, standards and models that govern and define the type of data collected and how it is used, stored, managed and integrated and its database systems. Delivering enterprise Business Intelligence, data warehousing, and information delivery solutions. Contribute to Business Intelligence (BI) Architecture efforts to establish appropriate information delivery solutions for disparate functional areas and user communities. Use a variety of information gathering techniques (e.g., interviews, facilitation, diagrams) to gather complex business data requirements from Business teams Coordinate data models, data dictionaries, and other database documentation across multiple applications Leads design reviews of data deliverable such as models, data flows, and data quality assessments Perform data analysis, discovery, profiling and identify cause of data issues and work with broader team to resolve Lead the development of present and future state data models and assist in meeting data strategy objectives and roadmap Lead Proof-of-Concepts as needed Perform analysis, design, development, and testing activities in support of enterprise reporting, Business Intelligence, and data analytics solutions across a wide range of business and operational functional areas Assist with the design, development, and deployment of next generation data warehouse and tools to support long term information delivery and data visualization needs. Skills and Experience: Experience with Data Modeling, strong knowledge and understanding of dimensional modeling, star schema, snowflake schema and cube design. 8+ years of experience with Reporting, Business Intelligence, Data Management, and Data Analytics using market-leading tools, including standard and ad-hoc reporting, dashboards and visualization tools. Strong Data Design and Analysis skills Strong data modeling skills (normalized and multidimensional) Expert level Data Warehouse Architecture and Design skills Up to date knowledge of the data warehouse market, vendors, tools and standards bodies Strong technical skills with all data warehousing technologies (e.g., ETL, ODS, DBMS, BI) Knowledge and experience with Business Intelligence / Data Warehousing implementation methodologies and architectures. Experience designing and developing reporting, information delivery solutions, data visualization, and dashboards in an enterprise data warehousing environment. Experience designing and building extract, transformation, and load (ETL) processes to convert operational transactional data into dimensions and fact tables Extensive experience with SQL Server Experience working collaboratively with business users and senior-lev   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 90736 while calling.   Other jobs in IA: Des Moines (16), West Des Moines (2), West Desmoines (1), SQL job openings in Des Moines, IA Jobs List SAS-SQL Developers - 64743 Create date: 07-Jul-2020 Candidate must be our W2 Employee. Candidate must be local : Yes We should submit only GC,GC - EAD, L2-EAD,H4-EAD and Citizens. Job Description : SAS-SQL Developers Duration: 6 months with extension Remediate 2MM+ queries for business-written queries/scripts against the data warehouse. Work w.... (This job is for - SAS Coding Jobs in IA DesMoines Developer - (in Des Moines, IA)) SQL Data Analyst - 63534 Create date: 26-May-2020 Candidate must be our W2 Employee. Job Description : SQL Analyst Des Moines, IA It is the nations 2nd largest IT Staffing firm, has a SQL Analyst open to help with customer remediation. Technical skills include: SQL, database queries. Preferred skills include: N/A Applicants must have SQL exper.... (This job is for - SAS Jobs in IA DesMoines Analyst - (in Des Moines, IA)) Data QA Analyst - 63232 Create date: 13-May-2020 Note :Interview times friday 5/15 Candidate must be our W2 Employee. Candidate must be local : Yes We should submit only GC,GC - EAD, L2-EAD,H4-EAD and Citizens. Job Description : Data QA Analyst Des Moines, IA Overview of position: Convert data approach to .... (This job is for - SAS QA Jobs in IA DesMoines Analyst - (in Des Moines, IA)) SQL/Data Analyst - 62791 Create date: 29-Apr-2020 Note: IV times Monday. *Please note that as a contract employee with it, youd be eligible for Health, Dental, Vision and Life Insurance; Short Term Disability; Hospitalization Coverage; Direct Deposit; Weekly Pay; Training and Development Programs; Corporate Discounts/Perks and our Referral Program.* Candidate must be our W2 E.... (This job is for - job Jobs in IA DesMoines Analyst - (in Des Moines, IA)) SQL Developer - 62729 Create date: 28-Apr-2020 Note: We have IV times for thursday 4/30 and Friday 5/1. Candidate must be our W2 Employee. We should submit only GC,GC - EAD, L2-EAD,H4-EAD and Citizens. Job Description : Position: Python Developer Location: Des Moines, IA Duration: 12+ Month Contract Required Experience: Python Jobs in IA DesMoines Developer - (in Des Moines, IA))    SQL job openings in other states Jobs List Data Warehouse Developer I -136603 Create date: 23-Oct-2024 No of Submissions : 1 start date : 11/18/2024 End date : 06/30/2025 submission deadline : 10/25 at 4 CST. client info : DPI Note: * Interview Process: Via Teams * Duration: Till June 30, 2025, with possibility of extension * Onsite or Remote: Candidate must.... (This job is for - Data Warehousing Jobs in WI Madison Developer - (in Madison, WI)) Programmer Analyst 6 - 135098 Create date: 17-Sep-2024 No of Submissions : 1 Start date : 10/21/2024 End Date : 1 Years from projected start date Submission deadline : 9/24 at 10AM EST. Client Info : LARA Note: * Interviews: 1st round interviews will be held via MS Teams. 2nr round interviews may be held in person, so candidates must b.... (This job is for - JavaScript Jobs in MI Lansing Analyst - (in Lansing, MI)) NCDPI - SQL/Snowflake-Tableau Analyst - Senior (746385) Create date: 09-Sep-2024 No of Submissions : 2 Start date : 09/16/2024 End Date : 09/15/2025 Submission deadline : 09/13/2024 Client Info : NCDPI Note: * Agency Interview Type : In Person Only * Onsite Description : Currently, the enterprise is a complex, multi-platform data.... (This job is for - SnowflakeDB2 Jobs in NC Raleigh Analyst - (in Raleigh, NC)) Senior Quality Assurance Specialist - 134717 Create date: 04-Sep-2024 No of Submissions : 1 Start date : 10/1/2024 End Date : 10/1/2027 Submission deadline : 9/11/2024 3:00:00 PM Client Info : MDHS Note: * No max bill rate * Onsite Required * Do not submit remote/hybrid candidates, MDHS does not make exceptions to this rule and .... (This job is for - Visio Jobs in MS Jackson Specialist - (in Jackson, MS)) Technical Specialist IV - B36991W112 Create date: 28-Aug-2024 No of Submissions : 1 Start date : 09/23/2024 End Date : 09/23/2025 Submission deadline : 09/02/2024 Client Info : Bill Rate : USD 95.00 Per Hour Max Rate : USD 103.00 Per Hour Note: * Position Location : Remote * Candidate must be local or willin.... (This job is for - job Jobs in OR Salem Specialist - (in Salem, OR))    SQL job openings in IA Jobs List Database Engineer - 64475 Create date: 26-Jun-2020 Candidate must be local : Yes Candidate must be our W2 Employee. We should submit only GC,GC - EAD, L2-EAD,H4-EAD and Citizens. Job Description : Lead Database Engineer Contract to Hire Des Moines, IA It is looking for a Lead Database Engineer for an immediate opportunity.... (This job is for - ETL SSIS Jobs in IA WestDesMoines Engineer - (in West Des Moines, IA)) Senior Developer - 64193 Create date: 16-Jun-2020 Notes :Candidate needs to be located in Iowa, the midwest, or previous experience in Des Moines. Candidate must be local : Yes Candidate must be our W2 Employee. We should submit only GC,GC - EAD, L2-EAD,H4-EAD and Citizens. Job Description : Senior Developer Location: Johnston, Iowa.... (This job is for - job Jobs in IA Johnston Developer - (in Johnston, IA)) Data Visualization Developer - 57616 Create date: 10-Jan-2020 Candidate must be our W2 Employee. Candidates RTR form should be only on the name of APEX Systems. Notes : Looking for an intermediate developer (3-5 years of experience) that can be their own SME within Power BI Job Description : Summary: The primary focus of this role is th.... (This job is for - SSIS Jobs in IA CedarRapids Developer - (in Cedar Rapids, IA)) Senior Developer - 57460 Create date: 08-Jan-2020 Candidate must be local : Yes Job Description : Work on an agile team to help support, develop, and maintain multi-tier high performance windows and web based applications using the following technology tools, languages, and frameworks: Visual Studio, VS Code, Angular, Typescript, C#, .Net+Core, Entity, MS .... (This job is for - job Jobs in IA Johnston Developer - (in Johnston, IA)) IA-ED-SDP5-SQL ETL Developer (603603) Create date: 19-Nov-2019 Start Date :11/29/2019 End Date :11/11/2020 Submission Dead Line :11/25/2019 Client Info :ED: Education Department Description : This position will be an ETL developer in the Department of Education. The job will work with existing ETL developer to load data from source system.... (This job is for - SSIS Jobs in IA Desmoines Developer - (in Desmoines, IA)) (Architect: SQL, ETL, DBMS, Informatica ERwin in Des Moines, IA)

Featured Jobs Developer (Jobs in Atlanta, Georgia) Data Architect ETL Specialist (Jobs in Raleigh, North Carolina) SQL Architect (Jobs in Richmond, Virginia) Business Analyst Financial Analyst (Jobs in Fredericksburg, Virginia) Cyber Architect (Jobs in Columbia, South Carolina) Project Manager Microsoft Manager (Jobs in Raleigh, North Carolina) Help Desk Consultant (Jobs in Hartford, Connecticut) PMP Agile Manager (Jobs in Iowa City, Iowa) Azure AWS Specialist (Jobs in Raleigh, North Carolina) Intune Communication Expert (Jobs in Raleigh, North Carolina)