The
role is of Cloud data engineer who has hands-on experience AWS DMS, Glue and
Athena. The candidate must be familiar at least in one Data ware housing
concepts such as ODS/Marts and must have done at least one end to end data
processing pipeline designing. Nice to have familiarity with AutoSys (job
scheduler) and MDM (master data management). He/she should be capable of
handling the ETL design and implementation solely and would work towards
creating a positive and innovation friendly environment. The incumbent would be
responsible to create new capabilities.
Roles & Responsibilities:
- Collaboration
& coordination with multiple business partners.
- Develop
pipelines to ingest data from different sources such as Database,
delimited files etc, do complex transformation and loading data into the
S3.
- Develop
Glue mapping and create Glue data catalogue.
- Implementation
of Athena.
- Can
optimize Informatica for performance improvements.
- SQLs
capability for data analysis.
- Able
to handle the end-to-end ETL or ELT pipeline solely.
- Ensuring
the work is delivered on time and with quality.
Requirements
- Extensive
practical experience in Information Technology and software development
projects of with at least 5+ years of experience in developing data
warehouse systems.
- Extensive
experience in on cloud data technologies – in particular on AWS.
- Strong
understanding of ETL and data warehouse concepts processes and best
practices.
- Good
understanding of Big data and cloud technologies
- Possess
a combination of solid business knowledge and technical expertise with
strong communication skills.
- Demonstrate
excellent analytical and logical thinking.
- Good
verbal & written communication skills and ability to work
independently as well as in a team environment providing structure in
ambiguous situation.
- Understanding
of Insurance Domain
- Good
understanding of Master Data Management and Data Governance.
- Basic understanding of data visualization
tools like SAS VA, Tableau
- Good understanding of implementing & architecting data
solutions using the AWS components.
Benefits
·Medical Insurance of INR. 5.0 Lakh for Self and Family (a total of 6
members)
·Group Personal Accidental coverage of INR.20.0 Lakh for the Employee
·Group Personal Term Insurance coverage of twice the CTC
·PF - As per the Standard regulations (12% on Basic Salary)
·Gratuity - Applicable after the completion of 5 Years
·Flexible work arrangements (Hybrid work, flexible hours, etc.).
·Annual leave of 21 days (apart from the 10 calendar holidays)
·Break-out area with Round the clock availability of soft drinks for
employee’s refreshment.
·Opportunity for professional growth and skill development.
·Professional certification reimbursement and incentive for Advance
Certifications
·Ninja Program is designed for Multi skill development of employees.
·Quarterly Rewards and Recognition program for celebrating employees’
milestones.
·Annual performance appraisal to recognize employee contributions for
salary increments, promotions etc.
·Training and Development programs by the external/internal trainers