Relevant Years of Experience :

4-8 years

Number of open positions : 2

 

Skill : Tableau
Database : SQL Server/Oracle, Teradata/Netezza/Green Plum/AWS redshift

Requirements

  • Good knowledge of dimensional modeling and DWH concepts like change data capture (CDC)

  • SQL Programming: Knowledge in basic and advanced concepts like PL/SQL, analytical functions etc.

  • Knowledge in Shell scripting

  • Data Profiling and Data validation

  • Ensuring accuracy and integrity of data and applications through analysis, coding, documenting, testing and problem solving

  • Setting up the development environment and configuration of the development tools

  • Efficient in coding and understanding the deliverables

  • Developing of the deliverables with unit testing and code documentation

  • Knowledge in performance tuning and optimization

  • Understanding and Implementing QA and various testing process in the project

  • Co-ordinating with the UAT team

  • Excellent verbal and written communication skills

Tableau Skill Set

    • Report/Dashboard development and understanding to convert the user analytical requirements to BI reports

    • Good Understanding of data connections, dashboard extracts and data sources

    • Knowledge in tableau admin activities like creation of users, groups, projects and to set appropriate permission in Tableau Server

    • Knowledge in filters, parameters, hierarchies, conditional formatting, sets and groups, table calculations etc.

    • Good Knowledge in developing different types of charts and dashboards

    • Understanding of data blending, scheduling and publishing the dashboards in server

Additional Skills:

 

    • Experience in estimating ETL requirements, designing and architecting integration solutions

    • Knowledge in designing and developing ETL mappings using Informatica Designer / any ETL tool

    • Knowledge in integration, migration, deployment and scheduling the ETL jobs

    • Exposure to other BI tools (MS SQL SSRS, Cognos, MSTR) a plus