Home       |     Overview      |     Candidate Login      |     Post Resume       |     Contact us
 
  
     
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
Executive Order 11246, Section 503 & VEVRAA EOE, including disability/vets
Architect Business Intelligence datawarehouse SAS 6 ETL Architect
(Jobs in COLUMBU
 
Requirement id 67754
Job title Architect
Job location in Columbus, OH
Skills required Architect, Business Intelligence, datawarehouse, SAS 6 ETL
Open Date 20-Feb-2018
Close Date
Job type Contract
Duration 1 Months
Compensation DOE
Status requirement ---
Job interview type ---
Apply
   Email Recruiter: coolsoft
Job Description Architect: Architect, Business Intelligence, datawarehouse, SAS 6 ETL

DUE TO NUCLEAR DATA AND INFORMATION ONLY USC CAN BE CONSIDERED

Informatica Archiect on the Enterprise Data Warehousing Team.

Under limited supervision, the IT Architect participates in all aspects of application delivery. The IT Architect will work closely with the developers and other project team members on low to medium scale assignments of minimum to medium risk. The IT Architect will gather and analyze user requirements, generate conceptual design and develop implementation strategies. This position requires basic communication, problem-solving and leadership skills. This position also involves extensive interactions with business unit customers requiring the IT Architect to have a good mixture of business knowledge and technical skills.

PRINCIPAL ACCOUNTABILITIES:

Examine and evaluate current business processes and tasks, and develop ideas for improvement.
Convert knowledge and ideas into better ways of doing business or into new or improved products and services.
Participate in review, evaluation, and recommendation of new technologies.
Assist with the preparation of resource estimates, evaluations, and recommendations.
Identify, control and manage the impact of uncertain harmful technology events on the project and the project deliverables.
Use diagrams to help discover, communicate and understand the problem being solved and develop the software solution.
Use patterns as a fundamental structural organization schema for software systems.
Demonstrate the highest standards of ethical behavior and support the Companys Corporate Compliance Policy.
Understand and support the policies, values, principles, structure and behavior of AEP.
Ensures alignment to AEPs supported technology stack with all provided solutions.
Promote continuous improvement within the project team.


Data Warehouse and ETL Architect, Data Analytics Team

Responsibilities:
Collaborate with Business Systems Analysts and Business SMEs to get a good understanding of business reporting and data consumption requirements
Responsible for preparation of High Level Solution design and preparation of Estimates.
Design and build conceptual designs and context diagrams to provide a good understanding of the business context to the business and development teams.
Responsible for carrying out Impact Analysis and Impact remediation
Identification of technical issues/risks, Remediation of issues/risks
Design and build Dimensional and Physical Data Model with a clear understanding of best practices.
Design the data integration approach based on requirements.
Prepare the detail design of ETL batch processes. Coach ETL developers to develop the batch processes ensuring ETL best practices are met
Responsible for the development of advanced ETL batch processes.
Develop implementation strategies for implementing the Data layer and the ETL process layer in production
Responsible for process improvements when working on enhancements to existing functionality
Collaborate with IT Support counterparts to conduct design and Code reviews
Coach and mentor junior resources on the team

Functional skills required:
Good blend of functional and technical skills. Good Business Acumen is a key skill.
Should be able to communicate with the business users at a functional level.

Technical Skills:
Informatica 9 Series: Minimum 8-10 Years of experience
Oracle, PL/SQL: Minimum 6-8 Years of experience (SQL Development, Performance Tuning)
Dimensional Modeling: Minimum 4-5 Years of experience
Agile Scrum framework: Must to have experience
Cognos, Business Objects: Preferred
Informatica Power Exchange experience would be a big plus

Soft Skills:
Good Team player. Should be well suited to work on an Agile Team
Good organization skills
 
Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 67754 while calling.
 
Other jobs in OH: Cincinnati (1), Cleveland (1), Columbus (233), Dublin (8), Solon (2),
Architect job openings in Columbus, OH
Jobs List

Business Analyst - 59151
Create date: 15-Dec-2021
Description:

Responsibilities

Our client in Columbus Ohio is seeking a Business Analyst.

Candidates must be local to central Ohio or relocated by day one for consideration.

Responsibilities

Lead requirement discussions to document, analyze and translate functional and non-functional busines.... (This job is for - Architect Jobs in OH Columbus Analyst - (in Columbus, OH))

Technical Specialist 4/TS4 - 78082
Create date: 08-Dec-2020
start date:1/4/2021

End date:06/30/2021

submission deadline:Monday 12/14/20 @ 10 am EST



Note:

** Interviews: digital RIVS interviews will be sent to the top 10 candidates. Then a TEAMS video interview will be next.

Description:
.... (This job is for - Architect Jobs in OH Columbus Specialist - (in Columbus, OH))

Senior Architect 2/SAR2 - 65215
Create date: 11-Sep-2019
Start Date : 09/30/2019
End Date : 12/31/2019
Submission Dead Line : Wednesday 9/18 @ 10AM
Client Info : DOH

Note:

* NTE Rate: 123.42
* Will Close to Submissions: Wednesday 9/18 @ 10AM
* Interviews: On-site interviews are preferred
* This position will be joining i.... (This job is for - Architect Jobs in OH Columbus Architect - (in Columbus, OH))

Senior Architect 2/SAR2 - 64780
Create date: 22-Aug-2019
Start Date : 9/16/2019
End Date : 12/31/2019
Submission Dead Line : Will Close to Submissions: Friday 8/30 @ 10AM
Client Info : DOH

Note:

* interviews: The team would prefer on-site interviews but will make exceptions for qualified candidates- please note in comments if they a.... (This job is for - Azure Architect Jobs in OH Columbus Architect - (in Columbus, OH))

Cognos Architect - J-11-325-601
Create date: 01-Jun-2018
Description: 6 months + possible extension. Must be US Citizen due to data they will work on.
Cognos Architect position on the Enterprise Data Warehousing team.

Under limited supervision, the IT Architect participates in all aspects of application delivery. The IT Architect will work closely with the developers and other project tea.... (This job is for - Architect Jobs in OH Columbus Architect - (in Columbus, OH))
 
 Architect job openings in other states
Jobs List

NCDHHS Salesforce Solutions Expert (768088)
Create date: 22-Jul-2025
Start date : 10/01/2025

End Date : 09/30/2026

Submission deadline : 07/28/2025

Client Info : NCDHHS-AM

Note:

* Agency Interview Type : Either Webcam Interview or In Person

* Hybrid

Description :

NCDHHS ITD is seeking an experienced Salesforce Solution Expert/Ar.... (This job is for - ArchitectMuleSoft Jobs in NC Durham Consultant - (in Durham, NC))

Programmer Analyst 6 - 142402
Create date: 05-May-2025
Start date : 06/02/2025

End Date : 1 Years from projected start date

Submission deadline : 5/12/2025 10:00:00 AM

Client Info : MiLEAP

Note:

* Interviews: MS Teams video interview with camera ON. 2nd round may be held in-person.

* Duration: 1 year with possible extension
Architect Jobs in MI Lansing Analyst - (in Lansing, MI))

Quality Assurance Analyst SME Level-140716
Create date: 06-Mar-2025
No of Submissions : 1

Start date : 4/7/2025

End Date : 2/28/2026

Submission deadline : 3/17/2025 3:00:00 PM

Client Info : MDEK12

Note:

* Remote

Description :

This position will require a qualified Quality Assurance Analyst to take the lead on the following Project Manager Architect Jobs in MS Jackson Analyst - (in Jackson, MS))

Application Architect II - 135267
Create date: 23-Sep-2024
Posting title*: Madison, WI - IT - DOC - DMS - BTM - Application Architect II - Repost*

No of Submissions : 2

Start date : 10/21/2024

End Date : 06/30/2025

Submission deadline : 9/30/2024 4:00:00 PM

Client Info : DOC.

Note :

* Interview Process: Microsoft teams. Video.... (This job is for - Architect SQL Jobs in WI Madison Architect - (in Madison, WI))

Business Intelligence Architect/Developer -63394
Create date: 18-Sep-2024
No of Submissions : 2

start date : 10/28/2024

End date : 01/31/2025

submission deadline : 09/27/2024

client info : Jefferson County

Note :

* Position Location : Hybrid

* Bill Rate : USD 80.00 Per Hour

* Max Rate : USD 110.00 Per Hour

.... (This job is for - Architect Developer Business Analyst Jobs in CO Golden Developer - (in Golden, CO))
 
 Architect job openings in OH
Jobs List

DRC-Technical Specialist 4/ TS4 (679292)
Create date: 30-Mar-2022
Start Date : 04/18/2022

End Date : 06/30/2022

Submission Deadline : 04/05/2022

Client Info: DRC

Note:

* Agency Interview Type:

Description:

Technical Specialist 4
The Ohio Department of Rehabilitation and Corrections is seeking a qualified ca.... (This job is for - DevOps Architect Jobs in OH Description Specialist - (in Description, OH))

Automation Architect - 70349
Create date: 18-Dec-2020
Note: They do a hair follicle test for the drug test. The role is 100% remote and is a 6 month contract.

Candidate must be our W2 Employee.

Job Description:

Job Title: RPA Architect

Our client is looking for exceptional Automation Architect in our AugIntel Center of Excellence (COE). In this role, you wil.... (This job is for - Architect Stakeholders Design Jobs in OH Dublin Architect - (in Dublin, OH))

SAP Security Architect - J-11-279-249
Create date: 31-Jan-2018
The candidate will CONTRACT for at least 12 MONTHS as CTC. After the 12 months our client might want to hire the consultant or keep them on contract for another year. That is why the candidates you submit must not require and sponsorship or visa transfer. That means they must be a US Cit or Green Card holder (or EAD GC but NOT OPT EAD).

.... (This job is for - ERP Architect Jobs in OH WICKLIFFE Architect - (in WICKLIFFE, OH))

OBIEE Architect - 24318
Create date: 05-Jun-2017
Start Date : 06/05/2017
End Date : 12/29/2017
Submission Dead Line : 06/09/2017
Description :


Candidate must be your W2 Employee

Role: OBIEE Architect (Location: St. Louis, some remote work possible though the role is considered on-site)

Duration: 1,160.00 hours (7.25 mo.... (This job is for - Obiee Architect RPD Jobs in OH Dayton Architect - (in Dayton, OH))

Sr. Backup Engineer - J-11-208-779
Create date: 23-Feb-2017
Start Date : 03/20/2017
End Date : 09/20/2017
Submission Dead Line : 03/01/2017
Description :

Senior Backup Engineer

Our Fortune 20 premier client in Dublin Ohio has an exciting opportunity for the right person - is it you?

Required Skills:
This is a Level 3 role, expectatio.... (This job is for - Architect Jobs in OH DUBLIN Engineer - (in Dublin, OH))
(Architect: Architect, Business Intelligence, datawarehouse, SAS 6 ETL in Columbus, OH)
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     

    About Us     Services    Privacy policy    Legal     Contact us