Data Engineer

Job Description

Siemens founded the new business unit Siemens Advanta (formerly known as Siemens IoT Services) on April 1, 2019, with its headquarter in Munich, Germany. It has been crafted to unlock the digital future of its clients by offering end-to-end support on their outstanding digitalization journey. Siemens Advanta is a strategic advisor and a trusted implementation partner in digital transformation and industrial IoT with a global network of more than 8000 employees in 10 countries and 21 offices. Highly skilled and experienced specialists offer services that range from consulting to craft & prototyping to solution & implementation and operation – everything out of one hand!
Technology advances every day. Information Technology is crucial to our future. As part of our IT R & D team, you’ll get the chance to build extensive IT digital systems, develop plans for using cloud technologies, and create industrial data analytics platforms. Your work will benefit everyone at Siemens business entities. If you are determined to take us further with innovative IT solutions that keep our world connected and businesses moving forward, then there’s a place for you at Siemens Energy.
This is your role. What part will you play?
• 6+ years of hands-on industry experience on designing and developing complex ETL programs
• Derive ETL requirements and specification, provide feasibility analysis and effort estimation
• Data Engineering and Analytics, Building Data Pipelines, Implementing algorithms in a distributed environment
• Create automated ETL pipelines for a wide variety of data sources.
• Understand business requirements and create Data models and ETL programs
• Analyze & translate functional specifications & change requests into technical specifications
• Triage the Production issues and work on the code fixes
• Work with the deployment team in the code migration across the environments
• Support QE on End-to-End testing and provide daily/weekly project status to the Project manager
• Create vital documentation as per the Standards and Update the project documentation
• Technical reviews, Data validation & end to end testing of ETL Objects, Source data analysis and data profiling
• Ensure accuracy & integrity of data & applications through analysis, coding, writing clear documentation & problem resolution
• Performance improvement & tuning of Matillion mappings
• Coach and guide the technical team on the development of ETL jobs
• Design the Logical and Physical data models using the Dimensional modelling techniques
• Handle multiple projects in parallel, Participate and deliver Solution design, working closely with the architecture team
• Should write Unit test cases and maintain code quality extremely well
• Collaborate with team as well as with all the stakeholders, highly proactive and team
• Responsible for the accurate translation of software architecture into design and code
• Work on Agile/Lean development methods using Scrum/Kanban
• Strong problem-solving and interpersonal skills
We’ve got quite a lot to offer. How about you?
Mandatory and strong hands-on experience:
• Develop, construct, test and maintain ETL/ELT architectures
• Expert in Matillion (or cloud ELT/ETL tool) , Alteryx
• Strong working knowledge in Databases  Snowflake/Redshift
• AWS (Lambda, ECS, EC2, S3, cloud watch)
• Expert in writing SQL
• Programming skills in Python, Unix
• GIT, Jira (Agile)
• AWS experience with cloud ETL/ELTs
• Good in code deployment and migration
• Expert in data warehousing and data modelling concepts
Good to Have:
• Custom ETL workflow experience in variety of environment
• Working experience in Agile methodologies
• Strong knowledge and experience in AWS technologies
• Experience with distributed data/computing tools: Map/Reduce, Hadoop, Hive, Spark, MySQL, etc.
• Experience in Finance Domain data
• Data security and handling
Make your mark in our exciting world at Siemens.
This role is in Gurgaon, where you’ll get the chance to work with teams impacting entire cities, countries – and the craft of things to come.
We’re Siemens. A collection of over 379,000 minds building the future, one day at a time in over 200 countries. We're dedicated to equality, and we encourage applications that reflect the diversity of the communities we work in. All employment decisions at Siemens are based on qualifications, merit and business need. Bring your curiosity and creativity and help us craft tomorrow.
We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.
At Siemens we are always challenging ourselves to build a better future. We need the most innovative and diverse Digital Minds to develop tomorrow ‘s reality. Find out more about the Digital world of Siemens here:
Find out more about Siemens Advanta at:

Organization: Advanta

Company: Siemens Technology and Services Private Limited

Experience Level: Mid-level Professional

Full / Part time: Full-time

Can't find what you are looking for?