Home       |     Overview      |     Candidate Login      |     Post Resume       |     Contact us
 
  
     
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
ETL Data Modeler SQL Server 2008 R2 Oracle datawarehouse MOLAP Cube Modeling & Desig
 
Requirement id 3124
Job title Architect
Job location in Philadelphia, PA
Skills required ETL, SQL, Data Modeler, SQL Server 2008 R2 Oracle datawarehouse
Open Date 09-Mar-2011
Close Date
Job type Contract
Duration 6 Months
Compensation DOE
Status requirement ---
Job interview type Phone Screen and Face to Face interview
   Email Recruiter: coolsoft
Job Description Architect: ETL, SQL, Data Modeler, SQL Server 2008 R2 Oracle datawarehouse

[Note:3 MANAGERIAL references will be required for this position
[PERSONAL INTERVIEW will be REQUIRED at the expense of your company or the candidate]

The Application Engineer:

Is responsible for the development & coding complete hands-on, with BI development using SSAS, backend database Sql server 2008 R2 & Oracle big plus. Candidate should have clear understanding dimensional modeling and ETLs for Dimensions and Facts, worked with DSVs and creating custom dimensions. Experience with ETLs for Cube and dimension. This position will also review existing Reports and modify them as per business requirement, Work experience with KPIs and Dashboard reporting is a must. Good Understanding of DataMarts/ Data warehouse Concepts and Good understanding of MOLAP/ROLAP Cubes structure. This position can create first level program and systems designs and will develop highly maintainable software by anticipating future changes and providing code flexibility. This position will also comprehend all detailed requirements before starting to design or code the solution.



Primary Duties and Responsibilities:

* Design and Develop MOLAP/ROLAP/HOLAP Cubes using SSAS/SSIS/SSRS
* Create SQL/MDx, DMx and XMLA queries and should built custom functions SSAS.
* Create KPIs and Dashboard reporting using SSAS and Performance Point as per Business unit requirement.
* Create and schedule cube with data updates
* Create, document, and implement unit test plans, scripts, and test cases.
* Create and maintain technical documentation using defined technical documentation templates.

Job Specifications:

* Design, prototype build, code, document and unit test solutions for projects.
* Determine level of effort to design, build, and code, document and unit test so that estimates can be provided to the Technical Supervisor.
* Contributes to the creation of solid coding techniques and recommends and reviews coding standards.
* Analyze application requests and business requirements for completeness and understanding.
* Keeps abreast of trends and developments in IT and mortgage insurance.

Technical Experience:

· 10-15 years of experience

· ETL Design Experience

· Data Modeling – Star Schema Design

· Minimum of 3-6 years programming experience

· Demonstrable Software Development experience

· Knowledge of database architecture and design

· Ability to interpret written requirements and technical specification documents.

· Ability to code software according to published standards and design guidelines.
 
Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 3124 while calling.
 
Other jobs in PA: Dauphin (1), Dauphin County (3), Downingtown (2), Glen Milla (1), Harribsurg (1), Harrisburg (47), Horsham (6), Malvern (2), Pennsylvania (13), Phila (2), Philadelphia (16), Pittsburgh (1), Radnor (2), Reading (1), Sharon (3), WAYNE (1), West Cheste (1), West Chester (33),
ETL job openings in Philadelphia, PA
Jobs List

PCI Software Developer - 65138
Create date: 20-Jul-2020
Note :Looking for someone with Data Engineering/Programming background.

Candidate must be our W2 Employee.

Candidate must be local : Yes

Job Description :

It is looking for a Data Engineer for one of our largest technology clients in Philadelphia OR Denver. This candidate must have strong scripting skills.... (This job is for - ETL MY SQL Jobs in PA Philadelphia Developer - (in Philadelphia, PA))

Informatica/ETL Lead Developer - NTTJP00017018
Create date: 27-Feb-2019
Start Date:3/18/2019
End Date:12/31/2019
Submission Deadline :3/12/2019

Description :
we know that with the right people on board, anything is possible. The quality, integrity, and commitment of our employees are key factors in our companys growth, market presence and our ability to help our clients stay a step ahead of th.... (This job is for - ETL Jobs in PA Philadelphia Developer - (in Philadelphia, PA))

ETL Developer - 35634
Create date: 13-Jun-2018
Required Skills :
Must Have: PL/SQL, ETL, Informatica experience
Must be available for on-site interview - NO OPT-STEM Candidates
Basic Qualifications :
Additional Skills :
Job Description :

Responsibility:
-Develop and test ETL components to high standards of quality and performance.
- Perform design/.... (This job is for - ETL Pentaho Jobs in PA Philadelphia Developer - (in Philadelphia, PA))

Data Analyst - 30367
Create date: 14-Dec-2017
Candidate must be our W2 Employee



Group/Team Details: fast-paced, innovative team that works heavily with customer data, call volume data, customer experience satisfaction data
Length: 12 month contract (possibility to be extended)
Tech Landscape: SQL, Tableau, Excel

Responsibilities of the Da.... (This job is for - ETL Jobs in PA Philadelphia Analyst - (in Philadelphia, PA))

Lavastorm Application Lead - J-11-080-875
Create date: 18-Jan-2016
Note:
Start date : 2/1/2016
End date : 1/31/2017
Submission deadline: 1/22/2016
Description:

Role: Lavastorm Application Lead
Location: Philadelphia, PA (19103)
Type: Contract
Duration: 12 months

Qualifications:
Total 8+ years of experience
Good knowledge of EAI La.... (This job is for - ETL EAI Tuning Jobs in PA PHILADELPHIA Developer - (in Philadelphia, PA))
 
 ETL job openings in other states
Jobs List

Business Intel Technical Lead II -134854
Create date: 17-Sep-2024
Bid Limit Per Vendor : 2

Start date : 10/14/2024

End Date : 06/30/2025

Submission deadline : 9/23/2024 at 4:00PM CST.

Client Info : DOT

Note :

* Interview Process: Teams interview with Camera On
* Duration: 6/30/25 with possible extensions
* Remote or On-site? Candida.... (This job is for - ETL Jobs in WI Madison TechLead - (in Madison, WI))

NCDPI - SQL/Snowflake - Tableau Developer - Expert (746387)
Create date: 09-Sep-2024
No of Submissions : 1

Start date : 09/23/2024

End Date : 03/21/2025

Submission deadline : 09/13/2024

Client Info :

Note:

* Agency Interview Type : In Person Only

* Onsite

Description :

***This is an onsite position in Raleigh, NC.

Current.... (This job is for - ETL Jobs in NC Raleigh Developer - (in Raleigh, NC))

Data Warehouse Developer III -134848
Create date: 09-Sep-2024
Bid Limit Per Vendor : 1

Start date : 09/23/2024

End Date : 06/30/2025

Submission deadline : 9/11/2024 at 4:00PM CST.

Client Info : ETF

Note :

* Interview Process: 1 round via Microsoft Teams.
* Duration: 6/30/2025, likely to extend.
* Onsite or Remote? No WI reside.... (This job is for - ETL Implementation Testing Jobs in WI Madison Developer - (in Madison, WI))

Data Warehouse Developer III -134705
Create date: 04-Sep-2024
Bid Limit Per Vendor : 1

Start date : 09/23/2024

End Date : 06/30/2025

Submission deadline : 9/6/2024 at 4:00PM CST.

Client Info : ETF

Note :

* Interview Process: 1 round via Microsoft Teams.
* Duration: 6/30/2025, likely to extend.
* Onsite or Remote? Candidate MU.... (This job is for - ETLDataloader Jobs in WI Madison Developer - (in Madison, WI))

RHAPSODY DEVELOPER-Consultant - 11216-1
Create date: 28-May-2024
No of submissions : 2

Start date : 6/17/2024

Submission deadline : 6/4/2024

Client info : Health & Environmental Control Department (DHEC)

Note :

* INTERVIEW PROCESS (who will conduct i/v, phone or in-person, how many rounds of i/vs)?

- An interview panel will conduct one initial.... (This job is for - T SQL ETL Sql Server 2000 Jobs in SC COLUMBIA Developer - (in Columbia, SC))
 
 ETL job openings in PA
Jobs List

Data Engineer (PySpark - Data Bricks) - 73189
Create date: 22-Mar-2021
Candidate must be our W2 Employee.

We should submit only GC,GC - EAD, L2-EAD,H4-EAD and Citizens.

Job Description:


Please send candidates for this role and we can accept pass through candidates.

Delhaize

Data Systems Analyst -- Arch-Bus Intel & Analytics

6 month contract to hi.... (This job is for - ETLSME Jobs in PA Carlisle Engineer - (in Carlisle, PA))

Data Operations Developer - 64243
Create date: 18-Jun-2020
Candidate must be local : Yes

We should submit only GC,GC - EAD, L2-EAD,H4-EAD and Citizens.

Candidate must be our W2 Employee.

Job Description :

It is recruiting a Data and Data Operations Developer for one of our clients here in the Pittsburgh area. The qualified candidate will work within an agile tea.... (This job is for - ETL SSAS Jobs in PA Pittsburgh Developer - (in Pittsburgh, PA))

ETL / Data Warehouse Tester - 64185
Create date: 16-Jun-2020
Note:(Must be able to convert with no current or future sponsorship issues)

We should submit only GC,GC - EAD, L2-EAD,H4-EAD and Citizens.

Job Description :

Title: ETL / Data Warehouse Tester

Location: Ft. Washington, PA (initially remote due to COVID-19)

Duration: 6 Months w/ Right to Hire (ca.... (This job is for - ETL Oracle Jobs in PA FortWashington Tester - (in Fort Washington, PA))

IT - Data Analytics Consultant - Senior - 58701
Create date: 30-Jan-2020
Candidate must be our W2 Employee.



Job Description :

Data Engineer / Data Warehouse Developer

20 week project

680 BLAIR MILL RD Horsham Pennsylvania USA 19044
************Must be within 2 hour drive and available for on-site interview! NO VIDEO INTERVIEWS - DO NOT ASK ME ABOUT VIDEO INTE.... (This job is for - Oracle ETL T SQL Jobs in PA Horsham Consultant - (in Horsham, PA))

ETL Developer - 49748
Create date: 15-Jul-2019
Description:
The BFF/Data Services team is seeking a Senior Informatica ETL Developer to do design, development for OPERATIONAL REPORTING project within Insurance Solutions . Work with initiative leads, business areas, technical leads, architects, subject matter experts, developers, technical support groups and test teams to integrate data and.... (This job is for - ETL Teradata Jobs in PA Horsham Developer - (in Horsham, PA))
(Architect: ETL, SQL, Data Modeler, SQL Server 2008 R2 Oracle datawarehouse in Philadelphia, PA)
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     

    About Us     Services    Privacy policy    Legal     Contact us