ETL Developer
(7+ years exp)₹7L – ₹14L
Published: 1 day ago
SecureNow Insurance Broker
Insurance broking firm with tech-based solutions for SMEs
Job Location
Job Type
Full TimeVisa Sponsorship
Not AvailableRelocation
AllowedSkills
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.
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
Similar Jobs
MangoReader
Create, Learn and Share interactive stories - The iTunes for children's books
WedMeGood
Making Indian Wedding planning easier
POOLit
POOLit is a community of verified professionals offering free classifieds & carpools
WedMeGood
Making Indian Wedding planning easier
Crontech Technologies
Creative web & mobile solutions company in Gurgaon-India that provides IT services
29Kreativ
We help people increase their client base using our Film/Web Development Services
Xebia
Software Development Done Right!
RepUp.co
Customer Experience Management platform for hospitality
FullCycle
Application Development for Technology Companies