06 Sep
|
Experion Technologies
|
Kerala
06 Sep
Experion Technologies
Kerala
Job Description / Duties and Responsibilities▪ Design, develop, and maintain scalable ETL/ELT data pipelines using Azure Data Factory and related Azure services.▪ Develop complex and optimized T-SQL queries, stored procedures, views, functions, and database objects in SQL Server.▪ Perform SQL Server database development and administration activities, including performance tuning, troubleshooting, and data integrity management.▪ Build and maintain data integration pipelines connecting multiple source and target systems.▪ Work with Azure data platform services to develop and support cloud-based data solutions.▪ Analyze source systems and changing data structures and adapt data pipelines accordingly.▪ Apply light-to-medium data modeling techniques to support analytical and operational data requirements.▪ Work with large volumes of structured and semi-structured data and ensure efficient data processing.▪ Troubleshoot data pipeline failures, data quality issues, performance problems,
and production incidents.▪ Monitor data pipelines and proactively identify and resolve issues.▪ Collaborate with developers, architects, QA teams, business analysts, and other stakeholders to deliver data solutions.▪ Participate in Agile ceremonies including sprint planning, daily stand-ups, backlog refinement, reviews, and retrospectives.▪ Create and maintain technical documentation covering data flows, mappings, processes, dependencies, and troubleshooting procedures.▪ Participate in code reviews and follow established development, security, and deployment standards.▪ Support production deployments, releases, and operational activities as required. Job Specification / Skills and Competencies▪ 7+ years of experience in Data Engineering, ETL, data integration, or related roles.▪ Solid hands-on experience with Microsoft SQL Server development and administration.▪Advanced knowledge of T-SQL, including:o Complex querieso Stored procedureso Views and functionso Query optimizationo Indexing and
📌 Lead Data Engineer (Kerala)
🏢 Experion Technologies
📍 Kerala