Sr. SQL SERVER Developer with SSIS experience

Rapinno Tech; Dallas (TX); Hybrid; USD 100,000 - 130,000; Full time

Job summary

A leading tech firm in Dallas, Texas is urgently seeking a Sr. SQL SERVER Developer with over 8 years of experience. The role involves SQL Server development, ETL processes using tools like SSIS and Alteryx, and enhancing data reliability and efficiency. Candidates should have expertise in data modeling, big data technologies including Hadoop and Spark, and must be a U.S. citizen or hold eligible visas. This is a long-term contract with a hybrid work model, requiring 2-3 days onsite weekly.

Qualifications

• Minimum 08+ years of experience as a SQL Server Developer.
• Expert knowledge of data warehousing.
• Working understanding of Microsoft VBA, HTML, Python.

Responsibilities

• Identify data sources and build pipelines using various ETL tools such as SSIS and Alteryx.
• Improve data reliability, efficiency, and quality.
• Define data architecture framework, standards, and principles.
• Optimize data models to support business applications.
• Automate workflows to ensure timely delivery.

Skills

SQL Server development

Alteryx Admin/User management

Data modeling

ETL experience

Big data technologies (Hadoop, Hive, Spark)

Data warehousing

Tools

SSIS

Alteryx

Microsoft SQL Server

Teradata

PostgreSQL

Oracle

Job description

Sr. SQL SERVER Developer with SSIS experience

About the job Sr. SQL SERVER Developer with SSIS experience

VERY URGENT AND IMMEDIATE NEED.

Note: Need Only US Citizen, Green Card, EAD-GC, J2 EAD, H4 EAD, L2 EAD, and TN Visa.

Job Title: Sr. SQL SERVER Developer with SSIS experience
Location: Dallas/Hidden Ridge, TX (2-3 days weekly onsite from Day 1)
Duration: Long Term Contract

Job Description:

Need minimum 08+ years of experience SQL Server Developer with SSIS experience

Must Have

• 5+ years of SQL Server development experience.
• 3+ years ALTERYX Admin /User management experience and advance workflow management.
• 5+ years data modeling experience.
• 5+ years of ETL experience.
• 5+ years of experience in working on more than one database technologies Microsoft SQL server, Teradata.
• 2+ years big data experience, Hadoop, Hive, Spark
• Expert knowledge of data warehousing.

Desired Skills

Working understanding of Microsoft VBA, HTML, Python

Responsibilities

• Data acquisition and ingestion - Identify data sources and build pipelines using various ETL tools such as but not limited to, SSIS, and Alteryx. Data sources including but not limited to SQL Server, SAP, Teradata, Hadoop\Hive, PostgreSQL, Oracle and flat files.
• Identifying ways to improve data reliability, efficiency and quality by various data solution techniques.
• Expertise in Alteryx Admin /User management experience , advance workflow management with proper roles and security.
• Assist in defining the data architecture framework, standards and principles, including modeling, metadata, security and reference data.
• Create and optimize data models to support various business applications.
• Reviewing modifications of existing data systems for cross-compatibility.
• Automate and support workflows to ensure timely delivery.