Sorry, this job is no longer accepting applications. See below for more jobs that match what you’re looking for!

Sr. ETL Developer

Expired Job

I5tech Inc Blacksburg , VA 24060

Posted 3 months ago

Sr. ETL Developer (Sr.Informatica Developer)
City :Blacksburg, State :VA
Required Skills :

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.
Design and develop processes to consume unstructured and semi-structured streaming event data in AWS.
Apply rules to data, restructure data and expose it to different technology and business partners in a format that best meets their needs.
Manage metadata and data governance processes in order to help end users research data needs.
Dominic Savio
Business Development Lead
Waynsys Inc (MWBE Certified)

Required Skills : 1.Talend 2.
Python 3. AWS

See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Sr Systems Engineer (Remote) Government Services


Posted Yesterday

VIEW JOBS 12/13/2018 12:00:00 AM 2019-03-13T00:00 Rackspace is seeking a Sr. Systems Engineer to join our team full time in our Government Services department in one of our office locations (Texas, Virginia, or New Jersey) or Remote Work From Home with travel for exceptional candidates. PRIMARY RESPONSIBILITY: * Responsible for making architectural design decisions in our environment, solving technical problems and making educated improvements to the system, and is expected to identify and advise on potential pitfalls that we may experience and suggest alternatives that may better serve the stability and security of our hosted platform. * Supports and maintains network communication and solutions using the Linux Platform. * Responsible for solving complex technical issues which can include OS level, web server, database server, applications server, DNS, SMTP, or other software issues. * Technical responsibilities include problem identification, systems architecture design, hardware/software specification and/or design, and implementation. SCOPE: * Applicants filling this position would be expected to keep abreast of current technologies and new versions of existing software solutions, be mindful of security implications at both an application and network level, understand how to manage disk I/O and memory usage, and how to evaluate and implement hot fixes or patches. KNOWLEDGE / SKILLS / ABILITY: * Excellent knowledge of MIS objectives and strategies. * Excellent technical knowledge in technology methodologies, design, and implementation. * Excellent analytical and design skills at multi-product/multi-environment level. * Aware of business issues as they impact overall project plans. * Strong communication and interpersonal skills. * Able to resolve problems in a timely manner. * Basic Knowledge of HTTP required. * General Knowledge of Puppet, Back-ups, Caching, CDN, Cluster management, Firmware, HTML, Linux Shell Scripting, OS/DISTR, OSPF/IOS, Role Servers, SMTP/Mail Relays, SQL query writing/troubleshooting, SSL Certificates, Sys Design, and Web servers. * Advanced knowledge of Kernel, Packet Management, Advanced scripting language, Auth/ Directory services, DBA, HA, Kernel, Networking, Packet analysis, Security, Storage, System Optimization, Leadership, and Patching required. * Advanced knowledge of FTP and Web Scripting required. * Expert knowledge of Hardware, Load balancing, Performance Monitoring, and DNS required. JOB COMPLEXITY: * Responsible for complex architectural design and development of hardware, software, and networking systems. * Analyzes systems and determines business requirements. * Ensures completeness and compatibility of the technical infrastructure to support system performance. * Requires leading-edge skills in the latest areas of new technology. * Mentors lower level engineers or administrators, and demonstrates the ability to own large subsystems with a high degree of accountability. * Assists Manager to identify gaps in training and process. * Reviews and approves technical documentation. * Ability to diagnose and fix the most complex server and system-wide issues. EXPERIENCE / EDUCATION: * High school diploma or equivalent required. * Bachelor's degree in Computer Science or equivalent experience. * Usually requires 6+ years of information systems design/architecture experience with a minimum of 3-4 years working in the Rackspace environment or equivalent FANATICAL customer support work place. * RHCE certification or equivalent is required. * At the manager's discretion equivalent experience may substitute for the degree requirement. * Some lifting up to 20 pounds required. PERSON SPECIFICATION: * Must be able to pass a Public Trust background check at hire. * Must be a U.S. Citizen. * May require further DOD security clearance. #LI-SR1 Rackspace Blacksburg VA

Sr. ETL Developer

Expired Job

I5tech Inc