ETL Informatica Lead

Dice is the leading career destination for tech experts at every stage of their careers. Our client, Avance Consulting, is seeking the following. Apply via Dice today!

We are seeking an experienced ETL Informatica Lead to join our team on a contract basis in Branchville, United States. In this role, you will be responsible for leading the development and implementation of enterprise data integration solutions using Informatica Power Center.

• Design, develop, and implement complex ETL processes using Informatica Power Center.
• Lead a team of developers in the development and implementation of ETL solutions.
• Collaborate with cross-functional teams to identify business requirements and develop solutions that meet those needs.
• Develop and maintain technical documentation for ETL processes and solutions.
• Troubleshoot and resolve complex ETL issues and errors.
• Stay up-to-date with industry trends and advancements in data integration and ETL.
• Communicate effectively with stakeholders to understand and meet their needs.
• Ensure all ETL solutions meet quality and security standards.
• Provide training and support to team members on ETL best practices and Informatica Power Center.
• Develop and implement processes to ensure data quality and integrity.

• 5+ years of experience in ETL development and implementation using Informatica Power Center.
• 3+ years of experience in a leadership role, leading teams of developers in ETL solutions.
• Proven experience in designing and developing complex ETL processes and solutions.
• Excellent understanding of data integration, ETL, and data warehousing concepts.
• Strong analytical and problem-solving skills.
• Excellent communication and interpersonal skills.
• Ability to work in a fast-paced environment and prioritize tasks effectively.
• Experience with data quality and integrity processes.
• Experience with Informatica Power Center 10.x and later versions.
• Experience with Windows, Unix, or Linux operating systems.

• Informatica Power Center 10.x and later versions.
• Oracle, SQL Server, and Teradata databases.
• Windows, Unix, and Linux operating systems.
• Agile development methodologies.
• Version control systems such as Git.
• Database administration and maintenance.
• ETL testing and validation.
• Data quality and integrity processes.
• Project management tools such as Jira and Asana.
• Strong understanding of data modeling and architecture.

• Master's degree in Computer Science, Information Systems, or related field.
• Experience with cloud-based ETL solutions such as Informatica Cloud.
• Experience with big data technologies such as Hadoop and Spark.
• Experience with data visualization tools such as Tableau.
• Experience with continuous integration and continuous deployment.
• Experience with Dev Ops practices.