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
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Develop and maintain full stack applications integrating AI models and financial datasets. Collaborate with teams to deliver secure, responsive web applications using modern technologies.
Top Skills:
Amazon NeptuneAWSDjangoDockerFastapiFlaskGitGithub ActionsJenkinsKubernetesMongoDBNeo4JNode.jsPostgresPythonReactReduxTailwindTypescript
Cloud • Information Technology • Security • Software • Cybersecurity
Manage field marketing strategies to boost awareness and demand for Zscaler while collaborating with sales and cross-functional teams.
Top Skills:
Ai Productivity ToolsGoogle SuiteSalesforce
Artificial Intelligence • Fintech • Payments • Business Intelligence • Financial Services • Generative AI
Provide IT support for Airwallex employees both on-site and remotely, troubleshoot hardware and software issues, facilitate new hire onboarding, and document processes.
Top Skills:
ConfluenceGoogle WorkspaceJIRAmacOSOktaSlackWindowsZoom
What you need to know about the Mumbai Tech Scene
From haggling for the best price at Chor Bazaar to the bustle of Crawford Market, the energy of Mumbai's traditional markets is a key part of the city's charm. And while these markets will always have their place, the city also boasts a thriving e-commerce scene, ranking among the largest in the region. Driven by online sales in everything from snacks to licensed sports merchandise to children's apparel, the local industry is worth billions, with companies actively recruiting to meet the demands of continued growth.



