Software Engineer

The impact you will have in this role:

Data Quality and Integration role is a highly technical position considered a technical expert in system implementation - with an emphasis on providing design, ETL, data quality and warehouse modeling expertise. This role will be accountable for, knowledge of capital development efforts.

Performs in an experienced level the technical design of application components, builds applications, interfaces between applications, and understands data security, retention, and recovery. Can research technologies independently and recommend appropriate solutions. Contributes to technology-specific best practices & standards; gives to success criteria from design through deployment, including, reliability, cost-effectiveness, performance, data integrity, maintainability, reuse, extensibility, usability and scalability; gives expertise on significant application components, vendor products, program languages, databases, operating systems, etc, completes the plan by building components, testing, configuring, tuning, and deploying solutions.

Software Engineer (SE) for Data Quality and Integration applies specific technical knowledge of data quality and data integration in order to assist in the design and construction of critical systems. The SE works as part of an AD project squad and may interact with the business, Functional Architects, and domain experts on related integrating systems. The SE will contribute to the design of components or individual programs and participates fully in the construction and testing. This involves working with the Senior Application Architect, and other technical contributors at all levels. This position contributes expertise to project teams through all phases, including post-deployment support. This means researching specific technologies, and applications, and contributing to the solution design, supporting development teams, testing, troubleshooting, and production support. The ASD must possess experience in integrating large volumes of data, efficiently and in a timely manner. This position requires working closely with the functional and governance functions, and more senior technical resources, reviewing technical designs and specifications, and contributing to cost estimates and schedules.

What You'll Do:

• Technology Expertise is a domain expert on one or more of programming languages, vendor products specifically, Informatica Data Quality and Informatica Data Integration Hub, DTCC applications, data structures, business lines.
• Platforms works with Infrastructure partners to stand up development, testing, and production environments
• Requirements Elaboration works with the Functional Architect to ensure designs satisfy functional requirements
• Data Modeling reviews and extends data models
• Data Quality Concepts Experience in Data Profiling, Scorecards, Monitoring, Matching, Cleansing
• Is aware of frameworks that promote concepts of isolation, extensibility, and extendibility
• System Performance contributes to solutions that satisfy performance requirements; constructs test cases and strategies that account for performance requirements; tunes application performance issues
• Security implements solutions and complete test plans working mentoring other team members in standard process
• Standards is aware of technology standards and understands technical solutions need to be consistent with them
• Documentation develops and maintains system documentation
• Is familiar with different software development methodologies (Waterfall, Agile, Scrum, Kanban)
• Aligns risk and control processes into day to day responsibilities to monitor and mitigate risk; escalates appropriately
• Educational background and work experience that includes mathematics and conversion of expressions into run time executable code.
• Ensures own and teams practices support success across all geographic locations
• Mitigates risk by following established procedures and monitoring controls, spotting key errors and demonstrating strong ethical behavior.
• Helps roll out standards and policies to other team members.
• Financial Industry Experience including Trades, Clearing and Settlement

Education:

• Bachelor's degree or equivalent experience.

Talents Needed for Success:

• Minimum of 3+ years in Data Quality and Integration.
• Basic understanding of Logical Data Modeling and Database design is a plus
• Technical experience with multiple database platforms: Sybase, Oracle, DB2 and distributed databases like Teradata/Greenplum/Redshift/Snowflake containing high volumes of data.
• Knowledge of data management processes and standard methodologies preferred
• Proficiency with Microsoft Office tools required
• Supports team in managing client expectations and resolving issues on time.
• Technical skills highly preferred along with strong analytical skills.