Vacancy expired!
- Oracle PL/SQL, SQL, shell scripting
- Good understanding of Oracle database concepts and query tuning in Oracle as well as being able to analyze and write PL/SQL
- Must have a total of 8+ yrs. in IT and 3+ years experience working as a snowflake Data Architect and 8+ years in Data warehouse, ETL, BI projects, and reporting.
- Proficiency in RDBMS, complex SQL, PL/SQL, Unix Shell Scripting, performance tuning, and troubleshooting.
- Must have experience working on MicroStrategy, Tableau, and other reporting tools.
- Expertise in Snowflake – data modeling, ELT using Snowflake SQL, implementing complex Stored Procedures and standard DWH and ETL concepts
- Experience in Data Migration from RDBMS to Snowflake cloud data warehouse
- Deep understanding of relational as well as NoSQL data stores, methods, and approaches (star and snowflake, dimensional modeling)
- Experience with data security and data access controls and design
- Experience with AWS or Azure data storage and management technologies such as S3 and ADLS Build processes supporting data transformation, data structures, metadata, dependency, and workload management.
- Provide technical solutions to critical business problems in production
- Guide team members on Standard Operating procedures, Technical Design document preparations, and problem-solving techniques