Senior Software Engineer - ETL, Informatica, Hadoop
PNC•Strongsville, OH
•$55,000 - $172,250•Onsite
About The Position
Provides detailed technical design and development of software solutions using existing and emerging technology platforms. Proposes & designs software solutions to address complex business needs. Writes code, tests and deploys software. Prepares technical and procedural documentation required for software. Maintains and debugs software.
Requirements
- University / college degree, with 3+ years of relevant / direct industry experience.
- In lieu of a degree, a comparable combination of education, job specific certification(s), and experience (including military service) may be considered.
Nice To Haves
- Hands-on experience in ETL development using Informatica PowerCenter and Power Exchange
- Strong experience designing, building, and supporting enterprise-scale data pipelines
- Proven ability to work with relational databases such as Oracle, SQL Server, Teradata, and NoSQL platforms like MongoDB
- Solid understanding of data integration from other sources like mainframe.
- Advanced SQL skills for data validation, reconciliation, and performance tuning
- Experience implementing complex data transformations, business rules, and data quality checks
- Knowledge of ETL job monitoring, troubleshooting, and production support processes
- Strong background in technical documentation, including ETL mappings, workflows, and design specifications
- Ability to collaborate effectively with Business Analysts, QA, and application teams to translate business requirements into technical solutions
- Experience ensuring data quality, accuracy, and completeness across enterprise data systems
- ServiceNow Experience as well as experience with presenting changes in CAB.
- OBI and Tableau experience
Responsibilities
- Design, develop, and maintain ETL workflows and mappings for enterprise data integration
- Build and support data pipelines using Informatica PowerCenter and Power Exchange
- Extract and process data from multiple areas (Oracle, Hadoop, SQL Server, flat files, etc.)
- Implement complex data transformations and business rules
- Write and optimize SQL queries for data validation, reconciliation, and performance tuning
- Work with relational databases such as Oracle, Mongo DB, SQL Server, or Teradata
- Monitor ETL jobs, troubleshoot issues, and provide support
- Ensure data quality, accuracy, and completeness
- Create and maintain technical documentation (mappings, workflows)
- Collaborate with Business Analysts, QA, and application teams to clarify data requirements.
- Willingness to work off hours for releases and offshore collaboration.
Benefits
- medical/prescription drug coverage (with a Health Savings Account feature)
- dental and vision options
- employee and spouse/child life insurance
- short and long-term disability protection
- 401(k) with PNC match
- pension and stock purchase plans
- dependent care reimbursement account
- back-up child/elder care
- adoption, surrogacy, and doula reimbursement
- educational assistance, including select programs fully paid
- a robust wellness program with financial incentives
- maternity and/or parental leave
- up to 11 paid holidays each year
- 9 occasional absence days each year, unless otherwise required by law
- between 15 to 25 vacation days each year, depending on career level; and years of service.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Upload and Match Resume
What This Job Offers
Job Type
Full-time
Career Level
Senior
