Offered Salary 1000
Career Level Others
Experience 8 Years +
Qualifications Degree Bachelor
Position: ETL Developer
Job Duties: Create database objects like tables, views, materialized views, triggers, procedures, functions, and packages to implement business logic using oracle tools like Toad, PL/SQL Developer and SQL* plus. Design and create scripts to create new tables, views, SQL queries for new enhancement in the application. Prepare and create Indexes on the tables for faster retrieval of the data to enhance database performance. Develop SQL and PL/SQL scripts to transfer tables across the schemas and databases. Develop SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling. Perform SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE. Use Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines. Use advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL. Conduct and be involved with Data Extraction, Transformation and Loading (ETL process) from Source to target and work on Windows Batch scripting, scheduling jobs and monitoring logs. Create control files and loaded the data into the database tables from flat files by using SQL*Loader. Create indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries. Fine-tune procedures/SQL queries using Oracle Hints for maximum efficiency to direct the optimizer to choose an optimum query execution plan.
Education and Experience: Requires a Master’s Degree or foreign equivalent in Computer Science or Electrical Engineering and one (1) year of experience in the job offered or one (1) year of experience in creating database objects like tables, views, materialized views, triggers, procedures, functions, and packages to implement business logic using oracle tools like Toad, PL/SQL Developer and SQL* plus; and Conducting and being involved with Data Extraction Transformation and Loading (ETL process) from Source to target and working on Windows Batch scripting, scheduling jobs and monitoring logs.
Location: Plano, Texas. 40 Hours/week. M-F. Job will require travel to client sites with expenses paid by employer. Must be authorized to work in the U.S. Email resumes to firstname.lastname@example.org or mail to Attn: HR, 4Consulting, Inc.,7700 Windrose Ave, Plano, Texas 75024. Please go to www.4ci-usa.com for more details. Please mention Job Id: 1477 while applying.