Mandatory Skills:

Python, Apache Spark, Data Quality & Validation, PySpark, SQL, Amazon Kinesis, Apache Kafka, Databricks Workflows, Delta Lake on Databricks

Additional Skills:

AWS S3 + Amazon Aurora + DynamoDB, AWS Glue, AWS Redshift, Data Governance Frameworks, GitHub

Key Responsibilities

- Design scalable data engineering solutions using PySpark and up-to-date distributed data processing frameworks.
- Define data ingestion, transformation, and processing architectures aligned with business and analytical objectives.

Behavioral Competencies

- Demonstrates strong ownership while driving data engineering excellence.
- Collaborate effectively with various teams and business stakeholders to ensure smooth delivery.

Must Have

- Python & Advanced SQL
• Spark / distributed processing / PySpark
• Cloud platforms (AWS) Modules like Lambda, Glue, EMR, Dynamo DB, S3, Redshift, EC2, RDS, Step Functions, Cloud Watch, Systems Manager, Event Bridge, DMS
• SSIS and experience with C# scripting
• Data pipeline automation

Nice to have
• Kafka/Kinesis streaming
• Basic knowledge of AI
• Power BI

- Postgre SQL
- DBT

Job Summary:

We are seeking a skilled ETL Developer able to develop and maintain jobs in SSIS and ETL pipelines in AWS.
The ideal candidate will have a strong background in SSIS ETL tool and knowledge of AWS modules like Lambda, Glue or EMR.
Key Responsibilities:




• Able to understand existing jobs in SSIS and ability to maintain them in production including resolving issues and making changes to them as per requirement.
• Basic understanding of C# coding.
• Hands on in Python and advanced SQL.
• Good understanding of Spark eco-system and PySpark programming.
• Able to convert existing SSIS workflows to ETL pipelines running on AWS. That includes knowledge of Lambda, Glue or EMR, Systems Manager, Event Bridge, DMS
• Knowledge of Dynamo DB, Redshift, RDS (Preferably Postgre)
• Awareness of reporting tool like Power BI.
• Monitor and troubleshoot migration processes, resolving issues in a timely manner.
• Work closely with business stakeholders, developers, and administrators to understand data requirements.
• Document migration procedures, processes, and best practices.

Required Skills and Qualifications:
• Bachelor’s degree in Computer Science, Information Technology, or related field.
• 5+ years of experience in data migration or similar roles.
• Strong proficiency in SSIS.
• Proven experience in ETL tools like SSIS and data migration pipelines build on AWS.
• Familiarity with data modeling and schema design principles.
• Ability to analyze and resolve complex data-related issues.
• Strong analytical and problem-solving abilities.
• Excellent communication and collaboration skills.
• Ability to work independently and in a team-oriented environment.

Preferred:
• Familiarity with Agile project management methodologies.

📌 Data Engineer (Noida)
🏢 IRIS SOFTWARE
📍 Noida