DATA ENGINEERS- SQL DEVELOPERS

IT POSITIONS: Cranbury, NJ & various unanticipated locations throughout the U.S.: DATA ENGINEERS: Gthr & anlyz biz rqmts & dvlp strtgs for ETL prcses.

Create TSD, source to target mpng, Trctblty Mtrx & non-functnl rqmt docs.

Dsgn & dvlp Cncptal, Lgcl & Physcl Data mdls.

Implmnt SCD & apply nrmlztn rule to avoid anmals & prfmng SQL prfmnc tuning of long running strd prcdrs.

Prfm efctv Data mdl cratn & vldtn by cmprng Rqmt, STM & data prflng rslts.

Cnvrt ETL tool objs to DB2 & Teradata SQL.

Work on metadata mngmnt for drvng Naming stds.

Invlv in Post prdctn implmnttn suprt.

Skills Req'd: Hadoop, Jenkins, Hive, Oracle, PL/SQL, Erwin, Visio, Teradata, GitHub & Jira.

SQL DEVELOPERS: Gthr user rqmts to bld optmzd SQL scripts, indexes & cmplx queries for data analysis & extraction.

Create & mnge indexes, views, triggers & functns to ensure efcent data mnpltn, prfrmnc optmztn & cnsstncy.

Write, anlyz, revw prgrms u/db wrkflw charts & diags.

Implmnt & estblsh best prctcs for ETL jobs to ensure hgh prfrmnc, rusblty & rstrblty of data prcses.

Skills Req'd: SQL Server, MySQL, SSIS, SSRS, Azure Data Factory, Power BI, C#, Python, GitLab, Bitbucket & TFS.

BOTH JOBS: Bachelor's in Sci, Tech, or Engg (any) w/2 yrs exp in job offered or rltd occup is req'd.

Mail CV to HR Dept.

Mindsys Inc.

1249 S River Rd., Ste 102, Cranbury, NJ 08512