ETL Production Support & Data Warehousing Expert

Manvitha Chinthapatla ********.************@*****.*** 609-***-**** TX, USA

SUMMARY

Experienced ETL Developer with over 6 years’ expertise in designing, developing, and implementing ETL workflows to extract, transform, and load data across multiple platforms. Skilled in improving data accuracy, integrity, and usability for business intelligence and reporting needs. Proficient in Informatica Power Center and Power BI for interactive dashboard development and data visualization. Strong background in Oracle, SQL Server, and other relational databases combined with expertise in performance tuning, scripting, and data warehousing concepts. Well-versed in Agile methodology and collaborative product support.

WORK EXPERIENCE

Informatica ETL Production Support & Developer Vensoft LLC Aug 2020 – Present

Provided L2/L3 production support and developed ETL processes using Informatica Power Center, Unix shell scripting, and SQL for enterprise billing and rebate applications.

Developed Power BI dashboards integrated with Oracle and SQL Server to track KPIs and automate monthly and ad hoc reporting for healthcare clients.

Led troubleshooting and execution of Informatica workflows; optimized ETL mappings and sessions to enhance performance.

Participated in Informatica upgrades and end-to-end testing, and managed offshore team coordination.

Prepared detailed technical documentation and collaborated closely with QA and development teams. Informatica ETL Developer & Support Headstrong Services LLC Jan 2018 – Aug 2020

Executed and optimized ETL workflows, using Informatica and UNIX shell scripts to automate data load and cleansing jobs.

Developed SQL queries, stored procedures, and complex Informatica mappings incorporating transformations like Lookups, Aggregators, and Update Strategies.

Monitored workflow sessions and performance, providing data validation and root cause analysis.

Assisted in Informatica upgrade projects and supported production incident resolution. Informatica ETL Developer Vensoft LLC Oct 2016 – Dec 2017

• Designed and implemented ETL mappings to support claims processing, applying techniques such as slowly changing dimensions (Type II).

• Managed SQL tuning, data modeling, and workflow scheduling using Informatica Workflow Manager and UNIX commands.

• Delivered performance improvements through fine-tuning mappings and sessions, enhancing data load efficiency.

• Provided production database support and collaborated on new system design and enhancements. Junior Database Developer Vensoft Solutions, India Jun 2012 – Jul 2014

Participated in system analysis, data modeling, and PL/SQL development for a financial accounting application maintaining customer financing data.

Developed and validated stored procedures, triggers, and packages; automated data load and error-handling processes.

Supported PeopleSoft migration efforts and maintained database objects and constraints. EDUCATION

Master of Technology in Computer Science, JNTU, Hyderabad, India

Bachelor of Technology in Computer Science and Engineering, JNTU, Hyderabad, India SKILLS

ETL Tools: Informatica Power Center (9.x, 10.x), Informatica Power Exchange

Databases: Oracle 9i/10g/11g/12c, DB2, SQL Server, Teradata, MS Access

BI & Reporting: Power BI (dashboard & report development, data modeling)

Others: PL/SQL, UNIX Shell Scripting, Java, SQL*Loader, TOAD, Oracle Report Writer

Scheduling: Autosys, Control-M

Operating Systems: UNIX, Windows Server

PROJECTS

Billing & Rebate Claims Automation

• Developed and maintained ETL workflows in Informatica Power Center to process billing and rebate claim data, ensuring accurate invoicing across multiple systems including Mainframe and SAP.

• Automated data extraction, transformation, and loading processes that improved the efficiency of customer transaction processing and reporting.

• Created Power BI dashboards integrating data from Oracle and SQL Server, enabling stakeholders to track key performance indicators and operational metrics.

• Collaborated with business users and developers to refine data requirements and deliver actionable reporting tools. Informatica Upgrade & Performance Tuning

• Led Informatica Power Center upgrade from version 9.5.1 to 10.2.0, conducting end-to-end testing and minimizing system downtime.

• Optimized existing ETL mappings and workflows by applying best practices and tuning techniques, reducing runtime and improving batch performance.

• Automated shell scripting for workflow scheduling and error handling, streamlining batch execution and monitoring processes.

Financial Accounting Data Integration

• Participated in the development of a financial accounting system by designing PL/SQL stored procedures, packages, and triggers for data processing and validation.

• Defined and implemented data conversion rules, error capturing mechanisms, and data integrity checks to enhance the accuracy of monthly collection and income reports.

• Supported database migration projects and contributed to system analysis and data modeling activities. CERTIFICATIONS

• Informatica Certified Professional Data Quality Specialist (Jan 2020)

Contact this candidate