Senior ETL Developer: SSIS, Data Warehousing & Quality

JPS Tech Solutions Pvt Ltd; Provo (UT); On-site; USD 90,000 - 120,000; Full time

Job summary

JPS Tech Solutions Pvt Ltd is seeking an experienced ETL Developer with strong SSIS, SQL development, data transformation, and data modeling expertise. You will develop and maintain ETL packages, extract data from multiple sources, and load into SQL data warehouses while ensuring data quality.

Collaborate with business users to translate rules into robust data processes throughout the SDLC. You will design efficient data models, optimize tables, and produce clear technical documentation.

Qualifications

• Experience with SSIS packages across large-scale ETL projects.
• Proven ability to write complex T-SQL and stored procedures.
• Experience analyzing and transforming data from multiple sources.

Responsibilities

• Develop, modify, maintain, and optimize SSIS packages for large-scale data extraction and transformation.
• Extract data from multiple source systems and load it into SQL data warehouses.
• Write complex T-SQL queries, stored procedures, and relational database queries.
• Analyze, profile, manipulate, and validate large volumes of diverse data.
• Identify data quality issues, outliers, abnormal values, and inconsistencies.
• Develop error-checking, troubleshooting, and resolution routines.
• Design and optimize database tables and data models.
• Work with business users to gather requirements and translate business rules into data transformation processes.
• Manage ETL development activities throughout the complete Software Development Life Cycle (SDLC).
• Prepare technical documentation and communicate effectively with customers and stakeholders.

Skills

SSIS

SQL development

Data transformation

Database modeling

Analytical skills

Business writing

Interpersonal skills

Data profiling

Tools

SSIS

SQL Server 2008+

Job description

JPS Tech Solutions Pvt Ltd is seeking an experienced ETL Developer with strong SSIS, SQL development, data transformation, and data modeling expertise. You will develop and maintain ETL packages, extract data from multiple sources, and load into SQL data warehouses while ensuring data quality.

Collaborate with business users to translate rules into robust data processes throughout the SDLC. You will design efficient data models, optimize tables, and produce clear technical documentation.