Gather and document requirements and develop functional specifications with a focus on ETL and Business Intelligence.
Involve in analyzing data to understand the information stored in different databases and use that knowledge to design ETL processes, transformations, and workflows that meet business needs.
Assist with ETL design, architecture, and technology, and suggest strategies for transitioning to an enterprise data warehouse and data marts.
Design and construct logical and physical data models based on requirements and plan and architect solutions accordingly.
Develop ETL processes, including designing, coding, testing, and migrating them to production environments.
Write and execute test scripts for ETL processes, extracting data from various sources like Oracle, MS SQL Server, flat files, and XML files.
Transform and load data into multiple targets such as MS SQL Server, Oracle database, flat files, and XML files.
Provide support after implementation and address critical and high-priority issues within the defined service level agreements (SLAs).
Requirements: Master's degree in Computer Science, IT, Electrical Engg, Biomedical Engg, Electronics Engg or related.
Any Graduate