ETL Process SSIS Architect (Jobs in Albany, NY)   Requirement id 131064 Job title Architect Job location in Albany, NY Skills required SQL Queries, Stored Procedures, Database Architecture, ETL Process SSIS Open Date 28-Dec-2021 Close Date Job type Contract Duration 1 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Architect: SQL Queries, Stored Procedures, Database Architecture, ETL Process SSIS Description: Day-to-Day Tasks include, but not limited to: Build complex SQL queries, stored procedures, functions, views, and reports. Understand the business needs and work with developers to design modern and effective database architectures. Analyze functional requirements to perform ad-hoc Extract, Transform and Load (ETL) processes involving data analysis, data manipulation and setting up SSIS packages. Review performance logs to track and analyze production issues, identify and eliminate obsolete DB objects, and optimize stored procedures and jobs to improve database responsiveness. Participate in unit and regression testing by assisting business analysis team to mine and translate complex dataset. Work with data modelling team to draft/maintain system data model and data dictionary. Establish standards for system documentation and advise other team members. Participate in data integration activities for PBS E-Registration and for mobile field inspection project. Mandatory Qualifications: Determines database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities, responding to user questions, and resolving problems. 84+ Months-Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field. Preferred Qualifications: 84 months experience in designing advanced SQL queries, stored procedures, triggers, scripts, cursors, and views 84 months experience in MS SQL Server Management Studio (MS SQL Server version 2012+, and upgrade to MS SQL 2019) 84 months of experience in designing data architecture and data modelling (data dictionary and system documentation) 84 months of experience in SQL code tuning, consolidating views and tracking and improving database performance metrics 60 months of experience in designing reports using either Crystal Reports (version 2016+) or Business Objects XI or SSRS   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 131064 while calling.   Other jobs in NY: Albany (4), Bethpage (6), BUFALLO (1), Buffalo (6), Commack (4), Commack Long (1), Jericho (5), Long Island (4), Long Island City (2), Manhattan (5), Midtown NYC (1), New York (41), New York City (8), NYC (2), SQL Queries job openings in Albany, NY Jobs List Expert Software Analyst - 7311 Create date: 14-Oct-2022 start date: 12/07/2022 End date: 12/07/2024 submission deadline: 10/21/2022 Note: * On-site/Remote : On-site * Interview : Phone or video call; then in-person Description: Qualifications: Software Analyst - Studies.... (This job is for - job Jobs in NY Albany Analyst - (in Albany, NY)) Senior IT Specialist - 6334 Create date: 08-Apr-2022 Description: Day-to-Day Tasks include, but not limited to: Providing Application backend system support and being on call as required. Support application backend in Windows Server 2016-2019 environments, production on-call / off-hours support, troubleshooting, system issue analysis & resolution, and developing te.... (This job is for - job Jobs in NY Albany Specialist - (in Albany, NY)) Expert Software Developer - 5800 Create date: 07-Dec-2021 Description: Day-to-Day Tasks include, but not limited to: Create/Modify Oracle stored procedures, packages, and triggers as necessary to eliminate redundancy and facilitate information sharing between systems. Modify ASP.Net application to provide better integration and implement a common look-and-feel to the var.... (This job is for - SDLC Jobs in NY Albany Developer - (in Albany, NY)) QA Analyst/Test Lead - 5032 Create date: 27-May-2021 Description: Day-to-Day Tasks include, but not limited to: Test Strategy document detailing how quality will be infused throughout the Software Development Life Cycle (SDLC) process Test Scenarios (business entities/objects and their relationships) Traceability matrix outlining the correlation between bus.... (This job is for - SDLC Jobs in NY Albany Analyst - (in Albany, NY)) Senior QA/Test Lead - 5028 Create date: 26-May-2021 Description: Day-to-Day Tasks include, but not limited to: Test Strategy document detailing how quality will be infused throughout the Software Development Life Cycle (SDLC) process Test Scenarios (business entities/objects and their relationships) Traceability matrix outlining the correlation between bus.... (This job is for - SDLC Jobs in NY Albany TechLead - (in Albany, NY))    SQL Queries job openings in other states Jobs List NCDIT - Applications System Analyst (751874) Create date: 25-Nov-2024 No of Submissions : 2 Start date : 12/02/2024 End Date : 06/30/2025 Submission deadline : 12/03/2024 Client Info : NCDIT Note: * Agency Interview Type : Webcam Interview Only * Remote Description : · The primary purpose of this position is to.... (This job is for - Jira Jobs in NC Raleigh Analyst - (in Raleigh, NC)) Programmer Analyst 6 -134720 Create date: 06-Sep-2024 Bid Limit Per Vendor : 1 Start date : 10/07/2024 End Date : 09/30/2025 Submission deadline : 9/12/2024 at 10am EST. Client Info : DIFS Note : * Interview Process: Virtual Interview via MS Teams video. Please use laptop and be prepared so share screen if asked. Use of headphone.... (This job is for - Powerbuilder Jobs in MI Lansing Analyst - (in Lansing, MI)) NCDIT - Applications System Analyst (735593) Create date: 18-Jun-2024 * Remote No of Submissions : 2 Start date :06/01/2024 End Date :10/29/2024 Submission deadline :06/20/2024 Client Info :NCDIT Note: * Webcam Interview Only Description : · The primary purpose of this position is to work in partnership with exte.... (This job is for - Jira Jobs in NC Raleigh Analyst - (in Raleigh, NC)) Programmer/Developer -62703 Create date: 08-May-2024 No of Submissions : Start date : 06/01/2024 End Date : 06/01/2025 Submission deadline : 05/20/2024 Client Info : CT DCF Position Location : Hybrid Description : ------------------------------------------------------ The Department of Children and Families depends on th.... (This job is for - job Jobs in CT Hartford Developer - (in Hartford, CT)) NCDA CS - Technical Architect- Expert (728547) Create date: 03-Apr-2024 Remote start date :04/29/2024 End date :04/27/2025 submission deadline :04/08/2024 client info :NCDA&CS Description : ***This is a remote position, but the candidate has to be located in either the Eastern or Central time zones. .... (This job is for - SSRS Jobs in NC Raleigh Architect - (in Raleigh, NC))    SQL Queries job openings in NY Jobs List Splunk Analyst - 84558 Create date: 05-May-2022 Description: Requirements Minimum education: Bachelor Years of work experience: 3 year(s) Remote conditions Candidates must be located in Oklahoma, Texas, Kansas, Missouri or New Mexico IT skills Must have SPLUNK 3 year(s) of experience SQL Query Vi.... (This job is for - SplunkVirtualization Jobs in NY NewYork Analyst - (in Newyork, NY)) Senior Software Architect - 5644 Create date: 27-Oct-2021 Description: Day-to-Day Tasks include, but not limited to: Review existing data model and recommend changes to support new and existing data requirements. Analyze source system data to uncover data redundancy and duplication. Maintain conceptual, logical and physical data models along with corresponding m.... (This job is for - Metadata Jobs in NY Menands Architect - (in Menands, NY)) Senior Data Warehouse/ODI/BI Developer - 5393 Create date: 25-Aug-2021 Description: Day-to-Day Tasks include, but not limited to: Review existing data model and recommend changes to support new and existing data requirements. Analyze source system data to uncover data redundancy and duplication. Maintain conceptual, logical, and physical data models along with corresponding .... (This job is for - DDL Jobs in NY Menands Developer - (in Menands, NY)) Software Analyst - 4892 Create date: 22-Apr-2021 Description: Day-to-Day Tasks include, but not limited to: Analysis, design, and development of enhanced features for the application. Work with business users for developing business analysis, documentation, and validation. Develop and execute SQL queries to extract data providing reports to business use.... (This job is for - Documentation Jobs in NY Rensselaer Analyst - (in RENSSELAER, NY)) ETL Lead Developer Create date: 08-Apr-2021 Description: We are looking for an Extract, Transform, and Load (ETL) Developer with extensive experience in Snaplogic/Informatica to support the Enterprise Data Warehouse (EDW) program. This individual will serve as the Snaplogic/Informatica ETL Senior Developer to lead. In this role you will participate in project teams to design, deve.... (This job is for - ETLCI CD Jobs in NY NewYork Developer - (in New York, NY)) (Architect: SQL Queries, Stored Procedures, Database Architecture, ETL Process SSIS in Albany, NY)

Featured Jobs Budgeting Office Consultant (Jobs in Harrisburg, Pennsylvania) PMP Manager (Jobs in Atlanta, Georgia) Javascript Developer (Jobs in Tucker, Georgia) Architecture - - Specialist (Jobs in Raleigh, North Carolina) Typography Power Consultant (Jobs in Nashville, Tennessee) - Consultant (Jobs in Bismarck, North Dakota) SSIS JAVA Analyst (Jobs in Richmond, Virginia) TSOISPF Specialist (Jobs in Columbus, Ohio) Integration IT Specialist (Jobs in Columbus, Ohio) API CI Developer (Jobs in Richmond, Virginia)