ETL Developer

Date: Jul 27, 2022

Location: San Juan-Cupey, PR

At Popular, we offer a wide variety of services and financial solutions to serve our communities in the Island and abroad. As employees, we are dedicated to making our customers dreams come true by offering financial solutions in each stage of their life. Our extensive trajectory demonstrates the resiliency and determination of our employees to innovate, reach for the right solutions and strongly support the communities we serve; this is why we value their diverse skills, experiences and backgrounds.

 

Are you ready for a rewarding career?

Over 7,900 men and women in Puerto Rico, Virgin Islands and the United States work at Popular.

Come and join our community!

Full Time Position

Remote work available.

General Description

We are currently searching for an ETL Developer to join our dynamic team.  In this position you will review, evaluate, design, implement, and maintain Data Integration components. You will identify data sources and targets, construct data decomposition diagrams, and document the process. You will develop ETL programs to load multiple data repositories for analytical and reporting purposes, and create extract files in a structured format for operational and other business purposes.

 

Essential Duties and Responsibilities

  • Analysis and Design Responsibilities

    • Prepare technical documents to identify workflows and data flows

    • Document the source and target data mapping appropriately

  • Development and Implementation Responsibilities

    • Follow industry/company naming conventions for database objects, file names.

    • Understand the source systems data thoroughly and identify the necessary objects for extraction.

    • Follow & enforce standards when creating extract files. Use control totals and checksums as necessary.

    • Use version control techniques and procedures as per company standards.

    • SQL scripting proven skills is a must. Any other programming language (R, Phyton, Scripting) is a plus

  • Testing & Quality Assurance Responsibilities

    • Ability to perform Data Profiling techniques to identify data issues proactively

    • Validate the data thoroughly for its accuracy against the source system or other standard system reports.

    • Technical and business data reconciliation skills is a must

    • Actively engage the database developers and analysts to validate the data before UAT

    • Adequate data management for data considered restricted or sensitive in terms of masking, encryption on-prem/in-transit, and/or any other method required for auditing/compliance reasons

Essential Duties and Responsibilities II

  • Administration and Maintenance Responsibilities

    • Pro-actively carry out project support /administrative functions.

    • Monitor the production jobs and make sure they are completed on-time.

    • Perform audits regularly in accordance with company policies.

    • Document the audits and its results and report to the management & appropriate personnel.

    • Correct the audit findings in a timely manner and complete necessary documentations.

  • Teamwork/Collaboration Responsibilities

    • Ability to work on multiple projects simultaneously

    • Good analytical, problem solving and decision-making skills

    • Excellent communication and interpersonal skills with technical

Minimum Education

  • Bachelor’s degree in computer science or related field

  • Certifications from major Data Integration vendor is a plus

Experience

  • 3+ years of experience in ETL Development using tools like Informatica, SAP Data Services (Data Integrator), or any other major ETL tool in the market.

  • 5+ years hands-on database development & SQL programming experience (stored procedures, triggers) using MS SQL Server, Oracle, and/or other databases

  • 5+ years of experience in Development and Implementation of Data warehouse & BI solutions

  • Thorough knowledge and experience in Relational & Dimensional Data Models, Star & Snow-flake schema and experience in developing and documenting data models in tools such as ERWIN, MS Visio, etc.

  • Full understanding and practical experience with Slow Changing dimensions

  • Experience with cloud components for storage and integration in AWS, Azure, Google is a plus

  • Good knowledge and experience of data architecture, design principles, practices, systems development, & analysis

 

Competencies

Accountability
Analytical Discipline
Business Excellence
Change Agent
Character
Collaboration & Teamwork
Customer Centric
Self Development

Important: The candidate must provide evidence of academic preparation or courses related to the job posting, if necessary.

 

Popular requires all employees to be fully vaccinated against COVID-19 by the first day of work. We will require you to provide a copy of your COVID-19 Vaccination Record Card. (1)

(1)  In general, people are considered fully vaccinated: ±

       2 weeks after their second dose in a 2-dose series, such as the Pfizer or Moderna vaccines, or

       2 weeks after a single-dose vaccine, such as Johnson & Johnson's Janssen vaccine

 

Popular may provide vaccination exemptions for medical or pregnancy reasons, or due to a sincerely held religious belief or practice, unless doing so would impose an undue hardship to Popular or pose a direct threat to the health and safety of others. If you wish to request a vaccination exemption or have a disability and need assistance with the application process, please contact us at asesorialaboral@popular.com. This email inbox is monitored for such types of requests only. All information you provide will be kept confidential and will be used only to the extent required to provide needed exemptions or reasonable accommodations. Any other correspondence will not receive a response.

 

As Puerto Rico’s leading financial institution, we reaffirm our commitment to always offer essential financial services and solutions for our customers, including during emergency situations and/or natural disasters. Popular’s employees are considered essential workers, whose role is critical in the continuity of these important services even under such circumstances. By applying to this position, you acknowledge that Popular may require your services during and immediately after any such events.

 

          .

 

Popular is an Equal Opportunity Employer

Learn more about us at www.popular.com and keep updated with our latest job postings at www.jobs.popular.com.

Connect with us!

LinkedIn |   Facebook   |   Twitter   |   Instagram


Job Segment: Data Architect, QA, Data Management, Sales Consultant, Data, Quality, Sales