Summary
Experienced ETL Informatica Developer with 5 years of experience in designing and developing ETL jobs to extract data from various sources, transform it, and load it into a target data warehouse. Proficient in designing mappings, workflows, and sessions with expertise in Informatica PowerCenter 10.x/9.x/8.x, Oracle and SQL Server databases.
Skills
- ETL Development
- Informatica PowerCenter 10.x/9.x/8.x
- Oracle and SQL Server databases
- SQL/PLSQL
- Data Warehousing concepts
- Data Analysis
- Data Cleansing
- Data Integration
Experience
ABC Financial Services, Inc.
ETL Informatica Developer | Jan 2018 – present
- Design and develop ETL jobs using Informatica PowerCenter 10.x/9.x to extract data from various sources, transform it, and load it into a target data warehouse.
- Create complex mappings, workflows, and sessions using various transformations including Source Qualifier, Expression, Filter, Router, Aggregator, Joiner, Lookup, Update Strategy, and others.
- Perform data analysis and data cleansing using SQL/PLSQL before loading data into target tables.
- Design and implement ETL job scheduling using Informatica Workflow Manager and Control-M Scheduler.
- Develop and maintain data mapping documents, technical specifications, and unit test plans.
- Optimize ETL jobs performance using partitioning, indexing, and parallel processing techniques.
- Provide production support and troubleshoot ETL job failures.
XYZ Insurance Company
ETL Developer | May 2016 – Dec 2017
- Developed and maintained ETL jobs using Informatica PowerCenter 9.x/8.x to extract data from various sources, transform it, and load it into a target data warehouse.
- Designed and developed complex mappings, workflows, and sessions using various transformations.
- Performed data analysis and data cleansing using SQL/PLSQL before loading data into target tables.
- Implemented ETL job scheduling using Informatica Workflow Manager and Control-M Scheduler.
- Optimized ETL jobs performance using partitioning, indexing, and parallel processing techniques.
- Provided production support and troubleshoot ETL job failures.
Education
Bachelor of Science in Computer Science
XYZ University, May 2016
Avoid Jargon
Unless it's a common term in your field, avoid using jargon or acronyms that the hiring manager may not understand. Stick to clear, plain language.
Introduction
An Etl Informatica Developer is responsible for designing and implementing ETL (Extract, Transform and Load) processes to transfer data between systems. Writing a resume that highlights your skills and experience can help you stand out to potential employers. Here are some tips on creating an effective Etl Informatica Developer resume.
1. Personal Information
- Start your resume with your name and contact details, including an email address and phone number.
- Make sure your email address is professional. Avoid using nicknames or personal email addresses.
2. Professional Summary
- Include a brief professional summary that highlights your Etl Informatica development skills and experience.
- Mention your experience with ETL tools, data warehousing, data modeling, and data integration.
3. Skills
- Create a separate section to highlight your technical skills and expertise.
- List the ETL tools you have worked on, such as Informatica PowerCenter, Talend, and DataStage.
- Mention your knowledge of databases, SQL, scripting languages, and data visualization tools.
4. Professional Experience
- List your professional experience in reverse chronological order.
- Mention the projects you have worked on, the ETL tools you used, and the roles you played.
- Highlight your achievements and contributions to your team or organization.
5. Education and Certification
- List your educational qualification and any relevant certifications.
- Mention any additional courses or training you have undergone in ETL and Informatica.
6. References
- Provide a list of professional references at the end of your resume, including their names, job titles, and contact details.
- Make sure to get their permission before you list them.
Following these tips can help you create a professional and impressive Etl Informatica Developer resume. Make sure to proofread your resume thoroughly before submitting it to potential employers.
Poor Spelling of Company Names or Job Titles
Spelling mistakes, particularly of company names or job titles, can be viewed negatively by hiring managers. Always double-check for correct spelling.
Professional
Simple
Modern
Creative
Premium
Popular
