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