The Role
Responsible for designing, developing, and deploying ETL workflows, optimizing performance, implementing data quality checks, and collaborating with stakeholders. Mentors junior staff and ensures adherence to data governance standards.
Summary Generated by Built In
Huron is a global consultancy that collaborates with clients to drive strategic growth, ignite innovation and navigate constant change. Through a combination of strategy, expertise and creativity, we help clients accelerate operational, digital and cultural transformation, enabling the change they need to own their future.
Join our team as the expert you are now and create your future.
Skilled relationship builders, our Associates are responsible for project work stream delivery, work plan management, analytics, reporting and client interface/presentations. They collaborate with client staff and leadership while managing and mentoring junior Huron staff. Our Associates gain valuable, hands-on consulting experience and world-class training and development…that translates to career growth. Huron is big enough to offer the opportunity and exposure you need for your career growth—but small enough to give you individual attention for your professional development.
We see what’s possible in you and help you achieve it.
Requirements:
- Design, develop, and deploy ETL workflows using Informatica IICS (Cloud Data Integration)
- Build scalable data pipelines integrating multiple data sources (databases, APIs, flat files)
- Implement data transformations, cleansing, and enrichment logic
- Optimize ETL jobs for performance and scalability
- Design and execute test strategies, test cases, and test plans for ETL workflows
- Perform source-to-target data validation and reconciliation
- Develop automated and reusable validation queries/scripts
- Implement and monitor data quality rules and checks
- Identify, log, and track defects; ensure timely resolution
- Collaborate with business analysts, data architects, and stakeholders to understand requirements
- Participate in UAT support, release validation, and production verification
- Ensure adherence to data governance and data quality standards
- Maintain detailed technical and test documentation
- Contribute to continuous improvement of ETL and QA processes
Preferences:
- 4–6 years of experience in ETL development and data testing
- Strong hands-on experience with Informatica IICS (Cloud Data Integration)
- Proficiency in SQL for both development and data validation
- Experience in data warehousing concepts (SCDs, star/snowflake schemas)
- Strong understanding of ETL testing methodologies and QA lifecycle
- Experience with data validation, reconciliation, and profiling techniques
- Familiarity with defect tracking and test management tools
- Strong analytical and problem-solving skills
- Experience with IICS Data Quality (IDQ) or similar tools
- Exposure to test automation frameworks for data pipelines
- Knowledge of Python or scripting for automation and validation
- Familiarity with cloud platforms (AWS, Azure, GCP)
- Experience with modern data warehouses (e.g., Snowflake, Redshift, BigQuery)
- Understanding of CI/CD pipelines in data engineering
- Strong attention to detail with a quality-first mindset
- Ability to manage dual responsibilities across development and QA
- Effective communication and stakeholder collaboration
- Proactive approach to identifying risks and improving processes
- Bachelor’s degree in Computer Science, Information Technology, or related field (or equivalent experience)
Skills Required
- 4-6 years of experience in ETL development and data testing
- Strong hands-on experience with Informatica IICS
- Proficiency in SQL for both development and data validation
- Bachelor's degree in Computer Science, Information Technology, or related field
Huron Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Huron and has not been reviewed or approved by Huron.
-
Retirement Support — Retirement programs include a company 401(k) match positioned as a core element of total rewards, signaling strong long‑term savings support. Company materials and filings describe a competitive match structure with broad availability.
-
Equity Value & Accessibility — An employee stock purchase plan provides company‑matched RSUs on purchased shares and is broadly accessible across the workforce, indicating meaningful equity participation. Company filings outline the plan’s match design and wide eligibility.
-
Leave & Time Off Breadth — Policies emphasize flexible/unlimited PTO, paid holidays, and parental leave with caregiving resources, reflecting expansive time‑off options. Careers and benefits pages present flexibility and time away as core components of the package.
Huron Insights
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Huron is a global consultancy that collaborates with clients to drive strategic growth, ignite innovation and navigate constant change. Through a combination of strategy, expertise and creativity, we help clients accelerate operational, digital and cultural transformation, enabling the change they need to own their future. By embracing diverse perspectives, encouraging new ideas and challenging the status quo, we create sustainable results for the organizations we serve.
