Design, develop, test, and implement ETL (Extract, Transform, Load) processes to move data from various source systems to the target data warehouse.
Ensure the efficiency, reliability, and scalability of ETL processes.
Data Modeling:
Work closely with data architects and analysts to understand data requirements and translate them into ETL specifications.
Develop and maintain data models for efficient data storage and retrieval.
Data Quality:
Implement data quality checks and validations during the ETL process to ensure accuracy and completeness of data.
Troubleshoot and resolve data quality issues in a timely manner.
Performance Tuning:
Monitor and optimize ETL processes for performance and efficiency.
Identify and resolve bottlenecks and other performance-related issues.
Documentation:
Create and maintain comprehensive documentation for ETL processes, data models, and related workflows.
Keep documentation up-to-date with any changes made to ETL processes.
Collaboration:
Collaborate with cross-functional teams, including data analysts, business analysts, and other stakeholders, to understand data requirements and deliver solutions.
Adherence to Best Practices:
Follow best practices for ETL development and adhere to coding standards.
Stay updated with industry trends and technologies related to ETL.
Qualifications:
Bachelors degree in Computer Science, Information Technology, or a related field.
3 to 5 years of hands-on experience in ETL development.
Proficient in ETL tools such as Informatica, Talend, or similar.
Strong SQL skills and experience working with relational databases.
Understanding of data modeling concepts and techniques.
Knowledge of data warehousing concepts and practices.
Familiarity with scripting languages (e.g., Python, Shell) is a plus.
Excellent problem-solving and troubleshooting skills.
Effective communication skills and ability to work collaboratively in a team.
Contract Duration:
1-2 years, with the possibility of extension based on project requirements.
