Module Lead - MS Azure ADF

Job Description

Skills and Experience

• 3+ years of experience in cloud technologies like Azure data services, snowflake etc.
• Overall 5 to 7 years of experience in data engineering experience
• Experience working with relational data sources (like Oracle / SQL Server) and flat files.
• Experience in optimizing user queries and dashboard performance.
• Ability to work well in a team environment Effectively manage multiple tasks with strong time management and prioritization skills.
• Proactive learner capable of independently assessing and addressing personal technical knowledge gaps.
• Good knowledge of Data Warehousing concepts are required.

Roles and Responsibilities

In this role, resource will primarily be responsible for ETL development activities using SQL and SSIS, bug fixes in existing ETL applications, performance improvements, technical documentation, provide updates on assigned tasks to team leads and customer. Detailed responsibilities are given below:

• Develop ETL solutions as per defined ETL standards by client - Review requirements and provide effort estimates.
• Coordinate with team members to perform database programming based on project requirements.
• Develop stored procedures, complex SQL queries, scripts and database programming for systems.
• Perform quality assurance tests for ensuring data integrity across multiple databases.
• Interact with business teams to understand project requirements - Analyze existing ETL applications and improve performance.
• RCA and Bug fixes for issues reported by customer.
• Assist in identifying process improvements for database performance, reliability and stability.
• Perform troubleshooting and analysis to assess root cause of data issues in a timely manner.
• Experience in Extracting, Transforming and Loading ETL data from Excel, Flat file, Oracle to MS SQL Server by using SSIS services.
• Understands best practices for data modelling, database programming and job scheduling and ETL package dependencies