ETL Developer

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

Job Summary

We are seeking an experienced ETL Developer with strong expertise in SQL Server Integration Services (SSIS), SQL development, data transformation, and database modeling. The role involves developing and maintaining ETL packages, extracting data from multiple source systems, transforming and loading data into SQL data warehouses, and ensuring data quality. The candidate will work closely with business users to understand requirements and apply business rules throughout the SDLC.

Key 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.

Required Qualifications

• Minimum 5 years of experience developing, modifying, and optimizing SSIS packages.
• Minimum 5 years of experience with SQL Server 2008 or later.
• Minimum 5 years of experience building SSIS packages using built-in SSIS components.
• Minimum 5 years of experience writing complex T-SQL queries.
• Minimum 5 years of experience analyzing, profiling, and manipulating data from multiple sources.
• Minimum 5 years of experience loading data into SQL data warehouses.
• Minimum 5 years of experience troubleshooting, profiling, and optimizing data.
• Minimum 5 years of experience developing error-checking and resolution routines.
• Minimum 5 years of data modeling and database table optimization experience.
• Minimum 5 years of experience gathering business requirements and applying business rules to data.
• Strong analytical, business writing, communication, and interpersonal skills.

Preferred Qualifications

• Experience working in Agile project environments.
• Experience working with large and diverse datasets, including demographic, personal, and numeric data.

Core Technical Skills

• SQL Server Integration Services (SSIS)
• Microsoft SQL Server 2008 or Later
• T-SQL and Stored Procedures
• ETL Development and Data Transformation
• SQL Data Warehousing
• Data Profiling and Data Quality
• Database Modeling and Table Optimization
• Error Handling and Troubleshooting
• Business Requirements Analysis
• Agile Project Methodologie