ETL Architect Resume

ETL ARCHITECT RESUME

Personal Information

Name:

[Your Name]

Address:

Kansas City, MO 64101

Email:

[Your Email]

Summary

Dedicated ETL Architect with over 8 years of experience in designing and implementing efficient ETL processes. Proficient in data integration, transformation, and loading from various sources into data warehouses. Strong expertise in Informatica, Talend, and Apache NiFi, with a proven track record of optimizing data workflows to enhance data quality and accessibility.

Skills

  • ETL Tools: Informatica, Talend, Apache NiFi, Microsoft SSIS

  • Database Management: Oracle, SQL Server, PostgreSQL, MySQL

  • Data Modeling and Architecture

  • Data Warehousing Concepts: Star Schema, Snowflake Schema

  • SQL and PL/SQL Programming

  • Performance Tuning and Optimization

  • Cloud Technologies: AWS, Azure, Google Cloud Platform

  • Agile and Waterfall Methodologies

  • Data Quality Management and Data Governance

Professional Experience

ETL Architect

Tech Solutions Inc. — San Francisco, CA
March 2020 - Present

  • Designed and implemented ETL processes to extract data from various sources, including APIs, CSV files, and relational databases, transforming it for analysis and reporting.

  • Collaborated with data analysts and stakeholders to gather requirements, ensuring high standards of data quality and integrity.

  • Developed and maintained ETL workflows using Informatica PowerCenter, improving data loading times by 30%.

  • Conducted performance tuning and optimization of existing ETL processes, resulting in increased efficiency and a reduction in resource usage by 25%.

  • Mentored junior developers in ETL best practices and data integration techniques.

Senior Data Engineer

Data Insights LLC — Los Angeles, CA
June 2017 - February 2020

  • Developed ETL pipelines to integrate data from multiple systems, ensuring accurate and timely data availability for business intelligence reporting.

  • Implemented data validation and cleansing processes using Talend, enhancing data quality and compliance with business standards.

  • Assisted in the migration of ETL processes to a cloud-based environment on AWS, reducing operational costs by 20% while improving scalability.

  • Designed and maintained a robust data warehouse architecture, enabling efficient querying and reporting for stakeholders.

Data Analyst

ABC Corporation — San Diego, CA
January 2015 - May 2017

  • Analyzed data trends and patterns to provide actionable insights to stakeholders, resulting in a 15% increase in sales performance through targeted marketing strategies.

  • Created reports and dashboards using Tableau and Power BI, allowing teams to visualize and understand key performance metrics effectively.

  • Collaborated with cross-functional teams to enhance data collection processes, improving overall data accuracy by 10%.

Education

Bachelor of Science in Computer Science
University of California — Los Angeles, CA
Graduated: May 2014

Certifications

  • AWS Certified Data Analytics – Specialty

  • Informatica Certified Professional

  • Microsoft Certified: Azure Data Engineer Associate

Projects

Data Warehouse Optimization Project

  • Led a team to redesign the ETL processes for a major retail client, utilizing Apache NiFi for real-time data ingestion. Achieved a 40% reduction in data processing time and improved data accuracy.

Cloud Migration Initiative

  • Managed the migration of on-premise ETL processes to AWS, implementing best practices for security and compliance. The project resulted in significant cost savings and enhanced data accessibility for users.

Reference

Available upon request.

Resume Templates @ Template.net