*Job title : SSIS-BI developer* *Job location : Lake forest, CA* *LOCAL consultants required. and H1B copy is must* *Interview mode: Telephonic and face to face*
*Required Skills* - SSIS - SQL- source queries, OPTIMIZATION (will spend most time on optimizing) - data warehouse exp working w/ ETL - Agile environment, reporting, data modeling (will be asked what tool they used) and SSAS- nice to have *Skills Required* · 5+ years’ experience with SQL Server Integration Services (SSIS). · 5+ years’ expertise in SQL programming. · Ability to manipulate data using SSIS and TSQL. · Ability to write complex stored procedures and TSQL code. · Experience in performance tuning SQL Server and SSIS Packages. · Ability to write efficient TSQL and ETL Code. · Experience with the process of loading Data Warehouse Systems. · Successful candidates will be quality oriented and demonstrate great attention to detail. · Must have excellent written and verbal communication skills and be able to interact with multiple IT teams. · Read, Write, and Speak fluent English. · Experience in an Agile environment. · Experience with source control tools and processes. · Work on multiple assignments concurrently under aggressive deadlines. · Report writing experience is a plus. · Data Modeling tool experience is a plus (ER_Studio or ER_Win) *Responsibilities* · Create and maintain SSIS packages to support ETL processes. · Convert legacy ETL processes to utilize SSIS Framework. · Be able to produce code that is well-formatted, documented and highly efficient. · Take part and contribute to code reviews. · Apply standards and best practices. · Perform data analysis and quality assurance · Unit testing of SSIS and TSQL code. · Collaborate with business analysts, subject matter experts, and other team members to determine data extraction and transformation requirements. · Work closely and be an active member of a scrum team. In case this position interests you please share below details to save on you valuable time; Pay rate expectations: Notice period: Work Authorization status: Current Location: Also share your updated resume to Varsha Yadav at vya...@okayainc.com > Varsha Yadav | Technical recruiter Okaya Inc. | Ronkonkoma, NY 11779 Phone: 6312674883 X 124 | Email: vya...@okayainc.com *Disclaimer:* We respect your Online Privacy. This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. If you are not interested in receiving our e-mails then please reply with a "REMOVE" in the subject line at rem...@okayainc.com <rem...@okayainfo.com> and mention all the e-mail addresses to be removed with any e-mail addresses, which might be diverting the e mails to you. We are sorry for the inconvenience. *Disclaimer:* We respect your Online Privacy. This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. If you are not interested in receiving our e-mails then please reply with a "REMOVE" in the subject line at rem...@okayainc.com <rem...@okayainfo.com> and mention all the e-mail addresses to be removed with any e-mail addresses, which might be diverting the e mails to you. We are sorry for the inconvenience. -- You received this message because you are subscribed to the Google Groups "Oracle Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to oracle-users+unsubscr...@googlegroups.com. To post to this group, send email to oracle-users@googlegroups.com. Visit this group at https://groups.google.com/group/oracle-users. For more options, visit https://groups.google.com/d/optout.