ETL Datastage Information System Team Environment Interpersonal Skills Verbal Commun   Requirement id 73047 Job title Developer Job location in Blacksburg, VA Skills required SQL, ETL, Data Stage, Information System Team Environment Inte Open Date 05-Sep-2018 Close Date Job type Contract to Hire Duration 7 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Developer: SQL, ETL, Data Stage, Information System Team Environment Inte Candidate must be our own W2 Employee Job Description : Position Summary The Data Engineer will be responsible for supporting and creating advanced ETL processes in an enterprise warehouse environment. These processes create data marts that are critical to the running of the universitys day-to-day operations. The ideal candidate will have strong problem solving skills that can contribute to best practices and moving the university forward with modern approaches to data delivery. This requires strong communication skills with business and technology partners where they can create win-win solutions. They will also be a part of a new initiative to create a data lake in AWS. Many of these technologies are new so the ideal candidate must be able to learn these new technologies on their own while documenting best practices and training others. Required Qualifications Bachelors degree in Business Information Technology, Computer Science, Information Systems or related field or equivalent training and/or experience. Experience in extract, transform and load (ETL) technologies such as DataStage or Talend. Good understanding of relational databases and proficient at SQL. Demonstrates skills in working effectively in a team environment. Strong verbal communication and interpersonal skills. Preferred Qualifications Ability and willingness to learn new technologies on their own. This includes technologies outside their comfort zone. A commitment to best practices and documentation, with ability to define operational processes, deployment checklists, and more. Advanced experience in ETL tools and best practices around warehouse load processes. Strong understanding of data warehouse concepts. Strong understanding in relational databases, like Oracle and Postgres. Advanced SQL writing ability. Experience in Business Intelligence tools such as Microstrategy, Tableau or SAS. Exposure to Docker, Version Control (Git) and Jenkins or any release management tool. Exposure to data lakes in a Hadoop or AWS environment. Exposure in cloud services. Ideally AWS services: VPC, IAM, EMR, RDS and Glue. Exposure with web services and APIs. Job Duties Data Warehouse Developer 50% Research and troubleshoot existing enterprise warehouse processes. This includes researching business and technical questions around data missing or data being incorrect. Support existing business critical ETL processes. Verifying nightly processes ran correctly and being a part of a 24/7 on call rotation to support critical systems. Design and develop changes to existing processes and create new data marts based on business user needs. Analyzing new and existing data for accuracy and completeness. There is not always somebody to help explain the data so the developer must be able to figure out how the data is related in order to complete their work. Supporting report developers to provide the best solution for the organization to meet their data delivery needs. This includes collaborating on the best place to apply rules and helping with advance SQL for complex reports. Working in an agile development environment where work is broken up into small pieces and distributed to multiple developers. This requires a lot of communication and meeting deadlines in order to not hold up others from doing their work. Data Lake Developer 50% Communicate with business and technology partners to gather and understand requirements and scope of their needs. Design and develop ETL processes to pull structured data from Oracle and place it in CSV, JSON or Parquet formats in AWS.   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 73047 while calling.   Other jobs in VA: Alexandria (1), Ashburn (3), Cardinal (1), Charllottesville (1), Charlottesville (6), Chesapeake (2), Chester (2), Dulles (3), Fredericksburg (1), Fremont (1), Glen Allen (2), Reston (4), Richmond (45), Roanoke (14), Virginia Beach (14), SQL job openings in Blacksburg, VA Jobs List SQL Database Administrator - 63424 Create date: 20-May-2020 Candidate must be our W2 Employee. Candidate must be local : Yes Job Description : Required Qualifications Demonstrated experience running multiple relational database systems Demonstrated SQL and data modelling skills Thorough understanding of and experience applying pri.... (This job is for - MY SQL Jobs in VA Blacksburg Administrator - (in Blacksburg, VA)) Technical Lead -45116 Create date: 25-Mar-2019 Job Description : Working Title: Lead Integration Engineer Faculty Rank: Lecturer Role Title: Professional Faculty Posting Number: AP0180367 About Virginia Tech: Virginia Tech is a public land-grant univer.... (This job is for - RestfulJava Jobs in VA Blacksburg TeamLead - (in Blacksburg, VA))    SQL job openings in other states Jobs List Data Warehouse Developer I -136603 Create date: 23-Oct-2024 No of Submissions : 1 start date : 11/18/2024 End date : 06/30/2025 submission deadline : 10/25 at 4 CST. client info : DPI Note: * Interview Process: Via Teams * Duration: Till June 30, 2025, with possibility of extension * Onsite or Remote: Candidate must.... (This job is for - Data Warehousing Jobs in WI Madison Developer - (in Madison, WI)) Programmer Analyst 6 - 135098 Create date: 17-Sep-2024 No of Submissions : 1 Start date : 10/21/2024 End Date : 1 Years from projected start date Submission deadline : 9/24 at 10AM EST. Client Info : LARA Note: * Interviews: 1st round interviews will be held via MS Teams. 2nr round interviews may be held in person, so candidates must b.... (This job is for - JavaScript Jobs in MI Lansing Analyst - (in Lansing, MI)) NCDPI - SQL/Snowflake-Tableau Analyst - Senior (746385) Create date: 09-Sep-2024 No of Submissions : 2 Start date : 09/16/2024 End Date : 09/15/2025 Submission deadline : 09/13/2024 Client Info : NCDPI Note: * Agency Interview Type : In Person Only * Onsite Description : Currently, the enterprise is a complex, multi-platform data.... (This job is for - SnowflakeDB2 Jobs in NC Raleigh Analyst - (in Raleigh, NC)) Senior Quality Assurance Specialist - 134717 Create date: 04-Sep-2024 No of Submissions : 1 Start date : 10/1/2024 End Date : 10/1/2027 Submission deadline : 9/11/2024 3:00:00 PM Client Info : MDHS Note: * No max bill rate * Onsite Required * Do not submit remote/hybrid candidates, MDHS does not make exceptions to this rule and .... (This job is for - Visio Jobs in MS Jackson Specialist - (in Jackson, MS)) Technical Specialist IV - B36991W112 Create date: 28-Aug-2024 No of Submissions : 1 Start date : 09/23/2024 End Date : 09/23/2025 Submission deadline : 09/02/2024 Client Info : Bill Rate : USD 95.00 Per Hour Max Rate : USD 103.00 Per Hour Note: * Position Location : Remote * Candidate must be local or willin.... (This job is for - job Jobs in OR Salem Specialist - (in Salem, OR))    SQL job openings in VA Jobs List Data Analyst 2 - REPLACING 742704 (744695) Create date: 13-Aug-2024 No of submissions : 2 Start date : 08/26/2024 End date : 06/30/2025 Submission Deadline : 8/16/2024 Client info : Albemarle County Note : * Agency Interview Type : Both Web Cam and In Person Interview * Hybrid Description : REPLACING REQ: 742704. Mgr unable.... (This job is for - job Jobs in VA Charlottesville Analyst - (in Charlottesville, VA)) VDH Business Analyst 3 (739888) Create date: 07-Jun-2024 * Hybrid No of submissions :2 Start date :07/01/2024 End date :06/30/2025 Submission deadline : 6/12/2024 Client info : VDH Note: *candidates should be willing to come onsite when needed *candidates will be required to interview onsite *parking not .... (This job is for - job Jobs in VA Richmond Analyst - (in Richmond, VA)) DBHDS - Data Systems Analysts - TWO ROLES (708281) Create date: 19-Apr-2023 Hybrid Start date :05/01/2023 End Date :06/30/2023 Submission deadline :4/24/2023 Client Info :DBHDS Description : Duration Expected: 3 months with possibility of extension. Local Richmond candidates preferred. ABOUT THE ROLE Agency needs a Data Systems Analyst to rev.... (This job is for - job Jobs in VA Richmond Analyst - (in Richmond, VA)) DBHDS - Data Analyst - 6166 Create date: 10-Mar-2022 Description: Day-to-Day Tasks include, but not limited to: Develop and implement databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality Filter and “clean” data by reviewing computer reports, printouts, and performance indicators to locate and correc.... (This job is for - MS Excel SharePoint Jobs in VA Richmond Analyst - (in Richmond, VA)) VITA Platform Security Architect - 73457 Create date: 30-Mar-2021 Candidate must be our W2 Employee. Candidate must be local: Yes Job Description: Platform Security Architect Chester, VA Through 4/30/2022 *local candidates strongly preferred *Candidate is required to go onsite to pick up equipment *Role is remote UNTIL restric.... (This job is for - HTTP IAM Jobs in VA Chester Architect - (in Chester, VA)) (Developer: SQL, ETL, Data Stage, Information System Team Environment Inte in Blacksburg, VA)

Featured Jobs Developer (Jobs in Atlanta, Georgia) Data Architect ETL Specialist (Jobs in Raleigh, North Carolina) SQL Architect (Jobs in Richmond, Virginia) Business Analyst Financial Analyst (Jobs in Fredericksburg, Virginia) Cyber Architect (Jobs in Columbia, South Carolina) VxRails Consultant (Jobs in Boise, Idaho) Project Manager Microsoft Manager (Jobs in Raleigh, North Carolina) Agile Jira UAT Manager (Jobs in Atlanta, Georgia) - - Analyst (Jobs in Portland, Oregon) HTMLCSSJavaScript Developer (Jobs in Lincoln, Nebraska)