Skillset:

ETL Data Warehouse & Data reservoir concepts (mandatory)
MS SQL Server 2016 (mandatory)
One out of the 3 - SSIS, SSRS or Informatica or DataStage (mandatory)
Visual Studio / C# / ASP .Net (nice to have)

Detailed JD:

Data extraction from different sources such as SQL Server, Teradata, flat files, Excel, and XML files into staging, transformation necessary to recast source data for analysis, and loading of transformed data into the presentation repository. It includes the selection criteria to extract data from source systems, perform any necessary data transformations or derivations needed, data quality audits, and cleansing.
Design, develop, and maintain relational databases for data storage and data mining. Create, maintain, and optimize stored procedures, functions, inline SQL, database structures, and ETL processes to adapt to changes in needs and requirements
Perform data warehouse design and testing, including data design, database architecture, metadata, and repository creation.
Design data warehouse schematics, layouts, and capacity planning.
Create and implement effective metrics and monitoring processes.
Develop processes and procedures for entering information into data warehousing systems and for ensuring reliability of information entered.
Seek continuous improvement in performance of data warehouse and ensure security of data.
Considered highly skilled and proficient in discipline.
Experience with defining and following Agile/Scrum project methodology.
Candidate must have thorough knowledge on the technical stack and they should be able to debug the existing code and do enhancements / improvements.
Knowledge on DevOps CI/CD is an added advantage.
Candidate must be willing to learn AWS/Azure and new concepts over the period and must have willingness to share the knowledge across the team.
Excellent communications skills.

ETL Data Warehouse Developer