Dataengineer

Job Description:

1. Proven expertise in architecting robust hashtag#ETL/ELT pipelines, real-time data integration using hashtag#DataStage, and advanced data analytics solutions.
2. Design, implement, and maintain data pipelines using hashtag#DataStage, ensuring efficient processing and analysis of large volumes of data.
3. Familiar with the functionality of data DataStage Director and scheduling tools.
4. Automate data-related tasks and processes using DataStage, enhancing efficiency and scalability.
5. Proficient in SQL query optimization, stored procedure development, and data integration across diverse sources.
6. Should be able to debug the jobs in case of failure and good to have experience working in L3 support.
7. Develop and optimize T-SQL queries, stored procedures, and functions to support data extraction, transformation, and loading (ETL) processes.
8. Implement data governance and quality control measures to ensure the accuracy, completeness, and consistency of data.
9. Document data models, processes, and procedures, ensuring knowledge transfer and compliance with best practices.
10. Stay up-to-date with emerging technologies and industry trends, evaluating new tools and methodologies to improve data engineering practices.

Required Skills:
1. Atleast 4 years of relevant working experience with hashtag#Datastage.
2. Develop robust and scalable data pipelines and workflows on hashtag#Azure with technologies like hashtag#Datastage
3. Proficiency in hashtag#TSQL query writing in hashtag#SQLServer.
4. Knowledge of data modeling and database design principles.
5. Good to have proven experience working with SQL Server Integration Services (SSIS) and SQL Server Management Studio (SSMS).
6. Experience in optimizing and tuning hashtag#ETL processes and SQL queries for performance.
7. Excellent problem-solving and analytical skills.
8. Strong communication and collaboration skills.
9. Strong understanding of data warehousing concepts, ETL best practices, and database administration.