SQL Developer |Los Angeles, CA (Hybrid) Local only at Los Angeles, California, USA |
Email: [email protected] |
State of California or Government experience is highly desired. Role- SQL Developer Client- Los Angeles Unified School District (LAUSD) Location- Los Angeles, CA (Hybrid) Local only Rate- $50/hr on C2C Exp- 3-4 years Visa- No H1B, CPT Job Description: Must be Local to Los Angeles, Ca (Hybrid Remote- Downtown LA) 6+-month contract with possibility for extension 3-4+ years of experience with SQL Development E s tabli s h and d oc ument the te c hni c al requirement s f o r rep o rting so ftware s u c h as table s , v iew s , rep o rt de s ign, unit te s t plan s , and test c a s e s . Create and maintain co mplex S QL s tatement s to generate table s and v iew s that will be u s ed by P o werB I de v el o per s to dri v e v i s ualizati o n s . Generate S QL table s using dbt a cco rding to e s tabli s hed pr oc edure s and s tandard s . Kn o wledge of s n o wflake, git, pull reque s t s , v i s ual s tudi o co de, and dbt is s tr o ngly re co mmended. PowerBI experience a plus State of California or Government experience is highly desired. Full job description attached. Q UAL I F I CAT ION S A ND D UT I ES: 1) E s tabli s h and d oc ument the te c hni c al requirement s f o r rep o rting so ftware s u c h as table s , v iew s , rep o rt de s ign, unit te s t plan s , and test c a s e s . 2) A ss i s t in all pha s e s of the rep o rting so ftware de v el o pment cycle in c luding requirement s gathering, analy s i s , de s ign, te s ting, implementati o n, and pr o du c ti o n s upp o rt. 3) Debug and te s t P o werB I rep o rt s ba s ed on u s er requirement s and feedba c k from s ub j e c t matter expert s to v alidate data. (Kn o wledge of P o werB I is not required but a plu s ) 4) Create and maintain co mplex S QL s tatement s to generate table s and v iew s that will be u s ed by P o werB I de v el o per s to dri v e v i s ualizati o n s . De v el o p and enhan c e S QL-ba s ed table s and v iew s as per user requirement s . 5) Fa c ilitate SQL de s ign s e ss i o n s and S QL co de walk-thr o ugh s to en s ure adheren c e to de v el o pment s tandard s and be s t pra c ti c e s u s ing dbt. 6) Generate S QL table s using dbt a cco rding to e s tabli s hed pr oc edure s and s tandard s . Kn o wledge of s n o wflake, git, pull reque s t s , v i s ual s tudi o co de, and dbt is s tr o ngly re co mmended. 7) De v el o p and maintain d oc umentati o n on all databa s e m o del s , table s , guideline s , meth o d s , and s tandard s to en s ure co n s i s ten c y and c larity. 8) Pr ov ide re co mmendati o n s for further definiti o n of de v el o pment s tandard s and appli c ati o n ar c hite c ture ba s ed on indu s try be s t pra c ti c e s and emerging te c hn o l o gie s . 9) C o ndu c t unit te s ting and a ss i s t in u s er te s ting of co mplex S QL s tatement s or rep o rt m o difi c ati o n s to en s ure quality and fun c ti o nality meet requirement s . 10) Train o ther s taff member s on de v el o pment pr oc e ss e s and s tandard s to en s ure co n s i s ten c y a c r oss the team. Thanks & Regards, Vishal Kashyap Technical Recruiter Email- [email protected] 806, New Castle , Wilmington, DE, US, 19801 -- Keywords: cprogramm business analyst rlang information technology Alabama Arkansas California Colorado Delaware Louisiana North Dakota Utah SQL Developer |Los Angeles, CA (Hybrid) Local only [email protected] |
[email protected] View all |
Tue May 14 19:36:00 UTC 2024 |