Senior ETL Developer
at Photon
Washington State, Washington, USA -
Start Date | Expiry Date | Salary | Posted On | Experience | Skills | Telecommute | Sponsor Visa |
---|---|---|---|---|---|---|---|
Immediate | 17 Dec, 2024 | Not Specified | 20 Sep, 2024 | 2 year(s) or above | Systems Analysis,Computer Science | No | No |
Required Visa Status:
Citizen | GC |
US Citizen | Student Visa |
H1B | CPT |
OPT | H4 Spouse of H1B |
GC Green Card |
Employment Type:
Full Time | Part Time |
Permanent | Independent - 1099 |
Contract – W2 | C2H Independent |
C2H W2 | Contract – Corp 2 Corp |
Contract to Hire – Corp 2 Corp |
Description:
Greetings Everyone
Who are we?
For the past 20 years, we have powered many Digital Experiences for the Fortune 500. Since 1999, we have grown from a few people to more than 4000 team members across the globe that are engaged in various Digital Modernization. For a brief 1 minute video about us, you can check
https://youtu.be/uJWBWQZEA6o
.
What will you do?
What are we looking for?
Job Title: Senior ETL Developer – Data Services Team
Key Duties
- Plays a lead role in the areas of ETL design, data modeling, and ETL development.
- Facilitates best practice guidelines around all stages of development.
- Provides technical leadership to serve as point of escalation, review, and approval for key issues, significant projects, and decisions.
- Able to work with stakeholders, and translate requirements to design and build a solution that will meet Business needs and integrate seamlessly with the EDW.
- Gain team and stakeholder approval for all designs, and effort estimates.
- Research and analyze current systems, subsystems and interfaces to understand the current or new process flow.
- Document work via Functional and Tech Specs.
- Develop unit tests, performance tests, and take into account security requirements.
- Prepare and participate in design and code reviews.
- Analyzes processes for gaps and weaknesses, building future state models and creating the roadmaps and migration plans to get there.
- Communicate progress and work using the Agile Methodology.
Job-Specific Skills
- Required:
5+ years of experience of with Oracle
5+ years of experience with Data Warehousing: building relational databases, star schemas
5+ years of experience with Data Modeling
4+ years of experience with ODI (Oracle Data Integrator Tool) or Informatica IDMC.
3+ years of experience with Databricks Lakehouse and/or Delta tables.
2+ years of experience in the design, implementation, and support of a Kimball method data warehouse on SQL Server or Oracle
Strong SQL reading and writing skills
Business and/or technical background in the areas of Data Integration (ETL), Data Security, and Enterprise Data Warehouse development
Experience in Change Management, Release Management, and Source Code control practices
Education
- High school diploma or equivalent is required.
- A Bachelor of Arts or a Bachelor of Science degree, with a focus in computer science, systems analysis, or a related area, is
preferred
Responsibilities:
- Plays a lead role in the areas of ETL design, data modeling, and ETL development.
- Facilitates best practice guidelines around all stages of development.
- Provides technical leadership to serve as point of escalation, review, and approval for key issues, significant projects, and decisions.
- Able to work with stakeholders, and translate requirements to design and build a solution that will meet Business needs and integrate seamlessly with the EDW.
- Gain team and stakeholder approval for all designs, and effort estimates.
- Research and analyze current systems, subsystems and interfaces to understand the current or new process flow.
- Document work via Functional and Tech Specs.
- Develop unit tests, performance tests, and take into account security requirements.
- Prepare and participate in design and code reviews.
- Analyzes processes for gaps and weaknesses, building future state models and creating the roadmaps and migration plans to get there.
- Communicate progress and work using the Agile Methodology
REQUIREMENT SUMMARY
Min:2.0Max:5.0 year(s)
Information Technology/IT
IT Software - DBA / Datawarehousing
Software Engineering
Diploma
Proficient
1
Washington State, USA