Responsibilities for the job
Key Responsibilities: –
• Data Model Designing, Developing and maintaining Data pipelines on cloud (AWS Platform)
• Translate business needs to technical specifications and framework
• Maintain and support data mart, data analytics platforms & application.
• Perform quality assurance to make sure the data correctness
• Develop sub-marts using SQL and OLAP function to fulfil immediate/ad-hoc need of the business users
basis the comprehensive marts
• Monitoring of the performance of ETL and Mart Refresh processes, understand the problem
areas and open a project to fix the performance bottlenecks.
Other Responsibilities (If Any):-
Availability during month-end Deck generation, may be sometime during week-end/holidays.
Eligibility Criteria for the Job
Education:-
B.E/B.Tech in any specialization, BCA, M.Tech in any specialization, MCA
Work Experience:-
Data Engineer:
- 4+ years of experience in data engineering on cloud platforms like AWS, Azure, GCP
- Exposure with working on BFSI domain / big data warehouse project
- Exposure to manage multiple source of the information, both structured / unstructured data
- Manage data lake environment for point in time analysis (SCD Type 2), multiple refresh during the day, event based refresh
- Should have exposure on Managing environment having real time dashboard, data mart requirement.
Primary Skill:-
1. Must have orchestrated using any of the cloud platforms
2. Expert in writing complex SQL Command using OLAP
3. Working experience on BFSI Domain
Technical Skills:-
• Must have orchestrated at least 3 projects using any of the cloud platforms (GCP, Azure, AWS etc.) is a must.
• Must have worked on any cloud PaaS/SaaS database/DWH such as AWS redshift/ Big Query/ Snowflake
• Python/Java Hands – on Exp from data engineering perspective is a must
• Experience with any of the object-oriented/object function scripting languages: Python, Java, Scala, Shell, .NET scripting, etc. is a must
• Experience in at least one of the major ETL tools (Talend + TAC, SSIS, Informatica) will be added advantage
Management Skills:-
1. Ability to handle given tasks and projects simultaneously in an organized and timely manner.
Soft Skills:-
1. Good communication skills, verbal and written.
2. Attention to details.
3. Positive attitude and confident.