Technical Lead - DAG

 

P31XDS-2580 | Technical Lead - DAG

ACCEPTED

8 Years

Max 15 days

Total Budget (₹10L - ₹15L)

16/02/2023

MumbaiKolkata

4.50% of CTC; ₹68K; 67 Payment Days; 90 Replacement Days

Above is Net Pay% after Platform Fee.

Amount is calculated on max job budget.

Hide project details

Job role :

Mandatory skills – MSSQL

* Min. 8 years of experience.

* Deep understanding and implementation experience in designing and developing ETL processes

that populate star schemas using a variety of source data on data warehouse implementations

supporting a product on both cloud as well as on premise.

* Solid understanding of design patterns and implementation experience in data modeling in SQL,

NoSQL spanning OLTP to OLAP (dimensional analysis and fact design).

* Solid understanding of design patterns and implementation experience in data pipelines -

Streaming (real-time) and Batch processing.

* Design and develop SQL procedural logic, functions, data materialization and triggers to be used

during the ETL process.

* Hands-on with proactive and reactive performance tuning instance-level, database-level and

query-level.

* Strong data analysis implementation experience - exploratory, time-series, data profiling etc.

* Will be responsible for success of the engagement working closely with the client stakeholders

(Technical SPOC)

* Primary contact for the client team on technical aspects

* Experience in the requirements gathering process and ability to design the business process

dimensional models.

* Work with data providers to fill data gaps and/or to adjust source-system data structures to

facilitate analysis and integration with other company data.

* Basic understanding of scripting such as using Python.

* Good understanding and preferably experience in all data areas on Cloud platforms.

* Good working experience on data visualization and reporting.

* Good working experience with Data Governance - row-level security, role-based access strategy,

encryption and masking of data, passwordless authentication etc.

* Perform analysis on source data to determine the feasibility of using this data to solve business

needs.

* Good understanding and previous implementation experience in high availability and disaster

recovery implementation on premise.

* Write scripts for automated testing of data in the target facts and dimensions.

* Prepare and establish update process for technical artefacts such as data catalog, ER diagrams,

Non-Functional requirements, data flow diagrams etc.

* Experience in conducting and responding to database audits information during all phases of the

ETL process including code reviews and refactoring recommendations.

* Excellent troubleshooting skills.

* Whatever else asked for the good of the company goals and initiatives.

* Implementation experience on Google Cloud Platform - BigQuery, Composer and Cloud Data

Fusion.

Technical AspectsDesign PatternsData WarehouseETL ProcessMSSQLSQLData ModelingBatch ProcessingNoSQLOLTPETL

Full-Time

1

Information Technology

E-Learning

Any

Full Time

Full Project

On-Site

Comments

Post a Comment

Popular posts from this blog

We want recruitment solutions as per below given details.ndustry : Banking / Financial Services / Stock Broking Functional Area : Accounting/Auditing/Taxation

Image
We want recruitment solutions as per below given details. Key Skill : Basic computer knowledge, Back Office Executive Exp : Fresher Industry : Banking / Financial Services / Stock Broking Functional Area : Accounting/Auditing/Taxation Qualification : Higher Secondary Vacancy : 28 Job Location : Sipahijala, Kolkata, Birbhum Company Name : Bankers City : Kolkata country Name : India
Read more

I've been active on clickworker for a while now. It's a site where you can earn some money on the side by writing, translating and doing research. I think it's something you'd be into. Check it out. Registration is free.

Image
 DEAR JOB SEEKERS, YOU CAN HERE EARN SOMETHING LIKE 20 DOLLARS TO 100 DOLLARS EVERYDAY DOING SIMPLE GTASK ONLINE.ITS ONLINE JOBS ,WHICH YOU CAN DO FROM ANYWHERE WITH THE HELP OF MOBILE OR LAPTOP,PC.THERE IS NO JOINING FEE,ITS TOTALLY FREE.THERE ARE LOTS OF EARNING OPPORTUNITIES HERE ,YOU CAN EVEN RECRUITE OTHER PERSONS HERE ALSO. I've been active on clickworker for a while now. It's a site where you can earn some money on the side by writing, translating and doing research. I think it's something you'd be into. Check it out. Registration is free. http://bit.ly/3TFn3AJ GET HELP HERE:-http://bit.ly/3TFRrLi YOURS RECRUITMENT PARTENER, ROHIT GUPTA IMMORTAL SOLUTION www.immortalsolution.in www.immortalsolution.co.in whats app:-8910207569 Solution home  FAQ   Registration and login How to register?   Print Modified on: Wed, 8 Feb, 2023 at 2:54 PM There are two ways you can sign up with us. You will need the clickworker app to log into your account later on regardless of wh...
Read more