ETL Developer
Posted 1 week ago by Prutech Solutions
Negotiable
Undetermined
Remote
Remote
Summary: The ETL Developer role at PruTech Solutions involves designing, building, and maintaining ETL workflows and SQL Server database solutions to support data migration, integration, and analytics. The position requires hands-on expertise with SQL Server technologies and a strong background in performance tuning and enterprise-scale ETL development. The ideal candidate will collaborate with various teams to ensure data quality and compliance with governance standards. This remote position offers an opportunity to contribute to innovative solutions in a diverse range of industries.
Key Responsibilities:
- Design, develop, and maintain ETL workflows to extract, transform, and load data between heterogeneous systems using SQL Server Integration Services (SSIS).
- Write and optimize complex T-SQL queries, stored procedures, functions, and triggers to support business logic and data processing.
- Collaborate with data architects, analysts, and application teams to write T-SQL queries based on defined data mappings, transformation rules, and integration strategies.
- Implement data quality checks, error handling, and logging within ETL processes.
- Optimize ETL pipelines and queries for high performance and scalability.
- Troubleshoot and resolve issues related to ETL job failures, SQL Server performance, or data integrity.
- Create and maintain documentation for ETL processes, workflows, and database design.
- Ensure compliance with data governance, audit, and security standards.
Key Skills:
- Bachelor's degree in computer science, Information Systems, or a related field.
- 6+ years of experience as a SQL Server Developer, Database Developer, or Database Engineer.
- Strong expertise in SQL Server (T-SQL, query optimization, stored procedures, indexing, partitioning).
- Hands-on experience with SQL Server Management Studio (SSMS) and related tools.
- Solid understanding of relational database design, normalization, and data modeling.
- Familiarity with ETL processes and data integration techniques.
- Strong troubleshooting and analytical skills.
- Excellent communication and teamwork abilities.
Salary (Rate): undetermined
City: undetermined
Country: undetermined
Working Arrangements: remote
IR35 Status: undetermined
Seniority Level: undetermined
Industry: IT
Job Title: ETL Developer
Location: Remote
Company: PruTech Solutions, Inc.
About Us:
Established in 1997, PruTech is committed to innovative problem-solving, solution creation, and fostering strong client partnerships. Serving a diverse array of industries, from government to finance, retail, and manufacturing, PruTech operates from strategic locations including New York City, Washington DC, North Carolina, and boasts a nearshore office in Mexico City and multiple offshore offices in India.
With over two decades of experience in Information Technology and system integration, PruTech offers a comprehensive suite of services to meet evolving technological needs:
- Project-based system integration
- Custom software solutions
- Package implementations
- Consulting and advisory services
- Big data and analytics
- Nearshore and offshore services
At PruTech, we are dedicated to shaping the future of technology and driving success for our clients through innovative solutions and strategic partnerships.
Job Title: ETL Developer
Overview:
We are seeking a highly skilled ETL Developer to design, build, and maintain ETL workflows and SQL Server database solutions that support data migration, integration, and analytics initiatives.
The ideal candidate will have hands-on expertise with SQL Server (T-SQL, SSIS, SSRS/SSAS), along with a strong background in performance tuning, and enterprise-scale ETL development.
Key Responsibilities:
- Design, develop, and maintain ETL workflows to extract, transform, and load data between heterogeneous systems using SQL Server Integration Services (SSIS).
- Write and optimize complex T-SQL queries, stored procedures, functions, and triggers to support business logic and data processing.
- Collaborate with data architects, analysts, and application teams to write T-SQL queries based on define data mappings, transformation rules, and integration strategies.
- Implement data quality checks, error handling, and logging within ETL processes.
- Optimize ETL pipelines and queries for high performance and scalability.
- Troubleshoot and resolve issues related to ETL job failures, SQL Server performance, or data integrity.
- Create and maintain documentation for ETL processes, workflows, and database design.
- Ensure compliance with data governance, audit, and security standards.
Qualifications:
- Bachelor s degree in computer science, Information Systems, or a related field.
- 6+ experience as a SQL Server Developer, Database Developer, or Database Engineer.
- Strong expertise in SQL Server (T-SQL, query optimization, stored procedures, indexing, partitioning).
- Hands-on experience with SQL Server Management Studio (SSMS) and related tools.
- Solid understanding of relational database design, normalization, and data modeling.
- Familiarity with ETL processes and data integration techniques.
- Strong troubleshooting and analytical skills.
- Excellent communication and teamwork abilities.
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, or national origin.