Senior ETL Developer Job Description
Senior ETL developer
provides business Intelligence experience to include understanding of data warehousing concepts, data marts, OLAP, logical and physical models, and dimensional modeling.
Senior ETL Developer Duties & Responsibilities
To write an effective senior ETL developer job description, begin by listing detailed duties, responsibilities and expectations. We have included senior ETL developer job description templates that you can modify and use.
Sample responsibilities for this position include:
Improve existing data designs and design new databases and data models, including relational table structures, using Unix Shell Scripting, Oracle and SQL Server
Manage the requirements gathering, development and rollout of major projects on the solution platform
Drive and develop new data import/export or other transformation exercises
Work directly with reporting team to ensure ongoing operational and new work complies with requirements and ETL best practice and audit standards
Provide ad-hoc support for advanced strategic data analysis initiatives
Act as the go-to expert on all underlying transformation logic against data in the data warehouse
Support business user questions about the data and provide documentation and training when and where necessary
Support campaign and report developers with data inquiries or new data requests
Drive and participate in all new data aggregation / snapshot processes
Identify process simplification opportunities for overall Data Warehouse environment
Senior ETL Developer Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Senior ETL Developer
List any licenses or certifications required by the position: AWS, ITIL, BODS, SAP
Education for Senior ETL Developer
Typically a job would require a certain level of education.
Employers hiring for the senior ETL developer job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and Master's Degree in Computer Science, Engineering, Education, Technical, Information Technology, Science, Business, Information Systems, Computer Engineering, Computers
Skills for Senior ETL Developer
Desired skills for senior ETL developer include:
SQL
ETL dependent technologies in the below scope:
Financial Services and IT industries
Oracle Database
ASP and .Net development to the oversight of significant assignments
Data warehousing concepts
Ab>Initio
Data architecture and concepts of relational and dimensional databases
Oracle
Design and analysis methodology and application development processes from both an industry and client perspective
Desired experience for senior ETL developer includes:
Excellent knowledge of and experience with data warehousing/data marts concepts and practices viz
Knowledge of retail broker dealer business
Informatica proficiency, SSIS experience is a plus
Experience with design methodologies related to reusable components and code
Experience with retail or e-commerce data models
At least 5 years of data warehousing ETL work
Senior ETL Developer Examples
1
Senior ETL Developer Job Description
Job Description Example
Our innovative and growing company is hiring for a senior ETL developer. We appreciate you taking the time to review the list of qualifications and to apply for the position. If you don’t fill all of the qualifications, you may still be considered depending on your level of experience.
Responsibilities for senior ETL developer
- Define level of effort and ensure all Janus standards and processes are followed and enforced for the movement, transformation and loading of data
- Create and support the associated scheduling logic for the ETL using CA Autosys scheduler
- Read and translate logical data models and use ETL skills to load the physical layer, based on an understanding of timing of data loads, data transformation and optimization of ETL load performance
- Provide production support and test approaches for data management projects
- Coordinate with infrastructure teams to ensure adequate capacity and performance planning
- Document ETL packages and processes deployment and support instructions
- Serve as a senior software developer understanding business data, processes, and requirements
- Work in a global team setting to design, develop and support ETL architecture for data integration, data warehouse, and data Marts for the organization
- Define and develop application components, platforms, and interfaces
- Provide data integration guidance to other MCM cross-functional, cross-platform application development teams
Qualifications for senior ETL developer
- Ability to think and communicate critically in order to support and facilitate strategic data warehouse extension and analytical initiatives
- Expert knowledge of data modeling concepts, data warehouse and data aggregation processes and strategies
- Experience with marketing / customer data
- Knowledge and command of data governance/best practices
- Previous experience with a corporate BI tool (MicroStrategy)
- You should be a stand out colleague and have a positive outlook, with the personality to work with the development committee present to business or IT senior managers as required
2
Senior ETL Developer Job Description
Job Description Example
Our growing company is looking for a senior ETL developer. Thank you in advance for taking a look at the list of responsibilities and qualifications. We look forward to reviewing your resume.
Responsibilities for senior ETL developer
- Act as subject matter export, as needed
- Make recommendations to use innovative, creative approaches as appropriate to meet internal client needs
- Assist in the design and development of enterprise data standards, best practices, and governance processes
- Develop data movement processes and code (using data movement tools, database stored procedures )
- Understands the common data movement architectures (like ETL, ELT,ETLT, ) and when/how each should be used
- Should be able to make judicious decision with respect to ETL design so that the final ETL solution satisfies all the quality and non-functional requirements criteria
- Should be able to come up with multiple approaches to any ETL problem statement/solution/technical challenge and take well informed decision to pick the best solution
- Making effective use of resources during the various stages of the work, ensuring that business objectives are met and deliverables achieved to agreed time, cost and quality
- Overseeing performance of programming staff, reporting on their effectiveness and takes action to remedy deficiencies
- Defines, oversees and contributes to ETL solutions, standards, controls, procedures, and documentation
Qualifications for senior ETL developer
- 2+ years of technical experience with SQL Server
- 5+ Years development experience, must include ETL tool like DataStage and/or Informatica , UNIX Shell /Perl Scripting
- 5+ Years experience with relational database technologies (preferably Teradata and or DB2)
- 5+ Years Data warehouse Applications Development experience
- 5+ Years development experience using standard Software Development Life Cycle Methodology
- Proficiency in MS Office (Word, Excel, PowerPoint, Outlook and Access)
3
Senior ETL Developer Job Description
Job Description Example
Our innovative and growing company is looking for a senior ETL developer. Please review the list of responsibilities and qualifications. While this is our ideal list, we will consider candidates that do not necessarily have all of the qualifications, but have sufficient experience and talent.
Responsibilities for senior ETL developer
- Collaborate with technical team members, business liaisons, and end-users to deliver enterprise data integration ETL solutions
- Design, Develop, implement, and optimize ETL workflows and transformations
- Implement standards and procedures for ETL development and tool configurations
- Triage the resolution of complex data integration ETL issues in a timely manner
- Serves as a key contributor to the design and development of exception handling, data standardization procedures and Quality Assurance controls
- Collaborate with the BI and Analytics teams to solve, understand and document complex business issues
- Develop the ETL packages to design specifications
- Update ETL package specifications with changes
- Partnering with team members throughout the organization to drive a culture of using data to deepen customer relationships, drive revenue and identify customer growth opportunities
- Expressing creativity building innovative ETL solutions for every phase of the data lifecycle according to data management best practices
Qualifications for senior ETL developer
- Experience in scheduling tool like TWS
- Java Development 3+ Years
- Bachelor of Science in Information Systems or related technical field
- 24 months of experience as an ETL Developer, Systems Analyst or related field
- Experience with any major ETL vendor, such as SSIS, Informatica, Data Stage
- Experience with Oracle E-Business Suite (EBS) application
4
Senior ETL Developer Job Description
Job Description Example
Our company is growing rapidly and is hiring for a senior ETL developer. Please review the list of responsibilities and qualifications. While this is our ideal list, we will consider candidates that do not necessarily have all of the qualifications, but have sufficient experience and talent.
Responsibilities for senior ETL developer
- Actively engaging in risk identification, action planning and mitigation activities
- Leading data warehouse development activities such as planning, designing, developing, testing, and implementing data system enhancements and functionality modifications
- 6+ years of experience designing, engineering and delivering data integration code in an enterprise environment
- Ability and passion to deliver ETL development projects quickly and efficiently
- Exceptional collaboration, project leadership and communication ability at the center of engineering projects involving other engineers, project managers, business stakeholders, analysts and business intelligence analysts
- Demonstrated ability to innovate, drive projects to successful completion and create enduring solutions to data management problems
- Experience with enterprise scheduling and data warehouse operations
- Demonstrated ability to optimize data warehouse ETL packages and processes
- Applies/uses complex tools and systems of several levels of depth
- Optimizes and implements different business applications/ modules for different IT Clusters or multiple sites
Qualifications for senior ETL developer
- Read, write, and maintain SQL statements
- Logical and physical data modeling from various data sources
- Experience with SSAS, SSRS
- Experience developing financial investment applications with a preferred understanding of securities operation including research analysis, portfolio management, asset allocation, trading and trade clearing
- A proven track record designing and developing high availability, multi-tier applications with hand-on experience developing on each tier (UI, middle tier, back end)
- Solid development discipline including requirements analysis, external and inline documentation and unit testing
5
Senior ETL Developer Job Description
Job Description Example
Our company is looking for a senior ETL developer. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for senior ETL developer
- SQL Server Database Development(T-SQL)
- Develops know-how for parts of the IT function
- Supports, manages and develops customer relations
- Uses standard analytical tools and rules to determine root cause and resolve the broad range of common system or application problems
- There is no supervisory responsibilities associated with this job
- Reconciliation checks
- Design processes to extract, transform and load the source data to the target data warehouse
- Develop Standard and Big data jobs in Talend studio
- Designing and implementing ETL architectures based on the business, data and functional requirement
- Develop, Maintain and Document SSIS Packages and Solutions
Qualifications for senior ETL developer
- Excellent technical and business oriented communication skills are a must
- A proven track record delivering complex solutions on time and in scope
- Self-driven with the ability to manage multiple projects
- 5+ years of experience in ETL design & development using industry standard ETL tools
- 5+ years of experience with Pentaho Data Integration or similar product
- 5+ years of design/architecture experience in data integration of master data and meta data