Oracle PL/SQL Developer

Company Description

Artech is the 10th Largest IT Staffing Company in the US, according to Staffing Industry Analysts' 2012 annual report. Artech provides technical expertise to fill gaps in clients' immediate skill-sets availability, deliver emerging technology skill-sets, refresh existing skill base, allow for flexibility in project planning and execution phases, and provide budgeting/financial flexibility by offering contingent labor as a variable cost.

Job Description

Looking for W2 candidate Only

Job Description:

Job Title: Oracle PL/SQL Developer
Location: Minneapolis MN and Des Moines IA
Duration: 9 plus Months

Position Description

Looking for a solid PL/SQL developer with experience in ETL and data management. Primary goal will be to lead an effort to implement a data management strategy against an existing Oracle OLTP production database. This strategy will include deleting a large amount of data and moving large amounts of data to an archive database from our current production OLTP database. Looking for someone who can multi-task, communicate well with the team and business, do solid PL/SQL development and provide analysis and recommendations to our existing Oracle RAC based database.

Duties to include: PL/SQL script development, design data ETL processes, one time initial move and on-going yearly scripts, assess business requirements around the data retention and meet those requirements in a controlled, verifiable approach.

Required skills

• Four-year college degree in computer science, computer engineering or related field and 5+ years database design and administration experience

• Proficient in advance features of Oracle for PL/SQL programming and ETL development

• Experience with relational databases, 5+ years’ experience writing SQL (Oracle preferred).

• Demonstrated problem solving and analysis skills in a highly complex business and technical environment.

• Demonstrated verbal and written communication skills, and strong teamwork orientation

• Strong experience with Oracle databases in the Financial Services Industry or Customer Relationship Management areas

• Experience in working on executing the PL/SQL scripts needed for Extracting, Transacting and Loading the data for the Data cleanup and migration to long term storage solutions.

• Experience in maintaining data integrity using integrity constraints and data consistency checks.

• Some experience in coding database triggers for automatically updating the tables and views.

• Experience in testing SQL code for performance tuning using explain plans and other technics

Description of Responsibilities

• SQL Developer on a java based CRM desktop critical to our Home Mortgage Sales business line, interacting with Oracle.

• Design and develop complex technical solutions that encompass data retention requirements.

• Use existing client system tools and methods in implementing any solution.

• Document script/process functionality for ongoing support, and assist in the development of documentation.

• Provide development support and problem identification/resolution of system problems.

• Perform other duties as required or assigned.

Qualifications

Additional Information

For more information, Please contact

Pavithra P

pavithra.p(at)artechinfo.com

973 507 7535