Anees Ansari
Technology Specialist In Data
Gr. Noida
Summary
Senior Technical Lead with 11 years of experience in designing and delivering scalable data engineering and ETL solutions in finance and healthcare. Expertise in cloud-native data platforms, automation, data modeling (Data Vault), and orchestrating large-scale pipelines. Skilled in AWS, Snowflake, Python, Airflow, CI/CD, and Agile methodologies, with hands-on experience in tools like Glue, S3, and Redshift.
Overview
3
3
Language
11
11
years of professional experience
Work History
Senior Technical Lead
COFORGE
Greater Noida, India
02.2024 - Current
- The project involves building and scaling a modern cloud data platform to support enterprise analytics and reporting for Texas Capital Bank. It includes integrating batch and near-real-time data feeds into Snowflake, implementing Data Vault 2.0-based modeling, establishing automated ETL/ELT pipelines using AWS Glue and PySpark, and orchestrating end-to-end workflows with Airflow. The engagement focuses on delivering a reliable, performant, and secure data ecosystem, aligned with banking and compliance standards.
- Technologies: AWS (Glue, S3), external table, Snowflake, Python, PySpark, SQL, dimensional modeling, Data Vault 2.0, GitHub, Azure DevOps (Repos and Pipelines), Apache Airflow, Coalesce transformation tool.
- Designed and developed scalable ETL/ELT pipelines in AWS Glue (PySpark) for ingesting structured and semi-structured data into Snowflake, implemented Data Vault 2.0 (Hubs, Links, Satellites) with standardized templates for governed, auditable data modeling, and built managed Apache Airflow DAGs with SLAs, retries, alerting, and dependency handling for orchestration, optimizing Snowflake performance through warehouse optimization, clustering, query tuning, and best coding practices, while enabling streamlined development workflows using Azure DevOps CI/CD and GitHub.
- Fostered teamwork and open communication within the workplace.
Senior ETL Developer
PCGI SYSTEMS
Remote
02.2021 - 12.2024
- Led development and automation of ETL processes, streamlining data flow across multiple environments to enhance business operations.
- Roles and Responsibilities: Spearheaded deployment activities across development, testing, and production environments, ensuring seamless data processing and reporting. Successfully generated and monitored Power BI reports for various regions, leveraging a robust tech stack, including Python, SQL, MSSQL, Salesforce, Oracle, RDS, Redshift, AWS S3, Snowpark, Snowflake, and AWS Lambda. Managed and supported the ETL pipeline, ensuring data accuracy, and timely report generation across all levels of the organization. Played a key role in team handling, providing guidance and support to junior developers, and ensuring adherence to best practices in ETL development and deployment.
- Spearheaded deployment activities across development, testing, and production environments, ensuring seamless data processing and reporting. Generated and monitored Power BI reports for various regions using Python, SQL, MSSQL, Salesforce, Oracle, RDS, Redshift, AWS S3, Snowpark, Snowflake, and AWS Lambda. Managed ETL pipeline, ensuring data accuracy and timely report generation across all organizational levels. Provided guidance to junior developers, ensuring adherence to best practices in ETL development and deployment.
- Managed multiple concurrent projects while meeting deadlines and maintaining high quality results.
APPLICATION DEVELOPMENT SENIOR ANALYST
Accenture
Mumbai, India
11.2018 - 07.2020
- Roles and Responsibilities: Led deployment activities in both development and testing environments, utilizing MATLAB and Python to ensure smooth and error-free transitions. Supported the generation and monitoring of trade reports, ensuring accuracy and timely delivery by overseeing the execution of relevant jobs. Provided technical leadership in team handling, mentoring junior team members, and ensuring the application of best practices in ETL processes and deployment activities.
- The project focused on building and enhancing end-to-end ETL and reporting processes to support trade operations across multiple business teams. As an ETL Developer, the role involved automating critical extraction, transformation, and loading workflows, improving operational efficiency, and ensuring data accuracy for downstream reporting systems. The engagement required managing MATLAB- and Python-based deployment processes across development and testing environments, ensuring smooth, error-free transitions, with minimal production impact.
- Technologies: MATLAB, Python, SQL.
- Collaborated with cross-functional teams to develop high-quality software solutions, contributing to improved client satisfaction and project outcomes.
Software Engineer
IQRA Software Technologies Pvt. Ltd
Lucknow, Uttar Pradesh
04.2017 - 11.2018
- Developed scalable and maintainable code, ensuring long-term stability of the software.
- Integrated new technologies into existing systems, increasing capabilities and improving overall performance.
- Developed reusable components that significantly reduced development effort on multiple projects.
- Implemented effective debugging strategies, resulting in fewer software defects and increased reliability.
- ETL developer, used Python and Matlab, Develop the projects using Python & Matlab, created job in python for retrieving data using scraping
Matlab Developer
DP project development Pvt. Ltd.
Ghaziabad, Uttar Pradesh
01.2016 - 04.2017
- Worked closely with clients to gather requirements and translate them into technical specifications for implementation.
- Continuously updated skills through training courses, workshops, and self-study—staying current on industry trends and emerging technologies.
- Debugged complex software issues, leading to a more stable product release.
- Collaborated with cross-functional teams to ensure seamless integration of new features.
Matlab Developer
IQRA Software Technologies Pvt. Ltd
Lucknow, Uttar Pradesh
01.2015 - 01.2016
- Updated old code bases to modern development standards, improving functionality.
- Estimated work hours and tracked progress using Scrum methodology.
Education
Master of Technology (M.Tech) - Power Electronics and Drives Department of Electrical Engineering
Madan Mohan Malaviya University of Technology (MMMUT)
Gorakhpur01-2015
Bachelor of Technology (B.Tech) - Electrical and Electronics Engineering
Hindustan College of Science & Technology
Mathura01-2013
Intermediate - undefined
Uttar Pradesh Board
01-2008
High School - undefined
Uttar Pradesh Board
01-2006
Skills
Data engineering
Data modeling
Data Warehousing
Orchestration: Apache Airflow
AWS services
Software architecture design
Team mentoring
Timeline
Senior Technical Lead
COFORGE
02.2024 - Current
Senior ETL Developer
PCGI SYSTEMS
02.2021 - 12.2024
APPLICATION DEVELOPMENT SENIOR ANALYST
Accenture
11.2018 - 07.2020
Software Engineer
IQRA Software Technologies Pvt. Ltd
04.2017 - 11.2018
Matlab Developer
DP project development Pvt. Ltd.
01.2016 - 04.2017
Matlab Developer
IQRA Software Technologies Pvt. Ltd
01.2015 - 01.2016
High School - undefined
Uttar Pradesh Board
Intermediate - undefined
Uttar Pradesh Board
Bachelor of Technology (B.Tech) - Electrical and Electronics Engineering
Hindustan College of Science & Technology
Master of Technology (M.Tech) - Power Electronics and Drives Department of Electrical Engineering
Madan Mohan Malaviya University of Technology (MMMUT)
Professional Awards / Achievements
Pat on the Back “Inspire Q1 and Q2 Felicitation” 2025-12-11.