Senior ETL Developer – IT

Senior ETL Developer

Typical Day in Role:
• Conduct source data analysis and profiling to complete source to target mapping
• Perform data wrangling to merge disjointed data sources and implement complex data transformation
• Develop ETL process using MS SQL Server, SSIS package and MS Azure Data Factory to ingest, transform, cleanse and load data into on-prem SQL Server and/or Azure SQL DB
• Investigate data to identify potential issues within ETL pipelines, notify end-users and propose adequate solutions
• Logical and physical data modeling to develop highly optimized data infrastructure for fast querying of large volume of data. Assure data quality, security, and compliance requirements are met
• Prepare documentation for further reference
• Work with Business stakeholders for requirement gathering and collaborate with QA for test cycles
• Conduct performance testing and tuning code for optimization
• Responsible for code deployment to all environments including production
• Provide Production Support for the current environment as required

Candidate Requirements/Must-Have skills:
1. 10+ years of experience in working for large projects and have advanced experience with SQL Scripting, ETL architecture, data analysis and profiling, data mapping, data modeling, data lakes, and analytics
2. 5+ years of extensive development experience with SQL Server SSIS, Integration Services Catalog and project deployment
3. 3+ years of experience working with BitBucket or TFS, and creating DevOps pipeline
4. You have experience working with an agile scrum team

Nice-To-Have Skills:
• Experience with Azure ADF and Azure MI
• Experience with static code scans such as Fortify, Blackduck, etc.
• Previous exposure to Banking/Financial Industry backgrounds

Soft Skills:
• You are excellent in written and spoken English to clearly communicate complex issues and interface with all levels of the organization with ease
• You are highly organized, disciplined, and responsive in a fast paced and demanding environment
• You constantly and strongly demonstrate the core values that continuously advance the productivity of high-performing and self-organizing teams: respect, commitment, courage, openness, and focus
• You are self-disciplined, proactive, take accountability

Education:
• University degree in a technical field such as computer science, computer engineering or related IT field is an asset