Missouri Manufacturing Jobs

Jobs.mo.gov mobile logo

Job Information

MAGELLAN HRSC, INC. Sr. Software Engineer (ETL / Informatica) - R00000039326 in Maryland Heights, Missouri

Looking for a Sr. Software Engineer with ETL / EDI x12 experence, SSIS, Informatica, AWS Redshift, etc. Candidate should have prior experience documenting business data and mapping requirements. Requires solid ETL/SSIS experience (Control flow components, data flow components, general ETL concepts). Proven capability to enhance the functionality and performance of various SQL scripts using stored procedures, temp tables, table variables, and CTEs. Analyzes, designs the framework for and participates in the development and delivery of ETL/ X12 EDI flat files, business intelligence reports, and other information objects. The primary focus of the job deals with Information Delivery and Data Analytic projects.This position is open to REMOTE / TELECOMMUTE / WORK FROM HOME candidates form anywhere in the US.Responsibilities to include:- Creates database tables and cubes utilizing academic methodology (normal forms) ensuring business smart resource allocation- Creates frameworks to provide accurate information quickly to the organization.- Analyze, design and build reports, ETL and assists in the creation of data marts as needed.- Designs user interfaces and dashboards using the Microsoft Business Intelligence Stack and .net architecture- Monitors ETL schedules and develops new ETLs to support new application and dashboard/information delivery- Responsible for large scale SQL development that drives cubes and information exchange for decision support applications and BI dashboardsThis position services as an expert technical and industry resource to management, clients and development staff in new uses of information technology and in all phases of major system and subsystem development. Provides consultation on internal and industry IT technical and business process capabilities including leadership in the identification and recommendation of new IT opportunities. Formulates, contributes to, and directs task identification, work effort estimates, and work schedules for research, prototype, and proof-of-concept IT activities. Directs and participates in software/hardware releases and installation tasks.Analyzes problems and program in two or more programming language/platforms.Understands and develops functional and non-functional requirements for a system.Works with multiple programming frameworks.Develops, tests and maintains code using software development methodology and appropriate technologies for the system being used.Integrates systems to databases and other applications using middleware such as SnapLogic and consume or produce SOAP or REST based services, etc.Agile, DevOPS and Cloud:Possesses proficiency in automated testing strategies, including TDD.Understands advanced concepts of Containers, Micro-Services, Continuous Integration.Understands Cloud computing concepts and how to build Cloud deployable application.Performs load and performance testing on the application and do regular performance tuning.Other Job RequirementsResponsibilities3 years of programming experience.Strong working knowledge of modern programming languages including JavaScript, Java, Swift etc.Critical thinker.Demonstrated problem solving techniques.Strong verbal and written communication skills.General Job Information TitleSr. Software Engineer (ETL / Informatica)Grade26Work ExperienceITEducationBachelors: Computer and Information ScienceLicense and Certifications - RequiredLicense and Certifications - PreferredMagellan Health Services is proud to be an Equal Opportunity Employer and a Tobacco-free workplace. EOE/M/F/Vet/Disabled. Every employee must understand, comply and attest to the security responsibilities and security controls unique to their position.Equal Opportunity Employerminorities/females/veterans/individuals with disabilities/sexual orientation/gender identity