Roles and Responsibilities
Desired Candidate Profile
- The BI ETL developer would need to have at least 4 years of Relevant experience in SSIS.
- 1.5 to 2 Years in Relevant Experience in ADF (Azure Data Factory)
- The candidate will be responsible for ETL development and maintenance.
- He/she should have working knowledge of T-SQL particularly analyzing the data structure and entity relationship in the SQL server database. Role & Responsibilities
- Analyze and interpret complex data on target systems and provide solutions to all data issues and coordinate with data analyst to validate all requirements
- Coordinate with ETL team to implement ETL packages for all new projects and maintain effective awareness of all production activities according to required standards and provide support to all existing ETL packages
- Develop ETL processes according to business requirements.
- ETL Package audit and error log process Required Competencies and Technical Skills
- Proven ability to interpret data files and record layouts to map fields between multiple systems and database tables
- Strong knowledge of relational databases management system (RDBMS)
- Strong knowledge of T-SQL queries
- SQL Server integration service (SSIS) package creation and data integration with SQL server
- Hand on experience on SSRS portal Familiarity with visualization tools like Power BI and Tableau will be an additional advantage
- Intermediate or greater proficiency in MS Office (Word, Excel, Access)
- Effective communication and deduction skills
- Be a good team player
- Work ethic based on a strong desire to exceed expectations.
Perks and Benefits