Application Developer III - ETL Developer - INF000AK
DESCRIPTION/RESPONSIBILITIES:
Summary
Blue Cross Blue Shield of Michigan is currently seeking an Application Developer III to support our Enterprise Information Technology division. The Application Developer III will be accountable for the following responsibilities:
Essential functions:
* Performs new ETL applications development and integration with existing systems.
* Deigns processes that are high performance, low maintenance and efficient in appropriately handling errors, in a time sensitive manner.
* Designs logical and physical data flow models according to functional requirements and mapping designs.
* Builds and maintains automated ETL processes by coding, testing and implementing ETL mappings and scripts.
* Analyzes various features such as feasibility, associated costs, time, and the compatibility of new processes with existing processes and
* Design, develop and test SQL stored procedures
* Execute unit and system test scripts, analyze, capture and publish test results
* May be required occasionally to work outside the normal hours for maintenance
Corporate Skills/Experience Requirements
Work closely with clients, business analysts and team members on major 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’s architectural standards. Provide support in the full systems life cycle that may span a broad range of applications to ensure application software is delivered on time and within budget.
* Code applications or enterprise wide software systems using a disciplined development process. Integrate solutions with other applications and platforms outside the framework. Create data extracts and reports from system based on requirements. Develop, execute, and document unit test plans. Support and/or execute all testing efforts across the life cycle.
* Identify technical requirements. Create technical design specifications and assist in sizing technical requirements, as needed. Assist and review technical design specifications developed by junior levels.
* Lead the deployment of new modules upgrades and fixes to the production environment, as needed. Make modules production-ready by moving them to libraries, completing forms and version control documents, following procedures, etc. Validate deployment.
* Evaluate new application packages and tools and performs research on best practices. Provide recommendations for solutions.
* Assist in production support. Troubleshoot existing information systems to identify errors or deficiencies and develops solutions. Provide ongoing maintenance applications.
* 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.
* Participate on teams that outline the process and scope out the improvements that can realized through the application solutions.
* Document functions and changes to new or modified modules and test activities/results and other areas such as error handling and backup/recovery procedures. Assist in the development of user guides and training documentation for systems.
* Participate in project planning processes. Develop work plan timelines and manages workflows to meet project timeframes, as needed.
* Identify best sources of data feeds and interfaces with architects to ensure their feasibility with corporate data warehouse, when needed.
* Adhere to standards and procedures; check for compliance. May assists in defining development guidelines and standards. Review modules for quality assurance. Prepare and present formal training to IT staff, as needed.
* Provide technical leadership, coaching and mentoring to team members. Provide technical guidance or systems process expertise. Develop reports and presentations for senior management, as needed. Other duties may be assigned.
All qualified applicants will receive consideration for employment without regard to, among other grounds, race, color, religion, sex, national origin, sexual orientation, age, protected veteran status or status as an individual with a disability.
