Senior Data Engineer - Product Delivery
Johnson Controls · pune, Maharashtra, India
Industrial Machinery Manufacturing · 10,001+ employees
About the role
Design, implement, and manage ETL processes to extract and transform data for reporting and analytics. Collaborate with architects and stakeholders to ensure data quality and optimize process performance.
What they look for
Requirements
Requires a bachelor's degree and 3 to 5 years of experience in ETL development with mandatory expertise in Snowflake and Azure tools. Proficiency in SQL and knowledge of scripting languages like Python are essential.
Benefits
Full description
Job Title: Software Developer – Data Solutions (ETL)
Overview
Johnson Controls is seeking an experienced ETL Developer responsible for designing, implementing, and managing ETL processes. The successful candidate will work closely with data architects, business analysts, and stakeholders to ensure data is extracted, transformed, and loaded accurately and efficiently for reporting and analytics purposes.
Key Responsibilities
- Design, develop, and implement ETL processes to extract data from various sources
- Transform data to meet business requirements and load it into data warehouses or databases
- Optimize ETL processes for performance and reliability
- Collaborate with data architects and analysts to define data requirements and ensure data quality
- Monitor ETL jobs and resolve issues as they arise
- Create and maintain documentation of ETL processes and workflows
- Participate in data modeling and database design
Qualifications
- Bachelor’s degree in computer science, Information Technology, or a related field
- 3 to 5 years of experience as an ETL Developer or similar role
- Strong knowledge of ETL tools – ADF, Synapse. Snowflake experience is mandatory. Multi cloud experience is a plus.
- Proficient in SQL for data manipulation and querying
- Experience with data warehousing concepts and methodologies
- Knowledge of scripting languages (e.g., Python, Shell) is a plus
- Excellent problem-solving skills and attention to detail
- Strong communication skills to collaborate with technical and non-technical stakeholders
- Candidates should be flexible / willing to work across this delivery landscape which includes and not limited to Agile Applications Development, Support and Deployment.
- Expert level experience with Azure Data Lake, Azure Data Factory, Synapse, Azure Blob, Azure Storage Explorer, snowflake, Snowpark.
What we offer
- Competitive salary and a comprehensive benefits package, including health, dental, and retirement plans.
- Opportunities for continuous professional development, training programs, and career advancement within the company.
- A collaborative, innovative, and inclusive work environment that values diversity and encourages creative problem-solving.
