Oracle PL/SQL Developer
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.
For more information, Please contact
Pavithra P
pavithra.p(at)artechinfo.com
973 507 7535