What are the responsibilities and job description for the Informatica Data Engineer position at SansuTek Inc.?
Job Summary
Seeking an experienced Informatica Data Engineer with 4 6 years of experience in data engineering, ETL development, advanced SQL, PL/SQL, and enterprise data warehousing. The engineer will develop and optimize scalable data pipelines supporting financial costing, customer profitability, and large-volume financial datasets.
Must-Have Skills
- Informatica PowerCenter and/or Informatica Cloud/IICS
- ETL Development
- Advanced SQL
- PL/SQL
- Data Engineering
- Large-Scale Data Transformations
- Data Warehousing
- Oracle, SQL Server, or Teradata
- Data Pipeline Performance Optimization
- Agile/Scrum
- Experience working with finance and business stakeholders
- 4 6 years of relevant experience
Nice-to-Have Skills
- UDeploy
- Artifactory
- AWS, Azure, or Google Cloud Platform
- Financial Services or Banking Experience
- Activity-Based Costing
- Customer Profitability Systems
- Financial and Cost Data Experience
Key Responsibilities
- Design, develop, and optimize ETL pipelines using Informatica, SQL, and PL/SQL.
- Process and transform large-scale financial datasets.
- Build efficient, scalable, and high-performing data solutions.
- Work with finance product owners and analysts to gather requirements.
- Design data solutions for costing and customer profitability applications.
- Develop technical specifications and procedural documentation.
- Perform hands-on coding, testing, and troubleshooting.
- Participate in code reviews and data validation.
- Improve ETL performance using partitioning, indexing, pushdown optimization, and related techniques.
- Mentor junior engineers and contribute to team development.
Soft Skills
- Strong verbal and written communication
- Excellent problem-solving skills
- Strong ownership and accountability
- Stakeholder management
- Collaboration and teamwork
- Ability to communicate with technical and non-technical audiences