Posted Aug 27, 2018 5 views
Aricrypta is seeking an SQL/Data Warehouse consultant for a full time position in our Islamabad office. The person will participate in tasks related to developing, fixing and updating tasks related to SQL data warehouse on azure environment.
As a data warehouse consultant, you will have the opportunity to work with famous clients across EU on variety of projects.
Responsibilities:
- Design and develop data warehouse and related structures
- Write stores procedures and functions according to customer needs
- perform ETL related tasks
- Use SSIS and Azure data factory for importing data into tables
- Performance tune queries and stored procedures to keep the database and application optimized
- Collaborate with other team members and customer to understand the requirement and deliver according to the business needs
- Create cubes in SSAS when needed
- Create reports in Power BI if any such need arises
Skills requirements
- a bachelor’s degree in Computer Science, Information Systems, or related field
- Minimum three years experience in data warehousing or related field
- Strong analytical and problem solving skills
- Fast learner to learn new technologies and tools
- 2 to 5 years of experience writing and executing all aspects SQL Server including base SQL, Procedures, Functions, Triggers, etc.
- Knowledge of SQL Tuning, Monitoring, and Performance measurement
- Ability to read, understand, and alter existing SQL when necessary
- Solid understanding of Relational Database Theory
- Excellent verbal and written skills and the ability to thrive in a team environment
Nice to have
- Reporting in Power BI, Qlikview or other related field
- Experience in SSIS or other ETL tool
- Experience with cube development
Benefits
- Market competitive salary
- Medical allowance
- international travel
- Opportunity to work with modern technologies in a challenging environment
Job Details
Aricrypta (PVT) LTD
Our company provides services in Data warehousing, Business Intelligence and Software development. We provide consultancy in BI tools like Microstrategy, Cognos, Business Objects, Qlikview, Tableau and BIRT. We also provide Software development services. We work in .Net, Java, php, drupal and wordpress technologies. At the moment, We have two core business lines. One is consultancy and development and the other line of business is support and operations. Our customers are based across UK, Europe and Canada
What is your Competitive Advantage?
Aqib Irshad
Head of HR, Training & OD
FINCA
Muzammil Baig
Digital Marketing Manager
IT Services Group
Sehrish Azhar
Motivational Speaker & Blogger
Living Upbeat
Zubair Anjum
Business Excellence Specialist
Nestle Pakistan
Ayesha Shaukat
Social Media Marketing Manager
Ivoke
Zohaib Ali
Marketing Manager
Digital Online Devices
Babar Ahmed Khan
Territory Sales Manager
Engro Foods
Mona Sharif
Senior Team Lead
Konext PVT. LTD
Ali Aziz
CEO
Shopistan
Usman Habib
Recruitment & Training Executive
ACS Synergy (Pvt) Ltd.
