Application Developer II

<p>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.</p>

Detroit, MI

Blue Cross Blue Shield of Michigan

When you think of <a href="https://www.bcbsm.com/" 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.<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="http://www.bcbsm.com/index/about-us/our-company.html" 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 />Learn more about your options as an external candidate. <a href="https://bcbsm.taleo.net/careersection/2/jobsearch.ftl?lang=en" target="_blank" rel="noopener noreferrer">Click here</a> to view open positions.&nbsp; http://www.bcbsm.com

keywords: professional,technical,quality assurance,leadership,experience,degree

Full-time

Competitive Total Compensation Package

Overview: Direct/participate in the discovery process. Provide subject matter expertise and knowledge guidance to a team of analysts and ETL developers. Lead the design and development of the ETL process. Lead the effort to fix processes defined. Contribute for process and performance improvements.
Responsibilities: Convert Business requirements into technical requirements and design. Create high levels designs. Create detailed technical design. Create SSIS Packages. Create Informatica Mappings, Workflows, and Sessions. Build Pig/Hive/Sqoop scripts. Create Shell Scripts for automation. Understand the source systems and conduct the data profiling. Coordinate Data Modeling of Sources and Targets, Create Source to target Mapping Specifications. Conduct Unit Testing and create Unit Testing Results documents. Provide Support for QA/UA Testing. Migrate the code to production issues. Provide hands on technical leadership. Lead technical requirements, technical and data architectures for the date warehouse projects.
Requirements: Bachelor&rsquo;s degree/equivalent in Computer Science, Engineering, or a related technical field. Employer will accept one (1) year of directly related experience in lieu of one (1) year of college.&nbsp; Must have three (3) years of experience as a Developer, Programmer Analyst, or related role.&nbsp;&nbsp;Must have 3 years of experience with ETL Tools like SSIS, Informatica 9.x and above; 3 years of experience with Microsoft SQL/Oracle 10g and above; 3 years of Unix Shell Scripting - AIX&nbsp;<strong><span style="font-family: Arial;">OR&nbsp;</span></strong>Linux; 3 years of experience with at least one of the following&nbsp;scheduling tools: CA-7, Tivoli, Auto-sys, SQL Server Agent&nbsp;<strong><span style="font-family: Arial;">OR&nbsp;</span></strong>Ctrl-M; 3 years of experience with Informatica Data quality; 1 year of experience with Informatica Big Data Management; and 1 year of experience with Hadoop Pig, Hive, Sqoop,&nbsp;<strong><span style="font-family: Arial;">and&nbsp;</span></strong>HBase.