P Anjali

Sr Data Engineer @Bank of America

Charlotte, NC, US

Design, develop, and deploy robust ETL frameworks using Ab Initio GDE, Express>It, and Control Center.Develop optimized graphs and plans for large-scale batch and real-time data processing leveraging Ab Initio components.Integrate Ab Initio workflows with diverse data sources including SQL Server, DB2, and Teradata within hybrid cloud architectures.Implement data partitioning, broadcasting, reformatting, join/sort/rollup/scan transformations to optimize ETL performance.Collaborate with DevOps teams to automate CI/CD pipelines for ETL deployments using Git, Jenkins, and Ab Initio’s Continuous Flows.Implement role-based access control and enforce data security policies in compliance with organizational and regulatory requirements.Develop and maintain enterprise-grade ETL solutions to process high-volume transactional data.Design and standardize ingestion and transformation pipelines integrating Azure Synapse Analytics and Snowflake.Utilize metadata-driven design patterns for job configuration management, audit tracking, data lineage, and recovery processes.Integrate ETL workflows with Control-M and Autosys for job orchestration, monitoring, and incident resolution.Work with IICS (Informatica Intelligent Cloud Services) and Power Exchange for ADF-to-Synapse integration tasks.Participate in the migration of legacy ETL jobs into modernized Ab Initio-based frameworks for enhanced scalability and performance.Prepare deployment scripts, document technical designs, and mentor junior developers on Ab Initio best practices.