About the Role
The selected candidate will be responsible for developing and managing ETL processes using Informatica PowerCenter, ensuring data accuracy, performance, and integration across multiple systems.
Responsibilities
- Design and implement ETL workflows using Informatica PowerCenter
- Extract, transform, and load data from various source systems
- Collaborate with data architects and analysts to define data requirements
- Optimize ETL performance and troubleshoot data issues
- Ensure data consistency, integrity, and security during transfers
- Develop mappings, sessions, and workflows for data integration
- Support data warehouse development and maintenance
- Validate data through testing and quality assurance procedures
- Document ETL processes and system configurations
- Work with relational databases and large datasets
- Participate in project planning and technical design sessions
- Maintain version control for ETL artifacts
- Support production deployments and post-release monitoring
- Respond to data-related incidents and service requests
- Integrate data from legacy and modern platforms
- Use SQL for data analysis and query development
- Follow data governance and compliance standards
- Assist in migration of data systems when required
- Provide technical guidance to junior team members
- Stay current with ETL and data integration best practices
Compensation
Competitive salary based on experience
Work Arrangement
Hybrid work model available
Team
Collaborative team environment focused on data integration
Technology Stack
- Informatica PowerCenter
- Oracle Database
- Microsoft SQL Server
- UNIX/Linux environments
- SQL Developer
- Git or similar version control
- Cloud platforms (AWS, Azure, or GCP)
Project Environment
- Agile development methodology
- Cross-functional team collaboration
- Regular code reviews
- Continuous integration practices
- Data security and compliance protocols
Sponsorship available for qualified candidates
