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 at 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)"