We are urgently looking for full time Data Architect/ Data Warehouse Developer.
Location: Mumbai
Exp required: 3-5 years
Requirements:
1. Bachelor’s Degree in Computer Science/ Information Systems/ Mathematics/ Statistics/ Finance/ Business, related field or equivalent working experience.
2. 3-5 years working experience with Data modelling, SQL, ETL and Data Warehousing. Experience on Data Modelling tools like Toad and Erwin is a must.
3. Expert in writing SQL scripts and knowledge of MySQL 5.6+ and SQL Server 2012+ databases or any other relational Database
4. Experience with enterprise-class Business Intelligence tools such as Micro strategy, Tableau, Oracle BI, Sales Force etc.
5. Experience in Microsoft SQL Azure and Talend is preferred
6. Experience with Big Data Analytics: ETL, in-stream processing, batch processing, map-reduce, querying, workflows and query optimization, knowledge of No SQL Databases , ability to deal with structured and unstructured data in Hadoop is preferred
7. Excellent verbal/written communication & data presentation skills, including ability to succinctly summarize key findings and effectively communicate with client. Ability to balance and prioritize multiple conflicting requirements with high attention to detail.
Responsibilities:
The individual should be able to :
1. Plan, deploy, and manage our logical data architecture, working with the Systems Architect to implement the data architecture across all core business systems
2. Be able to understand and document business requirements, and convert that to a suitable enterprise data architecture solutions.
3. Design, develop, and maintain appropriate and scalable enterprise data architectures, utilizing best practices and concepts
4. Design, develop, and implement appropriate database schemas to support the architecture
5. Should be able to design and review ETL routines
6. Should be able to create Analytical Reports and Standard Dashboards using Tableau , Sales Force etc.
Hello,
I have been working with a MNC based company since last ~ 5 years, as an IT BI DWH Professional.
The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped me in nourishing my talent in all the technologies around these 3 layers.
Below are some key areas of my skills:
• Expert in SQL Server, Oracle and MS Access Databases
• Expert in BO XI, Cognos and SQL Server Reporting Service (SSRS)
• Expert in & designing & Implementation of end to end ETL Process using Informatica & SSIS Tools
• Expert in Designing Qlikview Dashboard BI Solution
• Expert in ER & Dimension Data modeling
• Complete Command on PL/SQL concept e.g. Procedures, Functions, packages and complex queries.
• Basic knowledge of Unix Shell scripting
• Web Development using Java, CSS, and HTML ,PHP & Java Script
• Expert in excel Macro
• Expert in C & C ++ Programming
I have experience in all the above areas and during my project work I have completed all of the above tasks.
As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. I had conducted Informatica & DWH training for a US based training organization from Nov’14 to Dec’14.
We recently started our own company “Point5Nyble Your Needs, Our Dream”.
We always work to provide Best Delivery with 100 % customer satisfaction
Would be looking forward to work on this opportunity and will ensure to deliver best.
Regards,
Ashish-Point5Nyble
Hi,
- I have extensive experience (4 years) as a Data Warehouse developer working in several Business Intelligence projects.
- Expertise in the design, implementation and maintenance of ETL processes (Extracting, Cleaning and Conforming, Delivering, Managing components) using open source tools ‘Talend for Data Integration.’ and 'Talend for Big Data.'
- Hands-on experience developing Talend jobs that connect to Hadoop cluster (CDH/MapR), load source text files into HDFS, and then create target HIVE tables and build aggregates using Hive components. Exposure to Spark streaming using Talend as well.
- Proven skills in Transact-SQL as a server-side programming language developing core business logic in the form of stored procedures, functions and triggers running in the back-end of both business applications and business intelligence solutions.
- Working experience with Tableau software both as a data provider and data consumer designing dashboards.
- My most recent job experience involved the architecture and development of an end to end Business Intelligence solution tailored to the Australian hardware retail market, which was deployed to the Microsoft Azure cloud.
Look forward to hearing from you.
Kind regards,
Yordan B
I am a hands-on, highly competent software engineer with 3 years’ experience designing, programming and testing software across a variety of platforms. I have worked on numerous projects from concept to completion. A specialist in PHP, SQL and Java, I take pride in coding to consistently high standards and regularly refresh my skills to ensure I keep up with ongoing developments.
A total of 6 years of IT experience in Datawarehouse of which 2 years is in Hp Vertica, 4 years in Datastage,Teradata. Basic to intermediate knowledge of SQL
A highly motivated and versatile IT professional with more than 18 years of experience in a broad cross section of IT disciplines including:
* Complex enterprise level strategic and technical solution design
* Infrastructure architecture and software architecture
Trusted Technical Advisement:
Sought out by colleagues and clients alike to answer business questions that require cross- domain technical expertise. Technical pathfinder in enterprise information architecture with proven track record of seeing clients and employers through new or difficult terrain.
Aggressive Problem Solving:
Taking an enthusiastic and ambitious attack to technical business challenges. Tactful, respects historical solutions with eager and open mind to new approaches. Passionate about solutions to problems but is pragmatic about the tools and technology.
