ETL ENGINEER

Job Title: ETL Engineer Experience: 3 to 5 years Location: Bangalore Contract Duration: 12 years

Job Description:

Responsibilities:

1. ETL Development:

   • 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.

2. 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.

3. 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.

4. Performance Tuning:

   • Monitor and optimize ETL processes for performance and efficiency.
   • Identify and resolve bottlenecks and other performancerelated issues.

5. Documentation:

   • Create and maintain comprehensive documentation for ETL processes data models and related workflows.
   • Keep documentation uptodate with any changes made to ETL processes.

6. Collaboration:

   • Collaborate with crossfunctional teams including data analysts business analysts and other stakeholders to understand data requirements and deliver solutions.

7. 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:

1. Bachelors degree in Computer Science Information Technology or a related field.
2. 3 to 5 years of handson experience in ETL development.
3. Proficient in ETL tools such as Informatica Talend or similar.
4. Strong SQL skills and experience working with relational databases.
5. Understanding of data modeling concepts and techniques.
6. Knowledge of data warehousing concepts and practices.
7. Familiarity with scripting languages (e.g. Python Shell) is a plus.
8. Excellent problemsolving and troubleshooting skills.
9. Effective communication skills and ability to work collaboratively in a team.

Contract Duration: 12 years with the possibility of extension based on project requirements.