Pentaho,SQL / PL SQL

Secondary Skills:

Data Integration Tool (Any),Visualization Tool (Any)

Role Description:

Data engineering role requires creating and managing technological infrastructure of a data platform, be in-charge / involved in architecturing, building managing data flows/ pipelines and construct data storages (noSQL, SQL), tools to work with big data (Hadoop, Kafka), and integration tools to connect sources or other databases.

Role Responsibility:

• Translate functional specifications and change requests into technical specifications

• Translate business requirement document, functional specification, and technical specification to related coding

• Develop efficient code with unit testing and code documentation

• 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

• Communicate with all the project stakeholders on the project status

• Manage, monitor, and ensure the security and privacy of data to satisfy business needs

• Contribute to the automation of modules, wherever required

• To be proficient in written, verbal and presentation communication (English)

• Co-ordinating with the UAT team

Role Requirement:

• Proficient in basic and advanced SQL programming concepts (Procedures, Analytical functions etc.)

• Good Knowledge and Understanding of Data warehouse concepts (Dimensional Modeling, change data capture, slowly changing dimensions etc.)

• Knowledgeable in Shell / PowerShell scripting

• Knowledgeable in relational databases, nonrelational databases, data streams, and file stores

• Knowledgeable in performance tuning and optimization

• Experience in Data Profiling and Data validation

• Experience in requirements gathering and documentation processes and performing unit testing

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

• Knowledge in any BI tools will be an added advantage

• Sound aptitude, outstanding logical reasoning, and analytical skills

• Willingness to learn and take initiatives

• Ability to adapt to fast-paced Agile environment

Additional Requirement :