SQL Developer

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.