Oracle SQL Server Analyst (Jobs in Wallingford, CT)   Requirement id 11169 Job title Analyst Job location in Wallingford, CT Skills required SQL Database, ETL Tools, Data Analysis, Oracle SQL Server Open Date 04-Oct-2012 Close Date Job type Contract to Hire Duration 3 Months Compensation DOE Status requirement --- Job interview type Phone Screening Apply    Email Recruiter: coolsoft Job Description Analyst: SQL Database, ETL Tools, Data Analysis, Oracle SQL Server ** Only W2 Employee - No Subcontracting ** Can submit at higher rate *** Over Time is paid at 1.420 times OT - Extra Hours on Weekdays and Saturdays *** Double Time is paid at 2.0 times DT - Hours worked on Sundays Ideal candidates will fill the niche between business and technical expertise ? almost as liaisons between IS/IT staff and business data users. The will have strong experience analyzing, joining, relating and integrating relational data from multiple sources into a consolidated repository or data warehouse. Data modeling, data warehousing and multi-dimensional skills are preferred. Not looking for Database Administrators or PL-SQL programmers, however, are looking for the relational database and SQL querying skills associated with those roles. RESPONSIBILITIES: Analyze, architect, design, develop, support, and test data integration logic and ETL processes within an Oracle data warehouse. Analyze source data and identify relationships (ASCII and EBCDIC/COBOL source files) Import / Define source file layouts and fields within an ETL tool Define and build integration and transformation logic from sources to data warehouse tables Recommend data warehouse enhancements as required to support integrations Validate and test data integration logic Complete other duties as assigned POSITION QUALIFICATIONS: Education: A Bachelor?s Degree in Information Systems or equivalent education in a related discipline is required. Related work can be substituted for educational requirements. Job Related Experience: A Minimum of three to five years in data warehousing, data analysis, database or related experience. Functional Area Skills/Knowledge: A strong knowledge of SQL and relational databases Proficient in the use of both SQL databases and the deployment of ETL tools Two years of experience defining integration logic and data transformation using ETL tools Experience in Quality Assurance and testing of integration and ETL logic Experience designing and deploying enterprise wide Business Intelligence Solutions Experience with ETL tools such as Informatica, Data Junction, Data Stage is desired The ability to interact with external and internal clients for the purpose of data gathering and discovery Experience using at least one of the major reporting or relational OLAP tools Experience with MS Access, Oracle, SQL Server and other RDBMS is desired Experience with COBOL copybooks and EBCDIC data is desired Financial Services Industry experience is desired with specific interest in Commercial or Mortgage Lending Strong organizational skills Strong written, verbal and non-verbal skills   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 11169 while calling.   Other jobs in CT: Bristol (4), Hartford (1), Shelton (6), Westport (1), Windsor (4), Windsor Locks (1),    SQL Database job openings in other states Jobs List NCDOT - AASHTOWare Project Technical Specialist (751135) Create date: 20-Nov-2024 No of Submissions: 2 Start Date: 12/2/2024 End Date: 12/17/2025 Submission deadline: 11/26/2024 Client info: NCDOT Note: * Remote work from home * Either Webcam Interview or In Person * The candidate will need to use their own equipment from home to remote into.... (This job is for - job Jobs in NC Raleigh Specialist - (in Raleigh, NC)) GA DOR - Applications Developer 1 (751588) Create date: 20-Nov-2024 Onsite No of Submissions : 2 Start date : 12/16/2024 End Date : 06/30/2025 Submission deadline : 12/02/2024 Client Info : DOR - IT Note: * Agency Interview Type: In Person Only Description : *THE TAX CLEARANCE LETTER COMPLIANCE ITEM, IS DUE AT THE TIM.... (This job is for - Analytical Skills Jobs in GA Atlanta Developer - (in Atlanta, GA)) Programmer 6 - 136923 Create date: 04-Nov-2024 No of Submissions : 1 Start date : 12/02/2024 End Date : 12/01/2025 Submission deadline : 11/14/2024 10:00:00 AM Client Info : MDOT Note: * Interviews: MS Teams video interview with camera ON. * Duration: 1 year with possible extension * Position locatio.... (This job is for - GitHub Jobs in MI Lansing Consultant - (in Lansing, MI)) DHHS- SQL Server Administrator (748082) Create date: 30-Sep-2024 Hybrid No of Submissions : 1 start date :09/30/2024 End date :03/26/2025 submission deadline : 10/04/2024 client info : NCDHHS-AM Note: * Agency Interview Type: Webcam Interview Only Description : Due to.... (This job is for - Troubleshooting Jobs in NC Raleigh Administrator - (in Raleigh, NC)) GA DOR - Applications Developer 1 (740631) Create date: 02-Jul-2024 No of Submissions :2 Start date :7/22/2024 End Date :06/30/2025 Submission deadline :07/15/2024 Client Info :DOR - IT Description : *THE TAX CLEARANCE LETTER COMPLIANCE ITEM, IS DUE AT THE TIME OF CANDIDATE SUBMISSION* (pls review the compliance tab on how the candidate can obtain th.... (This job is for - Java Jobs in GA Atlanta Developer - (in Atlanta, GA))    SQL Database job openings in CT Jobs List Systems Administrator - Level 4 - 56587 Create date: 05-Oct-2021 start date:10/30/2021 End date:10/29/2022 submission deadline:10/15/2021 client info : CT DCF Note: * Candidate must be local or willing to commute or relocate Description: The agency needs the service of a mid-career level Microsof.... (This job is for - job Jobs in CT Hartford Administrator - (in Hartford, CT)) System Specialist - Level 3 - 56313 Create date: 11-May-2021 start date:6/7/2021 End date:06/06/2022 submission deadline:05/31/2021 client info : CT DCF Note: * Candidate must be local or willing to commute or relocate. Description: The application is used by a large m.... (This job is for - job Jobs in CT Hartford Specialist - (in Hartford, CT)) Quality Assurance Analyst - Level 2 - 82000 Create date: 30-Apr-2020 start date: 5/20/2020 End date: 05/21/2021 submission deadline: 5/6/2020 client info : CT CJIS Description: PROJECT/SYSTEM OVERVIEW The Connecticut Information Sharing System (CISS) provides an integrated solution for the sharing of criminal justic.... (This job is for - MS Excel Jobs in CT Hartford Analyst - (in Hartford, CT)) (Analyst: SQL Database, ETL Tools, Data Analysis, Oracle SQL Server in Wallingford, CT)

Featured Jobs VITA Manager (Jobs in Richmond, Virginia) AutoCad - Consultant (Jobs in Chicago, Illinois) outlook SharePoint MS Office Troubleshoot Analyst (Jobs in Colonial Heights NIST Cyber Architect (Jobs in Lansing, Michigan) Jira Analyst (Jobs in Richmond, Virginia) Analyst (Jobs in Columbia, South Carolina) - Consultant (Jobs in Columbia, South Carolina) Advanced Analyst (Jobs in Richmond, Virginia) JavaScript C# Developer (Jobs in Madison, Wisconsin) SAML Specialist (Jobs in Raleigh, North Carolina)