RMS Computer Corporation Application System Engineer-Expert in Jersey City, New Jersey
Reference # : 17-01184 Title : Application System Engineer-Expert
Jersey City, NJ
Position Type : Contract Experience Level : Start Date / End Date : 07/31/2017 / 12/08/2017
Our client, a leading global financial services company, has approximately 200 million customer accounts and does business in more than 140 countries. They provide consumers, corporations, governments and institutions with financial products and services, including consumer banking and credit, corporate and investment banking, securities brokerage, transaction services, and wealth management.
12+ years of hands on work experience in the Financial Services Data Warehousing.
Experience with high performance & high volume data ware house systems in a high pressure environment.
Strong database development capabilities.
Demonstrated design and delivery experience in the full lifecycle of data. Knowledge of information delivery architecture.
Broad and deep understanding of challenges with data management in large enterprises, data acquisition, integration and data quality architecture.
Extensive experience in developing and managing full life cycle of ETL deliverables. Sourcing from multiple source systems using ETL to implement the data transformation rules and load into the data warehouse.
Post Trade Processing Experience; Familiarity with Transactional costs of various securities, Trade Capture and Exception Handling.
Ability to carry out adaptive changes necessitated by changes in Business Requirements and Technology.
Display sound analytical, problem solving, presentation and inter-personal skills to handle various critical situations.
Qualifications - Bachelor’s Degree in Computer Science & Engineering. Master’s Degree in Computer Science & Engineering is a plus.
Technology: - Strong ETL (Extract, Transform and Load) concepts, DW (OLTP and OLAP) methodology and Strong SQL skills. Java and Scripting knowledge is a plus.
Tools and Applications: - Oracle, Netezza, Talend/Informatica, Java, Unix Shell Scripting, PL/SQL and Store Procedures.
Responsible for developing new business functionality and new features of a variable transactional expense system.
Extract data from heterogeneous data sources with multiple databases and transform into a harmonized data store under stringent business deadlines.
Responsible to design and implement all stages of data life cycle. Maintain coding and naming standards.
Interact closely with the Data Analysts and Users during Unit Testing, Integration, UAT and PROD rollout.
Design database table structures for transactional and reference data sources, maintain data model up to date as per the requirements.
Analysis design development installation and configuration of databases on multiple platforms and operating systems. Configure and administer Database servers. Create new functions, procedures and packages using NZSQL to implement business rules.
Generate automated and load procedures batch job administration, optimize database performance and SQL queries. Provide capacity planning and space allocation.
Designing, testing and implementation of backup / recovery procedure for database. Design and implement database security. Trouble shoots network databases. Design table structures and custom reports.
Program new transformations, mappings, workflows and loading procedures using ETL technologies to implement business rules using the best practices to achieve high performance load times.
Performs technical analysis of software, hardware, identifies and resolves complex problems utilizing structured troubleshooting methods, techniques and tools.
Evaluates systems specifications for complex business requirements, develops and prepares computer solutions; determines and implements the most efficient and cost effective solution. Prepare technical specification documents and mapping documents.
Designs logical and physical data bases and coordinates database development as part of project team, applying knowledge of data base design standards and data base management system.
Reviews project request describing database user needs. Estimates time and cost required to accomplish project. Determines if project requires creating series of new programs or modifying existing programs that access data stored in data bases.
Please see our complete list of jobs at: