What are the responsibilities and job description for the SQL Developer position at Aloden, Inc.?
SQL Developer ( US Citizen,Greencard Holder,TN Visa,GC EAD,H4-EAD)
Location : Jersey City, NJ 07302 (Hybrid Role)
Candidate Preference : Local to Jersey City, NJ, or nearby areas.
Must-Have Skills & Experience :
- Microsoft SQL Expertise : Extensive experience in Microsoft SQL database programming and development (10 years).
- Reporting & Analysis : 10 years of building Reporting and Analysis modules using Data Marts, SSAS Cubes, and SSRS.
- Microsoft BI Stack : Significant development and integration experience with SSRS, SSIS, SSAS, and Cube (Star Schema).
- ETL Migration : Experience migrating SQL code to ETL tools like SSIS or Informatica.
- Automation : Experience with job scheduling and triggering mechanisms like Autosys.
- Data Optimization : Expertise in data normalization, denormalization, and compression techniques.
- Data Flow Design : Experience designing and optimizing data flows across multiple ETL processes.
- CI / CD : Strong experience with CI / CD pipeline tools like Ansible, Bitbucket, Jenkins, and Datical.
- Database Optimization : Expertise in database optimization using indexing, partitioning, statistics management, and resource utilization analysis.
Desired Skills & Experience :
Responsibilities :