Kamalakar kusuma
Chantilly,VA
Summary
Senior engineering professional with deep expertise in data architecture, pipeline development, and big data technologies. Proven track record in optimizing data workflows, enhancing system efficiency, and driving business intelligence initiatives. Strong collaborator, adaptable to evolving project demands, with focus on delivering impactful results through teamwork and innovation. Skilled in SQL, Python, Spark, and cloud platforms, with strategic approach to data management and problem-solving.
Overview
17
17
years of professional experience
1
1
Certification
Work History
Sr. Data Engineer
Fannie Mae
08.2015 - Current
- Designed and deployed end-to-end AWS-based data pipelines using Step Functions, Glue, EMR, and PySpark for forecasting and modeling ecosystems.
- Built dynamic EMR orchestration using Step Functions for automated data processing, reducing manual intervention by 80%.
- Integrated Redshift Spectrum and Glue Catalog to enable unified analytics and BI access.
- Implemented Data Quality and validation frameworks with Python, DuckDB, and Cucumber, ensuring 100% data integrity.
- Automated event-driven workflows (SNS/SQS) to enhance downstream synchronization.
- Developed YAML-driven ETL configurations for multi-source ingestion (Parquet, CSV, Excel) with GitHub CI/CD and Jenkins.
- Migrated on-prem processes to AWS Cloud, improving scalability, cost efficiency, and reliability.
Sr. Informatica Developer
Fannie Mae
- Led real-time Oracle → Netezza replication using Informatica Data Replication (IDR); implemented CDC-based pipelines and operational automation.
- Developed and tuned Informatica PowerCenter mappings, workflows, and Autosys scheduling for high-volume financial datasets.
Informatica Developer
Thredz IT
08.2012 - 02.2015
- Developed ETL solutions for financial reporting and analytics using Informatica PowerCenter; built mapping patterns for SCD Type 1/2, fact loads, and Teradata optimizations.
- Automated loads, testing, and deployment scripts; supported UAT and production.
ETL Developer
Accenture
11.2010 - 08.2012
- Implemented enterprise ETL processes for the eCustomer program using Informatica; designed SCD Type 2 dimensions and performance-tuned sessions.
- Participated in requirements, design, and complex mapping development; provided production support.
PL/SQL Developer
Resource Square Solutions
06.2008 - 11.2010
- Created PL/SQL packages, exception-handling frameworks, stored procedures, and utilities to support reprocessing and operational stability.
- Unit-tested modules and supported deployment and production troubleshooting.
Education
Master of Computer Applications -
KU
Warangal, India01-2008
Skills
- Cloud & Big Data: AWS (S3, EMR, Glue, Redshift, Lambda, CloudWatch, EC2, SNS, SQS, Step Functions)
- Programming: Python, PySpark, SQL, PL/SQL, UNIX Shell Scripting
- Data Warehousing: Informatica PowerCenter, Redshift, Netezza, Oracle, Teradata
- Infrastructure & Automation: Terraform, GitHub, YAML, Jenkins
- Testing & QA: Cucumber, DuckDB, Python Testing Frameworks, Data Quality Rules
- Modeling & Design: Star/Snowflake Schema, ER Modeling, Dimensional Modeling
- Tools: DBeaver, Jira, Autosys, Control-M, Toad, Visual Studio, PyCharm, Excel
Accomplishments
Awarded Prathibha Award from Andhra Pradesh Board of Intermediate Education for academic excellence.
Received Gold Medal from Gujje Vydhyanath Memorial Trust for securing top position in Intermediate.
Certification
- AWS Certified Solutions Architect – Associate
- Teradata Certified Professional
- Informatica Level 1 Certified
- Database Concepts Certified
Timeline
Sr. Data Engineer
Fannie Mae
08.2015 - Current
Informatica Developer
Thredz IT
08.2012 - 02.2015
ETL Developer
Accenture
11.2010 - 08.2012
PL/SQL Developer
Resource Square Solutions
06.2008 - 11.2010
Sr. Informatica Developer
Fannie Mae
Master of Computer Applications -
KU