| Lead ETL Developer, Remote at Remote, Remote, USA |
| Email: [email protected] |
| From: abhishek, StellentIT [email protected] Reply to: [email protected] Lead ETL Developer, Remote 12+ Months Phone + Skype The Senior ETL Engineer is responsible for developing and maintaining applications using a variety of technologies that support multiple lines of Business and IT initiatives. This individual may work independently or collaborate with a smaller group of ETL engineers in similar efforts. This position is responsible for technical analysis, design, development, testing, and deployment of IT solutions as needed by business or IT. The Senior ETL Engineer works closely with other subject matter experts and works on delivering technology including ETL / ELT, batch processing using Informatica to support a multitude of data warehouse and its downstream. They are responsible for developing and maintaining applications using a variety of technologies like Informatica, shell scripting, SQL and ETL to support multiple lines of Business and IT initiatives. This position is responsible for technical analysis, design, development, testing, and deployment of IT solutions / Data warehouse solutions to support Medica business, and will play a critical role in developing and migrating the Medica data warehouse on-prem and into Snowflake environment. They are required to accurately track work time based on project and/or daily work activities according to Finance department guidelines This position combines the role of data analyst, developer, consultant, troubleshooter, extract, transform and load (ETL). KEY ACCOUNTABILITIES: Design (20%) Comprehend and analyze business requirements Provide Subject Matter Expertise across Medica Data warehouse (Presentation, Business Logic, Application Integration, and Data tiers) Creates technical and design documents both independently and in close collaboration with Data Architecture team to meet business and IT requirements for the Medica Data warehouse. Translate requirements into Functional and Technical Specifications for Common Information Model (CIM) and other Medica Data warehouses. Ensure technical specifications meet Analytics requirements and desired outcomes while mitigating security, vulnerabilities, and risk measures. Identify repeatable patterns of ETL code and make it reusable and efficient. Involve in data analysis and contribute to data design. Development, Testing, and Deployment (50%) Responsibility for technical documentation and content as required by Medicas SDLC. Research, propose and implement development best practices. Propose and justify changes and enhancements to existing technologies like Informatica. Supporting the Medica operational data store and slowly transition to new warehouse i.e. CIM. Shift the development from Informatica to Snowflake environment to perform the ETL. Conduct code reviews for completed work. Create robust applications and services through testing and validations. Expected to meet deadlines and milestones to meet project objectives while maintaining quality. Ensure that testing meets all security standards and eliminates any vulnerability appropriately. Perform integration testing and system testing to ensure that individual modules are combined and tested as a group with desired outcomes Perform root cause analysis and problem resolution for defects and incidents. Advocate and help with advanced testing in support of the snowflake environment to manage the cost. Assist in the deployment of applications to QA and Production environments based on release schedules. Create Deployment Plans, Deployment Scripts, Code Merges, and Source Control configuration. Evolve deployment processes and tools to keep abreast with industry best practices. Demonstrate inter-departmental communications and teamwork efforts related to the development of, access to, and use of Medica Health Plans Group data. (10%) Develop relationships within and outside of Medica IT, Business and partners that will prove to be effective in providing necessary data and metadata for customers. Partner effectively with Data Architects, Business Analysts, ETL engineers, PMO and other IT groups. Partner with the snowflake environment specific team member to perform the snowflake migration. Practice and advocate data governance policies and standards as defined by the data architects, leads and management. Support/Maintenance (20%) Support and maintain Service Level Agreements established by Medica IT to meet maintenance contracts for all software systems and services. This includes fixing production defects and providing Level 3 support to the service desk. ESSENTIAL QUALIFICATIONS/REQUIREMENTS: EDUCATION/EXPERIENCE: Education Level: Bachelor's Degree Major: BS in Computer Science or related field a plus Years of experience required: 8+ years of experience in data warehouse environment and building ETL solutions using Informatica & Oracle etc, as well as knowledge on Snowflake & cloud environment. Specific types of experience required: Proficiency in SQL and Oracle PL/SQL is required. (5-8 years) Experience in healthcare environment (2-5 years) ETL (SAS) experience (5-8 years) Business Intelligence / Data Warehousing methodology is required (5-8 years preferred) Knowledge of Snowflake implementation is preferred Strong data analysis skills The candidate has to be very analytical and strong data analysis skills are required. Work Arrangement Hub (highly preferred) or Remote The ideal candidate is local, however we would consider candidates from the following approved states; AR, AZ, DE, FL, GA, IA, IL, KS, KY, MD, ME, MI, MN, MO, ND, NE, OK, SD, TN, TX, VA, WI. Hub requires contractors to occasionally come onsite to the designated office (Minnetonka) for applicable heads-up work. Frequency is determined by business need as decided by leadership. Interviews 1st round: 30 minutes with Hiring Manager 2nd round: 1 hour with Team members Keywords: quality analyst information technology trade national procedural language Arizona Arkansas Delaware Florida Georgia Illinois Iowa Kansas Kentucky Maryland Michigan Minnesota Missouri Nebraska North Dakota South Dakota Tennessee Texas Virginia Wisconsin |
| [email protected] View all |
| Wed Aug 16 19:08:00 UTC 2023 |