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

Data Warehouse Developer III -129720
Create date: 24-Apr-2024
No of Submissions : 2

Start date : 06/03/2024

End Date : 06/30/2024

Submission deadline : 5/1/2024 at 4:00PM CST.

Client Info : ETF

Note :

* Interview Process: 1-2 rounds via Microsoft Teams.

* Duration: 6/30/2024, likely to extend.

* Onsite or Remote? No.... (This job is for - ETL Jobs in WI Madison Developer - (in Madison, WI))

Data Warehouse Developer III - 128748
Create date: 28-Mar-2024
Start date : 05/20/2024

End date : 06/30/2024

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

Client info : ETF

Note :

* Interview Process: 1-2 rounds via Microsoft Teams.

* Duration: 6/30/2024, likely to extend.

* Onsite or Remote? No WI residency required. Open to n.... (This job is for - ETL CDC Jobs in WI Madison Developer - (in Madison, WI))

Data Warehouse Architect 3 - 128536
Create date: 27-Mar-2024
Start date : 04/22/2024

End Date : 09/30/2024

Submission deadline : 4/1/2024 at 10am EST.

Client Info : DHHS

Note :

* Interview Process: Virtual Interview via MS Teams video. Please use laptop and be prepared so share screen if asked. Use of headphones is strongly discouraged. A screensho.... (This job is for - ETL Jobs in MI Lansing Architect - (in Lansing, MI))

Data Warehouse Developer III -128359
Create date: 18-Mar-2024
Start date : 04/08/2024

End Date : 06/30/2024

Submission deadline : 3/20/2024 at 4:00PM CST.

Client Info : ETF

Note :

* Interview Process: 1-2 rounds via Microsoft Teams.
* Duration: 6/30/2024, likely to extend.
* Onsite or Remote? Candidates MUST be WI residents or willing to r.... (This job is for - ETL Alteryx Jobs in WI Madison Developer - (in Madison, WI))

Data Warehouse Developer III - 128031
Create date: 07-Mar-2024
Start date : 04/22/2024

End date : 06/30/2024

Submission deadline : 3/14/2024 at 4:00PM CST.

Client info : ETF

Note :

* Interview Process: 1-2 rounds via Microsoft Teams.

* Duration: 6/30/2024, likely to extend.

* Onsite or Remote? Candidates MUST be WI residents or .... (This job is for - ETL CDC Jobs in WI Madison Developer - (in Madison, WI))
 
 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