- Data warehouse SDLC
- Expertise in DW/ETL development lifecycle for new development and maintenance & Support
- SDLC Experience with Data Migration related projects
- Provide the realistic effort and schedule estimation for the work involved
- Data Integration Services Maintenance & Support
- Oversee and manage all data imports, exports, and other interconnections to and from the Data Warehouse (DW).
- Develop technical requirements, level of effort and scheduling estimates, and implement DW enhancements as requested by the DW Steering Committee.
- Adjust existing ETL (Extract, Transform, and Load) routines for new data elements and data sources and integrate new data into DW.
- Oversee and monitor SQL System Agent jobs and analyze any failure
- Data Integration Services Development
- Architect, Design, Develop, Test and Deploy ETLs based on the Standards and needs
- Data Quality
- Verify that existing DW Dashboards are properly reflecting current DW values.
- Data Quality
- Develop the QA deliverables including Testing approach, Test Cases and Test Plan
- Task Documentation
- Experience in Requirement collection process from the Business Users and documenting the same and follow the approval process.
- Provide updated and current technical and user documentation for DW use and operation.
- Create and maintain the necessary documentations across SDLC
- System Maintenance
- Manage database storage, database performance, data availability, perform database compaction and manage the Data Warehouse database size.
- Perform database consistency checks between Data Warehouse and all other system interacting with Data Warehouse. (e.g., Delphi)
- DW health check proposal and Implementation
- Bachelor's degree and a minimum of ten years of experience providing data security for databases, with experience supporting Enterprise Data Warehouse (EDW Also Software design and development.
- Five of the ten years of experience must include software project responsibility for the design, deployment, and maintenance of DW/ETL applications
- Senior-level DW/ETL designers will demonstrate responsibility for successfully executing project programming tasks independently.
- MS SSIS (Extract, Transform, and Load)
- Data Warehouse Architecture & Design Concepts
- SQL System Agent
- MS Office Tools
- MS SQL server 2014 or later
- Azure cloud platform
- SharePoint
- Visual Studio, Git and GitHub
- Business Analysis
- MS SSRS
- MS Power BI
- Ability to work independently and manage and report the work without much oversight.
- Team Player, willing to share knowledge and pitch in wherever needed.
- Multi-tasking, Prioritization, and Time Management – Ability to pivot and act in a timely manner.
- Technical Aptitude – capable of handling a multitude of technical issues at the same time.
- Excellent written and verbal communication – Ability to accurately convey and receive information from various level of stakeholders.
- Work and Schedule Flexibility
- Able to work in an in-person and Remote work environments.
- Open to learn new technology and processes to adapt and improve based on the needs.
-
ETL Developer
1 week ago
Center For Health Information And Analysis Boston, United StatesJob Description · Job DescriptionAre you a skilled Software Development professional with a proven track record for designing and developing ETL code? Look no further – you could be the ideal candidate for us · At the Center for Health Information and Analysis (CHIA), we provide ...
-
ETL Developer
3 weeks ago
Global Channel Management Winchester, United StatesETL Developer needs 8+ years' experience · ETL Developer requires: · Expertise in data mapping from transactional application to data warehouse · Data validation · Data mapping · Data warehousing · ETL Developer duties: · Develop and maintain ETL processes that meet projec ...
-
Senior Data Warehouse/ETL Developer
4 weeks ago
Eliassen Group Cambridge, United States**Must be local to Boston, MA to go onsite 1-2 days a week in Cambridge, MA.** · Our government client is looking for a Senior Data Warehouse/ETL Developer to join their team. · Due to federal security clearance requirements, applicant must be a United States Citizen or Permanent ...
-
Talend ETL Developer
1 week ago
Center For Health Information And Analysis Boston, United StatesJob Description · Job DescriptionAre you a skilled Software Development professional with a proven track record for designing and developing ETL code, specifically using the Talend Data Fabric product suite? Look no further – you could be the ideal candidate for us · At the Cent ...
-
ETL Developer
3 weeks ago
firstPRO, Inc Waltham, United StatesfirstPRO is now accepting resumes for an ETL Developer with Experience in Matillion(ETL) and Snowflake. This is a 6+month contract with a hybrid schedule. · 2. Experience in Data warehousing. · 3. Strong SQL Skills. · Provides engineering support for routine daily and long term ...
-
ETL Developer
3 weeks ago
Raise Waltham, United StatesWere Hiring Our key client is hiring and looking to add an ETL Developer to their team. Please check the description below and reach out to us for more details if you are interested. · Pay Rate: $55.00-$65.00/hour on W2 · Work Type: Onsite Waltham, MA 02451 · Duration: 6-month ...
-
Etl Developer
2 weeks ago
Dart Point Boston, United States Full time, Part time, Contract, TrainingResponsibilities Participate in design & creation of scalable software. Write clean functional code on the front- & back-end Test & fix bugs or other coding issues. Work with development teams & product managers to create software solutions. Analyze functional business applicatio ...
-
ETL Developer
2 weeks ago
FirstPRO Watertown, United StatesfirstPRO is now accepting resumes for an ETL Developer with Experience in Matillion(ETL) and Snowflake. This is a 6+month contract with a hybrid schedule. · Take the next step in your career now, scroll down to read the full role description and make your application. · 2. Expe ...
-
ETL Developer
3 weeks ago
FirstPRO Watertown, United StatesFirstPro is now accepting resumes for an ETL Developer based in Waltham, MA. This role will focus on providing engineering support for routine daily and long term monitoring, process design and economic benefit analysis for process units from a data perspective. This is a contrac ...
-
ETL Developer
3 weeks ago
Global Channel Management Winchester, United StatesAbout the job ETL Developer · ETL Developer needs 8+ years experience · ETL Developer requires: · Expertise in data mapping from transactional application to data warehouse · Data validation · Data mapping · Data warehousing · ETL Developer duties: · Develop and maintain ...
-
Talend Senior ETL Developer
2 weeks ago
NavitsPartners Brookline, United StatesJob Description · Job DescriptionPosition: Talend Senior ETL Developer · Duration: 12 months · Location: HYBRID (Tue/Wed onsite - Back Bay area, Boston ) · Extension: Highly possible · Position Summary · The Client needs a talented Talend Senior ETL Developer to assist with t ...
-
ETL Developer
3 weeks ago
Raise Waltham, United StatesWe're Hiring Our key client is hiring and looking to add an ETL Developer to their team. Please check the description below and reach out to us for more details if you are interested. · Pay Rate: $55.00-$65.00/hour on W2 · Work Type: Onsite – Waltham, MA 02451 · Duration: 6-month ...
-
ETL Developer
3 weeks ago
firstPRO, Inc Waltham, United StatesFirstPro is now accepting resumes for an ETL Developer based in Waltham, MA. This role will focus on providing engineering support for routine daily and long term monitoring, process design and economic benefit analysis for process units from a data perspective. This is a contrac ...
-
Oracle ETL Database Developer
3 weeks ago
Global Channel Management Winchester, United States Full timeOracle ETL Database Developer needs 7+ years of experience as a Database Engineer, with a focus on Oracle databases, SQL, PL/SQL, Data Warehousing and ETL. · Oracle ETL Database Developer requires: · Bachelor's degree in computer science, Information Technology, or related fiel ...
-
DBA ETL Developer
2 weeks ago
Global Channel Management Winchester, United StatesAbout the job DBA ETL Developer · DBA/ETL Developer needs database design and DBA experience · DBA/ETL Developer requires: · Experience with ODI 12C2. · Experience in Data warehousing3. · Strong Communication Skills · DBA/ETL Developer duties:Perform transactional applicati ...
-
ETL Developer
4 weeks ago
Arbella Insurance Quincy, United States Full timeWhy Arbella? · At Arbella, we're focused on people. We work hard to attract and retain the best. That means providing a great work environment, encouraging work/life balance, offering flexible work arrangements, competitive salaries and exceptional benefits packages. We invest i ...
-
ETL Developer
3 weeks ago
Arbella Insurance Quincy, United StatesWhy Arbella? At Arbella, we're focused on people. We work hard to attract and retain the best. That means providing a great work environment, encouraging work/life balance, offering flexible work arrangements, competitive salaries and exceptional benefits packages. We invest in o ...
-
Senior ETL Developer
3 weeks ago
Global Channel Management Woburn, United StatesJob Description: · ETL Developer needs 8+ years' experience · ETL Developer requires: · •Expertise in data mapping from transactional application to data warehouse · •Data validation · •Data mapping · •Data warehousing · ETL Developer duties: · •Develop and maintain ETL processe ...
-
Senior Data Warehouse ETL Developer
1 week ago
Acord (association For Cooperative Operations Research And Development) Newton, United StatesBoston College Introduction · Founded in 1863, Boston College is a Jesuit, Catholic university located six miles from downtown Boston with an enrollment of 9,484 full-time undergraduates and 5,250 graduate and professional students. Ranked 35 among national universities, Boston ...
-
Senior Data Warehouse ETL Developer
1 week ago
Boston College Newton, United StatesBoston College Introduction · Founded in 1863, Boston College is a Jesuit, Catholic university located six miles from downtown Boston with an enrollment of 9,484 full-time undergraduates and 5,250 graduate and professional students. Ranked 35 among national universities, Boston ...
Senior Data Warehouse/ETL Developer - Cambridge, United States - Global Jupiter
Description
The Senior Datawarehouse/ETL Developer has expertise in MS SQL server-based data warehouse deployment, management, and maintenance.This position requires experience with enhancing and maintaining an existing data warehouse, integration of various source data systems, deploys and tests enhancements to the Data Warehouse system, including user interfaces, ETL processes, and data analysis.
The Senior Datawarehouse/ETL Developer must have DW SDLC knowledge and experience with MS-SQL Server database development, SQL Server Integration Services, Data Warehouse and database modeling and Data Warehouse architecture.
Core responsibilities and duties; highlight day-to-day activitiesTop Qualifications, Skills, Experience or Certifications:
MUST Have Skills:
Preferred Skills:
Attributes:
Note:
Candidate must be a U.S. citizen or green card holder who has resided in the U.S. for at least 3 years and the ability to obtain a public trust
SAIC accepts applications on an ongoing basis and there is no deadline.
Covid Policy:
SAIC does not require COVID-19 vaccinations or boosters. Customer site vaccination requirements must be followed when work is performed at a customer site
#J-18808-Ljbffr