Hands-on with K2View/any other ETL tool, with experience in developing ETL scripts and Data Warehousing for real world use cases. They must be at ease working with on-prem Big Data ecosystem in an agile environment with little supervision. The person should be a self-motivated person with a passion for problem solving and continuous learning.
The Business Intelligence (BI) Specialist is responsible for the design, development, implementation, management and support of mission- critical enterprise BI reporting and Extract, Transform, Load (ETL) processes and environments.
Developing architectural solutions utilizing K2View/any other ETL tool
Work with project management to provide effort estimates and timelines.
Interact with Business and IT team members to move the project forward in every Sprint.
Contribute the development of ETL scripts using K2View/any other ETL tool
Knowledge of Java and PHP is required to develop solutions for the ETL in use (K2View)
Work with Internal stakeholder and development teams during project lifecycle
Analyzing Business requirements and Preparing functional documents and detail design documents.
Deep knowledge of implementing K2View/any other ETL tool Mappings based on the requirement by writing functions, translations using SQL/BTEQ scripts.
Creating Corresponding Maps and Flows for that translation to run and check for any error and load the data into Staging.
Interacting directly with Product support team (K2View) to fix any K2View Admin bugs by raising case with them.
Debug the issues related to Process, Daily Runs and weekly Migration & Data.
Ability to interact with all levels of management
ETL Tools: K2View OR Informatica 9.x & 10.x
ETL experience is mandatory (ETL – Data Extract, Transform, Load)
PHP scripting language knowledge/experience would be added advantage
Should have very good SQL & Unix knowledge and skills
Should have JAVA Basic Coding knowledge
All you need is…
Bachelor's degree in Science/ IT/ Computer Science or equivalent
Experience/knowledge in ETL Programming, testing tools and testing methodologies