Snowflake , SQL(4-6Yrs)-Immediate joiner

Dear Candidate,

Greetings from 3i infotech!!

We rre looking for Snowflakes with 3-6Yrs years of experience. Experience in Banking Industries and a good understanding of Core Banking systems/flow is preferred.

Key responsibilities

• Support client needs by delivering Snowflake/Azure jobs and frameworks
• Support client needs by delivering Various Integrations with third party application
• Merge, Customize and Deploy data model as per client business requirements
• Experience working with clients throughout various parts of implementation lifecycle
• Proactive with Solution oriented mind-set, ready to learn new technologies for Client requirements.

Skills and attributes for success

• Deliver large/medium DWH programmes, demonstrate expert core consulting skills and

advanced level of Snowflake/Azure knowledge and industry expertise to support delivery to clients

Mandatory Requirements

• Experience in Snowflake/Azure (Development + Admin) and DWH concepts
• Experience of atleast 2 end to end DWH Implementation experience.
• Should have experience in using Python codes in Snowflake/Azure.

Auditing, data quality, etc. Should be able to implement reusability, parameterization,

Workflow design, etc.

• Integrate with multiple Source / Target (through APIs, Webservices etc.)
• Must be well versed and hands-on in using and customizing Knowledge Modules (KM)
• Knowledge of data modelling and ETL design
• Design and develop complex mappings, Process Flow, Load Plans and ETL scripts
• Setting up topology, building objects in Designer, Monitoring Operator, different type of KMs,

Agents etc.

• Packaging components, database operations like Aggregate pivot, union etc.
• Using ETL mappings, error handling, automation, Load plans, Migration of Objects
• Design and develop complex mappings, Process Flows and ETL scripts
• Experience of performance tuning of mappings
• Ability to design ETL unit test cases and debug ETL Mappings
• Expertise in developing Load Plans, Scheduling Jobs
• Experience in Data Migration using SQL loader, import/export

Desirable

• Strong knowledge of ELT/ETL concepts, design and coding
• Expertise in database development (SQL/ PLSQL) for PL/SQL based applications.
• Experience in designing and developing Snowflake/Azure objects such as
• Tables, Views, Indexes, Partitions, Stored Procedures & Functions in PL/SQL, Packages, Materialized Views and Analytical functions. Experience of creating PL/SQL packages, procedures, Functions, Triggers, views, and exception handling for retrieving, manipulating, checking and migrating complex datasets in oracle
• Experience in SQL tuning and optimization using explain plan and SQL trace files
• Partitioning and Indexing strategy for optimal performance
• Good verbal and written communication in English, Strong interpersonal, analytical and problem-solving abilities.
• Experience of interacting with customers in understanding business requirement documents and translating them into ETL specifications and High- and Low-level design documents.
• BFSI functional knowledge is an added advantage.
• The incumbent should be able to drive Snowflake/Azure Infrastructure related developments.
• Additional knowledge of complex source system data structures preferably in financial services (preferred) Industry and reporting related developments will be an advantage.

Note

Regards,

Kiran

HR