Job Description
Greetings from TCS
nJob Title: Senior Data Engineer (Azure/SSIS)
nLocation: PAN INDIA
nExperience Range: 7-14 years.
nRequired Skillset:
n
- n
- Minimum 6 yrs of experience in building ETL pipeline using Azure data Factory, Azure Synapsen
- Minimum 6 yrs of ETL development using PL/SQLn
- Exposure in Azure data brick is added advantagen
- Above average communication skilln
- should be willing to work as an individual contributor and experience of managing client delivery independently.n
nJob Description
nMust-Have:
n
- n
- Significant experience in Software Development and Agile Methodologies.n
- Excellent experience in developing ETL routines, processes and structures.n
- Expert in SSIS and Azure Synapse ETL development.n
- Significant experience in developing Python or pySpark.n
- Proven ability to set up Azure Synapse connectors (On-prem file shares, SFTP, SQL database, HTTP, etc..) in real world enterprise environment.n
- Significant experience in Database and Data Storage Platforms including Azure Data Lake.n
- Excellent experience in developing ETL routines, processes and structures.n
- Extensive knowledge of data modelling techniques and structures.n
- Practical experience of developing ETLs for Dimensions and Fact Tables including SCD I and II implementation.n
- Excellent experience of deploying solutions in a quick-moving enterprise.n
- Ability to validate engineering data and deploy solutions. Experience in incident, change management and transition processesn
- Creating data cataloguesn
- Identifying Critical Data Elementsn
- Recording data quality business rulesn
- Carrying our data quality assessmentsn
- Creating data quality assessment scripts & ETLsn
- Creating data quality reportsn
- Designing & implementing Conceptual, Logical, and Physical data modelsn
- Designing & implementing Relational data models with normalisationn
- Designing & implementing Dimensional Data Models (Dimensions, Facts, SCD I, S