Opening for .Net with ETL Developer :: F2F interview at Remote, Remote, USA |
Email: [email protected] |
From: Ansar Alam, Resource Consulting Services Inc [email protected] Reply to: [email protected] Title: .Net with ETL Developer Location: Quincy, MA/Hybrid Required experience: 8-10+ years Visa Status: All visas are workable except CPT, OPT, and H1B Interview In person Interview and Video Duration 6 12 Months with a possible extension Note: LinkedIn Needed. Local Only from MA, NH or RI Must have recent client exp from MA Minimum Requirements: Vaccination Mandatory 37.5 hours per week Hybrid - expect 2-3 days on-site per week Responsibilities Prior EDI experience required (preferably healthcare EDI). Must know EDI Data flows Prior experience in ETL environment with strong DB skills Prior healthcare/medicaid experience would be extremely beneficial The Massachusetts Executive Office of Health and Human Services (EOHHS) is the largest secretariat in MA state government, comprised of 16 agencies with over 23,000 employees state wide. EOHHS services directly touch the lives of slightly more than one in four residents in the Commonwealth some of our most vulnerable citizens, including children, youth, adults, and elders. EOHHS provides access to medical and behavioral health care, substance misuse treatment, long term services and support, and nutritional and medical benefits to those with low incomes. We connect elders, individuals with disabilities, and veterans with employment opportunities, housing, and supportive services. We steer troubled youth towards a more successful path and do everything possible to keep children in our child welfare system safe. We support individuals who are developmentally disabled, mentally ill, blind, deaf or hard of hearing. Job Overview The Executive Office of Health and Human Services (EOHHS) is seeking to hire a Sr. Application Developer (Lead Developer) to develop and maintain a variety of applications and interfaces that support our crucial services. The developer will work with project managers, business analysts and other technical teams to design and develop applications using ASP.net technologies, SQL Server, C#, TFS and other application tools. The Lead Developer will be responsible for architecting and developing the integration layer that supports the evolving interfaces for the Health Safety Network (HSN) application and the business partners including but not limited to providers, other agencies, and other internal/external teams. MassHealth applications provide critical support for access to health care for some of Massachusetts most vulnerable individuals. This role will serve the needs of MassHealth and its Health Safety Net (HSN) program. Health Safety Net helps pay for certain medically necessary services provided to qualified low-income patients at Massachusetts community health centers (CHCs) and acute care hospitals. HSN also pays CHCs and acute care hospitals for medical hardship expenses (when qualifying medical expenses exceed a specified percentage of a family's income), and for some types of bad debt. The HSN program serves a vital role in supporting both the qualified uninsured and underinsured Massachusetts residents of the Commonwealth. The Sr. Application Developers primary role is to support HSN in their many business processes which may require documenting these end-to-end processes, possibly redesign, re-solutioning, and/or requiring new development as part of their migration to the AWS cloud. This migration will require the Senior Developer to work in conjunction with the Shared Applications Architect and Release Management teams. MassHealth and HSN is looking for motivated individuals that seek-out public service as an opportunity to expand their knowledge, gain valuable experience, and give back to the community. This position is anticipated to be a long-term engagement and is currently a hybrid remote position with the candidate able to come into the Quincy MA office when requested. Job Duties: (Detailed list of Responsibilities) Lead development efforts on multiple priorities running in parallel work streams supporting a variety of applications and agency initiatives. Use knowledge of technologies, development strategies, and development best practices to support definition and delivery of the roadmap. o Craft overall technical vision and direction documents for large or complex initiatives, evaluate technologies and/or alternate approaches, work with stakeholders to estimate and design approaches, and support program-level trade-offs on priorities. Work with business leads and end users to analyze needs. Design, test, and develop application functionality to meet those needs. ETL/EDI Solution Design: Design and propose efficient data integration solutions using ETL/EDI tools that align with the business objectives and ensure data quality, accuracy, and security. Data Mapping and Transformation: Define data mapping and transformation rules to facilitate the exchange of data between different systems using EDI standards or custom ETL processes. System Integration: Work closely with development teams to integrate ETL/EDI solutions with existing systems and applications, ensuring smooth data flow and minimal disruption to operations. Move fluidly between the legacy and next generation applications, providing technical expertise to all teams and products in an Agile environment. Diagnose application, infrastructure, and technology issues using various resources; define an appropriate solution; support the resolution; and document the incident record. Perform necessary integration support to systems and evaluate & recommend software upgrades for existing and prospective technologies. Develop technical interfaces, specifications, and architecture. Communicate effectively with technical and nontechnical stakeholders. Requirements 5+ years of experience in the following: o Data Integration between systems (IIS, Middleware, Integration Services, Web Services, XML, Rest Services) o Application development and implementation o C#.NET, JavaScript, JQuery, ASP.NET, HTML 5 o C#, ASP. NET, MVC, JSON, WEBAPI, REST, SOAP. o Designing, architecting, and implementing middleware solutions. o MS SQL server 2012-2019 experience including SSRS and SSIS and/or other ETL tools. Writing relational database queries for stored procedures, query optimization and performance tuning. Strong quantitative, analytical, and conceptual thinking skills. Excellent verbal, written, and interpersonal communication skills. Knowledge and understanding of application lifecycle, from design and development to testing, implementation and production support. QUALIFICATIONS (Education, Years Experience, Certificates): Bachelors degree in a computer science or a related field or relevant work experience Strong working knowledge and experience in programming with MS SQL Server, Oracle and Java/J2EE technologies. Experience supporting a test-driven development culture. Knowledge and experience working with information and security architectures. Experience programming in Agile methodologies. Keywords: csharp database microsoft Massachusetts New Hampshire Rhode Island |
[email protected] View all |
Thu Dec 14 20:32:00 UTC 2023 |