Senior ETL Developer Job Description
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:
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:
Desired experience for senior ETL developer includes:
Senior ETL Developer Examples
Senior ETL Developer Job Description
- 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
- 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
Senior ETL Developer Job Description
- 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
- 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)
Senior ETL Developer Job Description
- 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
- 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
Senior ETL Developer Job Description
- 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
- 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
Senior ETL Developer Job Description
- 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
- 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