Senior ETL Developer
About the role
A full-time onshore ETL Developer is needed to support the Elevate Salesforce Integrations project. This role will support Salesforce-to-Workday Student integrations and help deliver backend readiness activities focused on end-to-end testing preparation, including data transmission between Salesforce and Workday.
Responsibilities
- Review and validate approved integration architecture, source-to-target mappings, transformation logic, and business rules for assigned integrations.
- Design and develop ETL pipelines supporting batch and real-time integrations between Salesforce, Workday Student, and related systems.
- Develop extraction logic, transformation rules, staging processes, reconciliation logic, and data quality validation routines.
- Support ETL processing for inbound and outbound integrations, including application data, advisor assignments, advising notes, student data synchronization, and real-time integration requirements.
- Cook up with internal ETL developers and Salesforce technical resources regarding mapping validation, deployment sequencing, defect remediation, and testing support.
- Coordinate with technical work sessions and provide implementation feedback regarding integration feasibility, performance considerations, and data dependencies.
- Execute ETL testing activities, including validation of transformed data, reconciliation against source systems, and defect resolution support.
- Prepare ETL-related Change Request documentation through Jira and coordinate production migration activities.
- Document ETL processes, transformation rules, dependencies, error handling approaches, and operational support requirements.
- Provide knowledge transfer and transition support to internal resources.
- Perform additional ETL and integration-related duties within the scope of the engagement as project needs arise.
Requirements
- Minimum 5 years of hands-on ETL development experience designing, building, testing, and supporting enterprise data integration solutions in a complex environment.
- Demonstrated experience developing and supporting integrations between cloud-based enterprise applications, preferably including Salesforce, Workday, Student Information Systems, or comparable SaaS platforms.
- Proficiency with ETL and data integration technologies, including: Data mapping, Transformation logic, API-based integrations, Batch processing, Real-time integrations, Data quality validation, Reconciliation processes, Error handling frameworks.
- Experience supporting full software development lifecycle activities, including requirements analysis, technical design, testing, deployment, production support, documentation, and knowledge transfer.
- Strong communication and collaboration skills with the ability to work effectively with functional stakeholders, developers, architects, and project teams in a higher education or similarly complex organizational environment.
Qualifications
Preferred qualifications include:
- Experience with Salesforce and Workday integrations.
- Knowledge of SQL and other database query languages.
- Experience with ETL tools such as Talend, Informatica, or SSIS.
- Experience with cloud-based environments and services.
Skills
- Strong analytical and problem-solving skills.
- Excellent communication and collaboration skills.
- Ability to work independently and as part of a team.
- Attention to detail and strong organizational skills.
Benefits
What Makes HTC A Great Place To Build Your Future
HTC Global Services wants you to join our team. Come build new things with us and advance your career. At HTC Global, you’ll collaborate with experts, work alongside clients, and be part of high-performing teams driving success together. You’ll have long-term opportunities to grow your career and develop skills in the latest emerging technologies.
At HTC Global Services, our employees have access to a comprehensive benefits package. Benefits can include Group Health (Medical, Dental, and Vision), Paid Time Off, Paid Holidays, 401(k) matching, Group Life and Disability insurance, Professional Development opportunities, Wellness programs, and a variety of other perks.
Our success as a company is built on inclusion and diversity. HTC Global Services is committed to providing a workplace free from discrimination and harassment, where every employee is treated with dignity and respect. We celebrate differences and believe that diverse cultures, perspectives, and skills drive innovation and success.
HTC is an Equal Opportunity Employer and a proud National Minority Supplier. We seek to empower each individual, fostering an environment where everyone feels valued, included, and respected.
Pay Transparency Tagline
For information on the compensation range and an overview of benefits offered by HTC Global Services, please email compensationrange@htcinc.com. Salary, other compensation, and benefits information shared by HTC are accurate as of the date provided. The disclosed range may vary based on factors such as geographic location, education, relevant experience, certifications, skills, role fit, organizational needs & other factors as applicable. HTC Global Services reserves the right to modify ranges in accordance with governmental, state, and local requirements.