Informatica Developer Sql Server

Harika Reddy

405-***-**** *************@*****.*** Dallas, TX LinkedIn

Experienced Data Engineering Professional with 12+ years in Data Warehousing, ETL development, and cloud integration. Skilled in delivering complex data integration projects, performance tuning, and collaborating with cross-functional teams to meet business goals.

Professional Experience

Sr. Informatica Developer

WEX Inc. Sep 2020 – Present

• Led design and development of complex ETL strategies using Informatica PowerCenter and IICS, integrating data from Salesforce and Oracle into Snowflake.

• Spearheaded migration of PowerCenter mappings to IICS/IDMC, improving data processing scalability and performance.

• Developed reusable transformations, mapplets, and workflows, ensuring modular and maintainable ETL code.

• Integrated Azure services (Azure SQL Database and Data Lake) with Informatica for cloud-based analytics.

• Tuned performance bottlenecks in mappings and sessions, improving data load times.

• Collaborated with stakeholders to define requirements and built robust source-to- target mappings.

• Created and executed unit tests, supported UAT, and ensured production stability with proactive monitoring.

• Worked extensively with SCD Type I & II, and dimensional modeling (Star/Snowflake schemas).

• Managed production support, troubleshooting issues, and providing on-call resolution.

Technologies: Informatica PowerCenter 10.5, IICS, Snowflake, Oracle, SQL Server, UNIX, Python, Azure

Informatica Developer

American Airlines, Fort Worth, TX Feb 2017 – Sep 2020

• Designed and implemented ETL workflows, transforming data from Oracle, DB2, and flat files to target systems.

• Developed technical design documents, source-to-target mapping specs, and guided ETL team in execution.

• Implemented performance tuning for ETL processes and optimized SQL queries.

• Maintained production support, managed session failures, and improved job reliability.

• Enabled data-driven insights through efficient ETL pipelines supporting reporting and analytics.

• Used Autosys scheduler for automation and managed production deployments. Technologies: Informatica PowerCenter 8.x, Oracle, SQL Server, DB2, Autosys, UNIX Informatica Developer

Kaiser Permanente Jun 2012 – Feb 2017

• Built reusable ETL components and complex mappings for large-scale healthcare data.

• Designed technical mapping documents and implemented business logic in Informatica.

• Used various transformations including aggregators, lookups, routers, and joiners.

• Developed SQL scripts and performed data validation and unit testing.

• Coordinated across teams, supported QA, and ensured successful production releases.

Technologies: Informatica PowerCenter, Oracle, SQL Server, UNIX Technical Skills

Category Skills

ETL & Cloud Informatica PowerCenter, IICS, IDMC, Azure Data Lake, Snowflake Databases Oracle, SQL Server, DB2

Scripting Python, UNIX Shell Scripting, PL/SQL

Tools SQL*Plus, TOAD, Visio, Erwin, Autosys

Development C, XML, VB Script

Methodologies SDLC, Agile, Dimensional Modeling (Star/Snowflake), SCD Type I/II Education

• M.S. in Computer Science – Herguan University

• Bachelor of Engineering in Electrical & Electronics Engineering – JNTU Strengths

• Expert in ETL design, performance tuning, and real-time data integration.

• Strong communication and stakeholder collaboration skills.

• Adaptable, proactive, and committed to continuous learning and process improvement.

Contact this candidate