Lead Consultant - (CREQ132205)
6 7 Yrs of experience
Complex problem solving capability and ever improvement approach.
Must be analytic, creative and self motivated.
Work Effectively within a global team environment.
Experience of working with a range of BI and analytics architectures. These may include traditional warehousing, visualization
Experience in building data pipelines using an ETL tool e.g. Talend Informatica or EMR based pipelines
Basic Data Modelling skills RDBMS concepts, Normalisation, dimensional modelling, star snowflake schema etc
Excellent SQL coding skills
Experience with AWS technologies Redshift, EMR, S3
Excellent communication documentation skills
Familiar with CI CD concepts and tools Jenkins
Experience and familiarity with data models and artefacts entity relationship diagrams, conceptual models, logical models, star schemas, third normal form.
Experience of delivering data analytics solutions using different delivery methodologies e.g. Agile, Waterfall
Good written and verbal skills, fluent English.
Coordinate with DBA in creating and managing tables, indexes, table spaces, auditing and data quality checks.
Work on the oracle SQL queries and PL SQL objects like functions, procedures, packages, triggers, views, cursors.
Implement procedures to install and deploy large numbers of Linux Unix servers.
Create database tables, create various db queries and assist in data mapping testing activities in support of project.
Develop Perl and shell scripts for parsing the incoming files data and loading them into the database.
Develop and optimize database structures, store procedures, dynamic management views, DDL triggers and user define functions.
Develop complex PL SQL packages, procedures, functions for the application, according to business requirements in UNIX and windows environments.
Modify, maintain and develop PL SQL codes for new customer requirements which involve cursors, functions, procedures triggers and collections.
Develop load processes and data warehouse integration ETL procedures.
Perform data modeling and create maintain and modify complex database triggers and data migration scripts.
: Full Time
: 02/06/2022, 9:13:24 PM