Software Developer with ETL and AWS

Posted Yesterday
Be an Early Applicant
Bangalore, Bengaluru Urban, Karnataka, IND
In-Office
Expert/Leader
Information Technology • Consulting
The Role
Build and support ETL solutions across on-premises and AWS environments using DataStage, Informatica, Python, Perl, Shell, and PySpark. Design data pipelines, APIs, and full-stack applications; validate data quality; automate workflows; troubleshoot production issues; document systems; and ensure security and compliance. Collaborate with analysts and architects on data integration, reporting, and business requirements while participating in code reviews and Agile development.
Summary Generated by Built In

This position requires a hands-on developer who can build new ETL solutions if necessary, thoroughly understand all existing on-premises ETL jobs, and serve as an expert to guide the team. Key responsibilities include job execution, data validation, ensuring data quality, and adherence to data compliance and business rules. The role also encompasses understanding AWS infrastructure-as-code orchestrating and validating jobs, and providing comprehensive production support. Candidates must possess technical development expertise and a strong background in data analytics

Responsibilities
  • Leverage development experience with DataStage or Informatica, Korn Shell, Python, and Perl scripting on Unix/Linux platforms.
  • Be able to design, develop, and implement ETL Glue PySpark processes to extract, transform, and load data from various sources into AWS cloud-based data warehouses and data lakes, specifically Redshift and Aurora PostgreSQL.
  • Be able to develop scalable and efficient full-stack applications, including both front-end and back-end components or APIs, as required.
  • Conduct business analysis and perform data analysis/ validation to minimize errors and inconsistencies, extract meaningful insights, and support business decision-making throughout the software development lifecycle.
  • Collaborate closely with data analysts, data architects, and other team members to analyze source data, enhance data accuracy and integrity, implement data reporting, and understand data and application requirements to deliver effective solutions.
  • Automate and orchestrate ETL processes, applications, and APIs to optimize performance and scalability across cloud environments.
  • Proactively provide production support, including monitoring, troubleshooting, and resolving issues for ETL processes, configurations, and data integrity.
  • Develop comprehensive documentation covering overall processes, data mappings, data flows, APIs, application code, and support procedures.
  • Perform impact analysis and effectively communicate technical processes and concepts to larger audiences.
  • Ensure data and application security and compliance with all relevant data protection regulations.
  • Participate in code reviews, adhere to best practices, and provide constructive feedback to peers.
  • Stay up to date with the latest industry trends and best practices in the areas of ETL development, full-stack development, data analysis, and cloud technologies.
Qualifications
  • Bachelor’s degree in Computer Science, Information Technology, or a related field.
  • More than 8 years of experience in ETL development, data warehousing, AWS cloud services, and API development.
  • Comprehensive proficiency in all AWS services with a strong understanding of data integration, transformation, and loading processes.
  • Expertise in scripting languages, including DataStage or Informatica, Shell scripting, Perl, and Python.
  • Experience with API development and frameworks such as REST and SOAP.
  • Advanced skills utilizing the AWS cloud platform and services, including AWS Glue, Step Functions, Airflow DAGS, Lambda, S3, EC2, and others.
  • Proficiency in SQL with both on-premises relational databases (such as DB2 on AIX) and AWS databases (such as Amazon RDS, Amazon Aurora PostgreSQL, and Redshift).
  • Experience with version control tools like Git or Bitbucket.
  • Familiarity with implementing Jenkins pipelines and CI/CD processes.
  • Demonstrated experience in data analysis/ validation, utilizing tools such as Excel, Python, and Tableau.
  • AWS certifications and expertise in AI/ML are advantageous.
  • Familiarity with automotive industry knowledge, data warehousing concepts, and adherence to developer best practices.

Experience working within Agile development methodologies

About Us

ABOUT US:

Bristlecone is the leading provider of AI-powered application transformation services for the connected supply chain. We empower our customers with speed, visibility, automation, and resiliency – to thrive on change.

Our transformative solutions in Digital Logistics, Cognitive Manufacturing, Autonomous Planning, Smart Procurement and Digitalization are positioned around key industry pillars and delivered through a comprehensive portfolio of services spanning digital strategy, design and build, and implementation across a range of technology platforms.

Bristlecone is ranked among the top ten leaders in supply chain services by Gartner. We are headquartered in San Jose, California, with locations across North America, Europe and Asia, and over 2,500 consultants. Bristlecone is part of the $19.4 billion Mahindra Group.


EQUAL OPPORTUNITY EMPLOYER:

Bristlecone is an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.


INFORMATION SECURITY RESPONSIBILITIES:

  • Understand and adhere to Information Security policies, guidelines and procedure, practice them for protection of organizational data and Information System.
  • Take part in information security training and act while handling information.
  • Report all suspected security and policy breach to InfoSec team or appropriate authority (CISO).
  • Understand and adhere to the additional information security responsibilities as part of the assigned job role.

Skills Required

  • Bachelor's degree in Computer Science, Information Technology, or a related field
  • More than 8 years of experience in ETL development, data warehousing, AWS cloud services, and API development
  • Proficiency with DataStage or Informatica, Shell scripting, Perl, and Python
  • Experience designing and developing AWS Glue PySpark ETL processes
  • Advanced knowledge of AWS services, including Glue, Step Functions, Airflow DAGs, Lambda, S3, and EC2
  • Experience developing REST and SOAP APIs
  • SQL proficiency with DB2 on AIX, Amazon RDS, Aurora PostgreSQL, and Redshift
  • Experience using Git or Bitbucket for version control
  • Familiarity with Jenkins pipelines and CI/CD processes
  • Experience with data analysis and validation using Excel, Python, and Tableau
  • Experience working within Agile development methodologies
  • Familiarity with automotive industry knowledge and data warehousing concepts
  • AWS certifications
  • Expertise in artificial intelligence and machine learning

Bristlecone Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Bristlecone and has not been reviewed or approved by Bristlecone.

  • Healthcare Strength — Health coverage is described as having improved recently, with core medical, dental, and vision coverage in place for U.S. employees. Health insurance is also characterized positively in several places.
  • Leave & Time Off Breadth — PTO, paid holidays, and WFH flexibility are outlined for U.S. employees, with PTO specifically called out positively. Employer-verified details indicate unlimited PTO for some exempt roles.
  • Wellbeing & Lifestyle Benefits — An employee assistance program (unMute) provides confidential counseling alongside wellness apps and webinars. Additional wellbeing initiatives and company celebrations reinforce lifestyle support.

Bristlecone Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
London
3,058 Employees
Year Founded: 1998

What We Do

Bristlecone is the industry’s largest pure-play supply chain service provider. As the trusted partner for AI-first supply chain transformations, we specialize in empowering customers with tech-enabled solutions for planning, sourcing, and fulfillment. Through our consulting, platforms, and supply chain build and enablement expertise, we help Global 2000 organizations in the life sciences, retail, consumer goods, manufacturing, and high-tech industries drive visibility, resiliency, and efficiency across their supply chain. Guided by a consulting-led approach, we serve as strategic partners to customers throughout their supply chain transformation journey. With comprehensive advisory and implementation capabilities, we offer high-value consulting spanning domains, processes, and change management, ensuring tailored solutions that drive meaningful outcomes for each customer. Bristlecone is headquartered in San Jose, California, with locations across North America, Europe, and Asia. It is part of the Mahindra Group. Learn more at www.bristlecone.com

Similar Jobs

Mondelēz International Logo Mondelēz International

Platform Engineer

Big Data • Food • Hardware • Machine Learning • Retail • Automation • Manufacturing
Remote or Hybrid
India
90000 Employees

Zscaler Logo Zscaler

Account Executive

Cloud • Information Technology • Security • Software • Cybersecurity
Easy Apply
Hybrid
Bangalore, Bengaluru, Karnataka, IND
8697 Employees

BlackRock Logo BlackRock

Managing Director, Global Head of Derived Data

Fintech • Information Technology • Financial Services
In-Office
Bengaluru, Bengaluru Urban, Karnataka, IND
25000 Employees

Zscaler Logo Zscaler

Development Engineer

Cloud • Information Technology • Security • Software • Cybersecurity
Easy Apply
Hybrid
Bangalore, Bengaluru, Karnataka, IND
8697 Employees

Similar Companies Hiring

NODA AI Thumbnail
Artificial Intelligence • Information Technology • Software • Cybersecurity • Defense • Defense Technology
Austin, TX
54 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
567 Employees
RapidScale Thumbnail
Cloud • Information Technology • Consulting
Raleigh, NC
600 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account