What are the responsibilities and job description for the ETL Developer position at AGS LLC?
Job Overview
Reporting to the Manager of Business Intelligence, you’ll be working with the team in building and maintaining SSIS ETL for AGS Enterprise Data backend and developing solutions for AGS business objectives.
AGS currently uses numerous SSIS ETLs to import and aggregate data from various sources including SQL server into a Central repository and Data Lake built on Kubernetes cluster. This data is warehoused into various DataMarts for use.
Thorough knowledge of designing and maintaining ETL tools, C#, and expertise in SQL Server database is a must. Expertise in python and other scripting tools is a plus.
This position requires excellent rapid problem solving and analytical skills. You will be in a team using agile software development life cycle and DevOps methodology working closely with various groups specializing in R&D, Product management, Accounting, Finance and C-Suite.
Responsibilities
- Design, develop and enhance new and existing SSIS ETLs
- Design and develop SQL tables, views, and queries.
- Design and develop process to extract data using scripts and other tools from non-traditional data sources like pdf’s and images
- Implement and enhance DataMarts for growing business needs.
- Identify, recommend, and implement performance enhancements and best practices.
- Research and suggest new tools and process.
- Work with AGS R&D, Product management and marketing to deliver best possible solutions.
Skills/Requirements
- Bachelor’s degree in Computer Science, or similar
- 5 years of experience in ETL tools including SSIS and C# script is a must have.
- Multiple years of work experience and strong skills in SQL Server.
- Strong skills in C# and scripting tools like python
- Experience in MVC and web development is a plus
- Rapid development analytical skills and experience managing huge volume of data
- Gaming or any high traffic transactional industry experience preferred
- Fluency in coding and systems design and a desire to tackle the complex problems
Note: All offers are contingent upon successful completion of a background check
*Posted positions are not open to third party recruiters and unsolicited resume submissions will be considered free referrals.
AGS is an equal opportunity employer.