ANITA DEVI
Charlotte,NC
Summary
Certified Data engineering professional with 11 years of expertise and solid history of creating and managing efficient data systems. Skilled in designing, optimizing ETL processes, and managing complex data pipelines. Proficient in dimensional and relational modeling, data warehousing, SQL, and cloud integration. Strong leadership background in mentoring teams and driving successful projects across industries such as Healthcare, Payments, Banking, Supply Chain, and Pharmaceuticals. Recognized for delivering impactful, results-driven solutions and adapting to evolving project needs.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Lead Data Engineer
Infosys
12.2024 - Current
- Designed, developed, and optimized Informatica Cloud (IICS) mappings and task flows ensuring seamless data integration with high quality and consistency, including analysis, data mapping, data transformation, and troubleshooting
- Created data integration using APIs to enrich data, ensuring comprehensive and accurate information flow across systems
- Loaded data into the MDM (Master Data Management) system for mastering the data, ensuring high standards of data integrity and consistency
- Automated file monitoring using Python, ensuring real-time alerts and triggering of ETL processes whenever a file is detected at the specified location
- Collaborated closely with cross-functional teams to understand business requirements and deliver robust data solutions
- Worked on data enrichment strategies and developed automated monitoring systems to ensure the reliability of data integrations
Senior Data Engineer
HCLTech
11.2021 - 06.2023
- Led migration from Informatica PowerCenter to IICS, ensuring smooth transition, optimizing operations, and minimizing disruptions to ongoing data processes
- Collaborated with clients to gather business requirements, translating them into ETL specifications, and implemented innovative solutions to meet data integration and transformation needs
- Optimized ETL workflows by fine-tuning performance, reducing data load times by30%, and improving operational efficiency through strategic SQL query optimizations and data partitioning
- Automated data quality checks and validation processes, reducing manual effort by35% and improving data reliability by15%, ensuring data warehouse integrity
- Created and maintained Linux shell scripts for task automation, logging, and workflow management, ensuring efficient data pipeline execution and troubleshooting
Senior Software Engineer (Informatica/Apache NiFi Developer)
Tech Mahindra
06.2018 - 11.2021
- Addressed business requirements and modifications in the Enterprise Data Repository (EDR) for Mastercard, a centralized data store for customer information, by analyzing and troubleshooting issues reported by users and downstream systems
- Developed and modified IDQ mappings using various transformations such as expression, joiner, and router, integrating data from flat files and databases (Oracle) to optimize data flows
- Implemented data partitioning strategies, improving query performance by30%, and optimized SQL queries, enhancing data retrieval speed by20%
- Led the migration of Informatica DIH applications to Apache NiFi, designing data ingestion pipelines and integrating diverse data sources like PostgreSQL, MS SQL Server, and Teradata into Elasticsearch
- Configured NiFi pipelines for data extraction, transformation, and loading, integrating audit data with Splunk for real-time tracking and reporting
- Facilitated knowledge-sharing sessions for over30 team members across6 teams, enhancing expertise in NiFi and supporting CI/CD migrations across environments
Associate Consultant (Informatica Developer)
Capgemini
08.2016 - 06.2018
- Generated FATCA reports to support cross-border tax compliance, developing and optimizing Informatica mappings for data integration between flat files and Teradata DB, improving reporting efficiency
- Designed and implemented a Data Mart using a Star schema, enhancing query performance by40%, and applied performance tuning techniques like partitioning and pushdown optimization, reducing data load times by50%
- Managed Informatica workflows, overseeing execution across OAT and Production environments, performing unit testing, and facilitating code migration while ensuring smooth integration and system performance
Systems Engineer (Informatica Developer)
Infosys
07.2012 - 06.2016
- Extracted, transformed, and loaded data from transactional databases (Oracle) and flat files into Business Object and AstraZeneca DWH for reporting and analysis using Informatica PowerCenter, ensuring data accuracy and integrity
- Developed and optimized Informatica mappings, including SCD Type1 and Type2 implementations, and crafted complex SQL queries to troubleshoot issues and enhance system performance
- Collaborated with clients to gather requirements, evaluated existing workflows, and executed change requests while ensuring smooth integration and timely delivery of modifications
Education
Master of Computer Applications -
Sikkim Manipal University
05-2017
Bachelor of Science -
Himachal Pradesh University
03-2012
Skills
- ETL Tools: Informatica Cloud (IICS/IDMC), Informatica PowerCenter, Informatica IDQ, Informatica DIH, Apache NiFi
- Databases: Oracle, Teradata, PostgreSQL, MS SQL Server
- Operating Systems: Linux, UNIX, Windows
- Languages: SQL, PL/SQL, Unix shell scripting, Python
- Scheduling Tools: Tivoli, Autosys
- Other Tools: JIRA, Rally, Remedy, ServiceNow, Oracle SQL Developer, Elasticsearch, Splunk
Certification
Cloud Data Integration Developer R41, Informatica Certified Professional (May2024)
Timeline
Lead Data Engineer
Infosys
12.2024 - Current
Senior Data Engineer
HCLTech
11.2021 - 06.2023
Senior Software Engineer (Informatica/Apache NiFi Developer)
Tech Mahindra
06.2018 - 11.2021
Associate Consultant (Informatica Developer)
Capgemini
08.2016 - 06.2018
Systems Engineer (Informatica Developer)
Infosys
07.2012 - 06.2016
Master of Computer Applications -
Sikkim Manipal University
Bachelor of Science -
Himachal Pradesh University