Etl Developer Resume Samples

HIGH QUALITY

The best examples from thousands of real-world resumes

EXPERT APPROVED

Handpicked by resume experts based on rigorous standards

DIVERSE EXAMPLES

Tailored for various backgrounds and experience levels

ETL Developers design data storage systems for companies and test and troubleshoot those systems before they go live. Example resumes for this position highlight skills like creating sessions, worklets, and workflows for the mapping to run daily and biweekly, based on the business' requirements; fixing bugs identified in unit testing; and providing data to the reporting team for their daily, weekly and monthly reports. Applicants' resumes should reflect a bachelor's degree in the fields of computer science, information technology or another computer-based discipline.

Find out what is the best resume for you in our Ultimate Resume Format Guide.

1

Senior ETL Developer

Built a decision support model for the insurance policies of two lines of Business- workers compensation and business owners' policy.

  • Created variables, using Informatica power center to score the policies, a process that increased the renewable policies by 35%.
  • Acted together with the users to design the underlying data warehouse and marts.
  • Analyzed and executed the test cases for various phases of testing - integration, regression and user
Candidate Info
5
years in
workforce
2
years
at this job
BA
Electronics And Communication Engineering
MS
Management Information Systems
2

ETL Developer

Involved in business analysis and technical design sessions with business and technical staff to develop requirements document and ETL design specifications.

  • A Used Erwin for Logical and Physical database modeling of the warehouse, responsible for database schemas creation based on the logical models.
  • Involved in performance tuning of targets, sources, mappings, and sessions.
  • Wrote complex SQL scripts to avoid Informatica Look-ups to improve the performance as the volume of the data was heavy.
  • Created and monitored sessions using workflow manager and workflow monitor.
Candidate Info
3
years in
workforce
2
years
at this job
BS
Computer Science
3

ETL Developer

Worked on the maintenance and enhancements for VMware Entitlements related data mart.

  • Co-ordinated monthly roadmap releases to push enhanced/new informatica code to production.
  • Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings using Informatica Designer 8.6 to extract the data from multiple source systems that comprise databases like Oracle 10g, SQL Server 7.2, flat files to the Staging area, EDW and then to the Data Marts.
  • Created mappings using different look-ups like connected, unconnected and Dynamic look-up with different caches such as persistent cache
  • Performed Impact Analysis of the changes done to the existing mappings and provided the feedback
  • Create mappings using reusable components like worklets, mapplets using other reusable transformations.
  • Participated in providing the project estimates for development team efforts for the off shore as well as on-site.
  • Coordinated and monitored the project progress to ensure the timely flow and complete delivery of the project
  • Worked on Informatica Source Analyzer, Mapping Designer & Mapplet, and Transformations.
Candidate Info
6
years in
workforce
9
months
at this job
4

ETL Developer

Worked on the maintenance and enhancements for VMware Entitlements related data mart.

  • Co-ordinated monthly roadmap releases to push enhanced/new informatica code to production.
  • Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings using Informatica Designer 8.6 to extract the data from multiple source systems that comprise databases like Oracle 10g, SQL Server 7.2, flat files to the Staging area, EDW and then to the Data Marts.
  • Created mappings using different look-ups like connected, unconnected and Dynamic look-up with different caches such as persistent cache
  • Performed Impact Analysis of the changes done to the existing mappings and provided the feedback
  • Create mappings using reusable components like worklets, mapplets using other reusable transformations.
  • Participated in providing the project estimates for development team efforts for the off shore as well as on-site.
  • Coordinated and monitored the project progress to ensure the timely flow and complete delivery of the project
  • Worked on Informatica Source Analyzer, Mapping Designer & Mapplet, and Transformations.
Candidate Info
6
years in
workforce
9
months
at this job
BA
Computer Science
5

ETL Developer

Technical environment/Tools used: MS SQL 2008, SSAS, SSRS, SSIS, MS Office, MS Project, Visio, Acorn EPS tools.

  • Provided technical support and development to the Profitability Systems and Reporting group. The group leveraged Microsoft's BI tools and Acorn's modeling software to implement accurate models, cubes, and reporting on customer and product profitability for the company's global business operations.
  • Designed and developed Data Warehouse for the Profitability Systems and Reporting group.
  • Implemented technical projects into production.
  • Wrote various technical documents, including Business Requirements, Functional and Technical Specifications, Data Flow and Process diagrams using MS Visio tools.
  • Implemented and managed project Change Control System and processes and tracks project issues resolution.
  • Managed team SharePoint site.
  • Coordinates and documents project's lessons learned.
  • Prioritized and handled multiple tasks in high-pressure environment.
Candidate Info
13
years in
workforce
4
years
at this job
6

Senior ETL Developer

Developed ETL procedures to migrate data from an existing data warehouse to an integrated enterprise level data warehouse.

  • Created and executed mapping using Slowly Changing Dimensions Type 2, Slowly Growing Target, and Simple Pass Through.
  • Prepared technical designs for Informatica mappings.
  • Developed mapping for fact loading from various dimension tables.
  • Contributed to logical and physical data modeling for the new data warehouse.
  • Created BTEQ, MLOAD and FLOAD scripts for loading and processing input data.
  • Created and executed macros using Teradata SQL Query Assistant (Queryman).
Candidate Info
6
years in
workforce
6
months
at this job
Computer Science
7

Data Architect/etl Developer

[company name] Resource Planning Database

  • Gathered requirements, designed, and developed DB2 database solution for an [company name] resource planning application.
  • The solution included DB2 configuration, data modeling, and identification of trusted data sources, database creation, and ETL processes.
  • Served as the data expert and created DB2 views for Cognos developers to complete reporting requirements.
  • Provided training and mentoring for junior database developer to resume with steady state operations.
Candidate Info
13
years in
workforce
1
year
at this job
8

Owner/senior Consultant/etl Developer

Established consulting firm specializing in data integration, Microsoft business intelligence, data warehousing, SSAS, SSIS, ETL solutions, and more. Plan and lead all projects and oversee requirements gathering. Supervise project teams. Carried out ETL development, process maintenance, flow documenting, and management, plus T-SQL tuning and SSIS for clients of Analyst Int'l, including Bank of America, Commonwealth of Pennsylvania, and Nordstrom.

  • Led successful conversion of SQL Server 2008 data integration process to SQL Server 2012.
  • Developed ETL framework for processing and monitoring import of flat files in SSIS for key client.
  • Enabled clients to align BI initiatives with business goals to facilitate competitiveness and productivity.
  • Improved efficiency for clients by training new programmers in organizational ETL processes.
Candidate Info
22
years in
workforce
4
years
at this job
AAS
Electrical Engineering
9

ETL Developer

Interacted with end users and line managers to gather business requirements and conducted user acceptance.

  • Interacted with third party vendors and identified different external and internal homogenous and heterogeneous sources and extracted and integrated data from flat files, Oracle, SQL Server sources and loaded to staging area and database/Datamart tables.
  • Created Informatica Data quality plans according to the business requirements to standardize, cleanse data and validate addresses.
  • Integrated data quality plans as a part of ETL processes.
  • Debugged existing ETL processes and did performance tuning to fix bugs.
  • Environment: Informatica Power Center 8.6.1, Informatica IDQ 8.6.2, Oracle 10g, SQL, PL/SQL, TOAD, SQL Server, Autosys
Candidate Info
7
years in
workforce
5
months
at this job
AS
Computer Technology
BS
Computer Technology
10

Data Analyst/etl Developer

Utilize my ETL background for the creation and execution of informatica workflow processes and complex SQL code.

  • Developed and tested extraction, transformation, and load (ETL) processes.
  • Designed and developed Informatica's Mappings and Sessions based on business user requirements and business rules to load data from source flat files and oracle tables to target tables.
  • Designed and implemented stored procedures, views and other application database code objects to aid complex mappings.
  • Maintained SQL scripts and complex queries for analysis and extraction.
  • Designed Tidal jobs that automated the ftp process of loading flat files posted on the ftp server.
  • Provided guidance to campaign analyst on complex technical projects that required Advance SQL coding
Candidate Info
14
years in
workforce
1
year
at this job
BS
Management

Your Resume, Made Easy.

You are looking for your dream job and need a resume? My Perfect Resume is your solution and takes the hassle out of resume writing. Create the perfect job-worthy resume effortlessly in just a few clicks!