SSIS ETL Developer

Shree Narayani Networking Solutions Pvt Ltd; Charlotte (NC); Hybrid; USD 110,000 - 140,000; Full time

Job summary

Shree Narayani Networking Solutions Pvt Ltd is seeking an experienced SSIS ETL Developer for a 12-month contract in Charlotte, NC. The role focuses on building scalable data integration solutions, optimizing SQL Server workloads and ensuring production stability within enterprise platforms.

You will collaborate with CTI, EET, APSE, GIS and Compliance teams to deliver reliable data pipelines, implement observability, and support large nightly batch processing in a hybrid work setup (3 days

Qualifications

• Extensive SQL Server development experience with SSIS-based ETL.
• Strong T-SQL and advanced development skills, incl. stored procedures and UDFs.
• Expertise in query optimization, indexing, and performance tuning.
• Experience with multi-database data integration and large-scale processing.

Responsibilities

• Design, develop and support enterprise ETL and data integration solutions.
• Collaborate with stakeholders to gather requirements for data platforms.
• Monitor and optimize nightly batch processing and data loads.
• Provide production support and issue resolution for data pipelines.
• Implement observability, logging and validation for data flows.

Skills

Advanced T-SQL

Query optimization

Stored procedures

UDFs

Index design

Performance tuning

Data integration

ETL development

SQL Server Administration

Troubleshooting

Tools

SSIS

SQL Server

Oracle

MySQL

PostgreSQL

REST APIs

Flat files

Excel

CI/CD

Job description

This
SSIS ETL Developer job is a
12 Months Contract with a client located in
Charlotte, NC (Hybrid 3 Days onsite every week).

Job Description

Seeking an experienced SQL Server and SSIS Developer to support enterprise data integration, database development, ETL processes, and production support activities for Compliance and Library Platforms within the Luminance team. The candidate will play a key role in the future-state database strategy by designing, developing, and supporting scalable data solutions that enable reliable end-to-end data flow, observability, automation, and operational excellence. The ideal candidate will bring deep expertise in SQL Server development, SSIS-based ETL solutions, database performance optimization, and large-scale data processing. This individual will work closely with technology teams across the organization to implement best practices and ensure the stability, scalability, and efficiency of critical data platforms. The contractor will work with internal customers and stakeholders across CTI, EET, APSE, GIS, and Compliance and Library Platform teams to gather requirements, support production issues, and deliver data integration solutions.

Required Hard Skills

• SQL Server Development (Expert)
• 7+ years of Microsoft SQL Server experience
• Advanced T-SQL development expertise
• Stored Procedures
• User Defined Functions (UDFs)
• Views
• Dynamic SQL
• Complex query development
• Query optimization and performance tuning
• Execution Plan analysis
• Index design and optimization
• Database troubleshooting
• Database Administration and Performance

Knowledge of:

• Blocking and deadlock analysis
• Transaction isolation levels
• Statistics and index maintenance
• Database recovery concepts
• Data integrity validation
• SSIS / ETL Development (Expert)
• 5+ years of SSIS development experience
• Enterprise ETL design and support
• Incremental load strategies
• Logging and auditing frameworks
• Error handling methodologies
• Event Handlers
• Package Configurations
• Deployment and scheduling
• Data Integration Experience

Experience integrating data through:

• SQL Server
• Oracle
• MySQL
• PostgreSQL
• REST APIs
• Flat files
• Excel
• Large Data Processing

Experience with:

• Multi-million row databases
• Large nightly batch processing
• High-volume data ingestion
• Data validation and reconciliation
• Partitioning strategies
• Bulk loading techniques
• Query optimization
• Table maintenance

Required Soft Skills / Behavioral Expectations

• Strong analytical and problem-solving skills.
• Ownership mentality with accountability for results.
• Ability to work independently with minimal supervision.
• Strong communication and stakeholder management capabilities.
• Ability to effectively communicate technical concepts to both technical and non-technical audiences.
• Strong collaboration and teamwork skills.
• Mentorship and knowledge-sharing mindset.
• Adaptability and willingness to learn new technologies.
• Continuous improvement mindset.
• Ability to operate effectively across development, infrastructure, DevOps, and support functions.
• Strong organizational and prioritization skills in a fast-paced environment.

Preferred Skills / Experience

• Experience supporting compliance, governance, or enterprise platform environments.
• Experience implementing observability and monitoring solutions for data platforms.
• Exposure to cloud-based data solutions and modern data engineering practices.
• Experience with DevOps and CI/CD deployment practices.
• Familiarity with automation frameworks and operational support tooling.
• Experience supporting mission-critical production systems.
• Knowledge of enterprise data governance and data quality practices.

Day to Day Responsibility

• Acts as both a developer and a problem solver.
• Quickly identifies root causes and drives issues to resolution.
• Consistently delivers high-quality, supportable solutions.
• Proactively identifies opportunities for automation and process improvement.
• Demonstrates strong ownership from requirements through production support.
• Balances technical excellence with business outcomes.
• Effectively partners with stakeholders and earns trust across teams.
• Can work independently while contributing positively to team success.
• Thrives in complex enterprise environments with high data volumes and multiple integrations.