Lead Engineer, Software

Opera Solutions USA, LLC seeks Lead Engineer, Software in Jersey City, NJ.


Analysis of Business Requirements. Loading of FFM Extracts into Oracle tables using Oracle Sql loader and control files. development of various Oracle procedures using static cursors, dynamic sql and Oracle functions for Pre-Audit load and Audit Stats, which has Load Checksums and Financial Checksums. Writing Unix Scripts for processing and transferring Files. Design and Implementation of CIC Policy Linking. Tuning of Oracle queries using hints, indexes, explain plans etc. for better performance. Coordinating processing of 1095 changes for FFM team and cognosante teams. Designed framework for processing of D820 and SI820 data and coded the procedures using cursors, collections, dynamic sql etc. Involved in SDLC phases such as analysis, design of frame work, development of Code, Testing (Unit testing, Integration Testing, QA Testing), Deployment of Code to Production and Production Support. Work assignment, Review among team members, time sheet management, Goal Sheet Assignment and Evaluation etc.


Requires a Bachelor's degree in Computer Science, Engineering or related field plus 5 years of experience.  Required experience must include: - 3 years of experience with data warehouse databases (OLAP) more than 500 million rows. - 3 years of experience bridging the OLTP environment with OLAP and other analytic capabilities. - 3 years of experience with UNIX development and production, ETL Tools (i.e., Informatica), Scheduling tools (i.e., Autosys and control M).


Must also have authority to work permanently in the U.S. Applicants who are interested in this position may apply at www.jobpostingtoday.com Job ID: 58931 for consideration.