Description
In this senior level role, you will be independently involved in the design, model and implementation of Enterprise data warehousing activities in support of projects and defect remediation process and will participate and lead 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.
You will also assist with designing, implementing and supporting solutions that meet business requirements related to data warehouses, data marts or operational data stores primarily using ETL and will work with application architects to implement enhancements to systems and remediate existing code.
Primary responsibilities include:
Developing and maintaining Enterprise Data warehouse system using ETL tools such as Data Stage, Talend etc to conform to the Regulatory Program Standards.
Creating and updating scripts in UNIX/Linux shell and python to meet the business requirements
Developing 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.
Participating in mapping sessions to understand business requirements, source to target relationships and complex transformations involved in processing data from source to target.
Writing 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.
Creating and updating Autosys JIL’s for scheduling ETL batch jobs, Autosys boxes to sequence batch windows schedule batch jobs and update dependencies.
Providing production support and defecting resolution for the ETL code developed by self and others in the team.
Qualifications
Experience and Skills:
At least 5 Years of 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 writing
Education:
Bachelor’s degree required in Computer Science, or equivalent. Master’s degree preferred
Hours and Work Schedule
Hours per Week: 40
Work Schedule: Monday-Friday 8:00AM-5:00PM
Position is not available in Colorado
Why Work for Us
At 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 Opportunity
Citizens, 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/Veteran
Citizens is a brand name of Citizens Bank, N.A. and each of its respective affiliates.
This job was posted by https://illinoisjoblink.illinois.gov : For more information, please see: https://illinoisjoblink.illinois.gov/jobs/11664201 Job Summary: We are looking for a...
Apply For This JobCareer Area: Engineering Job Description: Your Impact Shapes the World at Caterpillar Inc.: When you join Caterpillar, you’re joining a...
Apply For This JobWalnut Creek Psychiatry is a private psychiatric practice and is looking for an experienced receptionist to be a member of...
Apply For This JobWe are seeking an outgoing individual to join our remote team. You will be responsible for booking amazing trips for...
Apply For This JobThis job was posted by https://illinoisjoblink.illinois.gov : For more information, please see: https://illinoisjoblink.illinois.gov/jobs/10855794 The Sr. Analyst will be a key...
Apply For This JobGoodRx is America’s healthcare marketplace. Each month, millions of people visit goodrx.com to find reliable health information and discounts for...
Apply For This Job