Etl lead job description
Updated March 14, 2024
14 min read
Find better candidates in less time
Post a job on Zippia and take the best from over 7 million monthly job seekers.
Example etl lead requirements on a job description
Etl lead requirements can be divided into technical requirements and required soft skills. The lists below show the most common requirements included in etl lead job postings.
Sample etl lead requirements
- Strong experience with ETL development tools.
- Experience with data profiling and data modeling.
- High level of proficiency in SQL.
- Experience with data warehousing concepts.
- Ability to plan and lead ETL projects.
Sample required etl lead soft skills
- Excellent communication and interpersonal skills.
- Ability to work independently and in a team.
- Strong problem-solving and analytical skills.
- Highly organized and results-oriented.
Etl lead job description example 1
Crescens etl lead job description
Job DescriptionJob Description:
ETL Operations Lead
Skill : AbInitio or Informatica ( AbInitio preferred )
Database: Teradata ( Must) , Snowflake is a Plus
Must be willing to do Production support role – Requires weekend on-call once every 4-5 weeks and 1 day weekshit ( shift from 12 PM to 9 PM EST)
Job Desc:
Understand the business requirements
Translate the business requirements into warehouse specific technical requirements
Design and develop common processes to transform and integrate the data into data integration layer
Participate in the business team meetings to represent the technical team and help the business team with technical feasibility. And in ensuring effective and clear communication of requirements, expectations and feedback to the team at the offshore development centers
Support existing and enhance the processes as per new emerging requirements
Development of Reusable generic code which will be used across Teams
Preparation of Knowledge Transfer (KT) documents to share the knowledge to the Production support team
Creating generic documents and upload in the SharePoint to help developers across the teams.
Participate in touch point meetings with the delivery team to support the team in moving any code to production following Release and Change management process.
Customizing the Proprietary frameworks Applications Development and Systems Integration Framework, Agile BI process model ) as per the business requirements .Customizing the Proprietary frameworks will help by simplifying architectural decision making , Optimizing development costs and helps in building extensible and flexible architectures.
Participate in the business team meetings to represent the technical team and help the business team with technical feasibility. And in ensuring effective and clear communication of requirements, expectations and feedback to the team at the offshore development centers;
Working closely with the business, IT users and end users to get a good understanding of the scope, deliverables and timelines and resolve the issues.
Suggesting new techniques to improve the performance of the existing ETL code there-by reducing the total ETL batch window, and suggest new initiative ideas which will improve the productivity and help the business.
Creating High level and Low Level Design documents which will translate the client's business requirements into specific systems, applications, and process designs for custom technical solutions based on the business demands and creating new business applications for the client using Ab Initio as an ETL platform to load business related data into the client's Enterprise Data-warehouse, which will be used by its users for reporting and analysis purposes. Further, the Beneficiary will expand Ab Initio development experience and internal methodologies to create reusable components and sub-graphs to improve productivity of resources.
Delivering high performing applications using ETL experience to improve profitability of client and Reviewing the Teradata and Ab Initio code and ensure that all requirements and quality standards are met. Perform peer reviews for developed ETL codes and provide sign-offs. Perform sanity checks in Test environment to ensure the correct codes are in place for Quality Assurance team to go-ahead with testing;
Troubleshooting and resolution of user incidents ,Performing root cause analysis (RCA) for failures and resolve them with in the Service level agreement. Analyze and provide root cause and resolution for the defects and share report with the end user and client project team. And provide development effort estimates for the enhancements.
Participate in touch point meetings with the other application team to support the team in moving any code to production following Release and Change management process. And Making sure ZERO impact to the production system with the code movement.
Preparing production implementation plans for applications. Create production deployment notes and run books for new applications;
Provide support during Quality Assurance and User Acceptance Testing of applications;
Documenting lessons learnt during each phase in internal templates created by client and share with client project team. Prepare coding standards checklists for developed code that is to be used by the development team. Create issue logs to document issues faced by team during development and testing of applications;
Remarks
: 100% remote
ETL Operations Lead
Skill : AbInitio or Informatica ( AbInitio preferred )
Database: Teradata ( Must) , Snowflake is a Plus
Must be willing to do Production support role – Requires weekend on-call once every 4-5 weeks and 1 day weekshit ( shift from 12 PM to 9 PM EST)
Job Desc:
Understand the business requirements
Translate the business requirements into warehouse specific technical requirements
Design and develop common processes to transform and integrate the data into data integration layer
Participate in the business team meetings to represent the technical team and help the business team with technical feasibility. And in ensuring effective and clear communication of requirements, expectations and feedback to the team at the offshore development centers
Support existing and enhance the processes as per new emerging requirements
Development of Reusable generic code which will be used across Teams
Preparation of Knowledge Transfer (KT) documents to share the knowledge to the Production support team
Creating generic documents and upload in the SharePoint to help developers across the teams.
Participate in touch point meetings with the delivery team to support the team in moving any code to production following Release and Change management process.
Customizing the Proprietary frameworks Applications Development and Systems Integration Framework, Agile BI process model ) as per the business requirements .Customizing the Proprietary frameworks will help by simplifying architectural decision making , Optimizing development costs and helps in building extensible and flexible architectures.
Participate in the business team meetings to represent the technical team and help the business team with technical feasibility. And in ensuring effective and clear communication of requirements, expectations and feedback to the team at the offshore development centers;
Working closely with the business, IT users and end users to get a good understanding of the scope, deliverables and timelines and resolve the issues.
Suggesting new techniques to improve the performance of the existing ETL code there-by reducing the total ETL batch window, and suggest new initiative ideas which will improve the productivity and help the business.
Creating High level and Low Level Design documents which will translate the client's business requirements into specific systems, applications, and process designs for custom technical solutions based on the business demands and creating new business applications for the client using Ab Initio as an ETL platform to load business related data into the client's Enterprise Data-warehouse, which will be used by its users for reporting and analysis purposes. Further, the Beneficiary will expand Ab Initio development experience and internal methodologies to create reusable components and sub-graphs to improve productivity of resources.
Delivering high performing applications using ETL experience to improve profitability of client and Reviewing the Teradata and Ab Initio code and ensure that all requirements and quality standards are met. Perform peer reviews for developed ETL codes and provide sign-offs. Perform sanity checks in Test environment to ensure the correct codes are in place for Quality Assurance team to go-ahead with testing;
Troubleshooting and resolution of user incidents ,Performing root cause analysis (RCA) for failures and resolve them with in the Service level agreement. Analyze and provide root cause and resolution for the defects and share report with the end user and client project team. And provide development effort estimates for the enhancements.
Participate in touch point meetings with the other application team to support the team in moving any code to production following Release and Change management process. And Making sure ZERO impact to the production system with the code movement.
Preparing production implementation plans for applications. Create production deployment notes and run books for new applications;
Provide support during Quality Assurance and User Acceptance Testing of applications;
Documenting lessons learnt during each phase in internal templates created by client and share with client project team. Prepare coding standards checklists for developed code that is to be used by the development team. Create issue logs to document issues faced by team during development and testing of applications;
Remarks
: 100% remote
Post a job for free, promote it for a fee
Etl lead job description example 2
UnitedHealth Group etl lead job description
Combine two of the fastest-growing fields on the planet with a culture of performance, collaboration and opportunity and this is what you get. Leading edge technology in an industry that is improving the lives of millions. Here, innovation is not about another gadget; it is about making health care data available wherever and whenever people need it, safely and reliably. There is no room for error. If you are looking for a better place to use your passion and your desire to drive change, this is the place to be. It's an opportunity to do **your life's best work.(sm)**
You'll enjoy the flexibility to telecommute* from anywhere within the U.S. as you take on some tough challenges.
**Primary Responsibilities:**
+ Use Informatica PowerCenter to Extract, Transform, and Load (ETL) source data from agency sources, applying numerous transformations to the data that are required, applying corrections to the source files and the addition to the EDW of any new fields requested via the change request process
+ Automate the staging of data by scheduling scripts to run at optimal times enhancing overall system performance and efficiency
+ Create, maintain, and support an ETL/Informatica architectural and system environment for development and production
+ Perform domain/repository backups and recovery operations
+ Implement ETL jobs by creating mappings, mapplets, sessions, and workflows
+ Working with different ETL transformations including Aggregator, Expression, Filter, Router, Sequence Generator, Update Strategy, Joiner, Rank and Source Qualifier, Lookup, and Sorter
+ Schedule and monitor ETL/Informatica jobs in a development, system testing, and production environment
+ Develop proactive processes for monitoring capacity and performance tuning
+ Support and advising the development teams on technical issues
+ Troubleshoot production support issues post release deployment and come up with solutions
+ Develop and maintain complex SQL queries and/or scripts used to create data marts in Teradata
+ Participate in project discussions to document and recommend alternative technical solutions or requirements
+ Participate in unit, integration, and system testing
+ Maintain effective communication and relationships with all individuals involved with the project
+ Learn new technologies as needed to be able to perform job duties effectively
+ Provide status progress and meeting deliverables to the Optum's leadership and to Optum's customer
You'll be rewarded and recognized for your performance in an environment that will challenge you and give you clear direction on what it takes to succeed in your role as well as provide development for other roles you may be interested in.
**Required Qualifications:**
+ Bachelors or Advanced Degree in a related field such as Information Technology/Computer Science, Mathematics/Statistics, Analytics, Business Technology
+ 5+ years of Informatica PowerCenter / ETL experience
+ 5+ years of complex SQL and Performance Tuning experience
+ 2+ years of ETL / Informatica PowerCenter administrative experience
+ Full COVID-19 vaccination is an essential job function of this role. Candidates located in states that mandate COVID-19 booster doses must also comply with those state requirements. UnitedHealth Group will adhere to all federal, state and local regulations as well as all client requirements and will obtain necessary proof of vaccination, and boosters when applicable, prior to employment to ensure compliance. Candidates must be able to perform all essential job functions with or without reasonable accommodation
**Preferred Qualifications:**
+ ETL/Informatica or SQL or BI or Teradata Certification
+ 5+ years of Data Warehouse experience
+ 2+ years of Teradata Version 14+ years of experience including Teradata Utilities
+ 1+ years of experience leading ETL Development projects
+ Experience in Reporting/Analytics tool shall be a plus (SAP BO, Tableau, SAS, PowerBI)
+ Experience in Windows, Unix/Linux scripting, R, or Python
+ Experience in COBOL, CICS/JCL
+ Experience in Informatica Data Quality (IDQ), Address Doctor, Metadata Manager
+ Experience with State Medicaid / Medicare / Healthcare applications
+ Experience with Data Warehouse technologies within the domain of ETL/data integration, Business Intelligence, relational and multi-dimensional database systems
+ Adapting to the team and organizational culture
+ Excellent verbal/written communication skills, end-client facing, team collaboration, and mentoring skills
+ Solid organization skills and ability to set priorities and schedule work deadlines
+ Located in Springfield, IL
_To protect the health and safety of our workforce, patients and communities we serve, UnitedHealth Group and its affiliate companies require all employees to disclose COVID-19 vaccination status prior to beginning employment. In addition, some roles and locations require full COVID-19 vaccination, including boosters, as an essential job function. UnitedHealth Group adheres to all federal, state and local COVID-19 vaccination regulations as well as all client COVID-19 vaccination requirements and will obtain the necessary information from candidates prior to employment to ensure compliance. Candidates must be able to perform all essential job functions with or without reasonable accommodation. Failure to meet the vaccination requirement may result in rescission of an employment offer or termination of employment_
**Careers with Optum.** Here's the idea. We built an entire organization around one giant objective; make health care work better for everyone. So when it comes to how we use the world's large accumulation of health-related information, or guide health and lifestyle choices or manage pharmacy benefits for millions, our first goal is to leap beyond the status quo and uncover new ways to serve. Optum, part of the UnitedHealth Group family of businesses, brings together some of the greatest minds and most advanced ideas on where health care has to go in order to reach its fullest potential. For you, that means working on high performance teams against sophisticated challenges that matter. Optum, incredible ideas in one incredible company and a singular opportunity to do **your life's best work.(sm)**
**Colorado, Connecticut or Nevada Residents Only** : The salary range for Colorado residents is $82,100 to $146,900. The salary range for Connecticut / Nevada residents is $90,500 to $161,600. Pay is based on several factors including but not limited to education, work experience, certifications, etc. In addition to your salary, UnitedHealth Group offers benefits such as, a comprehensive benefits package, incentive and recognition programs, equity stock purchase and 401k contribution (all benefits are subject to eligibility requirements). No matter where or when you begin a career with UnitedHealth Group, you'll find a far-reaching choice of benefits and incentives.
*All Telecommuters will be required to adhere to UnitedHealth Group's Telecommuter Policy.
_Diversity creates a healthier atmosphere: UnitedHealth Group is an Equal Employment Opportunity/Affirmative Action employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status, sexual orientation, gender identity or expression, marital status, genetic information, or any other characteristic protected by law._
_UnitedHealth Group is a drug - free workplace. Candidates are required to pass a drug test before beginning employment._
You'll enjoy the flexibility to telecommute* from anywhere within the U.S. as you take on some tough challenges.
**Primary Responsibilities:**
+ Use Informatica PowerCenter to Extract, Transform, and Load (ETL) source data from agency sources, applying numerous transformations to the data that are required, applying corrections to the source files and the addition to the EDW of any new fields requested via the change request process
+ Automate the staging of data by scheduling scripts to run at optimal times enhancing overall system performance and efficiency
+ Create, maintain, and support an ETL/Informatica architectural and system environment for development and production
+ Perform domain/repository backups and recovery operations
+ Implement ETL jobs by creating mappings, mapplets, sessions, and workflows
+ Working with different ETL transformations including Aggregator, Expression, Filter, Router, Sequence Generator, Update Strategy, Joiner, Rank and Source Qualifier, Lookup, and Sorter
+ Schedule and monitor ETL/Informatica jobs in a development, system testing, and production environment
+ Develop proactive processes for monitoring capacity and performance tuning
+ Support and advising the development teams on technical issues
+ Troubleshoot production support issues post release deployment and come up with solutions
+ Develop and maintain complex SQL queries and/or scripts used to create data marts in Teradata
+ Participate in project discussions to document and recommend alternative technical solutions or requirements
+ Participate in unit, integration, and system testing
+ Maintain effective communication and relationships with all individuals involved with the project
+ Learn new technologies as needed to be able to perform job duties effectively
+ Provide status progress and meeting deliverables to the Optum's leadership and to Optum's customer
You'll be rewarded and recognized for your performance in an environment that will challenge you and give you clear direction on what it takes to succeed in your role as well as provide development for other roles you may be interested in.
**Required Qualifications:**
+ Bachelors or Advanced Degree in a related field such as Information Technology/Computer Science, Mathematics/Statistics, Analytics, Business Technology
+ 5+ years of Informatica PowerCenter / ETL experience
+ 5+ years of complex SQL and Performance Tuning experience
+ 2+ years of ETL / Informatica PowerCenter administrative experience
+ Full COVID-19 vaccination is an essential job function of this role. Candidates located in states that mandate COVID-19 booster doses must also comply with those state requirements. UnitedHealth Group will adhere to all federal, state and local regulations as well as all client requirements and will obtain necessary proof of vaccination, and boosters when applicable, prior to employment to ensure compliance. Candidates must be able to perform all essential job functions with or without reasonable accommodation
**Preferred Qualifications:**
+ ETL/Informatica or SQL or BI or Teradata Certification
+ 5+ years of Data Warehouse experience
+ 2+ years of Teradata Version 14+ years of experience including Teradata Utilities
+ 1+ years of experience leading ETL Development projects
+ Experience in Reporting/Analytics tool shall be a plus (SAP BO, Tableau, SAS, PowerBI)
+ Experience in Windows, Unix/Linux scripting, R, or Python
+ Experience in COBOL, CICS/JCL
+ Experience in Informatica Data Quality (IDQ), Address Doctor, Metadata Manager
+ Experience with State Medicaid / Medicare / Healthcare applications
+ Experience with Data Warehouse technologies within the domain of ETL/data integration, Business Intelligence, relational and multi-dimensional database systems
+ Adapting to the team and organizational culture
+ Excellent verbal/written communication skills, end-client facing, team collaboration, and mentoring skills
+ Solid organization skills and ability to set priorities and schedule work deadlines
+ Located in Springfield, IL
_To protect the health and safety of our workforce, patients and communities we serve, UnitedHealth Group and its affiliate companies require all employees to disclose COVID-19 vaccination status prior to beginning employment. In addition, some roles and locations require full COVID-19 vaccination, including boosters, as an essential job function. UnitedHealth Group adheres to all federal, state and local COVID-19 vaccination regulations as well as all client COVID-19 vaccination requirements and will obtain the necessary information from candidates prior to employment to ensure compliance. Candidates must be able to perform all essential job functions with or without reasonable accommodation. Failure to meet the vaccination requirement may result in rescission of an employment offer or termination of employment_
**Careers with Optum.** Here's the idea. We built an entire organization around one giant objective; make health care work better for everyone. So when it comes to how we use the world's large accumulation of health-related information, or guide health and lifestyle choices or manage pharmacy benefits for millions, our first goal is to leap beyond the status quo and uncover new ways to serve. Optum, part of the UnitedHealth Group family of businesses, brings together some of the greatest minds and most advanced ideas on where health care has to go in order to reach its fullest potential. For you, that means working on high performance teams against sophisticated challenges that matter. Optum, incredible ideas in one incredible company and a singular opportunity to do **your life's best work.(sm)**
**Colorado, Connecticut or Nevada Residents Only** : The salary range for Colorado residents is $82,100 to $146,900. The salary range for Connecticut / Nevada residents is $90,500 to $161,600. Pay is based on several factors including but not limited to education, work experience, certifications, etc. In addition to your salary, UnitedHealth Group offers benefits such as, a comprehensive benefits package, incentive and recognition programs, equity stock purchase and 401k contribution (all benefits are subject to eligibility requirements). No matter where or when you begin a career with UnitedHealth Group, you'll find a far-reaching choice of benefits and incentives.
*All Telecommuters will be required to adhere to UnitedHealth Group's Telecommuter Policy.
_Diversity creates a healthier atmosphere: UnitedHealth Group is an Equal Employment Opportunity/Affirmative Action employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status, sexual orientation, gender identity or expression, marital status, genetic information, or any other characteristic protected by law._
_UnitedHealth Group is a drug - free workplace. Candidates are required to pass a drug test before beginning employment._
Dealing with hard-to-fill positions? Let us help.
Etl lead job description example 3
Leidos etl lead job description
Leidos Government Health Safety Solutions Operation is seeking an experienced ETL Lead, contingent upon contract award, to support NIH programs in Bethesda, MD. The position is part of a highly visible Health Information Technology (IT) services effort. As the largest biomedical research agency in the world, NIH has access to extensive data via numerous web applications, data services and other mechanisms, and requires advanced business intelligence dashboards to support smart decision-making.
The ideal candidate is a good communicator, works well in teams as a leader and an individual contributor, and an intellectually agile problem-solver able to deal with complex concepts comfortably. The candidate will be able to retain composure and work well in a team while developing standard practices, participating in cross training, and sharing solutions for consistent support of the systems. The ETL Lead will have the unique opportunity to interact directly with analysts and other technologists to ensure applications and tools meet the mission requirements.
Primary Responsibilities:
As the ETL Lead, you will be able to demonstrate the skills, ability and experience required to do the following:
+ Lead and participate in all software development activities such as research, design, development and maintenance of dashboard and integration from multiple database systems
+ Responsible for performing complex ETL optimization tasks involving large ORACLE databases and supporting dependent applications and maintenance efforts
+ Work to ensure the accuracy, completeness, and integrity of data in multiple database environments
+ Work with Informatica PowerCenter for extraction, transformation and loading data into enterprise data warehouse.
+ Lead the monitoring, identification, advising, and responding to events such as changes to external data sources or "end of life" for existing technologies
+ Demonstrated experience upgrading databases and porting data is required
+ Work and manage within a 24/7 operations environments for availability to the users
+ Experience providing and recommending solutions on systems integration, system redundancies, business intelligence and how best to utilize and maximize current systems and infrastructure
+ Experience managing and initiating cross-team meetings, stand-up huddles and brainstorming sessions when needed to coordinate rapid response to emerging issues.
+ Work within Data Cloud, Data warehouse, Analytics, and/or Multi Cloud environment (Amazon, Azure)
+ Manage multiple, complex initiatives and communicate across multiple teams and leadership
+ Build and maintain positive relationships with multi-layered teams and staff
Job Requirements:
+ Bachelor's degree in Computer Science and 8+ years of relevant experience or Master's degree with 8+ years of related experience IT field
+ Ability to obtain a Public Trust Clearance
+ Experience working with Informatica PowerCenter in Enterprise Data warehouse
+ Expert in Informatica and its features extensively in migrating data to Enterprise Data warehouse
+ Experience with full life implementation of Datawarehouse projects; Ability to read/write complex queries for data validation and performance tuning techniques for Oracle/Informatica
+ Informatica Administration
+ Experience optimizing ETL loads and process automation; OLAP Business objects,
+ Support developers to develop and enhance the processes, test, and implement ETL stored procedures, triggers, and views
+ Experience working in Agile and/or ITIL framework
+ Must have experience developing database applications in.NET Framework, using SQL Server
+ Must be familiar with Object Oriented Design and use of Design Patterns
+ Must be familiar with ETL Development tools
+ Experience with managing 24/7 operations with 99.5% environments availability to the users
+ Must have strong Data analysis experience
+ Must have strong ETL Development
+ Must have experience in designing the solutions for architecture review
+ Must have experience developing and maintaining system design documentation
+ Must have the ability to communicate effectively verbally and in writing with technical and non-technical audiences.
+ Capability to initiate cross-team meetings, stand-up huddles and brainstorming sessions when needed to coordinate rapid response to emerging issues.
+ Have experience with Data Cloud, Data warehouse, Analytics, and/or Multi Cloud environment (Amazon, Azure).
+ Have the demonstrated ability to manage multiple, complex initiatives in a fast-paced environment.
+ Have customer focusing building and maintaining positive relationships with multi-layered teams and staff
+ Proven ability to do critical analysis to determine root cause in a complex environment while weighing the pressure of availability for a mission critical system
+ Must have a commitment to delivering high-quality software and data
+ Must demonstrate a sense of urgency, and the ability to work independently and proactively in achieving team and individual objectives
+ Must be able to understand the business uses of data and develop designs and specifications to meet those requirements
+ Must be comfortable in a dynamic and fast-paced environment
+ Must have strong attention to detail and an inquisitive mindset
Desired Requirements:
+ UML and database design
+ Experience working with the following technologies and platforms is a plus: Java, Oracle, MySQL, and SQL Server
+ Experience in database migration to Cloud
+ Experience in Cloud Data Factory and SQL Server
hhsnih
Pay Range:Pay Range $94,250.00 - $145,000.00 - $195,750.00
The Leidos pay range for this job level is a general guideline onlyand not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.
REQNUMBER: R-00094089
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status. Leidos will consider qualified applicants with criminal histories for employment in accordance with relevant Laws. Leidos is an equal opportunity employer/disability/vet.
The ideal candidate is a good communicator, works well in teams as a leader and an individual contributor, and an intellectually agile problem-solver able to deal with complex concepts comfortably. The candidate will be able to retain composure and work well in a team while developing standard practices, participating in cross training, and sharing solutions for consistent support of the systems. The ETL Lead will have the unique opportunity to interact directly with analysts and other technologists to ensure applications and tools meet the mission requirements.
Primary Responsibilities:
As the ETL Lead, you will be able to demonstrate the skills, ability and experience required to do the following:
+ Lead and participate in all software development activities such as research, design, development and maintenance of dashboard and integration from multiple database systems
+ Responsible for performing complex ETL optimization tasks involving large ORACLE databases and supporting dependent applications and maintenance efforts
+ Work to ensure the accuracy, completeness, and integrity of data in multiple database environments
+ Work with Informatica PowerCenter for extraction, transformation and loading data into enterprise data warehouse.
+ Lead the monitoring, identification, advising, and responding to events such as changes to external data sources or "end of life" for existing technologies
+ Demonstrated experience upgrading databases and porting data is required
+ Work and manage within a 24/7 operations environments for availability to the users
+ Experience providing and recommending solutions on systems integration, system redundancies, business intelligence and how best to utilize and maximize current systems and infrastructure
+ Experience managing and initiating cross-team meetings, stand-up huddles and brainstorming sessions when needed to coordinate rapid response to emerging issues.
+ Work within Data Cloud, Data warehouse, Analytics, and/or Multi Cloud environment (Amazon, Azure)
+ Manage multiple, complex initiatives and communicate across multiple teams and leadership
+ Build and maintain positive relationships with multi-layered teams and staff
Job Requirements:
+ Bachelor's degree in Computer Science and 8+ years of relevant experience or Master's degree with 8+ years of related experience IT field
+ Ability to obtain a Public Trust Clearance
+ Experience working with Informatica PowerCenter in Enterprise Data warehouse
+ Expert in Informatica and its features extensively in migrating data to Enterprise Data warehouse
+ Experience with full life implementation of Datawarehouse projects; Ability to read/write complex queries for data validation and performance tuning techniques for Oracle/Informatica
+ Informatica Administration
+ Experience optimizing ETL loads and process automation; OLAP Business objects,
+ Support developers to develop and enhance the processes, test, and implement ETL stored procedures, triggers, and views
+ Experience working in Agile and/or ITIL framework
+ Must have experience developing database applications in.NET Framework, using SQL Server
+ Must be familiar with Object Oriented Design and use of Design Patterns
+ Must be familiar with ETL Development tools
+ Experience with managing 24/7 operations with 99.5% environments availability to the users
+ Must have strong Data analysis experience
+ Must have strong ETL Development
+ Must have experience in designing the solutions for architecture review
+ Must have experience developing and maintaining system design documentation
+ Must have the ability to communicate effectively verbally and in writing with technical and non-technical audiences.
+ Capability to initiate cross-team meetings, stand-up huddles and brainstorming sessions when needed to coordinate rapid response to emerging issues.
+ Have experience with Data Cloud, Data warehouse, Analytics, and/or Multi Cloud environment (Amazon, Azure).
+ Have the demonstrated ability to manage multiple, complex initiatives in a fast-paced environment.
+ Have customer focusing building and maintaining positive relationships with multi-layered teams and staff
+ Proven ability to do critical analysis to determine root cause in a complex environment while weighing the pressure of availability for a mission critical system
+ Must have a commitment to delivering high-quality software and data
+ Must demonstrate a sense of urgency, and the ability to work independently and proactively in achieving team and individual objectives
+ Must be able to understand the business uses of data and develop designs and specifications to meet those requirements
+ Must be comfortable in a dynamic and fast-paced environment
+ Must have strong attention to detail and an inquisitive mindset
Desired Requirements:
+ UML and database design
+ Experience working with the following technologies and platforms is a plus: Java, Oracle, MySQL, and SQL Server
+ Experience in database migration to Cloud
+ Experience in Cloud Data Factory and SQL Server
hhsnih
Pay Range:Pay Range $94,250.00 - $145,000.00 - $195,750.00
The Leidos pay range for this job level is a general guideline onlyand not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.
REQNUMBER: R-00094089
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status. Leidos will consider qualified applicants with criminal histories for employment in accordance with relevant Laws. Leidos is an equal opportunity employer/disability/vet.
Start connecting with qualified job seekers
Resources for employers posting etl lead jobs
Average cost of hiring
Recruitment statistics
How to write a job description
Examples of work conditions
Etl lead job description FAQs
Ready to start hiring?
Updated March 14, 2024
Updated March 14, 2024