Key Skills: MSBI, SSIS SSRS, Ms Sql, SQL Certified Developer
Roles and Responsibilities:
- Developing projects from a detailed business requirements, working through solutions and managing execution and rollout of these solutions, in the context of an overall consistent global platform
- Understand business requirements.
- Create T SQL queries/stored Procedures/Functions/Triggers using SQL Server 2014 and 2017 or higher.
- Understand basic data warehousing concepts.
- Design/Develop SSIS packages to pull data from various source systems and load to target tables.
- May be required to develop Dashboards and Reports using SSRS
- Work on BAU JIRAs and also do some levels of L3 support related activities whenever required.
- Providing detailed analysis and documentation of processes and flows where necessary
Skills Required:
Microsoft SQL Server, SSIS, SSRS, Autosys
- Highly motivated, Needs minimal hand holding, Ability to multitask and work under pressure
- Strong Analytical and Problem solving skills; ability to analyze data for trends and quality checking
- Good to have: Talend , Github Knowledge
Knowledge/Experience:
- 6+ yrs. of overall IT experience
- Strong knowledge of database fundamentals and advanced concepts, ability to write efficient SQL, tune existing SQL
- 2+ yrs. experience in any ETL tool, preferably SSIS
- Experience with a reporting tool (e.g. SSRS, QlikView) is a plus
- Experience with a job scheduling tool (e.g. Autosys)
- Experience in Finance Industry a plus
- Experience with all phases of Software Development Life Cycle
Education: Bachelor's degree/University degree or equivalent experience
Apply NowShare this Job