Roles and Responsibilities
- 3+ years of professional IT experience
- Build data systems and pipelines.
- Experience in designing and building databases in MS SQL Server
- Architect, develop, and provide production support for complex SSIS packages.
- Support the continued evolution of the data warehouse by creating tables, indexes, views, indexed views, functions, triggers, stored procedures, and tuning complex SQL queries.
- Skilled in data modeling building warehouse designs and OLAP systems
- Write automation scripts for scheduling the SQL queries.
- Provides production support as required to ensure the availability and performance of enterprise data and BI environments for both external and internal users.
- Conducts code reviews of ETL and SQL processes.
- Hands-on experience with SQL database design & SSIS Packages.
- Technical expertise with data modeling, data mining, and segmentation techniques.
Working with the development team to create conceptual data models and data flows
Mandatory Technical / Functional Skills:
- Strong SQL Skills
- SSIS
- Data Modelling
Would be an added advantage: -
- Experience with ETL technology like Informatica and Pentaho
Operation Skills:-
- Good Business Communication with customer facing role