ETL Developer Company Hidden Bloomfield, CT 1 Opening $1,800 reward per hire

Agility Partners is seeking a qualified ETL Developer to fill an open position with a Fortune 15 company based in the greater Seattle area. In this exciting opportunity, you will play a crucial role in developing and modifying SSIS packages and related stored procedures on MSSQL Server. You will be responsible for analyzing data flow across multiple systems, dedicating time to evaluating SSIS packages and tracing data, and modifying/creating new SSIS packages and stored procedures.

In this role you will:

• Evaluate existing SSIS packages and trace data flow across multiple systems
• Develop and modify SSIS packages, ensuring their efficiency and functionality
• Work collaboratively with multiple remote teams to achieve project goals
• Utilize GitHub for code deployments and version control

The Ideal Candidate

• Intermediate to advanced T-SQL skills, including experience with complex JOINs, subqueries, stored procedures, indexes, temp tables, and CTEs
• Proficiency in using GitHub for code deployments
• Intermediate to advanced SSIS development skills with various source and destination types, including connecting with Teradata.
• Familiarity with ESP
• Problem-solving skills for server issues such as permissions, blocks, locks, long-running jobs, and indexing
• Experience with Medicare, Medicaid, and Risk Adjustment
• AWS experience, especially using Glue