PawtucketRecruiter Since 2001
the smart solution for Pawtucket jobs

Sr Data Engineer- ETL

Company: Citizens
Location: Pawtucket
Posted on: November 14, 2022

Job Description:

DescriptionThe Senior Data Engineer will report to the Principal Solution Engineer, Enterprise Data Platform. The position is independently involved in the design, model and implementation of Enterprise data warehousing activities in support of projects and defect remediation process. The Senior Data Engineer participates and leads segments in the programming and configuration of warehouses on database, and provides independent support to warehouse users under direction and supervision of more senior data architects and programmers. The Senior Data Engineer assists with designing, implementing and supporting solutions that meet business requirements related to data warehouses, data marts or operational data stores primarily using ETL. The Senior Data Engineer works with application architects to implement enhancements to systems and remediate existing code. - -Primary responsibilities include: -

  • Design, develop and maintain Enterprise Data warehouse system using ETL tools such as Data Stage, Talend etc to conform to the Regulatory Program Standards.
  • Create and update scripts in UNIX/Linux shell -and python to meet the business requirements
  • Design and develop code using ETL tools such as Datastage, Talend etc to load data from different sources to the enterprise data platform, including flat files, Complex flat files, AWS S3, Redshift, Oracle, SQL Server, DB2, and big data files.
  • Participate in mapping sessions to understand business requirements, source to target relationships and complex transformations involved in processing data from source to target.
  • Write complex SQL queries to extract data from databases using ETL tools such as DataStage, Talend or Query tools such as Aqua Data Studio, Dbeaver etc as part of ETL development, - impact analysis, unit testing and supporting end users by using database joins, self-joins, - aggregate functions, rank functions, case statements ,etc as per business requirements.
  • Create and Update Autosys JIL's for scheduling ETL batch jobs, Autosys boxes to sequence batch windows schedule batch jobs and update dependencies.
  • Provide production support and defect resolution for the ETL code developed by self and others in the team.QualificationsQualifications -
    • At 5 Years experience in ETL design and development utilizing Talend or IBM DataStage or other similar ETL tools.
    • Expert in AWS technologies
    • Experience working with DB2 on AIX and Oracle Exadata and other databases. DB2 and Oracle preferred.
    • Excellent SQL skills
    • Excellent scripting skills across Unix/Linux scripts using k-shell and python
      • Experience with SDLC and Agile Methodologies.
      • Experience with configuration management using Subversion
      • Ability to communicate effectively in verbally and in writingEducation:
        • Bachelor Degree required in Computer Science, or equivalent. -Masters Degree preferred -Hours and Work Schedule - -Hours per Week: - - 40Work Schedule: - - - Monday-Friday 8:00AM-5:00PM#LI-Sourcer3 Some job boards have started using jobseeker-reported data to estimate salary ranges for roles. If you apply and qualify for this role, a recruiter will discuss accurate pay guidance.Why Work for UsAt Citizens, you'll find a customer-centric culture built around helping our customers and giving back to our local communities. When you join our team, you are part of a supportive and collaborative workforce, with access to training and tools to accelerate your potential and maximize your career growth.Equal Employment OpportunityCitizens, its parent, subsidiaries, and related companies provide equal employment and advancement opportunities to all colleagues and applicants for employment without regard to age, ancestry, color, citizenship, physical or mental disability or perceived disability, ethnicity, gender, gender identity or expression, genetic information, genetic characteristic, marital or domestic partner status, victim of domestic violence, family status/parenthood, medical condition, military or veteran status, national origin, pregnancy/childbirth/lactation, colleague's or a dependent's reproductive health decision making, race, religion, sex, sexual orientation, or any other category protected by federal, state and/or local laws.Equal Employment and Opportunity Employer/Disabled/VeteranCitizens is a brand name of Citizens Bank, N.A. and each of its respective affiliates.

Keywords: Citizens, Pawtucket , Sr Data Engineer- ETL, Engineering , Pawtucket, Rhode Island

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Log In or Create An Account

Get the latest Rhode Island jobs by following @recnetRI on Twitter!

Pawtucket RSS job feeds