Application Developer II - Enterprise Data Warehouse Operations

With more than 7,000 employees, we are the largest health insurance company in Michigan. We offer an exciting work environment with a diverse group of employees. Our goal is to make health insurance easier for our members. We want to transform the industry and become a resource that people can trust.

Detroit, MI

Blue Cross Blue Shield of Michigan

When you think of <a href="" target="_blank" rel="noopener noreferrer">Blue Cross Blue Shield of Michigan</a> for health insurance, you can know you&rsquo;re getting much more. We're a company founded on a tradition of affordable, quality health care for everyone, improving the present and investing in the future.&nbsp;<br /><br />We offer:<br />Plans for employers and individuals that meet today&rsquo;s needs, budgets and lifestyle<br />The largest network of doctors and hospitals in the state<br />Lower health care costs Higher quality health care<br />Award-winning diversity practices<br />Grants and programs that promote better health throughout Michigan<br /><strong><br />Mission:&nbsp;</strong>We commit to being our members&rsquo; trusted partner by providing affordable, innovative products that improve their care and health.<br /><br /><a href="" target="_blank" rel="noopener noreferrer"><strong>Click here</strong></a> to learn more about our commitment to our Social Mission, view company updates and reviews, and view our awards &amp; accolades.<br /><br />For Application Timeline &amp; Selection Process:&nbsp;<a href="" target="_blank" rel="noopener noreferrer">Click Here</a>. Learn more about your options as an external candidate. <a href="" target="_blank" title="BCBSM" rel="noopener noreferrer">Click here</a> to view open positions.

keywords: position summary,departmental summary,analysis,assist,create,performance,control,teamwork,departmental preferences,experience,project management,degree,departmental requirements


Competitive Total Compensation Package

Overview: Work closely with clients, business analysts, and team members on small to large, complex projects to understand the business requirements that drive the analysis and design of quality technical solutions that align with business and IT strategies and are in compliance with the organization&rsquo;s architectural standards. Provide support in the full systems life cycle for multiple applications to ensure application software is delivered on time and within budget.<br /><br /><strong>Departmental Summary:</strong><br /><br />The Application Developer II for IM Operations&nbsp;will be responsible&nbsp;for contributing to the team of Informatica developers for on-call application and ETL support. He/She must have prior hands-on experience designing and developing ETL solutions for successful enterprise data warehousing projects as well as supporting enterprise-level ETL applications and EDW solutions in an operational setup.
Responsibilities: <ul> <li> <div>Code applications using a disciplined development process.</div> </li> <li> <div>Integrate solutions with other applications and platforms outside the framework.</div> </li> <li> <div>Create data extracts and reports from system based on requirements.</div> </li> <li> <div>Develop, execute, and document unit test plans.</div> </li> <li> <div>Support and/or execute all testing efforts across the life cycle.</div> </li> <li> <div>Assist in the deployment of new modules, upgrades and fixes to the production environment. Make modules production-ready by moving them to libraries, completing forms and version control documents, following procedures, etc.</div> </li> <li> <div>Validate deployment.</div> </li> <li> <div>Assist in production support.&nbsp;</div> </li> <li> <div>Troubleshoot existing information systems to identify errors or deficiencies and develops solutions.</div> </li> <li> <div>Provide ongoing maintenance of applications.</div> </li> <li> <div>Evaluate existing applications and platforms and provides recommendations for improving application performance by conducting gap analysis, identifying feasible alternative solutions, and assisting in the scope of modifications.&nbsp;</div> </li> <li> <div>Document functions and changes to new or modified modules and test activities/results.&nbsp;</div> </li> <li> <div>Assist in the development of user guides and training documentation for systems.</div> </li> <li> <div>Participate in project planning processes, as needed.</div> </li> <li> <div>Identify better sources of data feeds and interfaces with architects to ensure their feasibility with corporate data warehouse, when needed. Identify technical requirements, as needed.</div> </li> <li> <div>Create technical design specifications and assist in sizing technical requirements, as needed. Adhere to standards and procedures; check for compliance.</div> </li> <li> <div>Review modules for quality assurance.&nbsp;&nbsp;</div> </li> <li> <div>Evaluate new application packages and tools and perform research on best practices and provide recommendations for solutions, as needed.</div> </li> <li> <div>Prepare and present formal training to IT staff, as needed.&nbsp;</div> </li> <li> <div>Provide technical coaching and mentoring to less-experienced team members.</div> </li> <li> <div>Other duties may be assigned.</div> </li> </ul> <p><strong>Departmental Preferences:</strong></p> <p>The Application Developer II will be a key member of an Enterprise Data Warehouse Operations and Services team. He/She will be responsible for the following key deliverables and activities:</p> <ul> <li>Monitor ETL Application Framework and respond to alerts as per SLAs.</li> <li>Follow defined production support and development standards and processes.</li> <li>Participate in on-call support schedule on a rotation basis.</li> <li>Monitor and maintain ticket queues and follow standard escalation procedures.</li> <li>Manage incidents and problems by providing root cause analysis for reported issues.</li> <li>Work with Business teams for resolving production issues.</li> <li>Provide code and performance tuning analysis, recommendations, and development services.</li> <li>Maintain and develop documentation for operational procedures.</li> </ul>
Requirements: <ul> <li>Bachelor's degree in related field preferred.</li> <li>Three (3) years of advanced programming techniques and application design required.</li> <li>Experience in systems design and have a solid understanding of development, database development, testing, and integration methodologies required.</li> <li>Project management experience preferred.</li> </ul> <br /> <p><strong>Departmental Requirements:</strong></p> <ul> <li>Bachelor and / or Maters degree in a related field such as Computer Science, Computer Engineering, MIS or a related computer field.</li> <li>1-3 years of experience&nbsp;with Hadoop, Databricks, Impala, Hive, Tableau or Redshift.</li> <li>1-3 years of experience&nbsp;Writing SQL and working with relational databases such as Redshift or Postgres.</li> <li>2-3 years of Unix Shell Scripting.</li> <li>2-3 years of experience in Production Support supporting&nbsp;enterprise Informatica applications.</li> <li>1-2 years of experience in Scheduling tools like Stonebranch and Oozie Scheduler.</li> <li>Experience in Healthcare.</li> <li>Strong SQL.</li> <li>Experience in Scheduling Tools - Tivoli, Autosys, Tidal.</li> <li>Working knowledge of data streaming solutions such as Kafka.</li> <li>Ability to build and modify Spark jobs in Scala&nbsp;is a plus.</li> <li>Strong knowledge and experience in Data Warehousing concepts.</li> <li>Bachelor and / or Maters degree in a related field such as Computer Science, Computer Engineering, MIS or a related computer field.</li> </ul> <p><strong>OTHER SKILLS AND ABILITIES:</strong></p> <ul> <li>Analytical and systems thinking.</li> <li>Accuracy and attention to detail.</li> <li>Written and verbal communication skills.</li> <li>Ability to work independently, or within a team environment.</li> <li>Other related skills and/or abilities may be required to perform this job.</li> <li>Strong analysis, troubleshooting and problem-solving skills.</li> <li>Experience with Mainframe applications is desirable.</li> <li>Experience with SCALA and other cloud scripting languages is desirable.</li> <li>Excellent communication and documentation skills using PowerPoint, Excel and Visio.</li> <li>Excellent organizational and multitasking skills.&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</li> <li>Ability to work with cross functional teams to achieve desired results.</li> <li>Hands-on experience managing critical events and incidents.</li> <li>Ability to work independently under general direction.</li> <li>Ability to work in fast paced environment with short deadlines.</li> <li>Ability to provide subject matter expertise on Informatica development.</li> </ul>