FMR LLC – $161,616.00/Year

CONTD from H.10.B performing data analysis and design in a financial services environment.br br Education and Experiencebr br Bachelors degree or foreign education equivalent in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Physics, or a closely related field and five 5 years of experience in the job offered or five 5 years of experience performing data analysis and design in a financial services environment.br br Or, alternatively, Masters degree or foreign education equivalent in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Physics, or a closely related field and three 3 years of experience in the job offered or three 3 years of experience performing data analysis and design in a financial services environment.br br Skills and Knowledgebr br Candidate must also possessbr br Demonstrated Expertise DE creating EntityRelational ER and Data Warehouse DW Data Models conceptual to be presented to information architects, logical for business stakeholders, and physical data models to be implemented in databases; proposing, designing, and implementing ER entity relationship or DW models based on business requirements; creating conceptual, logical, and physical data models using SAP PowerDesigner; and generating Data Definition Language DDLs for physical implementation of tables using SAP PowerDesigner.br br DE performing data analysis of source systems and tables and analyzing how to store data in the new format, using TOAD and Oracle; performing data profiling on feed files Excel, COBOL, Mainframe tables, or OracleSQL Server tables using Informatica Analyst; identifying data gaps and duplicates using Informatica Analyst; and performing data analysis using SQL query.br br DE performing data analytics for business users based on requirements using SQL analytical functions; creating and implementing data quality checks to ensure the accuracy of data for business use using Informatica EDQ; and providing data support to data engineering teams during production issue triage monitoring Informatica jobs and Oracle Stored Procedures to resolve data quality incidents.br br DE liaison between business and technology partners to translate business requirements into technical design solutions; creating business requirement documents documenting requests from business partners and defining technical components of work to be done by data engineering teams; and collaborating with technology partners to use TOAD to analyze data and create a SourceToTarget STM mapping document using TOAD that contains source related information and information on how the source should be mapped to target tables in Microsoft Excel.