Job Description
Education And Experience
- Bachelor’s degree in Computer Science, Information Technology, Data Science, or a related field.
- 1 to 3 years of experience in ETL development and data warehousing.
- Knowledge of database concepts such as views, tables, star schemas, data normalization and indexing; with practical experience.
- Proficiency in SQL for querying and manipulating data in relational databases and/or star schemas; database management systems such as Oracle, SQL Server.
- Familiarity with data warehouse concepts.
- Knowledge of ETL design best practices.
- Experience with tuning of complex ODI scenarios and SQL queries for optimal performance.
Key Responsibilities
- Develop, test, and maintain ETL processes to support data warehousing and analytics solutions.
- Ensure data is accurately extracted, transformed, and loaded into the data warehouse.
- Provide production support for data warehouse processes and resolve issues promptly.
- Ensure data security, quality, and compliance with industry standards.
- Optimize ETL processes for performance and scalability.
- Integrate AI to enhance data analytics capabilities and automate processes.
- Develop and implement AI-driven solutions.
- Collaborate with stakeholders to optimize analytics outcomes.
Knowledge, Skills & Abilities
Technical Skills
- 1 to 3 years of experience in ETL development, data warehousing and data lifecycle management.
- Competence in utilizing ETL tools such as Informatica, Oracle Data Integrator (ODI) 12c, and Oracle Cloud Infrastructure Data Integration (OCI DI).
- Experience with Business Intelligence Cloud Connector (BICC).
Data Management
- Understanding of data lifecycle concepts, including data collection, processing, and visualization.
- Knowledge of data modeling techniques and data warehouse concepts.
- Understanding of data security and compliance principles.
Communication and Collaboration
- Strong communication and interpersonal skills.
- Effective collaboration within a team.
- Ability to build and effectively manage relationships.
Problem Solving and adaptability
- Strong analytical and problem-solving skills.
- Ability to interpret and analyze data to generate insights.
- Skills in assessing and improving data quality through profiling, cleansing, and validation.
- Self-motivation to work effectively with limited direct supervision.
- Adaptability to ambiguous or changing requirements.
Soft Skills
- Strong communication skills to collaborate with team members and stakeholders.
- Attention to detail and a commitment to quality and accuracy.
- Ability to manage time effectively and handle multiple tasks simultaneously.
- Aptitude and willingness to learn new technologies.
- Ability to evaluate situations, processes, and data critically to make informed decisions.
- Knowledge of the different phases in the Software Development Life Cycle (SDLC), including requirements analysis, design, implementation, testing, deployment, and maintenance.
Project Support
- Understanding of project management principles.
- Ability to provide time/effort estimates for tasks.
Artificial Intelligence
- Foundational understanding of AI and Machine Learning.
Behavioral Attributes
- Takes personal ownership of career development.
- Demonstrates “ Our Values ” - Safety First, Intentional Inclusion (We are One Team), Act with Integrity, Superior Performance.
- Continuous learner with a high level of interest in learning and applying new technologies and concepts.
- Result Oriented, can act with speed and decisiveness; take initiative and does what it takes to meet commitments.
- Focus on quality, reliability, and efficiency.
- Effective in organizing tasks, managing multiple priorities, meeting schedules, and delivering on commitments.
- Methodical approach to solving problems.