Dwh Architect

2 months ago

Mumbai, India SNG Talent Full time

Hands-on experience and knowledge of Data Warehouse best practices, Teradata, Hadoop, and Informatica ETL, and working knowledge of SDLC/agile methodology is required for the role. Additionally, you should have experience with systems design and development from business requirements analysis through implementation and ongoing support. We believe a good work ethic, superb communication, Excellent analytical and problemsolving skills, and the ability to effectively engage with technical and non-technical colleagues will allow for success.

Your responsibilities will include: Datawarehouse Architect:
**Responsibilities**:

- Define the LDM,CDM and PDM for data analytics project
- Analyze and organize raw data
- Experience in developing and maintaining the complex data repositories
- Experience in handling slowly changing dimension datasets, master data management
- Expertise in defining the enterprise data warehouse as well as Dimensional data model using star/snowflake schema
- Build data systems and pipelines
- Create and maintain optimal data pipeline architecture,
- Assemble large, complex data sets that meet functional / non-functional business requirements.
- Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition,

operational efficiency and other key business performance metrics
- Conduct complex data analysis and report on results
- Prepare data for prescriptive and predictive modeling
- Build algorithms and prototypes
- Identify opportunities for data acquisition
- Collaborate with data scientists and architects on several projects

**Requirements and skills**
- Previous experience as a data engineer or in a similar role
- Technical expertise with data models, data mining, and segmentation techniques
- Knowledge of programming languages
- Advanced working SQL knowledge and experience working with relational databases, query authoring

(SQL) as well as working familiarity with a variety of databases.
- Hands-on experience with SQL database design
- Data engineering certification (e.g IBM Certified Data Engineer) is a plus
- Strong analytic skills related to working with unstructured datasets.

8+ years experience in Data Warehousing including the following:

- 2+ years of hands on ETL (i.e, Informatica/Data Stage) experience
- 2+ years of hands on Big Data Experience (Hadoop, Spark, Hive)
- 2+ Unix/Linux scripting experience o 4+ years Database experience in SQL Server/ Oracle/ MySQL/Postgres SQL o 8+ years experience working in a cross-functional environment
- 8+ years of Teradata experience or related Appliance, PowerBI, Tabular Data Models

**Tech stack**:

- Mysql, Postgresql, sql server Database platform, ETL tools like Talend(preferred), SSIS,
- Data visualization Tool: Power BI, Tableau.Knowledge on Javascript : highcharts, D3.js good to have

**Job Types**: Full-time, Regular / Permanent

**Salary**: ₹4,000,000.00 per year

Schedule:

- Day shift

  • Data Architect

    3 weeks ago

    Mumbai, India Aspire Systems Full time

    **Experience**: 10 to 15 years **Location**: Mumbai (Client Location) **Notice Period**: Immediate - 30 Days We are looking to hire a Data Architect with extensive knowledge and work experience in Data modelling & business intelligence to join our team. **Requirements**: Participate in data strategy and road map exercises, data architecture definition,...

  • Data Architect

    1 week ago

    Mumbai, Maharashtra, India Aspire Systems Full time

    Experience: 10 to 15 yearsLocation: Mumbai (Client Location)Notice Period: Immediate - 30 DaysWe are looking to hire a Data Architect with extensive knowledge and work experience in Data modelling & business intelligence to join our team.Requirements:Participate in data strategy and road map exercises, data architecture definition, business intelligence/data...

  • Cloud DWH

    3 weeks ago

    Mumbai, India Anicalls (Pty) Ltd Full time

    Knowledge in collecting, structuring, and summarizing requirements in a data warehouse environmentKnowledge in turning requirements into data warehouse design artifacts (ETL framework design, data modeling, source-target-mapping)Knowledge of modern Relational Database Systems such as Oracle, DB2, SQL Server, Postgres, AWS Athena, and SnowflakeExperience with...

  • Data Platform Architect

    2 months ago

    Mumbai, India Hewlett Packard Enterprise Full time

    Data Platform Architect This role has been designated as ‘Office’, which means you will primarily work from an HPE office. **Who We Are**: **HPE Services** is our innovative IT services organization. It provides the expertise to advise, integrate, and accelerate our customers’ outcomes from their digital transformation - giving clients the most...

  • Snowflake Solution Architect

    3 weeks ago

    Chennai/Hyderabad/Bangalore/Mumbai/Pune/Kolkata, India Swift Strategic Staff Solutions INC Full time

    Key Skills : Snowflake, Snow SQL, Snow Pipe, ETL, Data Warehouse, Cloud servicesHybrid Mode : Weekly two days have to report to the office which is mandated.Notice Period : Immediate joinersJob Description : - Must have experience working as a Snowflake Data Architect and in Data Warehouse, ETL, BI projects.- Must have prior experience with end to end...

  • Snowflake Solution Architect

    2 months ago

    Chennai,Hyderabad,Bangalore,Mumbai,Pune,Kolkata, India Swift Strategic Staff Solutions INC Full time

    Key Skills : Snowflake, Snow SQL, Snow Pipe, ETL, Data Warehouse, Cloud servicesHybrid Mode : Weekly two days have to report to the office which is mandated.Notice Period : Immediate joinersJob Description : - Must have experience working as a Snowflake Data Architect and in Data Warehouse, ETL, BI projects.- Must have prior experience with end to end...

  • Cloud Solution Architect

    2 months ago

    Mumbai, India Course5 Full time

    **Job Descrip - on** **Company** **Posi - on Title** **Repor - ng to** **Schedule** **Work Loca - on** Course5 Intelligence Solu - ons Architect VP Advanced Analy - cs & Applied AI Full-Time Mumbai / Bangalore / Gurgaon **OVERVIEW** **Course5 Intelligence** We enable organiza - ons to make the most effec - ve strategic and tac - cal moves rela - ng to...

  • Practice Architect- Snowflake

    1 week ago

    Mumbai, India citius tech Full time

    **Location** Mumbai, Bangalore, Pune **Experience** 15 - 17 Years As a **Practice Architect - Snowflake**, you will be responsible for designing and implementing data engineering solutions for life science organizations. They collaborate with clients to understand their business needs and create custom solutions that meet their requirements. They also...

  • Qlikview/Qliksense Admin_ Mumbai/Pune Full-Time

    2 weeks ago

    mumbai, India HyreFox Consultants Full time

    What can you expect? ·Recognition – global career advancementopportunities ·Accountability – accountability and ownership of SolutionDelivery of DWH Solutions ·Career Growth –excellent performance is recognized by career mobility ·Design and implement complexreporting dashboards for visualization of key company metrics, models, andother...

  • Data Platform Architecture Consultant

    9 hours ago

    Mumbai, Maharashtra, India HPE Full time

    Data Platform Architecture Consultant This role has been designed as ''Onsite' with an expectation that you will primarily work from an HPE partner/customer office.Who We Are:Hewlett Packard Enterprise is the global edge-to-cloud company advancing the way people live and work. We help companies connect, protect, analyze, and act on their data and...

  • Data Platform Architecture Consultant

    1 day ago

    Mumbai, India HPE Full time

    Data Platform Architecture Consultant  This role has been designed as ‘’Onsite’ with an expectation that you will primarily work from an HPE partner/customer office.Who We Are:Hewlett Packard Enterprise is the global edge-to-cloud company advancing the way people live and work. We help companies connect, protect, analyze, and act on their...