ETL Application Developer Resume Sample
Work Experience
- Understands customers’ processes and products and how they fit within the goals of the business unit
- Oracle experience with working knowledge in performance and tuning, efficient SQL writing, stored procedures/PLSQL coding etc.
- Play a lead role to facilitate the full product life cycle of various data initiatives. This includes design technical solution, writing of detailed specifications for developers, performing code reviews, coordinating code migrations, managing the user acceptance testing, ensuring successful migration to production
- Maintain the production Business Intelligence products and solutions, including resolving production issues and responding quickly to priority problems
- Research, troubleshoot, and resolve data issues impacting extract delivery
- Work closely with Business Systems Analysts to understand requirements regarding solutions, ensure data quality and match-back to core systems transaction results
- Collaborate on the definition, development, and maintenance of standards and processes
- Drive continuous improvement and automation in BI solutions and processes
- Serve as mentoring resource for other developers
- Support DentaQuest’s goals and objectives by working closely with management team to deliver value to the business
- Evaluate technical designs and data mapping documents, in partnership with designers and developers, based on user requirements
- Utilize designs to develop and implement accurate, defect-free code
- Create and update technical documentations with a detailed level of technical specification
- Create unit test plans and conduct unit testing accordingly
- Participate and provide feedback in
- Design technical solutions and advise on the appropriate use of ETL technology (Oracle, Informatica, Unix and others)
- Build quality, well defined and performing ETL components for Bank's Ledger and P&L systems
- Ensure high code quality and usage of best practices
- Support defects resolution
- Provide key project execution and L3 production support capability
- Guide and mentor a geographically dispersed team of ETL developers and information analysts to provide best-in-class data reporting and analytics to the enterprise
- Manage team work efforts, including job prioritization, work effort estimation, and team scheduling
- Take ownership of applications and data products, as assigned
Education
Professional Skills
- Autosys experience or experience with other scheduling/monitoring tools
- Experience writing technical specifications including ETL source to target mapping documents
- Experience in performing general trouble shooting and provide consultation to the development teams
- Experience in PL/SQL, SQL Loader, PERL, scheduling tool and UNIX Shell scripting required
- UNIX scripting, job scheduling tool, Oracle SQL and PL/SQL experience with full development lifecycle from inception through implementation
- Experience in any scheduling tools such as IBM Tivoli Workload Scheduler, Control M, AutoSys, etc
- UNIX scripting and Oracle SQL or PL/SQL experience, with full development lifecycle from inception through implementation
How to write ETL Application Developer Resume
ETL Application Developer role is responsible for insurance, modeling, assembly, research, design, reporting, architecture, database, integration, software.
To write great resume for etl application developer job, your resume must include:
- Your contact information
- Work experience
- Education
- Skill listing
Contact Information For ETL Application Developer Resume
The section contact information is important in your etl application developer resume. The recruiter has to be able to contact you ASAP if they like to offer you the job. This is why you need to provide your:
- First and last name
- Telephone number
Work Experience in Your ETL Application Developer Resume
The section work experience is an essential part of your etl application developer resume. It’s the one thing the recruiter really cares about and pays the most attention to.
This section, however, is not just a list of your previous etl application developer responsibilities. It's meant to present you as a wholesome candidate by showcasing your relevant accomplishments and should be tailored specifically to the particular etl application developer position you're applying to.
The work experience section should be the detailed summary of your latest 3 or 4 positions.
Representative ETL Application Developer resume experience can include:
- Develop complex data extracts, applications, and ad-hoc queries as requested by internal and external customers using SQL, SSIS or Informatica toolset (Powercenter, B2B with MFT)
- Work with business professionals within Risk and Return to develop and continuously improve our data infrastructure. to support the reporting, monitoring, evaluation, and analysis of various risks across the investment portfolio
- Experience and solid understanding of Bigdata ecosystems such as Hadoop, Spark, Kafka
- Experience using SQL Server 2008, 2012, 2016 or equivalent tools
- Database experience using Oracle or SQL Server (T-SQL, PL/SQL)
- Experience developing large-scale distributed applications in Cloudera Hadoop, Hive, and/or Impala
Education on an ETL Application Developer Resume
Make sure to make education a priority on your etl application developer resume. If you’ve been working for a few years and have a few solid positions to show, put your education after your etl application developer experience. For example, if you have a Ph.D in Neuroscience and a Master's in the same sphere, just list your Ph.D. Besides the doctorate, Master’s degrees go next, followed by Bachelor’s and finally, Associate’s degree.
Additional details to include:
- School you graduated from
- Major/ minor
- Year of graduation
- Location of school
These are the four additional pieces of information you should mention when listing your education on your resume.
Professional Skills in ETL Application Developer Resume
When listing skills on your etl application developer resume, remember always to be honest about your level of ability. Include the Skills section after experience.
Present the most important skills in your resume, there's a list of typical etl application developer skills:
- Good track record in Oracle database development, i.e. good knowledge & practice of Oracle SQL and PL/SQL
- Being a true team player and effective communicator
- Very good track record in OFSAA/informatica development, i.e PowerCenter, Developing SCD/T2T
- Experience working with Oracle 10G or later
- Experience in running batches via job scheduler (e.g. Control M)
- Experience as Software Developer
List of Typical Skills For an ETL Application Developer Resume
Skills For Mainframe & ETL Application Developer Resume
- Experience using Oracle supplied utilities including: SQL Loader, external tables, and Oracle built in packages
- Working Knowledge of Hadoop, Hive, Spark/Scala and other Big Data platforms and applications
- Understanding of data warehousing techniques and dimensional modeling
- Extensive knowledge of data integration and processing including extraction, transformation, and loading (ETL)
- Participate in unit testing and system integration testing
- Expertise in developing Informatica, OFSAA, Database and Autosys components
- Deep expertise in writing PL SQLs in Oracle and ETL tools
- Develop technical solutions using Big Data techniques in data & analytics processes
- Maintain existing data platforms and create new business solutions from inception to fully developed products
Skills For Lead ETL Application Developer Resume
- Collaborate with others to automate processes and ensure appropriate ongoing access to data
- With coaching, can identify new areas of data, research and big data technology that can solve business problems
- Knowledge of OFSAA data model and Hyperion suit is mandatory
- Experience in writing and tuning SQL scripts including: tables, views, indexes, and complex PL/SQL objects including: procedures, functions, triggers, and packages
- Experience developing ETL/E-LT objects including Interfaces, Packages, Scenarios and Procedures and load strategies for relational, Type 1, 2, and 3 slowly changing dimensions using Oracle Data Integrator
- Experience as a technical team lead responsible for data warehouse ETL components architecture
- Experience using ETL tools like Oracle Data Integrator or Oracle Warehouse Builder and migrating data from various sources and targets including databases, flat files, and XML files
Skills For Etl-application Developer Resume
- Hands on experience in Ab Initio tools such as Graphical Development Environment (GDE), Enterprise Metadata Environment including air commands (EME), and data profiling
- Broad-based cross-functional IT experience in application design and development with multiple tool sets is essential
- Experience with common tools: Jenkins, Artifactory, GitHub, InelliJ, JUnit, JIRA
- Strong knowledge of UNIX, Shell and Perl scripts
- Help develop automated test cases and plans to complete the unit testing and support System testing
- Code, test, modify, debug, document, and implement software using approved methodologies
- Develop scripts to automate the execution of code using shell scripts under Unix or LINUX
Skills For ETL Application Developer Lead Resume
- Willingness to work outside of normal business hours to coordinate with US and offshore teams
- Participate in daily scrum and other Agile ceremonies
- Create, read and translate business requirements
- Exp. with ETL tools like Informatica (Informatica Power center 9x, Informatica Data Quality 9x) and/or SSIS or equivalent tools
- Familiarity with waterfall, iterative, and agile development methodologies
- Extensive knowledge of Informatica
Skills For Abinitio ETL Application Developer Resume
- Hands on experience in Ab Initio tools such as Graphical Development Environment (GDE), Enterprise Metadata Environment including air commands (EME), and data profiling
- Experience in relevant technologies
- Develop data acquisition and infrastructure processes to deliver the data required to build predictive and other analytic models
- Resolve code problems and data-related issues on a timely basis