Etl Developer

Role & responsibilities

Preferred candidate profile

Experience:

A minimum of 4-10 years of experience into data integration/orchestration services, service architecture and providing data driven solutions for client requirements 

Experience on Microsoft Azure cloud and Snowflake SQL, database query/performance tuning. 

Experience with Qlik Replicate and Compose tools(Change Data Capture) tools is considered a plus 

Talend Cloud Data Integration tool

Exposure to the financial domain knowledge is considered a plus. 

Cloud Managed Services such as source control code Github, MS Azure/Devops is considered a plus. 

Prior experience with State Street and Charles River Development ( CRD) considered a plus. 

Experience in tools such as Visio, PowerPoint, Excel. 

Exposure to Third party data providers such as Bloomberg, Reuters, MSCI and other Rating agencies is a plus. 

Strong SQL knowledge and debugging skills is a must. 

Responsibilities:

As a Data Integration Developer/Sr Developer, be hands-on ETL/ELT data pipelines, Snowflake DWH, CI/CD deployment Pipelines and data-readiness(data quality) design, development, implementation and address code or data issues. 

Experience in designing and implementing modern data pipelines for a variety of data sets which includes internal/external data sources, complex relationships, various data formats and high-volume. 

Experience and understanding of ETL Job performance techniques, Exception handling, 

Query performance tuning/optimizations and data loads meeting the runtime/schedule time SLAs both batch and real-time data uses cases. 

Demonstrated ability to rationalize problems and use judgment and innovation to define clear and concise solutions. 

Demonstrate strong collaborative experience across regions (APAC,EMEA and NA) to come up with design standards, High level design solutions document, cross training and resource onboarding activities.  

Good understanding of SDLC process, Governance clearance, Peer Code reviews, Unit Test Results, Code deployments, Code Security Scanning, Confluence Jira/Kanban stories. 

Strong attention to detail during root cause analysis, SQL query debugging and defect issue resolution by working with multiple business/IT stakeholders.