ETL Developer

 (7+ years exp)
₹7L – ₹14L
Published: 1 day ago
Avatar for SecureNow Insurance Broker

SecureNow Insurance Broker

Insurance broking firm with tech-based solutions for SMEs
Company Size
201-500
Company Industries
Small and Medium Businesses
See all jobs at SecureNow Insurance Broker image

Job Location

Job Type

Full Time

Visa Sponsorship

Not Available

Relocation

Allowed

Skills

MySQL
MongoDB
ETL
Etl Development
Etl Tools Datastage
Dimensional Modeling
Star Schema
Date Warehouses/ Data marts

The Role

ROLES & RESPONSIBILITY :

Participate in discovering the Decision Support needs of the organization.
Conceptualize, design, and implement the data warehouse to align with the Business Intelligence
strategy in order to achieve desired decision support.
Develop ETL code using SQL, NoSQL, PL/SQL and UNIX scripting. (evaluate open source third party tool if
possible such as Talend)
Review requirements and data models, and translate into ETL design processes that effectively populate
data warehouse and data mart tables
Conduct One time historical data migration and testing for the same. Schedule Delta Loads on RDBMS
(mySQL)
Conduct POCs on proposed solutions or technologies. Utilize open source wherever feasible as per tech
policy.
Support staging, testing and production data warehouses & B.I environments.
Perform database design, schema change management, and database administration tasks (backups/
restores). Perform proactive and reactive monitoring and performance tuning of databases and
optimization of application code; troubleshoots and resolves database integrity issues, performance
issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues,
security issues, index management and statistics.

CANDIDATE BACKGROUND:

Bachelor's degree in Computer Science or related
7+ years solid experience in mySQL/ Mongo DB, Stored Procedures and PL/SQL
Experience with ETL architecture and scripting.
End to end implementation of at least two data warehouses ( & data marts )
Experience with Star Schema & dimensional modelling.

More about SecureNow Insurance Broker

Founders

Abhishek Bondia
Founder • 3 years
Gurgaon
image
Kapil Mehta
Founder • 3 years
image
Go to team image

Similar Jobs

MangoReader company logo
MangoReader
Create, Learn and Share interactive stories - The iTunes for children's books
POOLit company logo
POOLit
POOLit is a community of verified professionals offering free classifieds & carpools
Crontech Technologies company logo
Crontech Technologies
Creative web & mobile solutions company in Gurgaon-India that provides IT services
29Kreativ company logo
29Kreativ
We help people increase their client base using our Film/Web Development Services
Xebia  company logo
Xebia
Software Development Done Right!
RepUp.co company logo
RepUp.co
Customer Experience Management platform for hospitality
FullCycle company logo
FullCycle
Application Development for Technology Companies