Job Description

Years Of Experience

4 - 8 years

Location

Mumbai, Bangalore, Trivandrum

Designation

Data Engineer


:

Role: Senior Data Engineer
Experience Level: 4 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. Define the processes for database usage,
role based access controls, data security compliance
? 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.
� 3-8 years? experience as a Database Administrator.
? Minimum 2+ years of experience with AWS services like Redshift, RDS, Dynamo db or any
other columnar databases
� Hands-on DB and Server troubleshooting experience.
� Knowledge of day to day database operations, deployments and development
� Extensive database experience with RDS, AWS Redshift, MySQL
� Knowledge of Linux Shell Scripting or Python
� Hands-on DB and Server troubleshooting experience.
� Hands-on experience with database standards and end user applications.
� Minimize database downtime and manage parameters to provide fast query responses.
� Sound knowledge of SQL and Performance tuning
� Determine, enforce and document database policies, procedures and standards.
� Knowledge of AWS CLI, Snapshot, Route 53, S3, EC2, ECS
� Quick learner, self-starter with strong troubleshooting and communication skills
� Strong customer service skills and ability to work in team environment
? 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.

No. of Open Positions :
1

Skills Required :
AWS, Redshift, SQL, Data Engineer, Database Administrator,