Job role
we are seeking an experienced and skilled business intelligence professional to join our team as a powercenter specialist. Your primary role will be designing, developing, and maintaining etl processes to efficiently extract, transform, and load data from various sources into our centralized repository.
* etl development: design and develop etl processes using informatica powercenter to extract, transform, and load data into our central repository.
* data consolidation: work with multiple data sources, including databases, applications, flat files, and external apis, to consolidate data for reporting and analysis purposes.
* quality assurance: implement quality checks and measures to ensure data accuracy and integrity throughout the etl process.
* process optimization: continuously optimize etl processes for improved efficiency and reduced data processing times.
* data modeling: collaborate with the data modeling team to create and maintain data models that support business needs.
* collaboration: partner with business analysts, stakeholders, and cross-functional teams to understand and address their data requirements.
* documentation: maintain comprehensive documentation of etl processes, data mappings, and data lineage.
* monitoring and resolution: proactively monitor etl job executions and troubleshoot any issues or errors that arise.
requirements
* bachelor's degree in computer science, information systems, or a related field.
* strong sql skills and knowledge of relational databases.
* data modeling expertise and understanding of data warehousing best practices.
* proficiency in data quality assurance and data profiling.
* excellent problem-solving and analytical skills.
* strong communication and collaboration skills.
* powercenter certification (preferred but not required).
benefits
as a business intelligence professional with informatica powercenter experience, you will have the opportunity to work on complex projects, collaborate with cross-functional teams, and contribute to the growth and development of our organization.