• Data Architect

Location Karnataka Bangalore
Experience Range 10 - 15 Years
Open

Skills ssis MS SQL Lead
Job Description
About Us
EVRY India and EVRY USA are wholly owned subsidiaries of TietoEVRY, a leading digital services and software company headquartered in Finland with annual revenues of around USD 3.3 billion. TietoEVRY employs around 24,000 experts globally and is recognized as the #1 IT services and #1 financial services company in the Nordics. TietoEVRY serves thousands of enterprises and public sector customers in more than 90 countries. We foster a culture of continuous learning and focus on helping our customers in accelerating their digital journey to scale business advantage. Be it talent, speed to market, innovation, or cross-pollination of ideas across markets, TietoEVRY leverages USA and India operations to compete locally as well as globally.
About EVRY USA
NA
Roles and Responsibility

Min 10+ yrs exp

Job description: -

Technical Experience

?           Hands-on experience in design and implementation of Data Warehousing solutions

?            Have built at least two Enterprise Data Warehouses from scratch

?            Must possess complete hands-on experience in anyone RDBMS such as SQL Server / Oracle

?            Knowledge on Columnar databases such as Microsoft Azure SQL Data Warehouse, Amazon Redshift, Vertica, GreenPlum, Snowflake etc.

?            Strong knowledge on SQL and procedural languages such as T-SQL, PL/SQL etc

?            Hands-on experience on any of the ETL Tools such as SSIS,IBM Data Stage, etc

?            Good exposure on cloud based ETL and Database services on Azure

?            Fair knowledge on NoSQL databases such as MongoDB, HBase, Cassandra etc.

 

Designing Skills

?            Must have hands-on experience of relational and dimensional modelling

?            In depth knowledge on at least one designing / modeling tool such as ERwin, ER Studio, Power Designer, etc.

?            Must have experience in understanding business vision to prepare ETL solution architecture

?            Well experienced in designing ETL/ELT approaches while authoring the data flows

?            Identifying solutions to key technical challenges in projects concerning data warehousing and business intelligence

 

Communication Skills

?            Must have very good oral and written communication skills

?            Must have experience in presenting technical topics to large audiences

 

 

Preferred Skills & Technical Skills

?            Exposure to conducting maturity assessments of existing data warehousing / ETL solutions

?            Exposure to Data Governance best practices

?            Fair Knowledge on Microsoft SQL Server Analysis Services, SSAS

?            Fair Knowledge on Azure Data Factory(ADF) Data Integration Service

?            Fair Knowledge on Hadoop technologies (Cloudera / Hortonworks)

?            Exposure to BI / Visualization solutions using tools such as SSRS / Tableau / Power BI

?            Fair knowledge on scripting languages such as Shell Scripts, PowerShell, Perl, Python etc

 

Recruiter Name Mahesh
Recruiter Email Id mahesh.mohanraju@evry.com
A+| A| A-