Job Description
Manage a team of ETL developers, assign tasks, and ensure timely delivery of projects and PoCs.
Provide technical leadership and groom a team of ETL developers.
Design and develop complex mappings, Process Flows and ETL scripts.
Perform data extraction and transformation using SQL query to create data set required for dashboards.
Optimize ETL processes for efficiency, scalability, and performance tuning.
Utilize appropriate ETL tools and technologies (e.g., ODI, ADF, SSIS, Alteryx, Talend, etc.)
Stay up to date on the latest ETL trends and technologies.
Exposure to designing and developing BI reports and dashboards using Power Bi/Tableau and other tools to meet business analytic needs.
Requirements
Bachelor's degree in computer science or related field.
Relevant experience of 7+ years.
Extensive experience in designing and implementing ETL processes.
Experience in designing / developing ETL processes such as ETL control tables, error logging, auditing, data quality, etc.
Expertise in Data Integration tool sets - Azure Data Factory, Oracle Data Integrator, SQL Server Integration Services, Talend, etc. - and PL/SQL.
Exposure to one or more of these data visualization tools - OAC, Power BI, Tableau, OBIEE.
Excellent written, verbal communication and interpersonal skills
Qualification
Bachelor's Degree
Key skill Required
- Oracle
- SQL
- SQL Server
- Alteryx
- Azure
- Data extraction
- Azure Data Factory
- Communication
- Computer Science
- Data Integration
- Data Quality
- Data Set
- Data Visualization
- Design
- Integration
- Interpersonal Skills
- Leadership
- Logging
- Oracle Data Integrator
- Performance Tuning
- PL/SQL
- Power BI
- Scalability
- Science
- SQL Server Integration Services
- Technical Leadership
- Timely Delivery
- Verbal Communication
- Visualization
