Systems Data Mgmt. Consultant

Description

Required Skills ARCHITECTURECAPACITY PLANNINGDATA GOVERNANCEDATA MANAGEMENTAdditionalDATA TRANSFORMATIONDATA WAREHOUSINGDB2DESIGN REVIEWETLINTEGRATIONJOB SCHEDULINGMAESTRODOCUMENTATIONODSORACLEPROJECT ARCHITECTUREPROJECT DESIGNPROJECT PLANREQUIREMENT WRITINGSQLSYSTEMS INTEGRATIONTECHNICAL DESIGNTECHNICAL LEADERSHIPTECHNICAL REQUIREMENTSTEST PLANSXML.NETXSLTDuties The Integration Analyst is responsible for the analysis and design of complex data integration processes supporting the Clients Investment Management and corporate programs. This role supports strategic investment initiatives within these areas and ensures recommended solutions are aligned with business, project and MM IT strategies while adhering to relevant technology standards.This role leverages problem solving and analytical skills to design technical solutions related to data management and system integration challenges and contributes to troubleshooting efforts across multiple functional areas and programs including General Investment Accounts, Separate Investment Accounts, Securities & various technology platforms supporting Investments, Finance, and Enterprise Risk.Accountable for documentation of the technical design and nonfunctional requirements.Review and provide input to the business functional and nonfunctional requirements for sufficiency to determine technical requirements.Contribute to the development of nonfunctional requirement and architectural artifacts.Accountable for the quality and thoroughness of the information contained in the design document.Review and provide input to design duration and completion dates along with task dependencies.Establish and approve best practices and standards with respect to design and development.Participate / lead complex project design teams.Perform impact analysis on various proposed technical solutions.Design and document the right technical solution to meet requirements.Understand the Project Architecture and translate into efficient designs that are scalable, maintainable, and reusable, ensuring that designs are aligned with business and technical strategy.Understand relevant LOB/SBU Reference/Domain Architectures.Contribute to and review estimates for development efforts.Participate in / lead (level dependent) peer design reviews.Drive performance and capacity planning (including instrumentation).Clarify and resolve design related issues with developers.Contribute to and review test strategy and test plans.Review and provide input to the project plan during architecture & design phase.Review and quality oversight of migration packages and procedures (prepared by developers).Contribute to the design/configuration of interface monitoring and exception notification processes.Transition operational schedules and other related support information for inclusion in the production support playbooksParticipate in and signoff on requirements and design review gates.Raise program / project issues to program / project managers transparently and effectively using recommended approaches.Highlight potential and actual design / development issues effectively.Skills Mastery level Application or ETL Developer with deep understanding of the SDLC, development patterns, and best practicesMastery level knowledge and experience with C# .NET, Entity Framework, HTML 5.0, Angular JS, Windows Workflow Foundation (WWF), Windows Communication Foundation (WCF), IIS, SQL Server TQuery, SQL Server XQuery8 or more years of experience with designing and implementing data transformation and data management solutions within Data Warehousing, ODS, SQL, ETL, and systems integration.Knowledge and experience with batch job scheduling (TWS/Maestro), orchestration, secure file transfer (MFT), XML and XML concepts (schemas, XSD, XSLT), DB2/SQL/Oracle query and query writing practices preferred.Knowledge and experience with data governance and data management technologies and methodologies.Skilled leading and/or participating in system design and architectural activities including technical requirement writing experience and ability to lead collaboration for important design decisions.Knowledge of investment security master data and/or financial data preferred but not required.Demonstrated experience in solution design related to enterprise critical data (e.g. customer, financial, or policy related data).Strong collaboration skills with the ability to work in a teambased environment including employees, vendors, and thirdparty contractors.Proven ability to provide technical leadership and guidance to less experienced team members.Strong understanding and adherence to IT SDLC and operational best practices.Minimum Degree Required Bachelors degree or higher in computer or businessrelated field.