ETL Tester

Role description

We are looking for a highly technical ETL Tester who comes from a development background and has experience meeting with users, business units and data modeling teams to craft and assemble technical designs for solutions to be implemented. This person will be interacting with both technical and non-technical audiences within an Informatica PowerCenter ETL development environments while providing Production support and defining dataflows.  


Job Duties:

·      Analyze existing ETL processes, data slows and models to write and create test cases while understanding the business requirement or the downstream process requirements.

·      Take source to target DDR and write Test Cases independently while serving as technical liaison between teams regarding new system implementations, development, integration, and changes while collaborating with management to design technical solution. 

·      Navigate through Flat Files, assist in UAT Testing while understanding the scope of the work and ask clarifications and escalate to the right leads in case of issues/delays.

·      Test, debug, and document system and application programs within Informatica PowerCenter solution implementation and support in collaboration with Data Mapper and Data Modeler to test the dataflow and enhance the ETL to fulfill the requirement.

·      Prepare test cases and documentation based on functional and technical requirements ensuring adherence to best practices for developing PowerCenter solutions are followed.

·      Review functional and technical specifications prepared by vendors.

·      Review test scope, test approach/strategies, manage defects closing during the SIT and UAT.

·      Liaise with infrastructure team on nonproduction and production infrastructure and environments and other teams involved.

·      Provide support in Production for Informatica PowerCenter v8 and up, and fix production defects.


Education & Requirements:

·      Bachelor’s Degree is required

·      3+ years’ Informatica PowerCenter ETL testing experience within large data warehouses

·      Experience with working on Oracle, SQL Server, PL/SQL and Informatica ETLs is required

·      Strong understanding of Control-M Scheduling, Datawarehouse architectural patterns, and batch processes is a must

·      Previous experience with Snowflake

·      Strong experience of UNIX operating system


Plus:

•        Previous experience in banking/financial sectors is a plus


Latest jobs

The Cervantes Group

Security Engineer

December 6th, 2024
Remote
Full-time

This person will be configuring and installing firewalls and proxies within virtual and physical network IT infrastructures (IPS, network access controls, and security infrastructure). Collaborate with upper management to design solutions and document vulnerabilities detected within areas such as third party connections while collaborating with technical teams to resolve any vulnerabilities. Ensure compliance with industry regulations. The ideal person can prepare technical procedures, standards & network schematics interfacing with stakeholders and technical audiences in an international environment.


Primary Duties & Responsibilities:

  • Plan and implement enterprise networks and related hardware and software in addition to establishing security (firewalls, intrusion detection), connectivity and access parameters.     
  • Prepare and configure technical procedures, standards & network schematics/design for firewall infrastructure (CheckPoint preferred & Cisco is a plus), proxy technologies (Blue Coat, Cisco IronPort/Umbrella, Zscaler), IPS, and Network Access Control (Cisco ISE).
  • Offer tier-2 troubleshooting and support engineering in addition to supporting the evaluation of technical requirements for projects to determine the impact to the infrastructure including equipment redundancy and capacity requirements.
  • Configure and maintain virtual network and update in CMDB, diagrams, and network security devices information about third party connections while collaborating with technical teams to take corrective action when necessary.
  • Escalate incidents within company and/or with external technical resources when necessary.
  • Prepare coverage reports for management review and recognize threats and intrusions by identifying abnormalities and reporting violations. 
  • Determine security violations and inefficiencies by conducting periodic audits.
  • Evaluate applications to discover vulnerabilities and prioritize remediation efforts based on risk.


Education & Qualifications:

  • Bachelor’s degree or experience in relevant field/equivalent work experience
  • Must be bilingual (written and verbal communication) in both English/Spanish
  • 2-3+ years of relevant IT work experience within Security Engineering and Configurations
  • Previous experience configuring and managing CheckPoint firewalls, Cisco ISE, ASA, security devices, firewalls, IPS/IDS
  • Previous experience configuring proxy technologies (Blue Coat, Cisco IronPort/Umbrella, Zscaler),
  • Knowledge and previous experience with vulnerability and hardening guide compliance


Desire Requirements (Not Mandatory):

  • Check Point Certifications (CCSA or CCSE) are highly preferred
  • Highly preferable experience with hardening of network and security devices
  • Proven routing and switching experience is highly preferred
The Cervantes Group

Sr. Program Manager

December 2nd, 2024
Remote
Full-time

The Sr. Program Manager will be developing and delivering new payment types or processes in line with industry developments, competitor developments. The ideal person has experience overseeing domestic US instant payment capabilities that include The Clearing House Real Time Payments system (RTP) and the Federal Reserve’s FedNow system in addition to covering cross-border instant payments solutions, such as IXB, as/when these gather industry momentum. The Sr. PM will also be responsible for providing direction and guidance for activities associated with planning and management to ensure projects are completed on time, within budget and to client specifications. The Sr. Program Manager will drive execution of key deliverables calendar from information gathering, multiple management reviews, approvals and ongoing improvements within digital transformation initiatives.


Job Duties:

  • Execute payment strategies in conjunction with the Head of Transaction Banking Product Management, payments partners in the CBB/Digital, Commercial and CIB Lines of Business, as well as functional partners including IT, Operations, Marketing, Risk, Compliance and strategic third party providers (such as PagoNxt).
  • Develop product specifications and business requirements for new products to deliver the strategic product roadmap, with initial focus on real-time payments (RTP).
  • Manage the implementation and launch of RTP and FedNow to support US market clients.
  • Understand and actively manage the risks associated with instant payments products.
  • Actively manage the P&L of instant payments products, ensuring full visibility to costs and ROI.
  • Understand deeply how end users/customers use individual products, and how products deliver value for them in addition to the capabilities of our bank and non-bank competitors, and deliver product strategies that position us favorably in the market.
  • Work with Marketing partners to build effective market launch / go-to-market programs.
  • Build strong relationships with client-facing teams to ensure they fully understand the value of our payments products and how to position them with client.
  • Leverage data analysis and market intelligence to bring new ideas forward and align closely with Client Service & Onboarding to build and maintain a strong client experience.
  • Explore other emerging payments opportunities, including services leveraging blockchain and/or digital assets and near-term, innovative approaches as interim solutions.


Education & Requirements:

  • Bachelor’s Degree is required
  • 6+ years’ formal program management experience within payments technology (e.g. online channels, Transaction Banking/Payments, mobile payments, etc.)
  • Experience working on teams in a hybrid Agile/Waterfall delivery approach
  • Solid understanding of Project Management Office governance procedures within IT and technical project environments (systems integrations, digitalization, automation and/or cloud computing)
  • Must understand Real-time Payments (RTP) and FedNow requirements, operating rules, and format specifications


Plus:

  • Bilingual in English and Spanish is a plus
  • Previous experience with blockchain technologies is a plus
  • PMP, Scrum Master (CSM) and/or SAFe certifications are highly desirable


The Cervantes Group

QA Analyst

December 2nd, 2024
Remote
Full-time

The QA Analyst will help analyze, define, create, and test the functionality of systems, platforms, SW and applications. This person will help to implement quality control processes to ensure service compliance to design specifications and work with cross-functional teams to identify root cases for defects through statistical process control techniques. Must be able to prepare and document findings and recommendations to improve testing execution and impact.


Responsibilities:

  • Define and implement quality control processes to measure product or service compliance to design specifications in addition to developing new processes and tools as needed in order to improve testing execution and impact.
  • Lead and coordinate activities to deploy the scripts and test cases created for monitoring.
  • Create and conduct sampling and testing procedures while identifying root causes for defects and participates in continuous improvement initiatives.
  • Estimate, prioritize, plan and coordinate testing activities, work with Product Owners to plan for needs related to automation and produce documentation for end-to-end automation scenarios and testing strategy.
  • Create and execute test specifications from design requirements, analyzing and reporting test results and reporting on defect resolution.
  • Work with technical teams, customers and upper management to produce project documents and understand customer demands, and product objectives to create and execute test cases.
  • Create detailed, comprehensive, and well-structured test plans and test cases. 


Required Experience & Education: 

  • Bachelor’s degree is required
  • Must be bilingual in English & Spanish (written, verbal)
  • 1-2+ years’ of experience in Software Testing & Quality Control Process experience is required
  • Experience in designing and implementing test strategies to ensure product functionality
  • Ability to identify root causes for defects and participates in continuous improvement initiatives
  • Must be familiar with statistical process control techniques

 

Plus: 

  • Knowledge on test automation using JMeter/Selenium/Cypress/Postman is a plus
  • Previous experience in banking is highly desired
  • Expertise in Agile SAFe methodologies, iterative methodologies and Behavior Driven Development techniques is highly preferred


The Cervantes Group

Risk Analyst

December 2nd, 2024
Remote
Full-time

The Risk Analyst will be supporting and driving various activities relating to IT risk management, 3rd party vendor risk-based assessments monitoring and reporting. This person will be monitoring inventory of third-party relationships to develop teams to oversee and facilitate onboarding of 3rd-Parties that require expedition or additional sensitivity based on services provided. The ideal person for this role will have experience presenting to executives and upper management and excellent communication skills.


Job Duties:

  • Ensure transparency of business results, finance and processes and track goals accomplishment, collect and process data and provides managers with all necessary company management data and information.
  • Challenge stratification of third-party risk-based assessments and refreshed regularly to efficiently allocate resources to relationships posing the highest risk.
  • Monitor inventory of third-party relationships including outsourcing partners, suppliers of goods and services (including third-party administrators), distribution partners, entity relations (associates, affiliates, joint ventures) and important fourth parties (sub-contractors).
  • Ensure capture of the full lifecycle and range of third-party relationships, identify, monitor and track exceptions to policy.
  • Ensure awareness in the Business Line of risk frameworks, policies and standards.
  • Maintain two-way communications with SLoD (Second Line of Defense) and facilitate training for Business Lines to provide awareness of risk frameworks, policies, programs, processes, etc.
  • Facilitate Business Line awareness of and adherence to risk frameworks, policies, and standards in addition to reporting and escalating exceptions and facilitate Business Line corrective actions.
  • Continuously monitor all sources of risk existing within the Business Line and externally.
  • Monitor Key Risk Indicators and report on negative/adverse trends in Business Line. Monitor risk profile to maintain tolerance within Risk Appetite.
  • Engage and hold Business Line process owners accountable to identify and assess risks. Support Business Lines in risk identification (e.g. NPBA, change management, etc.) Ensure all issues (Self-Identified, IA, Credit Risk Review or Regulatory) pertaining to the Business Line are resolved within established timelines.
  • Liaison with the Business Line for all exam related activities including regulatory, Internal Audit and Credit Risk Review.


Education & Requirements:

  • Bachelor’s Degree is required
  • 3+ years’ banking experience or relevant industry experience, preferably in areas such as Audit, Technology, Risk, Vendor Risk Analysis, Operations, and/or public accounting
  • Must have deep knowledge in key domains of Third-Party Risk Management (TPRM), TPRM Metrics Design and Implementation and TPRM Policy and Procedures development
  • Experience in Vendor Management, Risk Management, Internal Controls, Auditing, relevant line of business experience and/or legal or regulatory experience
  • Proven success within Agile/Scrum environments, Project Management Office governance procedures within digital project settings


Plus:

  • Industry certifications are preferred, such as CRISC, CGEIT, CISA