*Position: ETL Lead Developer* *Location: Santa Ana, CA*
*Duration: 6 months+* * * *Need GC & Citizens only * *Description:* · The ETL Developer will participate in the design, development, and deployment of the ETL and data management processes for a multi-terabyte data warehouse. · This will involve development and deployment of ETL job workflow with reliable error/exception handling and utilizing roll-back framework, identifying, researching, and resolving performance and data quality issues. · The ETL Developer will perform the unit testing and assist the Business Analysts with integration, performance, and user acceptance testing. · They will document the ETL design and test results. The selected candidate should be self-motivated and have a proven record of managing their own time and work. · He/She will need to provide regular status reporting to their manager and be able to assess potential issues and risks to project timelines. *Job Requirements: * · Experience working with high volume databases with partitioned data, performance and tuning experience is required · Demonstrated experience ensuring ETL code delivered is running, conforms to specifications and design guidelines and is within estimated timelines · Demonstrated experience in clearly documenting ETL logic and components. · Strong knowledge of Data Warehousing methodologies and concepts, including and not limited to: star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools (e.g. Cognos a plus) · Experience working with and within cross functional Development, QA, Test and Functional Teams · Excellent analytical skills, the ability to integrate information from multiple sources to execute effectively and efficiently in a dynamic environment and · pursue a proactive approach to problem solving. · Strong exposure in data quality identification and remediation and data conversion requirements. · Able to work flexible hours as required by business priorities *Education and/or Relevant Experience:* · 8-12+ years of ETL development and data warehousing experience · Strong preference for experience with TIBCO Data Exchange ETL (previously named Embarcadero DTStudio) · Deep knowledge in pervasive ETL toolset (Informatica/Ascential) may be substituted including system administration and change management. · Strong ability in ETL performance tuning in an Oracle environment · Experience in Unix scripting · Familiarity with ETL testing an quality assurance methods · Web-based application development, framework object development experience, Oracle Relational Databases and J2EE platform development a plus · BS in CS or MIS required or related experience Regards Ejaz Talent Acquisition Manager Symphony Enterprises LLC 412 250 7227 (Tel) | 412 774 9230 (Fax) [email protected] | www.symphonyenterprises.com WMBE & NWBE Certified Company A Member of Women's Business Enterprise National Council (WBENC) and National Association of Women Business Owners (NAWBO) -- You received this message because you are subscribed to the Google Groups "US_IT.Groups" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/us_itgroups?hl=en.
