Critical Tasks and Expected Contributions/Results :
The role will be primarily focused on the design, development and testing of ETL workflows (using Talend) as well as the batch management and error handling processes. Build Business Intelligence Applications using tools like Power BI.
Additional responsibilities include the documentation of technical specifications and related project artefacts.
Gather requirement and propose possible ETL solutions for in-house designed Data Warehouse - Analyze & translate functional specifications & change requests into technical specifications.
Design and Creating star schema data models
Design, Build and Implement Business Intelligence Solutions using Power BI
Develop, implement & test ETL program logic.
Deployment and support any related issues
Key Competency :
A good understanding of the concepts and best practices of data warehouse ETL design and be able to apply these suitably to solve specific business needs.
Expert knowledge of ETL tool like Talend
Have more than 8 years experience in designing and developing ETL work packages, and be able to demonstrate expertise in ETL tool- Talend
Knowledge of BI tools like Power BI is required
Ability to follow functional ETL specifications and challenge business logic and schema design where appropriate, as well as manage their time effectively.
Exposure to Performance tuning is essential - Good organisational skills.
Methodical and structured approach to design and development.