Are you ready to make an impact at DTCC
Do you want to work on innovative projects, collaborate with a dynamic and supportive team, and receive investment in your professional developmentAt DTCC, we are at the forefront of innovation in the financial markets. We are committed to helping our employees grow and succeed. We believe that you have the skills and drive to make a real impact. We foster a thriving internal community and are committed to creating a workplace that looks like the world that we serve. Job Family: Enterprise Services
Pay and Benefits:
- Competitive compensation, including base pay and annual incentive
- Comprehensive health and life insurance and well-being benefits, based on location
- Pension / Retirement benefits
- Paid Time Off and Personal/Family Care, and other leaves of absence when needed to support your physical, financial, and emotional well-being.
- DTCC offers a flexible/hybrid model of 3 days onsite and 2 days remote (onsite Tuesdays, Wednesdays and a third day unique to each team or employee).
The Impact you will have in this role:
We are seeking a skilled ETL developer with expertise in Talend, SQL Server and related technologies to join our dynamic team. The ideal candidate will be responsible for designing, developing, and maintaining ETL processes using Talend, and is comfortable creating data models and retrieving data from MS SQL Server databases - coupled with the work associated with developing a modern web application. This role requires coordination with multiple geographically dispersed groups (Business partners, Subject Matter Experts, Senior Technologists, Analyst as well as infrastructure teams) across the enterprise to implement solutions.
- Design, develop, and maintain ETL processes using Talend to extract, transform, and load data from various sources.
- Write high performance queries on SQL Server databases, ensuring data integrity, performance, and security
- Collaborate with cross-functional teams to gather requirements, design solutions, and implement data integration and reporting solutions.
- Troubleshoot and resolve issues related to ETL processes, data visualizations, and database performance
- Collaborates with other team members and analysts through the delivery cycle.
- Participates in an Agile delivery team that builds high quality and scalable work products.
- Assists in the evaluation of upcoming technologies and contributes to the overall solution design.
- Supports production releases and maintenance windows working with the Operations team
Qualifications:
- Bachelor s degree in computer science, Information Technology, or a related field.
Talents Needed for Success:
- 2 to 4 years experience in ETL domain
- Proven experience as a Talend Developer, with a strong understanding of ETL processes and data integration.
- Expertise in SQL including database design and query optimization
- Strong understanding of agile processes (Kanban and Scrum) and a working knowledge of JIRA is required
- Strong analytical and problem-solving skills, with the ability to work independently and as part of a team.
- Excellent communication and interpersonal skills, with the ability to collaborate effectively with stakeholders at all levels.
Additional Skills for Success:
-
Talend Expertise
: Proficiency in using Talend Studio for data integration, data quality, files manipulation. This includes designing and developing ETL processes, creating and managing Talend jobs, and using Talend components for data transformation and integration -
Data Integration Knowledge in Talend
: Understanding of data integration concepts and best practices. This includes experience with data extraction, transformation, and loading (ETL) processes, as well as knowledge of data warehousing and data modeling. -
Architectural Experience
: Experience in designing and implementing ETL architecture. This includes defining ETL workflows, designing data pipelines, and ensuring data quality and consistency. Knowledge of ETL performance optimization and troubleshooting is also essential. -
Database Skills
: Proficiency in working with various databases, including MS SQL and/or Oracle databases. This includes writing complex SQL queries, understanding database schemas, and performing data migrations. -
Integration Knowledge
: Experience with integrating Talend with various data sources and targets. This includes knowledge of APIs, web services, and other data integration methods. Familiarity with cloud platforms and services (e.g., AWS, Azure, Google Cloud) is also beneficial. -
Version Control and Collaboration
: Experience with version control systems (e.g., Git) and collaboration tools (e.g., Jira, Confluence). This is important for managing code changes, collaborating with team members, and tracking project progress. -
Job Scheduling and Automation
: Experience with job scheduling and automation tools. This includes setting up and managing Talend jobs using schedulers like Talend Administration Center (TAC), Autosys or third-party tools to automate ETL workflows. -
Data Visualization
: Ability to create visually appealing and insightful reports and dashboards. This involves selecting appropriate visualizations, designing layouts, and using custom visuals when necessary using Power BI - Expertise in scripting languages such as Python, and Shell/Batch programming is a plus
The salary range is indicative for roles at the same level within DTCC across all US locations. Actual salary is determined based on the role, location, individual experience, skills, and other considerations. Please contact us to request accommodation.
