Send me more jobs like this

ETL & Data Warehouse Support Specialist

Keywords / Skills : SSIS, SQL Server, SSRS , penta ho, BI tools

4 - 6 years
Posted: 2017-12-08

Nationality
India
Industry
IT/ Computers - Software
Function
IT
Role
Datawarehousing Consultants
Education
BCA, B.E/B.Tech, MCA, M.E/M.Tech/MS
Stream:
• Computers
• Any
Posted On
8th Dec 2017
Job Description
Key Responsibilities
• Running/monitoring ETL jobs in multiple environments

• Providing level-2 troubleshooting analysis for failed ETL jobs

• troubleshoot the reasons for a job failure

• Creating star & snowflake schema data models, performing ETLs and validating results with business representatives

• Provide support to all MOLAP and ROLAP.

• Supporting implemented BI solutions by: monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance and communicating functional and technical issues.

Knowledge Skill & Ability required to execute the role 
• 4-5 years of experience in L2 Support

• Running/monitoring ETL jobs in multiple environments

• Providing level-2 troubleshooting analysis for failed ETL jobs

• Must have a sound understanding of BI best practices, relational structures, and dimensional data modeling, structured query language (SQL) skills, data warehouse and reporting techniques.

• Ability to troubleshoot the reasons for a job failure

• Hands-on experience providing end-user support in a high availability

• ETL application experience preferred

• Good in SQL queries, SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)

• Good to have knowledge of “Halo BI”

• Willingness and ability to learn quickly new BI Tool e.g. PentaHO, Halo BI, PowerBI, Tableau etc...

• Strong understanding of Data Warehousing Concepts

• Excellent verbal and written communication skills (English)

• Must be able to work well within a team and take ownership to the work assigned.

• Should be ready to work in shifts, work off-hours and occasional weekends



About Company

Pyramid serves companies in North America, Europe, and Asia. We’re based in metropolitan Atlanta, Georgia, with additional offices in New Jersey, Virginia, and the Carolinas; as well as in Middlesex, England. Our wholly owned, fully equipped development centers are in Noida and Hyderabad, India. Among our numerous awards and rankings on top business lists, we are honored to have been named National Supplier of the Year by the National Minority Supplier Development Council. Its a CMMi Level 3 Certified Offshore centerGMSDC- Supplier of the Year (Class IV) - 2008 Deloitte - Technology Fast 50 in Georgia - 2006, 2007 | ABC - Georgia Fast 50 Pacesetters Award - 2005, 2006, 2007, 2008.

URL :- http://www.pyramidci.com
Career Advice to Find Better

What can I do when my salary history makes me really expensive in my current job market? I dont want to take a huge salary cut, but I am not having success interviewing.
Ironically, years of experience or having valuable expertise can sometimes put you in a tough spot and leave you feeling frustrated and discouraged. You cannot control where

Similar Jobs
View All Similar Jobs




Walkin for you