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.