IT - Enterprise Platforms Admin - Sr ETL Developer

JOB TITLE: Senior ETL Developer DEPARTMENT: IT- Enterprise Platforms Admin STATUS: EXEMPT JOB CODE: 10049 PAY GRADE: 22S PAY SCALE: $123,600.00 - $160,000.00 Annually GENERAL DESCRIPTION The Sr. ETL Developer provides technical leadership and hands on expertise with respect to the analysis, design, development and support of Golden 1’s Informatica ETL implementation. This is a senior position responsible for assisting the ETL Architect with implementation methodologies including standards, design patterns and best practices for enterprise data warehouse development. The Sr. ETL Developer will assist in leading other ETL developers. This includes both leading and participating in ETL development activities to ensure an efficient, high-performance implementation which fully supports the business’ data needs. TASKS, DUTIES, FUNCTIONS 1. Helps creates standards, design patterns and best practices for ETL development in an enterprise data warehouse environment. 2. Installs, configures and administrates Informatica PowerCenter and IDQ. Informatica Web Services Hub experience also desired. 3. Responsible for workflow and mapping analysis, design, development, testing, and configuration. 4. Functions as both an expert and lead technical resource on ETL projects throughout the project lifecycle. 5. Provides support for enterprise data warehouse ETL jobs and processes. 6. Diagnoses and remedies technical problems to ensure platform up-time and application service levels are met. 7. Supports, maintains and monitors the health of the platform and associated processes. 8. Writes high quality processes utilizing structured development techniques to support process components and development. 9. Utilizes agile-based approach to implementing data services and solutions. 10. Recommends improvements to ETL processes to improve on data delivery, data quality and overall processing efficiency. 11. Partners with quality assurance testing teams to identify errors and confirm business specifications have been achieved. 12. Able to organize and lead code releases using native Informatica PowerCenter capabilities. 13. Develops support guides and run books for operational support purposes. 14. Collects information to analyze and evaluate existing or proposed application designs. 15. Maintains system and programming guidelines by adhering to the software development lifecycle; develops and maintains artifacts related to standards and architecture. 16. Assists with the definition and implementation of processes, policies, standards and procedures to assure compliance with corporate and regulatory policies. 17. Effective oral and written communication skills required to train, direct, and evaluate staff, diagnose, correct and resolve system problems. 18. Maintain a thorough understanding of state and federal laws and regulations related to credit union compliance including bank secrecy and anti-money laundering laws appropriate to the position. PHYSICAL SKILLS, ABILITIES, AND EXERTION UTILIZED IN THE PERFORMANCE OF THESE TASKS 1. Availability for emergency and on call duty 24 hours a day, 7 days a week, as needed. 2. Occasional travel may be required. 3. Lift and carry communications equipment and computer hardware weighing up to fifty pounds. 4. Must possess sufficient manual dexterity to skillfully operate applicable computer hardware, a variety of hand tools and standard office equipment. 5. May work additional work hours to accomplish tasks. ORGANIZATIONAL CONTACTS & RELATIONSHIPS 1. INTERNAL: All levels of staff and management 2. EXTERNAL: Vendors QUALIFICATIONS 1. EDUCATION: Bachelor’s degree in Computer Science, Management Information Systems or comparable discipline or equivalent work experience. 2. EXPERIENCE: Minimum of five years’ experience, designing, developing and supporting enterprise data warehouse ETL implementations. 3. KNOWLEDGE/SKILLS: • Experience with Cloud implementations is essential. • Highly experienced working with Kimball based data warehouse implementations. • Strong understanding of all aspects of dimensional modeling as it pertains to ETL design and development. Must have prior experience designing loads for daily and monthly snapshot facts, accumulating snapshot facts, factless facts, type 1, 2, 3 and other hybrid dimension types as well as 3NF and other modeling techniques. • Strong understanding of enterprise architecture, security, management and monitoring. • Strong understanding of data management best practices and concepts including data quality, reference data, metadata, and data lineage. • Strong SQL skills expected. • Data Integration experience necessary. • This is a master developer role. PHYSICAL REQUIREMENTS 1. Prolonged sitting throughout the workday with occasional mobility required. 2. Corrected vision in the normal range required to configure, test, and troubleshoot network server hardware and data. 3. Hearing within normal range. A device to enhance hearing will be provided if needed.

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...