Principal ETL Engineer
The Principal 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: defining networking requirements; 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. This role may also integrate solutions or build via DevOps depending on the maturity of the organization and/or product.
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, identity 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 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
- 6 years of Technology experience
- 7 years in identifying technical solutions for complex business problems, identifying the benefits and risks of the solutions and providing recommendations
- 5 years of experience mentoring another technologist
- This position is not eligible for sponsorship. Must have indefinite employment authorization.
Preferred Qualifications:
- 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
- 2 years of experience leading a Power Center to IDMC migration for existing code
- 2 years of experience proactively identifying/planning & driving upgrade projects for EOL Informatica products/components
Category C - Days in the office will either be designated days or will vary week to week from 2-5 days
8:00am - 5:00pm Monday - Friday
To Be Determined Based on Individual Experience
About Comerica
We know our employees are critical to our overall success and we are dedicated to investing in their future. One of the ways we do this is to offer a comprehensive Total Rewards package designed to recognize and reward individual performance, as well support health, well-being, development and security for our colleagues and their family. Total Rewards consists of cash compensation, development and flexible benefit programs designed to meet individual needs today and in the future. Your salary will be commensurate with your work experience and our programs are reviewed regularly to ensure each remain competitive. We are proud to offer benefits such as health and welfare programs, strong retirement benefits, and generous paid time off programs. You and your eligible family members, including domestic partners and their children, can participate in medical, dental, and vision benefits, 401(k) and pension, income protection benefits such as life insurance, AD&D, and supplemental health programs to offset unexpected health care expenses. We also have a variety of time off programs for things like vacation, sick time, disability, and parental leave. Eligibility for some programs varies based on employment status and tenure.
Upon offer, Comerica conducts a comprehensive background and fingerprint check.
NMLS certification requirement: where applicable, a favorable background check screening, credit check, fingerprint check, and NMLS certification is required in accordance with the SAFE Act.
Comerica Incorporated (NYSE: CMA) is a financial services company headquartered in Dallas, Texas, and strategically aligned into three major business segments; the Commercial Bank, the Retail Bank, and Wealth Management. Comerica's colleagues focus on relationships, and helping people and businesses be successful. In addition to Texas, Comerica Bank locations can be found in Arizona, California, Florida and Michigan, with select businesses operating in several other states, as well as in Canada and Mexico.
Comerica is proud to be an Equal Opportunity Employer - veterans/individuals with disabilities, committed to workplace diversity.
