SQL Developer

About the job
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

Database Upgrades: Experience with upgrading and regression testing database versions.
Big Data: Exposure to Big Data technologies like Spark and Hadoop.
Education: BS/MS in Computer Science, Engineering, or a quantitative discipline.
Agile: Experience working with Agile methodologies.

Responsibilities

Design, develop, and maintain reporting and analysis modules using SQL Server, SSAS, and SSRS.
Migrate existing SQL code to ETL pipelines.
Implement and manage automated job scheduling and execution.
Optimize database performance through indexing, partitioning, and other techniques.
Design and optimize data flows across multiple ETL processes.
Build and maintain CI/CD pipelines for database deployments.
Collaborate with cross-functional teams to gather requirements and deliver solutions.
Troubleshoot and resolve database-related issues.