Cloud ETL Engineer

General Dynamics Information Technology is a global technology and professional services company that delivers consulting, technology and mission services. The Cloud ETL Engineer will support Drug data Processing System (DDPS) Part D Processing for CMS, focusing on ETL development and testing for CMS Part D Medicare processing.

Responsibilities:

• Builds and codes applications and/or models using various computer programming languages
• Designs, develops, deploys, and maintains advanced operating systems and operating system software
• Installs enhancements and performs updates to software of existing systems, including middleware and application programs that run on the system
• Performs troubleshooting of advanced problems and provides customer support for software systems and application issues
• Debugs advanced problems with system software. Provides recommendations for continuous improvement
• Performs maintenance tasks to keep systems running smoothly
• Writes and updates test procedures and programs
• May coach and provide guidance to less-experienced professionals
• May serve as a team or task lead

Requirements:

• 5 + years of related experience
• BA/BS in a Computer Science or related technical discipline or the equivalent combination of education, technical certifications or training, or work experience
• 5+ years of direct related computer programming experience
• 5+ years of IT experience with at least 4 years of SQL development experience developing on multiple relational database platforms like Snowflake
• 2+ years of Cloud ETL development experience using AWS Services / tools, Databricks, Snowflake, and/or similar technologies
• 4+ years of physical data modeling, partitioning, and developing optimization/indexing strategies on the Teradata platform or similar DBMS
• 2+ years of experience with Snowflake and Snowflake ETL for loading data from AWS S3
• 2+ years of experience with UNIX scripting and utilities
• In depth knowledge on Data Warehouse (DW) concepts for ETL Development
• 2+ year of experience in Code migration and deployment using AWS resources in the cloud environment
• 3+ years of experience in working with Python and Spark programming
• AWS Development using S3, EC2 Lambda functions
• Extract Transform Load (ETL)
• Python (Programming Language)
• Apache Spark programming
• Knowledge on Snowflake Data Warehouse with ETL
• Knowledge on Databricks and notebook, coding and execution
• GitHub Code configuration and Management
• Attend daily stand-up scrum calls
• Collaborate in a 'war-room' setting with business analysts, developers, testers, architect, scrum master, and product owner to assist in grooming, designing, coding, unit testing user stories related to the Program Increment and current iteration
• Exercise positive interpersonal communication skills and works independently and within an agile team during all phase of the software development lifecycle
• Design, develop and implement complex ETL processes of healthcare data to meet a wide range of business and system requirements
• Support the ETL operational processes including but not limited to: automation, job scheduling, dependencies, monitoring, maintenance, patches, upgrades, security, and administration
• Investigate and corrects software defects and analyzes and maintains data quality
• Mentor and provide guidance to junior team members
• Identify process improvements and innovative ways to solve existing or new problems
• Prior experience developing healthcare IT solutions strongly preferred
• 2+ years of experience in Github, or similar version control tools
• Prior experience using the Agile development framework, and CI/CD DevOps
• Prior working experience with Medicare Part D Data with ETL development