Shanam Ambreen Shahab

About Shanam Ambreen Shahab

I am a Data Engineer with extensive experience in architecting, developing, and modernizing enterprise-scale data platforms and ETL pipelines, with a strong focus on cloud transformation and data platform modernization. I have played a key role in transitioning legacy ETL ecosystems, including Informatica-based solutions, to scalable, cloud-native architectures using AWS Glue, Python, and PySpark.With a strong foundation in SQL and Python, I design and implement high-performance, fault-tolerant data pipelines that support critical analytics, reporting, and decision-making workflows. My expertise spans the entire data lifecycle—ranging from source system integration and complex data transformations to data validation, optimization, and delivery of analytics-ready datasets.In my current role, I am actively involved in leading and executing Informatica-to-AWS Glue migration initiatives, translating complex business logic into efficient PySpark-based Glue jobs. I focus on building pipelines that are not only scalable and cost-efficient, but also maintainable, well-monitored, and aligned with cloud engineering best practices. I consistently emphasize performance tuning, reusability, and operational excellence while working with large and diverse datasets.I bring strong hands-on experience with AWS services including Glue, S3, Glue Data Catalog, and Athena, along with deep expertise in ETL design patterns, data migration strategies, and pipeline optimization. I have implemented robust error handling, logging, and data quality frameworks to ensure reliability and consistency in production environments. In addition to technical execution, I collaborate closely with stakeholders and cross-functional teams to translate business requirements into scalable data solutions.Beyond delivery, I am focused on continuous improvement and technical leadership, staying aligned with evolving trends in cloud-native data engineering, distributed data processing, and modern data architectures. I aim to build future-ready data platforms that scale with business growth, enable advanced analytics, and serve as a strong foundation for data-driven decision making. I am a Data Engineer with extensive experience in architecting, developing, and modernizing enterprise-scale data platforms and ETL pipelines, with a strong focus on cloud transformation and data platform modernization. I have played a key role in transitioning legacy ETL ecosystems, including Informatica-based solutions, to scalable, cloud-native architectures using AWS Glue, Python, and PySpark.

Experience

1. Application Development Analyst

   Accenture

   Aug 2025 — Present · Gurugram, IN

   Designed and developed end-to-end ETL pipelines using Informatica and AWS Glue, handling large-scale structured data.• Migrated legacy Informatica mappings to AWS Glue PySpark jobs, improving scalability and reducing operational overhead.• Developed complex SQL queries for data transformations, validations, and performance optimization.• Built Python-based transformation logic for data cleansing, enrichment, and schema standardization.• Worked with AWS S3, Glue Data Catalog, and Athena for cloud-based data processing.• Implemented error handling, logging, and data quality checks to ensure reliable pipeline execution.• Collaborated with cross-functional teams to understand business requirements and deliver analytics-ready datasets.•

Education

• Biju Patnaik University of Technology, Odisha

  Bachelor of Technology - BTech, Computer Science