Peersight
Employers
Jobs
Companies
Top Cities
Log In
Jobs
Service Product Tester at Home In-Home Usage Tester Product Tester at Home Sales Representative Chauffeur d Handydart Bus Driver - Kelowna In-Home Usage Tester Service Desk Associate- Part Time Service Kitchen Designer Full-Time Sales Representative Sales Representative Sales Representative In-Home Usage Tester Product Tester at Home Service Service Service In-Home Usage Tester Product Tester at Home Product Tester at Home In-Home Usage Tester Chauffeur d In-Home Usage Tester Chauffeur d In-Home Usage Tester Product Tester at Home Product Tester at Home Product Tester at Home Transit Bus Drivers - HandyDART - In-Home Usage Tester Product Tester at Home Product Tester at Home School Bus Driver - Edmonton In-Home Usage Tester School Bus Driver - Ottawa Chauffeur d Product Tester at Home Product Tester at Home Product Tester at Home Product Tester at Home Product Tester at Home Product Tester at Home In-Home Usage Tester Product Tester at Home School Bus Driver - Barrie Product Tester at Home In-Home Usage Tester In-Home Usage Tester Newest Jobs
Companies
Yelp ContactMonkey CareGuide Sterling-Turner Clearbanc Two Sigma WeWork Aecom Exact Media Aerotek Jane Street Doordash First Convenience Bank AsteroidX Shopify AT&T Insight Global Hatchways Creative Circle Borrowell Square Clickworker Amazon Flex Recovhub Vector Marketing Walgreens LowCostWebDesignFirm.com Instacart American Income Life Scotiabank 51talk Microsoft TD Bank Akira UnitedHealth Group Paylocity Top Hat CI&T mappedin Desjardins Mobeewave Checkout 51 The Youth Connection GoParkr Peel Regional Police Hootsuite autoTRADER.ca ScribbleLive SnapTravel Xiaomi All Companies
Top Cities
Chicago, Illinois Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs New York, New York Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Toronto, Ontario Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Vancouver, British Columbia Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Calgary, Alberta Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs San Francisco, California Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Montréal, Quebec Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Los Angeles, California Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs
Navigation
My Profile Log Out

ETL Developer At Banco Popular de Puerto Rico

Location: Rosemont, Illinois

Job Description

Join the Popular Team!

Founded in 1893, Popular Inc. has been built upon strong institutional values while providing broad financial services within the United States, Puerto Rico, and the Caribbean.

We strive to create an extraordinary legacy with a passion for customer service, tremendous dedication to our employees, and strong partnerships in the communities where we reside. Come explore Popular - Our bottom line is you.

Data Integration

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

In this position, you will:

Analysis and Design Responsibilities

  • Prepare technical documents to identify work flows and data flows
  • Document the source and destination mapping appropriately

    Development and Implementation Responsibilities

  • Follow industry/company naming conventions for database objects, file names.
  • Understand the source system thoroughly and identify the necessary objects for extraction.
  • Create accurate mapping from source to destination and ensure the data is accurately transferred.
  • Follow & enforce standards when creating extract files. Use control totals and checksums as necessary.
  • Use version control techniques and procedures as per company standards.
  • Proven skill on the use of sql is a must. Any other programming language is a plus

    Testing & Quality Assurance Responsibilities

  • Validate the data thoroughly for its accuracy against the source system or other standard system reports.
  • Actively engage the database developers and analysts to validate the data before UAT.

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

To be considered, you will need:

  • 3+ years of experience in Development and Implementation of Data warehouse & BI solutions
  • 3+ years solid hands-on database development & SQL programming experience (stored procedures, triggers) using MS SQL Server, Oracle, and/or other databases
  • 2+ Experience in ETL Development using tools like Informatica, SAP Data Service (Data Integrator)
  • Thorough knowledge and experience in Relational & Dimensional Data Models, OLAP, Star & Snow-flake schema and experience in developing data models using Erwin , MS-VISIO
  • Good knowledge and experience of data warehouse architecture, design principles, practices, systems development, & analysis
  • Experience in developing Reporting & Analytical solutions using tools like Business Objects, Cognos, etc.

Academic Background:

  • Bachelor’s degree in computer science or related field

Please consider joining our DYNAMIC, friendly team! It takes only a few minutes to check-out this great opportunity and apply!

We are proud to be an EEO/AA employer M/F/D/V. We maintain a drug-free workplace and perform pre-employment substance abuse testing.

To learn more about Popular, visit our website at www.popularbank.com.