Senior ETL Developer - Chennai/Banglore, India
Photon · India ·
- Seniority
- Senior
- Category
- Data engineering
- Experience
- 2+ years
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 .
What will you do? What are we looking for?
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.