DATA ENGINEERS- SQL DEVELOPERS - Cranbury New Jersey

Company: Mindsys Inc.
Location: Cranbury, New Jersey
Posted On: 05/02/2025

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

Qualifications, skills, and all relevant experience needed for this role can be found in the full description below.

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 More...

Register an account with us and set up job agents! We'll email you immediately when jobs like this are posted on our site.