ETL Developer

Required Skills:

• Work in coordination with a data architect to design and create data warehouses and marts.
• Prepare necessary queries and procedures to transform and move data from Data Lake -> Warehouse -> Marts.
• Schedule automated execution of scripts to keep the warehouse marts up to date.
• Skills Required: T-SQL or PL/SQL development.

Key Responsibilities:

• Ascertain the organization s data storage requirements and understand your data sources.
• Come up with the best strategy for best data extraction, suited to your organization.
• Handle data modeling, data warehouse architecture, data pipeline management, and ETL testing.
• Utilize various data warehousing fundamentals for setting up a data warehouse.
• Help to collect, manage, and analyze huge volumes of data for extraction, transformation, and loading.
• Implement database structure, data marts, data stores, and data lakes.
• Ensure high-end security and good quality of data.
• Come up with robust data flow models for the applications.
• Transforms data requirements into functional mapping designs.
• Safeguard proper functioning of data once the transfer is done.
• Seamless collaboration with data management teams on giving required data.
• Testing the warehouse infrastructure/storage system prior to data extraction.
• Offer regular maintenance support.
• Administering ETL tools, app integration, performance tuning.
• Working on technical/functional documentation.
• Monitor pre-decided ETL jobs and ensure resolution of discrepancies.