Senior Software Engineer - ETL

Job Location

Bengaluru, Karnataka, India

Published By

WorkGeek

Type of Job

Full Time

Mode of Working

Work from home till Covid

Published Date

29 December 2020, 9:30:00 pm

Role Summary

Senior Software Engineer with 4-8 years of experience in ETL and DWH

Requirements

  • Must Have (Required Skills):

  • Problem Formulation:

  • >Identi fies possible options to address the business problems and must possess good understanding of dimension modelling

  • >Mus t have worked on at least one end to end project using any Cloud Datawarehouse (Azure Synapses, AWS Redshift, Google Big query)

  • >Good to have an understand of POWER BI and integration with any Cloud services l ike Azure or GCP

  • >Experi ence of working with SQL Server, SSIS(Preferred)

  • Applied Business Acumen: Supports the development of business cases and recommendations. Owns

  • delivery of project activity and tasks assigned by others. Supports process updates and changes. Solves business i ssues.

  • Data Transformation/Integration/Optimization:

  • >The ETL developer i s responsible for designing and creating the Data warehouse and all related data extraction, transformation and load of data function in the company

  • >The developer should provide the oversight and planning of data models, database structural design and deployment and work closely with the data architect and Business analyst

  • >Duti es include working in a cross functional software development teams (Business analyst, Testers, Developers) following agile ceremonies and development practices.

  • >The developer plays a key role in contributing to the design, evaluation, selection, implementation and support of databases solution.

  • Development and Testing:

  • >Devel ops codes for the required solution by determining the appropriate approach and leveraging business, technical, and data requirements. >Minimum 4-8 years of software development experience

  • >Ba chelor's and/or Master’s degree in computer science

  • >Del ivered DW-ETL projects in any of the Cloud platforms (AWS / Azure / GCP)

  • >Experi ence in delivering projects in a highly collaborative delivery model with teams at onsite and offshore

  • >Excel lent analytical and problem-solving skills

  • >Succes sfully delivered large scale data management initiatives covering Plan, Design, Build and Deploy phases leveraging different delivery methodologies including Agile Data warehouse design techniques, Data modeling, ETL tools (e.g. Informatica), SQL, Scripting Language, Power BI, Good Knowledge in any one Cloud platform (Azure, AWS, GCP) Preferred Skills

  • >Mi nimum 4-8 Years of experience in Data warehouse design and development for large scale application

  • >Mi nimum 3 years of experience with star schema, dimensional modelling and extract transform load (ETL) Design and development

  • >Experti se working with various databases (SQL Server, Oracle)

  • >Experi ence developing Packages, Procedures, Views and triggers

  • >Ni ce to have Big data technologies

  • >The individual must have good written and oral communication skills.

  • >Ni ce to have SSIS Actual Skills Reqd- "Data modeling, ETL tools (e.g. Informatica), SQL, Scripting

  • Language, Power BI, Good Knowledge in any one Cloud platform (Azure, AWS, GCP)"