Informatica Developer - ETL & IDMC Specialist

LAKSHMI PUSULURI

+1-469-***-**** *******.**********@*****.*** Plano, Texas

LinkedIn: www.linkedin.com/in/lakshmi-pusuluri-982952255 PROFESSIONAL SUMMARY

Informatica Developer with 5+ years of experience in ETL development, data integration, data migration, and cloud-based solutions. Skilled in Informatica PowerCenter, Informatica IICS/IDMC, and data warehousing (Oracle, Snowflake, SAP HANA, MS SQL Server). Expertise in ETL design, performance tuning, CDC, SCD, API integrations (REST/SOAP), and CI/CD pipelines. Proven success in delivering scalable, secure, and optimized solutions across Banking and Retail domains. Experienced in IDMC Administration covering user/role management, Secure Agent operations, connection setup, environment configuration, and deployment governance. TARGET ROLES

Informatica Developer ETL Developer Data Integration Engineer IDMC Developer TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter, Informatica IICS (IDMC), Informatica CDI Cloud & Databases: Snowflake, Oracle, MS SQL Server, SAP HANA Languages & Scripting: SQL, PL/SQL, Unix Shell Scripting Data Integration & APIs: REST, SOAP, JSON, XML

Schedulers & Tools: Autosys, Informatica Scheduler, UC4 (Automic), JIRA, ServiceNow, Postman Methodologies: Agile Scrum, SDLC, Onsite-Offshore Model Domains: Banking, Retail

PROFESSIONAL EXPERIENCE

Attivo Technology Solutions Pvt Ltd – Informatica Developer/Support Hyderabad, India Feb 2022 – Jun 2025

Client: Schlumberger Project: SIMS

• Migrated and optimized 100+ ETL workflows from Informatica PowerCenter to IICS Cloud, reducing processing time by 20% and improving scalability.

• Designed and developed complex CDI workflows integrating SAP, Oracle, MS SQL Server, and Snowflake for real-time and batch processing.

• Led IDMC Administration across user/role governance, Secure Agent and Runtime environment management, connection/security configuration/code deployments. PROFESSIONAL EXPERIENCE (CONTINUED)

• Implemented real-time data synchronization between SAP and Oracle systems, improving data accuracy.

• Built error-handling frameworks, reusable transformations, and UDFs to standardize integration logic.

• Automated job scheduling and workflow management using UC4 (Automic), reducing manual interventions by 30%.

• Created runbooks, migration manuals, and data validation frameworks to ensure seamless production migrations.

• Collaborated with onsite and offshore teams to deliver ETL solutions within tight deadlines. Attivo Technology Solutions Pvt Ltd – Associate Informatica Developer Hyderabad, India Jan 2020 – Jan 2022

Client: Wells Fargo Projects: iHUB & Adjustments Utility

• Developed Informatica mappings and workflows to process backdated transactions, enabling accurate month-end reporting.

• Implemented CDC and SCD Type 1 & 2 for effective dimension management across large datasets.

• Optimized ETL jobs improving overall performance and ensuring SLA compliance.

• Automated ETL workflows using Autosys, reducing manual monitoring efforts by 25%.

• Designed error-handling and logging mechanisms, reducing production issues by 20%.

• Conducted UAT, managed defect tracking via ServiceNow, and provided 24/7 production support.

• Partnered with business teams to gather requirements and deliver scalable ETL solutions. EDUCATION

Bachelor of Science (B.Sc.) – Acharya Nagarjuna University, Andhra Pradesh, India AWARDS & ACHIEVEMENTS

• SPOT Award – Excellence in ETL Development

• Rise Team Award – Outstanding Team Contribution

ADDITIONAL DETAILS

Visa: L2S Languages: English, Telugu Nationality: Indian

Contact this candidate