Data Engineer - ETL/SSIS/Datastage
MOURI Tech Foundation
- Location
- Hyderabad, Telangana, India
- Job type
- Full-time
Required skills
- Python
- Azure
- compliance
- data analytics
- data modeling
- data models
- database
- ETL
- Spark
- SQL
- T-SQL
- TSQL
About the role
MOURI Tech Foundation
Website:
mourifoundation.org
Job details:
Job Description
- 3 pm IST to 12 pm IST -Tuesday - Saturday Working
- Hyderabad
Desired Job Attributes
- Proven expertise in architecting robust ETL/ELT pipelines, real-time data integration using Data Stage, and advanced data analytics solutions.
- Design, implement, and maintain data pipelines using DataStage, ensuring efficient processing and analysis of large volumes of data.
- Familiar with the functionality of data stage director and scheduling tools.
- Automate data-related tasks and processes using Data Stage enhancing efficiency and scalability.
- Proficient in SQL query optimization, stored procedure development, and data integration across diverse sources.
- Should be able to debug the jobs in case of failure and good to have experience working in L3 support.
- Develop and optimize T-SQL queries, stored procedures, and functions to support data extraction, transformation, and loading (ETL) processes.
- Implement data governance and quality control measures to ensure the accuracy, completeness, and consistency of data.
- Document data models, processes, and procedures, ensuring knowledge transfer and compliance with best practices.
- Stay up-to-date with emerging technologies and industry trends, evaluating new tools and methodologies to improve data engineering practices.
Required Skills
- At least 4 years of relevant working experience with DataStage.
- Develop robust and scalable data pipelines and workflows on azure with technologies like DataStage
- Proficiency in TSQL query writing in SQL Server.
- Knowledge of data modeling and database design principles.
- Good to have proven experience working with SQL Server Integration Services (SSIS) and SQL Server Management Studio (SSMS).
- Experience in optimizing and tuning ETL processes and SQL queries for performance.
- Excellent problem-solving and analytical skills.
- Strong communication and collaboration skills.
- Strong understanding of data warehousing concepts, ETL best practices, and database administration.
Nice-to-Have Skills
- Experience in SSIS, Data Bricks, Spark, Python
(ref:hirist.tech)
Click on Apply to know more.
This page is fully interactive when JavaScript is enabled. Please enable JavaScript to apply or browse related roles.