ETL Developer

• 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 
• Strong Data warehousing Concepts, ETL tools such as

  Talend Cloud Data Integration tool

  is must 
• 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.