DATA ENGINEERS- SQL DEVELOPERS

Company: Mindsys Inc.
Location: Cranbury
Posted on: April 14, 2025

Job Description:

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

Keywords: Mindsys Inc., Bridgeport , DATA ENGINEERS- SQL DEVELOPERS, Engineering , Cranbury, Connecticut