The DTCC AD Senior Software Engineer (SSE) applies specific technical knowledge in order to assist in the design and construction of critical systems. The SSE works as part of an AD project team and may interact with the business, Functional Architects, and subject matter experts on related systems. The ASD may 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 SSE must possess good communication skills and be able to work well on a team. 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.
About 6 -8 years of IT experience in application development and systems analysis.
Knowledge & Skills:
Knowledge and experience in Cloud technologies (AWS S3, RDS, Aurora, DMS, RedShift, Glacier etc.)
Languages/Methodologies – PL/SQL, SQL
Software / Tools: TOAD, Eclipse.
Design and development of stored procedures and functions using SQL and Oracle PL/SQL
Strong database design and modeling experience
Experience in DWH, ETL, Data modeling and Data Marts
Data warehouse products experience in Greenplum or Netezza or Teradata
Experience in ETL and data integration technologies like Informatica or Datastage.
Experience in BI tools like Tableau, Cognos
Experience in Perl Scripting
Familiarity with Unix OS and shell scripting
Demonstrate strong analytical and communication skills.
Thorough understanding of the software implementation lifecycle, Agile, Continuous Integration.
System Performance – contributes to solutions that satisfy performance requirements; tunes application performance issues
Security – develops and executes security requirements
Education, Training &/or Certification:
Degree in a technical discipline and related experience.