Principal ETL Engineer

Principal ETL Engineer

The Principal ETL Engineer role will provide engineering and architecture support for complex system management activities related to system software, hardware, performance, problem determination or resource management requiring communication and coordination with vendors, technicians, clients, and management. Provide technical input to management decision making in the areas of software, hardware, and performance.

Responsibilities include: performing detailed analysis of various projects and requests; developing designs for projects that have medium to high complexity; formulating procedures; monitoring key performance indicators; and implementing advanced business solutions. The Principal ETL Engineer will collaborate with business partners, technical teams, and product managers to understand the data requirements and provide technical project solutions. Successful candidates will have excellent written and analytical skills; and be able to identify, recommend, improve and document the CICD and change management processes. The Principal ETL Engineer must possess excellent communication and presentation skills to interact with all levels of technology and business teams. Candidates should be available to provide the off-hours support, coordinate with the data teams to lead the production and non-production deployment and validation efforts.

Position Responsibilities:

Design and Methodology

• Work closely with business units, application teams, infrastructure areas and vendors to identity, review and evaluate the solution requirements.
• Investigate and propose strategic fits for virtualization, consolidation and rationalization solution opportunities within the infrastructure or business. Propose changes to the technical architecture and design solutions as applicable.
• Evaluate and align strategic fit solutions across infrastructure platforms and solutions specific to system hardware and software technologies.
• Understand, participate, review and influence long term capacity planning and technology investments.

Technical Consulting

• Provide Client consulting and planning guidance as applicable for moderate to large highly complex projects/programs.
• Provide consultation and works closely with other functional infrastructure areas/departments on multiple initiatives to meet common organizational / business goals and objectives.
• Participate in and provides consulting to project teams on architectural, design development, integration opportunities, planning of highly complex systems and assures it is aligned to our established strategies, guiding principles, rationales and practices.

Planning and Organizing

• Identify and evaluate projects/programs/initiatives and design processes that enhance and rationalize existing and upcoming solutions.
• Map requirements into standard services solution, identify opportunities for integrating to existing or reuse technology and provide cost effective solutions for moderate to large highly complex project/programs/initiatives.
• Review, identify and manage requirements for moderate to complex solutions and do a cost value, feasibility and risk analysis.

Risk Management

• Review, participate, develop and update architectural standards, guiding principles, rationales and strategies.
• Evaluate, review and approve highly complex design solutions for business and Infrastructure project or programs or initiatives.

Position Qualifications:

• Bachelor's Degree from an accredited university in Computer Science, Engineering or in a Technology related field, OR equivalent through a combination of education and/or technology experience, OR 12 years of technology experience
• 7 years of experience identifying technical solutions for complex business problems, identifying the benefits and risks of the solutions and providing recommendations
• 7 years of experience in Technology, Data Engineering field in architecting, developing end-to-end scalable data applications and data pipelines; work with product manager and scrum masters and lead the team in assisting the story creations and sprint deliverables
• 7 years of experience leading and developing automated Informatica data pipelines with at least 2 years Informatica cloud (IDMC) and relevant knowledge in data profiling, data quality, catalog tools
• 7 years of experience working in enterprise data warehouse solutions and platforms, and working knowledge of different databases (e.g., RDBMS, Snowflake), S3 Datalake, CICD, Jenkins and AWS cloud technologies
• 5 years of experience designing, implementing automated data solutions, building workflows, developing, and scheduling ETL processes using programming SQL
• 5 years of experience mentoring another technologist
• 5 years of experience implementing data solutions by adopting, recommending and improving CICD, change management, data security, auditing processes
• 4 years of experience with cross-platform scheduling tools like CA7
• 4 years of experience with data replication technologies like IBM infosphere data replication or IDMC data replication and synchronization
• 4 years of experience working with software engineering best practices across the development lifecycle, including agile methodologies, coding standards, code reviews, source management, build processes and testing
• AWS or Informatica or Snowflake certification is preferred
• This position is not eligible for sponsorship. Must have indefinite employment authorization.

Work Best Category: Category C - Days in the office will either be designated days or will vary week to week from 2-5 days

Hours: 8:00am- 5:00pm Monday- Friday

Salary:To Be Determined Based on Individual Experience