APPLICATIONS DEVELOPER

JOB OVERVIEW: the Applications Developer will be responsible for providing analytical support for conceptualization, development, and implementation of complex systems of multiple inter-linked programs. In-depth knowledge of all phases of client/server applications technology. Responsible for the analysis, design, coding, debugging, testing and documentation of computer programs. Broad experience in programming graphical user interfaces (GUI). Extensive knowledge and skill with object-oriented programming, relational database structures and cloud engineering. May also act as team or project leader on major applications projects. The ideal candidate must demonstrate confidence, creativity, and keen problem-solving abilities. DETAILED LIST OF JOB DUTIES AND RESPONSIBILITIES: • Understand and translate business requirements into Data Warehouse solutions. • Create data models and designs to meet specific business needs that require sourcing data from multiple source systems. • Has the ability to mentor other technical staff in cloud technologies at all levels of understanding and can adjust the message accordingly. • ssists in identifying, planning, and migration of on-premises data solutions suitable for migration to the cloud. • Code Oracle, Snowflake or IICS ETL scripts that will transform data from an operational database and populate to various targets. • Document design using industry standards. • Capable of monitoring and optimizing data processing and storage performance with cloud environments. This includes identifying bottlenecks, tuning and optimizing queries, and recommending architectural changes to improve efficiency. • Provide query writing support and tuning expertise to analysts and end users. • Develop shell/Python scripts for production job automation. • Work in a 24x7 environment which requires on-call rotation. QUALFICATIONS: Preferred Knowledge, Skills & Abilities: • 5 years of experience in database development including analyzing, designing, documenting, coding, testing, and implementing primarily SQL code. • Thorough knowledge of Data Warehouse applications on AWS. • Experience working with Airflow. • Exceptional Oracle/Snowflake SQL skills • Hands on experience with Cloud architectures. • Strong problem solving and analytical skills. • Proficiency in Informatica IICS • Understand the concepts of version control and use of GitHub. • Experience working with a large, multi-terabyte data warehouse. • BS in Computer Science or related degree, or equivalent experience • Medicaid or other healthcare or claims processing experience • Experienced in Oracle SQL skills and PL/SQL skills. • Experience with Perl, system administration, database administration, storage architectures, backup & recovery, and networking EDUCATION AND CERTIFICATIONS: • BS in Computer Science, Information Technology or an equivalent combination of education and work experience required. • mazon Web Services (AWS) Cloud Certification and AWS Certified Solutions Preferred • Snowflake Certification Preferred • Informatica IICS Certification Preferred EEO: "Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of - Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans."