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
Artificial Intelligence • Cloud • HR Tech • Information Technology • Productivity • Software • Automation
The role involves building partner practices, managing partner ecosystems, generating new business, and executing growth plans aligned with ServiceNow's goals while collaborating with marketing teams for demand generation.
Top Skills:
AIMarketing ToolsPartner ManagementServicenow Platform
Big Data • Food • Hardware • Machine Learning • Retail • Automation • Manufacturing
As a TTF India Graduate Intern at Mondelēz, you will experience a supportive environment to grow, take on new challenges, and contribute to various areas in snack production and development.
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
As an AVP - Finance Data Quality, you will support data services for Finance regarding compliance and risk management, collaborate with IT and business stakeholders, and document data processes.
Top Skills:
AlteryxConfluenceExcelMicrosoft PowerpointMicrosoft VisioPythonQlik SenseRational Team ConcertSASSQLTableauVBA
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.



