job summary: **W2- USC/ GC only** No C-C or Vendors **onsite: candidates can sit out of Charlotte, NC, Pennington, NJ or Plano, TX client locations** 3 year tenure #LI-VB1 The Oracle Developer will work as a data specialist and will work with the on design, development and optimization of the ETL process and the reporting data mart for critical client profile and related product revenue and volume data. The duties will also include working with development leads in finalizing ETL architecture, monitoring compliance with changes made in systems of record, and overseeing data conversions and migrations. In addition to this the developer will also be expected to build formatted reports using standard BI tools. The engineer will also work with application support teams to ensure design incorporates requires monitoring and alerting mechanisms to ensure timeliness and accuracy of reporting data. To succeed in this role, you should know how to examine new data system requirements and implement migration models. The ideal candidate will also have proven experience in data analysis and management, building large scale data marts for high volume and near real time reporting and possess excellent analytical and problem-solving abilities. Key responsibilities - Prepare accurate database design and architecture documents for management and executive teams. - Designing and coding the solution to ensure it meets client activity monitoring reporting requirements. - Developing optimal solutions for sourcing required data from upstream systems and transferring it into the new warehousing environment. - Assess database implementation procedures to ensure they comply with internal and external regulations. - Oversee the migration of data from legacy systems to new solutions. - Monitor the system performance by performing regular tests, troubleshooting, and integrating new features. - Educate staff members through training and individual support. - Offer support by responding to system problems in a timely manner. location: Charlotte, North Carolina job type: Contract salary: $62.00 - 66.50 per hour work hours: 8am to 5pm education: Bachelors responsibilities: Minimum 10 years of experience with the following: - A minimum of 5 years' experience in a similar role. - strong knowledge of database structure systems and data mining. - strong knowledge of object-oriented design and development - strong SQL skills with experience working on relational databases (ORACLE) - Experience using DB tools like Toad Data Point, Toad Data Modeler etc. - Knowledge of Global Banking and Markets client data management requirements - Experience working in Agile teams and good understanding of software development lifecycle - Experience design data marts for near real time, high volume reporting needs - Experience with multiple business intelligence tools and working with modern ETL processing based on streaming data - Experience building formatted reports using BI tools like SSRS, Power BI or Cognos - Excellent organizational and analytical abilities. - Outstanding problem solver. - Good written and verbal communication skills. qualifications: Experience level: ExperiencedEducation: Bachelors (required) skills: MUST HAVE: Strong knowledge of database structure systems, data modeling and data mining.Strong SQL skills with experience working on relational databases (Oracle, SQL Server or equivalent)Strong knowledge of ETL Platforms like Informatica, SSIS, etc.Strong knowledge of UNIX Shell scripts and Python. Candidate MUST HAVES: Must be really good with databases - how they're organized, how to design them, and how to find information in them (like Oracle or SQL Server).Know how to use tools that move and change data (ETL tools like Informatica).Be skilled in writing computer instructions for systems like UNIX (using Shell scripts) and in the Python programming language.Experience with database tools (like Toad).Know how to use Autosys for scheduling tasks. Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com. Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, and life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility). This posting is open for thirty (30) days.