ETL Lead
Mastech Digital - Pittsburgh, PA
Apply NowJob Description
Role: ETL Informatica Lead Location: Pittsburgh, PA (Hybrid) Job type: Full time/ Permanent roleResponsibilities: Lead the design, development, and implementation of ETL processes using Informatica PowerCenter and related technologies. Collaborate with business stakeholders, data architects, and analysts to understand data requirements and translate them into effective ETL solutions. Manage a team of ETL developers, providing technical leadership, guidance, and mentoring. Oversee the development, optimization, and maintenance of ETL pipelines for various data sources and targets, ensuring data integrity and performance. Troubleshoot and resolve data integration and transformation issues, optimizing ETL processes for efficiency and scalability.Conduct code reviews, performance tuning, and testing to ensure quality and compliance with standards. Ensure data security and privacy policies are implemented throughout the ETL process. Coordinate with project managers and other team members to ensure project milestones are met and delivered on time. Provide ongoing support for production data pipelines, troubleshooting issues as they arise. Stay current with industry trends, ETL tools, and technologies, and recommend improvements. Qualifications: Must have experience working as a Technical Lead in the project. Must have at least 8-10 years of Informatica ETL development experience with good Oracle database background. Must have experience in Informatica Powerexchange and Powercenter. SQL, Shell scripting, UNIX/Linux commands Must be proficient in building data integration between systems/applications, building complex data aggregation, and transformation logic. MUST HAVE EXPERIENCE. Must be proficient in data analysis - MUST HAVE EXPERIENCE Must be good on data warehousing Must have very strong experience with CA7 scheduling tool Very strong programming and debugging skills.Reporting experience is highly recommended. Very strong communication skills Strong Documentation skills required Strong Banking Domain knowledge is good to have.
Created: 2024-11-16