Salary
💰 $123,250 - $166,750 per year
Tech Stack
AWSCloudETLInformaticaPythonSQLUnix
About the role
- 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
- Support ETL operational processes including automation, job scheduling, dependencies, monitoring, maintenance, patches, upgrades, security, and administration
Requirements
- 8+ years of IT experience with at least 8 years of SQL development experience developing on multiple relational database platforms
- 2+ years of Cloud ETL development experience using AWS Services / tools, Databricks, Snowflake, and/or similar technologies
- BA/BS in a Computer Science or related technical discipline or the equivalent combination of education, technical certifications or training, or work experience
- Experience with physical data modeling
- Experience with Informatica PowerExchange/ Informatica PowerConnect/ Informatica PowerCenter and UNIX scripting and utilities
- In depth knowledge on Data Warehouse (DW) concepts for ETL Development
- Experience with code migration and deployment using AWS resources in the cloud environment
- Good experience working with Python programming
- Experience with AWS Devops, Databricks Platform, ETL Development, Structured Query Language (SQL)
- Good customer service and communication skills, to include presenting to all levels of leadership
- Must have good problem-solving skills
- Requires ability to pass CMS background check and meet the residency requirement for having resided in the US at least (3) three out of the last (5) five years
- US Citizenship Required: No