ETL Developer

Job Description:

We are looking for smart and passionate ETL Developer, who will design and fill a bespoke data warehousing environment for our company

Key Responsibilities

• Overall responsible on the Implementation of the Tasks allocated during the sprint
• Ensure the software is developed confirming the project architecture, coding standards and NFRs
• To analyse the User Requirements, NFRs and Technical requirements for the project
• Identify any unknowns i.e. missing scenarios, etc and consult with PO to ensure those are defined either as a User story or UAC
• Identify ways to implement stories and select the approach that is best suited for the project. Consult with L3 as required
• Break down user stories along with the team to identify technical tasks
• Provide detailed estimates before the start of the sprints. Need to work with the Team to get the estimates
• Proactively pre-plan the sprints to achieve 90+% confidence of delivery
• Create Technical documents as required for the project in Jira, Confluence or other tools
• Provide POs and ADMs with daily updates of the team via Jira and Slack
• Proactively communicate with other members of the team
• Provide HR and Management with any relevant information to help improve organisation culture & performance

Key Skills

• Strong proficiency in SQL
• Expertise in ETL solutions like Informatica, SSIS, Talend
• Understanding of the underlying storage engines and how data is maintained.
• Experience of Data warehousing
• Experience of python
• Familiarity with other SQL/NoSQL databases is a plus
• Experience of Snowflake and Apache airflow
• Proficient understanding of code versioning tools (Git/SVN/SourceSafe)
• Ability to create scripts for automation purposes
• Strong knowledge of Elastic
• Determines data storage needs
• Uses different data warehousing concept to build a data warehouse
• Creates and enhances data solutions enabling seamless delivery of data and is responsible for collecting, parsing, managing, and analyzing large sets of data
• Design develop, automates, and support complex application to extract, transform and load data
• Ensure data quality
• Develops logical and physical data flow models for ETL applications
• Translate data access, transformation, and movement requirement into functional requirements into functional requirements and mapping designs

Education and Experience

• B Tech or B. E. (Computer Science / Information Technology)
• 5- 7 years as a ETL Developer or similar roles

Analytical & Person Skills

• Must have good logical reasoning and analytical skills
• Good Communication skills in English – both written and verbal
• Demonstrate Ownership and Accountability of their work
• Attention to details