LTIMindtree
Location
Delhi | India
Job description
Primary Skill -
DBT Secondary Skill – Informatica, Yellow brick, SQL, Shell scripts Client Interview – Yes / No: No Total Exp – 5+ Notice Period – 30 days or less Job Location – Are we flexible for other locations ? Flexible DBT ---- Core Responsibilities Data Modeling and Warehouse Design: Design and maintain robust data models using DBT. Develop and optimize data warehouse schema design for better performance and scalability. ETL Development and Optimization: Develop, test, and maintain ETL processes using Informatica to ensure efficient data extraction, transformation, and loading. Implement best practices in ETL processes for data integrity and efficiency. Optimize ETL workflows for performance and reliability. Data Transformation: Leverage DBT for transforming large-scale data sets in the data warehouse environment. Write complex SQL queries for data transformation and aggregation. Ensure that data transformation logic aligns with business requirements and data governance standards. Data Pipeline Management: Build and maintain data pipelines using DBT and Informatica. Automate data pipeline processes to streamline data flow and improve data quality. Monitor and troubleshoot data pipeline issues. Data Quality and Governance: Implement data quality checks within the ETL and DBT processes. Ensure adherence to data governance and compliance standards. Testing and Documentation: Conduct thorough testing of ETL processes and data transformations to ensure accuracy and completeness of data. Document ETL processes, DBT models, and data transformation logic for future reference and compliance. Performance Tuning: Optimize SQL queries and Informatica workflows for performance. Tune DBT models for efficient execution in the data warehouse environment. Additional Skills Proficiency in SQL and experience with scripting languages (Python, Bash). Experience with version control systems like Git. Strong analytical and problem-solving skills. Excellent communication and teamwork abilities. Technical Skills ---------------- DBT Informatica SQL Queries Python/Bash scritsJob tags
Salary
