Home       |     Overview      |     Candidate Login      |     Post Resume       |     Contact us
 
  
     
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
SSIS ETL SSRS Logic And Analysis Tools & Methods Analyst
(Jobs in Madison, WI)
 
Requirement id 51541
Job title Analyst
Job location in Madison, WI
Skills required SQL, SSIS, ETL, SSRS Logic And Analysis Tools & Methods
Open Date 12-Feb-2016
Close Date
Job type Not specified
Duration 12 Months
Compensation DOE
Status requirement ---
Job interview type ---
   Email Recruiter: coolsoft
Job Description Analyst: SQL, SSIS, ETL, SSRS Logic And Analysis Tools & Methods

Note:
Start date : 3/7/2016
End date : 2/28/2017
Submission deadline: 2/18/2016
Description:

SQL Server Tools
Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, DTS, SSIS, SSRS, SSAS, Sharepoint.

Database
MS SQL Server 2008 R2, SQLCMD, Microsoft Office 2010/2007/2003, MS-Access.

Operating System
Windows XP/NT/2000/2003/2008, DOS

Tools
Erwin Data Modeler, MS Visio, SAS/Access, Crystal Reports 8.5,10,XI,R2, Business Objects, Microsoft office 2003/2007

Experience
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
• Experienced in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports: Drill Down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub-Reports.
• Experienced in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
• Excellence in high level design of ETL DTS packages & SSIS packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, text format data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
• Experienced in developing reports on SSRS on SQL Server (2000/2005/2008). Sound experience and understanding of SSAS, OLAP cube and architecture.




• Experienced in writing expressions in SSRS and Expert in fine tuning the reports. Experience in creating many Drill Through and Drill Down reports using SSRS.
• Excellent knowledge in creating databases, tables, stored procedures, DDL/DML triggers, views, user defined data types, functions, cursors and indexes using T-SQL.
• Significant ability to create and manage various database objects like tables and views.
• Worked extensively on ETL process using SSIS package.
• Experienced in data conversion and data migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Experienced in using T-SQL in SQL Server 2008 platforms.
• Experienced in Performance Tuning and Query Optimization.
• Designed dashboards, scorecards and reports using multiple KPIs, OLAP charts and SSRS reports with PPS.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP),Data Transformation Services (DTS) and SQL Server Integration Services (SSIS)
• Experienced in maintenance and administration of SSIS by creating jobs, alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Experienced in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment
• Experienced in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using DTS/SSIS.
• Expert in creating Parameterized Reports.
• Hands on experience in creating Star Schema and SnowFlake schemas.
• Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.
• Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.
 
Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 51541 while calling.
 
Other jobs in WI: De Pere (2), Green Bay (8), Kenosha (2), Madidson (1), Madison (36), Menomonee Falls (19), Milwaukee (59), Sun Prarie (1), Unknown (2), Waukesha (2),
SQL job openings in Madison, WI
Jobs List

Java Developer IV - 118103 - SP
Create date: 15-May-2023
Start date : 06/05/2023
End Date : 06/30/2023

Submission deadline : May 17th at 4:00PM CST.

Client Info :DOR

Note:
* nterview Process: Microsoft Teams with video

* Duration: 6/30/23 with extensions possible

* Remote or onsite? Local candidates or willing to relocate at the
c.... (This job is for - DevelopmentJavaScript Jobs in WI Madison Developer - (in Madison, WI))

Data Warehouse Developer III -116961-SP
Create date: 10-May-2023
Start date : 07/01/2023
End Date : 06/30/2024

Submission deadline : 5/12/2023 4:00:00 PM

Client Info :DCF

Note:
* INTERVIEW NOTES:
• Phone and web based interviews will be acceptable.
• However, an in--person interview may be required.
• Interviews will be set up shortly after the post.... (This job is for - job Jobs in WI Madison Developer - (in Madison, WI))

Data Engineer - 60190
Create date: 26-Feb-2020
Job Description :

It is looking for a Data Engineer for one of our clients in Madison, WI.

Job Description:
The Data Engineer is accountable for analyzing and developing complex logical database designs, logical data models and relational data definitions in support of corporate and customer information systems requiremen.... (This job is for - SAS Jobs in WI Madison Engineer - (in Madison, WI))

Data Warehouse Developer II - WISCJP00016536
Create date: 26-Feb-2020
Start Date : 04/02/2020
End Date : 06/30/2020
Submission Dead Line : 8:00 a.m. CT on Thursday, March 05th, 2020
Client Info : ETF – Employee Trust Funds

Note:

* All candidates submitted need to have a reason to be in Madison and be able to provide at least two references from curre.... (This job is for - job Jobs in WI Madison Developer - (in Madison, WI))

Software Engineer-3 - WISCJP00014418
Create date: 27-Feb-2019
Start Date :3/18/2019
End Date :to 06/30/2019
Submission Deadline :3/4/2019

Description :

The Wisconsin Court System - CCAP is seeking application developers to contribute to our highly skilled application development team. As the IT provider for the Wisconsin Court System, CCAP provides a.... (This job is for - job Jobs in WI Madison Engineer - (in Madison, WI))
 
 SQL job openings in other states
Jobs List

NC DIT-DATA-Business Analyst- Expert (721283)
Create date: 29-Sep-2023
Hybrid

start date :10/02/2023

End date :10/01/2024

submission deadline :10/02/2023

client info :NCDIT

Description :

The Department of Information Technology (DIT) serves as the Technology Center for the State of NC. Services that DIT p.... (This job is for - Analytical Skills Jobs in NC Raleigh Expert - (in Raleigh, NC))

Programmer 5 - 119294 - SP
Create date: 19-Jun-2023
Start date : 07/10/2023
End Date : 1 Years from projected start date

Submission deadline : 6/23 at 10am EST.

Client Info :

Note:
* Interviews: In-Person ONLY

* Duration:1 year to start with extension likely. Long term position.

* Position location: Lansing, MI CANDIDATES MUST BE LO.... (This job is for - job Jobs in MI Lansing Consultant - (in Lansing, MI))

Programmer/Developer - 60912
Create date: 16-Jun-2023
Start date : 06/24/2023
End Date :06/06/2024

Submission deadline :06/24/2023

Client Info : CT DCF

Note:
* Position Location Hybrid

Description :

The candidate will serve in the capacity of an application COBOL/DB2 developer. Participating in various SDLC processes including requirem.... (This job is for - Cobol Jobs in CT Hartford Developer - (in Hartford, CT))

Business Systems Consultant III - 60911
Create date: 16-Jun-2023
Start date :07/24/2023
End Date :12/31/2023

Submission deadline : 06/21/2023

Client Info :OSL

Note:
* Position Location Remote


Description :

Full-time professional Information Technology Project Development work experience and/or Function/Business Process Analysis work exper.... (This job is for - job Jobs in OR Salem Consultant - (in Salem, OR))

Application Developer IV - FR0000102301
Create date: 23-May-2023
start date :06/12/2023
End date :02/29/2024

submission deadline : 05/26/2023

client info : OIT

Note:
* Position Location Remote

Description :

This position requires an individual to go through a National background check with
finge.... (This job is for - job Jobs in CO Denver Developer - (in Denver, CO))
 
 SQL job openings in WI
Jobs List

Data Modeler - 70417
Create date: 22-Dec-2020
Job Description:

Data Modeler / “Data Wizard”. Strong SQL reporting and development, PowerBI a plus. Building complex views, “gear head.” Snowflake schemas / Strong ETL experience.

Develop database models and support documentation in order to meet business requirements for reporting and analytic databases.

Analy.... (This job is for - Development Jobs in WI Milwaukee Modeler - (in Milwaukee, WI))

Data Engineer - 69497
Create date: 19-Nov-2020
Candidate must be our W2 Employee.

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

Job Description :

CONTRACT - TO - HIRE BIG QUERY Data Engineer

Project: Working with their IT Supply Chain team to create reporting across all their channels for the business.

Day to Day: Working w.... (This job is for - job Jobs in WI MenomoneeFalls Engineer - (in Menomonee Falls, WI))

Machine Learning Engineer - 64593
Create date: 01-Jul-2020
Candidate must be our W2 Employee.

Job Description :

Our GREAT Client in the Greater Milwaukee Area is looking for a talented Machine Learning Engineer to join their team.

Project: Demand Forecasting- The objective is to be able to better forecast inventory needs across channels and locations using well-established .... (This job is for - PythonJupyter Jobs in WI MenomoneeFalls Engineer - (in Menomonee Falls, WI))

Programmer-Analyst - 3 - 63520
Create date: 22-May-2020
Candidate must be our W2 Employee.

Candidate must be local : Yes

Job Description :

This client is working toward modernizing legacy COBOL applications to a current web framework.

This candidate will work closely with our COBOL application developer to ensure business requirements and functionality are ma.... (This job is for - MVCCoding Jobs in WI Milwaukee Analyst - (in Milwaukee, WI))

Data Engineer - 62711
Create date: 28-Apr-2020
Note: 1 interview to hire.
Candidate must be our W2 Employee.

Job Description :

3 years of data warehousing
3 years of SQL, potential for some tuning but mainly knows the knowledge for SQL
Migrated over from Erwin to Power Designer
He has a full time data modeler on his team who does this PowerDesigner Jobs in WI MenomoneeFalls Engineer - (in Menomonee Falls, WI))
(Analyst: SQL, SSIS, ETL, SSRS Logic And Analysis Tools & Methods in Madison, WI)
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     

    About Us     Services    Privacy policy    Legal     Contact us