Sr Software Engineer - ETL Tools

Sr. Software Engineer Tempe, Az ETL Tools

Performs systems design and analysis, develops code, and testing to ensure successful and seamless communication among the various IT systems users and applications components. Develop and support customized code, ETL, interfaces, and reports for the implementation and ongoing development and operations of Regulatory Reporting.

Early identification of development issues and take corrective measures/actions to mitigate issues

Help to define the coding standards for the regulatory reporting applications

Develop detail-level design documents from functional requirements and adhere to the development and naming standards established

Works on projects providing subject matter expertise and technical direction/guidance to junior technical staff and technically lead medium size projects

Reviewing and evaluating new requirements, change requests and problems by conferring with business analysts and SMEs

Estimating, Planning, Organizing and collaborating for delivery with large cross functional teams, small teams as well as taking sole ownership of the task and produce necessary deliverables

Representing the Regulatory team in status and management meetings with business stakeholders as a technology expert Partner and with Architecture team on development standards, processes, tools, techniques and product selection

Prepare and present technical concepts to internal audiences and management

Work within a disciplined change-and-configuration management environment to maintain control over the development and introduction of new function to the operations

Influence the change control team on best practices of handling code migrations between environments

Participate in the rollout of any changes to the production environment and the setting of new standards using change control, documentation, and full communication with the operations and Third level support for development/production support issues

Qualifications:

• 7+ years of experience with software engineering and production support (L3 and L4)
• Bachelor's degree in Computer Science, Information Science, or related discipline or equivalent work experience
• Experience in Banking/Financial domain with knowledge in loans, deposits and securities related systems etc.
• Hands-on development experience in Axiom Controller View
• Ability to provide subject matter expertise and technical direction to team members with respect to Regulatory Reporting (FR-Y9C, FR Y-14 A/M/Q, FFIEC 031 etc)
• Technical expertise in process and data modeling
• Hands-on experience with Restful Web Services, web applications, JSM, transactional databases, and NoSQL databases
• Experience in SDLC, Software Design, Software Documentation and Software Testing methodologies
• Technical Knowledge of ETL tools like Informatica, SQL, PL/SQL programming skills
• Experience in writing stored Procedures, Functions, Packages and Triggers
• Experience working in banking environment
• Ability to analyze and troubleshoot production issues
• Experience in implementing and supporting of SaaS applications
• Experience with distributed systems
• Strong understanding of SQL
• Experience with enterprise integration services/solutions
• Experience with systems implementation projects
• Experience with development coding and relational database (SQL) queries
• Advanced knowledge and analytical skills of systems integration through web services, ETL, etc.
• Strong written and verbal communication skills with the ability to interact with all levels within the organization
• Experience with production and disaster recovery systems/application support
• Ability to execute and prioritize multiple tasks, initiate and conduct meetings with team and peers
• Able work independently with minimal supervision
• Able to streamline complex requirements to simplify Business Processes
• Excellent communication and interpersonal skills to interact with all levels. Demonstrate good organization, presentation and customer service skills
• Experience with Agile Methodologies in a distributed team environment is a plus
• Must be willing to collaborate and engage with a global team which will involve some early morning or late evening meetings