Livecareer-Resume

Etl Pl Sql Developer Resume Example

Love this resume?

By clicking Build Your Own Now, you agree to our Terms of Use and Privacy Policy

Jessica Claire
  • Montgomery Street, San Francisco, CA 94105
  • H: (555) 432-1000
  • C:
  • resumesample@example.com
  • Date of Birth:
  • India:
  • :
  • single:
Professional Summary
Around 6months of experience with design/developing ETL processes using BO Data Integrator. Experience in Design & Development of Enterprise Data Warehouse infrastructure processes for extracting, transforming and loading data Analyzed Source Systems, Business Requirements, Identify and Document Business Rules for Decision Support Systems. Extensively used SQL and PL/SQL for development of Procedures, Functions, Packages and Triggers. Wide experience in reengineering concepts and tools along with End-to-End understanding of Business Concepts. Experience in developing Unix Shell Scripts for automation of ETL process. Experience in developing XML/XSD/XSLT as a part of Source XML files for Talend and also input XML for Webservice Call. Strong communication skills and demonstrated ability to work effectively with business users. Experience with shell scripting schedulers for scheduling nightly jobs. Experience with AGILE Methodologies.
Core Qualifications
  • Operating Systems * Windows, Linux
  • Programming Languages
  • Databases * JAVA, Hibernate, J2EE, SQL and PL/SQL.
  • Oracle 10g/11g, MySQL, DB2, PostgreSQL.
  • Scripting Languages * HTML, AJAX, JavaScript, XML, CSS
  • Web Servers
  • IDE’s & Tools * Apache Tomcat
  • Eclipse, NetBeans, Talend Open Studio for Integration and Talend for MDM
  • Oracle Tools * TOAD , SQL Developer, SQL Navigator, SQL*Loader and SQL*PLUS
Experience
ETL / PL-SQL Developer, 06/2011 to 07/2014
, ,
Data migration, to
Amentum , ,
  • It deals with the data moving into our database from the client’s old application.
  • For this we used Talend Open Studio (IDE) which is a java environment Oriented IDE.
  • I used to design talend jobs to complete migration of data (Extract transform, Load).Writing queries flat file loading into Database using sqlloader, Optimizing queries at developer’s desk, developing talend jobs for a complex Financial System, scheduling jobs are my primary tasks.
  • Responsibilities: Develop Talend jobs migrate the data from flat file such as CSV, fixed length files etc.
  • to oracle tables.
  • Jobs are able to process large amount of data in quick time Performing logical operations in talend jobs to transform data into application understandable format Data first loaded into the staging tables and then into original tables.
  • Communicated with business customers to discuss the issues and requirements.
  • Troubleshooting issues in the production environment and help in resolving issues in the same.
  • Used debugging tools to debug the flow of data and found the exact issues where expected data was not populated correctly Designed custom components in talend to specific needs Created shell scripts to fine tune the ETL flow and execute them in a proper way Performed unit testing at various levels of the ETL and actively involved in team code reviews.
  • Worked with team to maintain version control of talend Jobs Able to write sub jobs and call them from a parent jobs Used to design job to perform data validations.
JAVA Developer, 06/2013 to 06/2014
EVAN , ,
  • Carter Bank & Trust Module : “Coresoft” Description: Coresoft is a typical Core banking application specially designed for the teller to make their task pretty much easy when compared to other applications with enhanced security.
  • I have been working with the Interface module and in specific I have been dealing with interface which handles client’s teller machine requests and converts into product understandable format.
  • Responsibilities: Used to write java code to interpret 128 character length message coming from a third party and split it into parts so that useful information can be gathered then pass it to application for processing.
  • Used inheritance to comply with company standards.
  • Used single pattern to reduce the redundancy of objects Used log4j for errors Used hibernate one-to-many , many-to-many concepts for persistence.
Education
Masters: Applied Computer Science, Expected in
to
Northwest Missouri State University - Maryville, MO
GPA: GPA: 3.8/4.0
Applied Computer Science GPA: 3.8/4.0
Diploma: JAVA, Expected in Mar 2012
to
NIIT - Hyderabad,
GPA: GPA: 3.0/4.0
JAVA GPA: 3.0/4.0
Bachelor of Technology: Computer science, Expected in April 2011
to
JNTU - Hyderabad,
GPA: GPA: 3.0/4.0
Computer science GPA: 3.0/4.0
Professional Affiliations
3 Years of experience on a Data Integration/Data warehouse Projects using Talend ETL tool, OLAP Tools, Oracle, Web Designing, XML and Unix Scripting. Extensive experience with Talend (ETL Tool) for Data Extraction, Transformation and Loading. Extensive experience in building Data Warehouses/Data Marts using ETL tool Talend for Data Integration (5.x). Worked on Web services as a part of Talend and obtained the successful connection of the external Webservice call. Reporting experience with tools like Tableau.
Skills
AJAX, Apache, banking, CSS, client, version control, Databases, Database, debugging, Eclipse, ETL, XML, Financial, HTML, DB2, IDE, J2EE, java, JavaScript, Linux, log4j, Windows, migration, MySQL, Navigator, Operating Systems, Oracle, developer, PL/SQL, PostgreSQL, Programming, quick, scheduling, shell scripts, Scripting, SQL, SQL*Loader, sqlloader, tables, TOAD, Tomcat, Troubleshooting, Web Servers

By clicking Build Your Own Now, you agree to our Terms of Use and Privacy Policy

Disclaimer
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

How this resume score could be improved?

Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:

69Fair

Resume Strength

  • Length
  • Personalization
  • Target Job

Resume Overview

School Attended
  • Northwest Missouri State University
  • NIIT
  • JNTU
Job Titles Held:
  • ETL / PL-SQL Developer
  • Data migration
  • JAVA Developer
Degrees
  • Masters
  • Diploma
  • Bachelor of Technology