Job Description

Role & Responsibilities

The Senior Data Engineer will be responsible for

·    Create and maintain optimal data pipeline architecture; assemble large, complex data sets that meet functional / non-functional requirements.

·    Design the right schema to support the functional requirement and consumption pattern.

·    Design and build production data pipelines from ingestion to consumption.

·   Build the necessary datamarts, data warehouse required for optimal extraction, transformation, and loading of data from a wide variety of data sources.

·   Create necessary preprocessing and postprocessing for various forms of data for training/ retraining and inference ingestions as required

·   Create data visualization and business intelligence tools for stakeholders and data scientists for necessary business/ solution insights

·   Identify, design, and implement internal process improvements: automating manual data processes, optimizing data delivery, etc.

·    Ensure our data is separated and secure across national boundaries through multiple data centers and AWS regions.

Technical Skill Set

·       Hands on experience in Informatica PowerCenter/IICS as an ETL tool

·    Experience with AWS cloud services: EC2, EMR, RDS, Redshift, S3, Athena and familiarity with various log formats from AWS.

·       Experience in AWS Glue ETL, AWS Crawler, AWS Lambda, Glue Data Catalog, AWS Glue Studio.

·       Hands on experience with python programming, spark, shell scripting

·       Knowledge of Database Concepts – Indexing, Partitioning is must.

·       Knowledge of Data warehousing – Normalization, Denormalization, Star/Snow-flake schemas.

·       Good Hands -on the table’s creations, DDL, DML and TCL

·       Experience with big data tools: Hadoop, Spark, Kafka, etc.

·       Experience with data pipeline and workflow management tools: Airflow, Luigi etc.