Senior Software Engineer

Responsibilities Support whole lifecycle of software development activities including requirement gathering, analyzing, designing, developing and testing; Support key systems including Data Warehouse, Data Lake and MDM solutions by analyzing existing code base, data models, data flows and making relevant changes based on new requirements; Work with Architects and Data Modelers to understand the business process and functional requirements in order to design and deliver technical design documents; Create, modify and enhance high level technical documentation for designing and developing solutions for projects, including Sales Force Project, IHA Project, and Data Lake Migration; Create data models; design Hive and RDBMS tables and generate corresponding scripts for their creation to support Data Lake Migration and Data Integration solutions within the enterprise; Develop data integration solutions for the enterprise and develop data mapping applications based on tools including Informatica PowerCenter, Cloudera and Informatica Big Data Edition; Analyze, design, develop, test and implement software programs, components, modules, applications and business intelligence reports; Enhance existing Informatica Big Data applications, PowerCenter workflows and mappings that move data between files, Oracle databases and within the Cloudera data lake environments; Analyze the job log and monitor the execution statistics on the Informatica monitoring console to identify the execution time versus volume of data, identify bottlenecks and optimize the mapping to improve performance in the PowerCenter environment; Utilize and apply knowledge of RDBMS tables, Informatica Power Center, AWS, PERL scripts, Big Data Management, SQL Server, DB2, Eclipse, Oracle, JIRA and UNIX to perform duties; Optimize and improve the performance of the software programs and applications; Analyze production data to provide historical and ongoing data fixes per requirement and issues raised via service requests from key departments; Work on production issues reported by team/users on the JIRA ticket tracking tool; Provide support to key decision support systems within the enterprise; Support the automation of batch processes by writing shell and PERL scripts; Perform software quality assurance tests at different levels including functional testing, unit testing, configuration testing, integration testing, systems testing, regression testing, performance testing and user acceptance testing; Analyze and interpret test results, test data and prepare reports; and troubleshoot and resolve systems software and application issues. Location Novi, MI and multiple undetermined worksites throughout the U.S. Salary $108,000 per year Education Masters – Computer Science, Computer Engineering, Electrical Engineering, Engineering Management, or in a related field of study (will accept equivalent foreign degree). Experience Six (6) months in the position above as a Software Engineer, as a Lead Consultant, or in a related occupation. Training None Requirements Use of RDBMS tables, Informatica Power Center, AWS, PERL scripts, Big Data Management, SQL Server, DB2, Eclipse, Oracle, JIRA and UNIX; will also accept any suitable combination of education, training and/or experience. #J-18808-Ljbffr