Senior Data Engineer

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.