Business Technology Solutions Associate Consultant
ZS
·Today
- Location
- Pune, MH, IN · Gurgaon, HR, IN · Bengaluru, KA, IN
- Type
- Full-time
- Department
- IT
- Seniority
- Entry
- Experience
- 2+ years
- Closing date
- Today
- Source
- iCIMS
Description
Role Description
Location: Pune & Gurugram
Region: India
Category:Technology
Subcategory: Business Technology Solutions
As a Business Technology Solutions Associate Consultant in Technology, you will…
What you’ll do:
- Take ownership of designing, building and unit testing AWS-based data pipelines and data products for your workstream, and drive them to completion on time;
- Translate business and technical requirements into designs for batch and near real-time data flows (for example Redshift data products, DynamoDB-backed stores and event-based publishing);
- Build and optimize ETL/ELT using AWS Glue, Lambda, Python/PySpark and SQL; use Airflow for orchestration and dbt for transformations;
- Build restartable, monitored flows with logging, failure handling, and audit and balance checks;
- Develop and integrate APIs and messaging components (SQS or similar, Mulesoft) as the design requires;
- Apply development best practices (agile delivery in sprints, code reviews, unit and volume testing, embedded QA) to ensure quality and timely delivery;
- Partner with the Tech Lead / Project Lead on task planning, status reporting and issue management;
- Guide and mentor Associates in your pod, and distribute and track tasks across the team;
- Collaborate with onshore and offshore teammates, and with upstream and downstream teams, to support integrated testing;
- Communicate clearly with project and client stakeholders as assigned;
- Bring a continuous improvement mindset and a willingness to learn new areas (cloud services, MDM and pharma data concepts): o Understand the problem statement and requirements, and build solutions using programming languages and AWS data services; o Make timely decisions on approach and technical trade-offs, considering the bigger picture.
What you'll bring:
- Bachelor’s/Master’s degree in Computer Science, MIS, IT or a related discipline;
- 2-4 years of relevant experience on medium to large-scale data solution delivery engagements:
- At least 2 years of hands-on experience with AWS data services (Glue, Lambda, Redshift, S3, DynamoDB)
- Strong Python or PySpark and a deep understanding of SQL
- Experience building ETL/ELT pipelines (Informatica, Talend or SSIS experience is also valued)
- Experience with Airflow and dbt preferred
- Data modelling and data warehousing exposure preferred
- Exposure to event streaming or messaging (SQS, Solace) and API integration (Mulesoft) is a plus
- Pharma or life sciences domain knowledge, and exposure to MDM (for example Reltio), is a plus
- Additional Skills:
- Strong communication skills, both verbal and written, with the ability to structure thoughts logically during discussions and presentations
- Capability to simplify complex concepts into easily understandable frameworks and presentations
- Proficiency in working within a virtual global team environment, contributing to the timely delivery of multiple projects
- Travel to other offices as required to collaborate with clients and internal project teams
- Fluency in English
- Client-first mentality
- Intense work ethic
- Collaborative spirit and problem-solving approach