Calibro Corp.
Role Title: ETL Developer
Role Type: Direct Hire
Location: On-Site - Latham, NY (this is a 100% onsite role, no hybrid option)
Role Summary: Responsible for designing, developing, and maintaining ETL processes to extract, transform, and load data from various sources into target databases, data warehouses, or cloud platforms. Ensure data accuracy, optimize performance, and collaborate with team members and stakeholders to support reliable data integration workflows.
Key Responsibilities:
ETL Development: Design, develop, and maintain ETL pipelines from structured and unstructured sources. Implement incremental and full data load strategies. Build reusable components to standardize ETL processes. Data Modeling & Integration:
Develop and optimize data models for data warehouses and operational data stores. Use indexing, partitioning, and other optimization techniques. Data Quality & Validation:
Implement data validation, error handling, and reconciliation processes. Support data governance and compliance initiatives. Performance Tuning:
Monitor ETL job performance and optimize using query tuning and parallel processing. Collaboration:
Work with analysts and business users to understand requirements and translate them into technical solutions. Documentation:
Maintain clear documentation of ETL processes, data flows, and technical specifications. Requirements:
Experience:
Minimum 5 years in ETL using Microsoft stack. Technical Skills:
Advanced SQL/T-SQL, SSIS, Azure Data Factory. Database Knowledge:
Relational and dimensional concepts, database design, query optimization, performance tuning. Data Warehousing:
Dimensional modeling, star schema design. Data Quality:
Data cleansing, validation, and profiling methods. Preferred Tools:
Experience with Informatica, Pentaho, or similar ETL tools.
Calibro Corp. is a professional staffing and services firm specializing in the technology areas of Project Management, Business Analysis, Infrastructure and Development. We offer great benefits to both salaried and hourly employees including medical, dental, vision, 401k with match. Calibro Corp is committed to providing the highest levels of professional services to job seekers and employers. Reach out to our staffing specialists to experience the difference!
Role Summary: Responsible for designing, developing, and maintaining ETL processes to extract, transform, and load data from various sources into target databases, data warehouses, or cloud platforms. Ensure data accuracy, optimize performance, and collaborate with team members and stakeholders to support reliable data integration workflows.
Key Responsibilities:
ETL Development: Design, develop, and maintain ETL pipelines from structured and unstructured sources. Implement incremental and full data load strategies. Build reusable components to standardize ETL processes. Data Modeling & Integration:
Develop and optimize data models for data warehouses and operational data stores. Use indexing, partitioning, and other optimization techniques. Data Quality & Validation:
Implement data validation, error handling, and reconciliation processes. Support data governance and compliance initiatives. Performance Tuning:
Monitor ETL job performance and optimize using query tuning and parallel processing. Collaboration:
Work with analysts and business users to understand requirements and translate them into technical solutions. Documentation:
Maintain clear documentation of ETL processes, data flows, and technical specifications. Requirements:
Experience:
Minimum 5 years in ETL using Microsoft stack. Technical Skills:
Advanced SQL/T-SQL, SSIS, Azure Data Factory. Database Knowledge:
Relational and dimensional concepts, database design, query optimization, performance tuning. Data Warehousing:
Dimensional modeling, star schema design. Data Quality:
Data cleansing, validation, and profiling methods. Preferred Tools:
Experience with Informatica, Pentaho, or similar ETL tools.
Calibro Corp. is a professional staffing and services firm specializing in the technology areas of Project Management, Business Analysis, Infrastructure and Development. We offer great benefits to both salaried and hourly employees including medical, dental, vision, 401k with match. Calibro Corp is committed to providing the highest levels of professional services to job seekers and employers. Reach out to our staffing specialists to experience the difference!