SQL Developer position visa : EAD GC USC Location: Los Angeles , CA Duration:6-12 months Skills: *Sample of your work in Bash and SQL queries must be provided before client interviews* Length:6 Months+
Major organization in downtown Los Angeles has a 6 Month+ consulting opportunity for a Bash, SQL Query Developer. The Consultant will design, develop and implement data integration components and backend solutions that support project and enterprise level data strategies while taking lead responsibility of all backend processes for all areas of the data warehouse. Please note: Sample of your work in Bash and SQL queries must be provided before client interviews. JOB RESPONSIBILITIES: - Work closely with Data Analysts and Data Modelers to develop enterprise data integration solutions that promote reusability and standardization. - Modify and create new and existing backend processes using shell scripts.. - Execute all phases of programming activities including program design, coding, debugging, testing, documentation and implementation. - Review data loaded into Data Warehouse for accuracy. - Assist with migration of existing applications from Oracle/SQL Server to Vertica using ELT methods - ReDevelop and tune existing Data Warehouse applications to ensure optimum performance. - Monitor existing Data Warehouse production jobs JOB REQUIREMENTS: - 7+ years of software development experience on large scale distributed systems - Proficient working in Linux Command Line Interface (CLI) only environment. (No GUI) - Strong Bash Shell scripting experience, must know how to write reusable and object-oriented bash scripts. Full understanding of Bash built in commands is expected. - Solid experience writing complex SQL-92 statements using various SQL Analytics functions, such as Time Series, Gap Filling and Interpolation, and Window Partitioning. - Must have a curious mind and able to create various data validation strategy - Familiarity with PERL, RDBMS such as Vertica or PostgreSQL is a plus - Excellent written/oral communication skills Regards, Sam Williams |Recruiting Manager Direct : 646-499-5264 Princeton | New Jersey-08540 [email protected] || [email protected] <file:///C:/Documents%20and%20Settings/user2/Local%20Settings/Temporary%20Internet%20Files/Content.IE5/ODEFO5I7/Jennifer%20Logo.html> ITBrainiac Inc. www.itbrainiac.com <file:///C:/Documents%20and%20Settings/user2/Local%20Settings/Temporary%20Internet%20Files/Content.IE5/ODEFO5I7/Jennifer%20Logo.html> -- You received this message because you are subscribed to the Google Groups "oraapps" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/oraapps. For more options, visit https://groups.google.com/d/optout.
