Data Engineer - Etl Developer Job in Quantiphi

https://drive.google.com/open?id=1CjlM9DIuI8JrDk3yeJoLsPRuigvrZFMY

Job Description
Role: Senior Data Engineer
Experience Level: 6 to 8 Years
Work location: Mumbai / Bangalore/ Trivandrum
Role & Responsibilities:
Work with business users and other stakeholders to understand business processes.
Ability to design and implement Dimensional and Fact tables
Identify and implement data transformation/cleansing requirements
Develop a highly scalable, reliable, and high-performance data processing pipeline to extract, transform
and load data from various systems to the Enterprise Data Warehouse
Develop conceptual, logical and physical data models with associated metadata including data lineage
and technical data definitions
Design, develop and maintain ETL workflows and mappings using the appropriate data load technique
Provide research, high-level design and estimates for data transformation and data integration from
source applications to end-user BI solutions.
Provide production support of ETL processes to ensure timely completion and availability of data in the
data warehouse for reporting use.
Analyze and resolve problems and provide technical assistance as necessary. Partner with the BI team
to evaluate, design, develop BI reports and dashboards according to functional specifications while
maintaining data integrity and data quality.
Work collaboratively with key stakeholders to translate business information needs into well-defined
data requirements to implement the BI solutions.
Leverage transactional information, data from ERP, CRM, HRIS applications to model, extract, and
transform into reporting & analytics.
Define and document the use of BI through user experience/use cases, prototypes, test, and deploy BI
solution.
Develop and support data governance processes, analyze data to identify and articulate trends,
patterns, outliers, quality issues, and continuously validate reports, dashboards and suggest
improvements.
Train business end-users, IT analysts, and developers.

Required Skills:
Bachelor s degree in Computer Science or similar field or equivalent work experience.
Minimum 4+ years of experience with AWS services like S3, DMS, Redshift, Glue, Lambda etc is must
have.
Good Knowledge and hands on in SQL and Python is a must.
Expert with SDLC processes.
Good knowledge of at least one ETL tool and experience of creating data pipelines is a must.
Knowledge of Data ingestion and Engineering Platforms is a must
Good understanding and experience on Data Warehousing or Data Integration projects is must have.
IICS/Informatica knowledge is a good to have
Knowledge of the Insurance domain is good to have.
Expert with data warehousing standards, strategies and tools.
Strong knowledge of relational databases preferably ORACLE and SQL Server.
Good knowledge of UNIX/LINUX shell scripting.
Strong problem-solving, multitasking and organizational skills.
Good written and verbal communication skills.
Demonstrated experience of leading a team spread across multiple locations.