Etl Developer Resume
This is a free Etl Developer Resume example that covers objectives and tips to gets you the best job. This professional resume template with action words will help you in writing perfect CV for the desired Etl Developer Job.
Etl Developer Job Description
- An ELT Developer is experience with database procedural languages / commercial ETL Tools/shell scripting / XML/ file transfer methods/ mainframe systems/ financial applications/brokerage and investment systems.
- Responsible for the design, development, coding, testing, debugging and documentation of applications to satisfy the requirements of one or more user areas.
- Includes hands-on new development as well as support, maintenance or enhancement of existing applications.
- Works closely with client management to identify and specify complex business requirements and processes. Researches and evaluates alternative solutions and makes recommendations.
- Responsible to create and maintain Informatics processes, mentor junior Informatics developers, manage data warehouse schema, assist with SQL tuning, create views, tables, snapshots to assist report team.
Sample Etl Developer Resume Template
Contact information
In this section you have to include your Name, current home address, Mobile telephone number, Landline telephone number and your personal email address which is currently used.
- Full name
- Present and permanent addresses
- Telephone numbers
- Email address
Professional or career objective
Your objective is the one that clearly underlines your aims and aspirations in that profession. For example a Computer Graduate will have to write an objective which is concise and precisely speaks about his role that he wants to play in the Organization.
Sample Objective for Etl Developer
An innovative, forward-thinking, proactive, respected professional who has accomplished significant achievements in business intelligence, ETL, data warehousing, analysis, problem-solving, training, negotiating, cost-reduction, research and development
Career Achievements
If you have any major Career Achievements or any Appreciation then this is the section where they should be listed. For Example an Etl Developer can add his/her career achievements like,
- An innovative, forward-thinking, proactive, respected professional who has accomplished significant achievements in business intelligence, ETL, data warehousing, analysis, problem-solving, training, negotiating, cost-reduction, research and development.
- Presents experience in effectively applying in-depth technical knowledge to the design and development of new and efficient systems.
- Takes a hands-on approach to implementing change and formulating policy for improving production within highly respected industry leading firms and fast-moving growth companies in the public and private sectors. Career history demonstrates expertise in learning and adapting to various software programs in a timely manner.
- Adept at time management and project management.
Experience:
Previous work experience plays an important role while applying for a Job and hence it should be well presented in the resume. Most of the questions during your resume will be related to the previous job that you had and hence you should be well prepared for it. You should begin with putting the name of the organization that you worked for, the duration of your work and the post or the designation at which you were working. After this, you can effectively place points in a bulleted format that talk about the responsibilities and the achievements that you may have achieved during your stay at the previous organization. The work experience of an experienced Etl Developer applying for a job would look like,
Etl Developer/Technical Analyst
Reliance InfoTech, Customer Care Center, Technical Team, Mumbai, 2006-Present
- Create new and/or modify existing Crystal Reports for Department Vice-Presidents, middle managers and staff.
- Design reports from IVR (Interactive Voice Response), Edge, and Focus databases to meet requirements of Reliance Customer Care Center and its clients.
- Create new and/or modify existing Oracle PL/SQL stored packages and procedures using multiple databases to feed the data into the Crystal Reports more efficiently. Strong PL/SQL skills are required.
- Analyze reports, data and systems when existing reports do not function properly. Correct these reports and/or data. Recommend solutions to keep the data correct in real-time.
- Create new tables and correct data in Oracle database as required.
- Import data from Excel spreadsheets to Oracle tables. Export data from Oracle tables to Excel spreadsheets. Export Crystal Reports to Excel spreadsheets.
- Automate reporting functions by posting reports on the intranet web site.
- Backup system analyst for backup tape rotation and system status reports as needed.
- Create documentation for the system and the position. Map Oracle main database tables used in the web site reports.
- Other duties as assigned.
- Worked as a team member and independently.
Maharashtra Government, Information Technology Department
ETL/Oracle Applications Development Contractor, Mumbai, 2004-2006
- Developed specifications, reviewed design, and migrated data for two phases of the Planning and Development Tidemark Permit Plan system installation of 38 case types.
- Main contact for vendor regarding technical and user issues for the design, development and maintenance of the new Oracle based client-server software system.
- Designed a new system for the Fire Prevention Department using Tidemark’s Advantage, Utilities, Designer and Import/Export modules.
- Created links between Fire Prevention Department case types never done before in Tidemark Advantage.
- Supported the Tidemark Permit Plan / Advantage client-server software and AIRS (Automated Inspection Request System) for the Department of Planning and Development and Fire Prevention Department for over six years.
- Main technical advisor for the customer departments.
- Coordinated efforts with several departments for data transfers and data standardization across micro and mainframe platforms.
- Created links between Tidemark Permit Plan / Advantage and other batch and real-time, third-party software systems.
- Worked closely with third-party software vendors.
Senior Systems Analyst
Mahalaxmi Corporates, Mumbai, 2001-2004
- Extracted, transformed, cleansed, and loaded (ETL) Fire Prevention Department data from their legacy Access system to Oracle and Permit Plan / Advantage.
- Extracted, transformed, cleansed, and loaded (ETL) Long Range Planning Department data from their legacy RBase system to Oracle and Permit Plan / Advantage.
- Prepared Fire Prevention Department data to use an Automated Inspection Request System for maximum effectiveness, virtually eliminating their staff time for inspection request data entry and reporting.
- Automated manual processes by creating Oracle SQL scripts, PL/SQL cursors, packages, procedures, functions, triggers, mutating table triggers, tables, indexes, views, and constraints.
- These were used to check and correct data entry and automatically update data records to improve the accuracy of data and the speed of the system.
- Created and modified many Oracle control files for data loads.
- Taught Tidemark Advantage and Tidemark Utilities training classes for Fire Prevention staff.
- Created and streamlined over 150 Crystal Report Writer daily, weekly and monthly reports used for day-to-day operations and management decisions.
- Clarified user procedures for best results in their new software.
- Coordinated and conducted weekly project status meetings.
Education and Certification:
The academic details need to be mentioned in a tabulated format with respect to the degrees or the courses that the candidate would have undertaken in the past. The latest degree or course comes first followed by the last completed course and hence forth going backwards. For example an Etl Developer who has completed post graduation or graduation course is applying for a Job or to a company or an organization then his/her details would be like,
- B Sc, With Honors
Pune Science Collage, Pune, 1999
- Diploma Course in Industrial Engineering / Information Systems
Taxila Career Acheivers, Mumbai, 2001
Honors
If you have won any competitions national or international then they could also be highlighted here. For example an Etl Developer could lay stress on any exams that he may have given or any seminars or conferences attended. If you are a part of any honorary society or any nonprofit organization then that could also be added here.
The honors and the activities section of an Etl Developer would look like,
- Certified Developing Personal by Maharashtra Govt.
- Multiplying Increase in Remuneration in short Service time.
References:
The References are generally required so that your present employer can gauge you through the eyes of the people who you were associated with or have worked for. So your teachers or college professors’ details could be placed here. Or your past employer who you would have worked under can also be used as a reference. Ensure that the people whose names you enter know you well and do inform them that you are placing their names as reference because many companies call to confirm. For example the references section of an Etl Developer could also look like,
Mr. Danish Gosh
Sr. Programmer
GL Software’s
danishghosh@iiijjkk.com
Salary Range of a Project
- The average salary received is approximately Rs. 20000 per month. This works out to an annual pay package of 2.40 Lakhs to 2.85 Lakhs per annum CTC.
- The salary from an American perspective works out to be $16500 per Month.
Note: This salary may be variable and it may change from organization to organization.
Frequently asked Etl Developer Interview Question
- How to work with mapplet designer in informatics?
- What is the filename which you need to configure in UNIX while installing informatics?
- After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualifier can we map these ports directly to target and how?
- What is fatless fact schema?
- How many ways you create ports?
- How the informatics server sorts the string values in Rank transformation?
- What is casual dimension?
- Without source how to insert record to target?
- In which conditions we can not use joiner transformation (Limitations of joiner transformation)?
- Which kind of index is preferred in DWH?
- How to load a relational source into file target?