Sr. ETL Developer - Ageatia Global Solutions
chicago, IL
About the Job
Senior ETL Developer
The Senior ETL Developer will be held accountable for the following responsibilities:
Type of Education Required:
Type of Experience and Number of Years:
Knowledge, Skills, and Abilities:
The Senior ETL Developer will be held accountable for the following responsibilities:
- Maintain and Manage the existing Client Enterprise Data Warehouse and ODS builds.
- Model extensions to the existing Data Warehouse
- Builds ETL components according to ETL specifications. Code must address performance,dependency, auditing, error handling and data quality issues.
- Support post deployment by debugging, fixing, and participating in maintenance.
- Create reports to meet business requirements and address data needs.
- Create Dashboard pages and metrics within Client custom dashboard solution.
- Responsible for data integrity as well as the quality of data within Dashboard presentation layer.
- Participate in code reviews and ensure that all solutions are aligned to pre-defined architectural specifications; identify/troubleshoot code-related issues; and review and provide feedback to the final user documentation.
- Read and understand business requirements, write functional requirements, develop detailed technical designs, and build / unit / system test ETL code.
- In order to be successful and achieve the above responsibilities, the Senior Business Intelligence
Type of Education Required:
- Bachelor's Degree in Computer Science or related field
Type of Experience and Number of Years:
- 10+ years of Enterprise Data Warehouse experience
- 5+ years of experience with an ETL product (SSIS, Ab Initio, etc) in a development role
- Good knowledge of data modeling/Star Schema
- Strong ANSI SQL expertise
- REST APIs development experience
- Experience with C#, Python, Java
- 3+ years of experience with Unix and Shell Scripting
- Experience with latest releases of SQL Server
- Experience with Azure DevOps
- Ability to develop and organize high-quality documentation
- Experience with at least one job scheduler
- Experience with Client or a large school district
Knowledge, Skills, and Abilities:
- Strong written and oral communications skills.
- Proven ability and initiative to learn and research new concepts, ideas, and technologies quickly.
- Strong systems/process orientation with demonstrated analytical thinking, organizational skills and problem solving skills.
- Ability to work in a team-oriented, collaborative environment.
- Ability to quickly pick up new tools and technologies.
- Willingness and ability to train and teach others.
- Ability to facilitate meetings and follow up with resulting action items.
- Ability to prioritize and execute tasks in a high-pressure environment.
- Strong presentation and interpersonal skills.
- Ability to effectively move forward on tasks even with ambiguous or changing requirements
Source : Ageatia Global Solutions