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.
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)
Similar Jobs
Cloud • Information Technology • Security • Software
Lead quality efforts for major product areas, define test strategies, write and maintain complex automated tests, enable developers to shift testing left, participate in incident reviews and root-cause analysis, mentor junior QEs, and ensure releases meet reliability, performance, and security standards while partnering with architects and development leads.
Top Skills:
Ci/CdJavaScriptPlaywrightPytestPythonTypescript
Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
Lead clinical trial disclosure strategy and operations for Pfizer-sponsored interventional trials. Ensure timely, compliant posting of protocols, SAPs, CSRs, and clinical summaries per EMA Policy 70 and other regulations. Manage vendors, develop processes and technical solutions, represent Medical Writing on governance committees, and maintain regulatory knowledge and best practices to drive quality and consistency across disclosures.
Artificial Intelligence • Fintech • Hardware • Information Technology • Sales • Software • Transportation
Own and roadmap fleet management product experiences for dispatchers, operators, and drivers. Translate customer pain into web and mobile workflows, define metrics, run betas, work with data scientists to build AI features from sensor data, and collaborate cross-functionally while gathering field feedback.
Top Skills:
AIAutomotive SystemsIndustrial IotSQLTelematics
What you need to know about the Pune Tech Scene
Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.
