Data Integration Engineer

1. 3+ (up till 7 years max) years experience in SSIS packages development, test and deployments.
a. Provide support on projects including designing, maintaining metadata models and complex ETL packages.
b. Troubleshoot/resolve SSIS packages, importing data from files, file operation, tune SSIS packages to ensure accurate and efficient movement of data. Gathering and analysing business requirements: This includes working with business stakeholders to understand their data needs and translating those needs into Power BI solutions.
2. 3+( up till 7 years max) years of SQL development experience on MS SQL Server in designing and implementing database structures: This involves creating tables, views, stored procedures, and other database objects
3. Troubleshooting database issues: This includes identifying and resolving database errors, performance issues, and other problems
4. Experience in Performance Tuning, Query Optimization and constructing dynamic queries.
5. Developing and maintaining database applications: This includes writing SQL queries, creating reports, and developing database-driven applications.
6. Collaborating with other IT professionals: This involves working with developers, system administrators, and other IT professionals to ensure that the database meets the needs of the organization.
7. Good to have hands on experience working Vermillion reporting suite (VRS) which Developing and maintaining reports, designing and developing reports that provide insights into financial data, such as performance reports, risk reports, and compliance report
8. Ensuring data accuracy and consistency: This involves validating data and ensuring that it is accurate and consistent across all reports
9. Perform unit testing/validation Testing
10. Knowledge of Financial Markets or Asset Management domain.
11. Willing to learn new technology. Must have good analytical skills.
12. Must have good communication (verbal, written) skills, able to connect co-ordinate with client.
13. Good to have knowledge in SSRS, Crystal reports or other Reporting tool.
14. Optional knowledge of GIT, JIRA and Control-M.
15. Staying up to date with new technologies: This includes keeping up with the latest trends and developments in financial reporting and applying them to the organizations Vermilion Reporting Suite.