Overview:
Job DescriptionJob Description- Design and Develop ETL Processes: Create and manage ETL workflows to extract data from various sources, transform it into the required format, and load it into target databases or data warehouses.- Data Integration: Consolidate data from multiple sources, ensuring data quality, accuracy, and consistency.- Performance Optimization: Analyze and enhance system performance, troubleshoot and debug data and system issues.- Data Modeling: Design and implement data models to support data integration and analysis.- Automation: Automate ETL workflows to improve efficiency and reduce errors.- Collaboration: Work closely with data analysts, data scientists, and other stakeholders to understand data requirements and ensure data quality.- Documentation: Document ETL processes, data flows, and system architecture.Required Skills:- Technical Proficiency: Strong knowledge of SQL, ETL frameworks, data modeling, and data warehousing.- Programming Languages: Proficiency in programming languages such as Python, Javascript, Shell Scripting, Java, or Scala.- Tools and Technologies: Experience with ETL tools like Informatica, Tableau, Talend, Dell Bhoomi, AWS glue or Apache NiFi etc (Any ETL tool(Ex: Informatica) exp is considered)Nice to Have:Pentaho ETL, ELT and any cloud (AWS, GCP or Azure)