Interpro, Inc. Software Engineer (Ref# SE612BK) in Keego Harbor, Michigan

Interpro, Inc. has an opening for a Software Engineer em(Ref# SE612BK)/em to work in Keego Harbor, MI and various unanticipated locations throughout the U.S. Job Duties: Design, develop, implement, test, document, and maintain business and computer applications software or specialized utility programs, including data warehousing and ETL development, and major enhancement of existing systems. Responsible for designing and developing Business Intelligence solutions in staging environments and populating operational data store (ODS), enterprise data warehouse (EDW), and data marts using Informatica Power Center. Facilitate data requirement meetings with business and technical stakeholders. Understand business requirements and conceptual solution. Convert business requirements into technical requirements and design. Implement data warehouse projects and customize to client requirements. Create high-level design and detailed technical design. Create Informatica mappings, workflows, and sessions. Understand existing Oracle/MS SQL server code base to convert SQL logic into ETL transformation logic as per the business scenarios. Coordinate data modeling of sources and targets and create source to target mapping specifications. Create shell scripts for automation. Prepare unit and integration testing plans. Conduct unit testing and create unit testing results documents. Provide support for QA/UA testing. Migrate the code to production. Provide production fixes and code enhancements. Use of Informatica, Ab Initio, SSIS, SSAS, SSRS, Data Modeler, Crystal Reports, Tableau, Teradata, PL/SQL, Oracle, SQL Server, PowerShell, Control-M, UNIX, and Windows. Travel and/or relocation required.Requirements: This position requires a Master’s degree or foreign academic equivalent in Computer Science, Computer Engineering, CIS, MIS, or a related field. Plus 2 years of experience in the job offered or 2 years in a related occupation including Programmer Analyst, Systems Analyst, Associate Projects, or related experience. Will accept a Bachelor’s degree plus 5 years of progressive experience in lieu of the required education and experience. Position requires 1 year of experience with ETL, Informatica, Oracle, SQL Server, and UNIX. Will accept any suitable combination of education, training, or experience as per the requirements cited herein. 40hrs/week.Application Instructions: To apply, please MAIL resume to referenced address, ensuring to indicate the position reference code em(Ref# SE612BK)/em for which you are applying. Mail to: Interpro, Inc., Attn: HR, 3265 Orchard Lake Road, Keego Harbor, MI 48320.