Senior Software Engineer (Informatica)

JOBLINE RESOURCES PTE. LTD.; Singapore; On-site; SGD 100,000 - 125,000; Full time

Job summary

A recruitment agency in Singapore is seeking a Data Integration Specialist to design and implement ETL processes for migrating applications to the AWS Cloud. The ideal candidate has a degree in computer science or engineering, along with 3-5 years of experience with Informatica PowerCenter and AWS Glue. Responsibilities include developing data integration solutions, optimizing ETL processes, and collaborating with teams. This role offers a 1-year agency contract employment.

Qualifications

• 3-5 years of experience using Informatica PowerCenter for data integration.
• Strong understanding of relational database concepts and performance tuning.
• Experience in creating ETL jobs using AWS Glue and managing ETL mappings.

Responsibilities

• Design and implement integration solutions for applications migrating to AWS.
• Develop ETL processes to extract, transform, and load data from various sources.
• Collaborate with teams to understand business requirements and execute migration plans.

Skills

Informatica PowerCenter tools

SQL querying and manipulation

Data transformation design and development

ETL process optimization

Python with PySpark

AWS Glue Studio

AWS services (S3, Redshift, RDS, Lambda)

Education

Degree in Computer Science or Computer Engineering

Tools

Informatica Designer

Informatica Workflow Manager

Informatica Repository Manager

AWS CodePipeline

Job description

Responsibilities

• Design, develop, and implement integration solutions for applications migrating to the AWS Cloud platform.
• Design and develop ETL processes to extract data from various sources (e.g., databases, flat files, APIs), transform as per business requirements and load it in to data warehouse or other data storage systems.
• Integrate data from multiple heterogeneous sources and ensure it is transformed and loaded correctly into the target system, maintaining data quality and integrity.
• Write complex SQL queries and use transform logic to clean, aggregate, and transform data as per business requirements.
• Ensure ETL processes are optimized for performance, scalability and reliability.
• Implement data validation rules and perform data quality checks to ensure accuracy and completeness of data.
• Troubleshooting and resolve issues related to data integration, loading failures, and performance bottlenecks in the ETL process.
• Document ETL workflows, processes, logic and prepare reports as needed.
• Prepare detailed migration plans, timelines, and risk mitigation strategies.
• Collaborate with cross-functional teams to understand business requirements and implement effective integration strategies.
• Work closely with the migration team to execute the migration of applications to the AWS Cloud.
• Conduct thorough testing to ensure functionality, performance, and data accuracy.
• Provide documentation for troubleshooting and support purposes.

Requirements

• Degree in Computer Science, Computer Engineering or equivalent with 3-5 years of experience in using Informatica PowerCenter tools for data integration and ETL processes.
• Knowledge of Informatica Designer, Workflow Manager, and Repository Manager.
• Experience with creating and managing ETL mappings, sessions, and workflows.
• Proficiency in designing and developing data transformations.
• Strong SQL skills for database querying and manipulation.
• Understanding of relational database concepts and performance tuning. and also familiarity with data warehousing concepts, star schema, snowflake schema, and data marts.
• Ability to optimize ETL processes for performance and efficiency.Understanding of AWS Glue components like Crawlers, Jobs, Triggers, and Data Catalog.
• Experience in creating and managing ETL jobs using AWS Glue Studio.
• Proficiency in Python, especially with PySpark, for writing ETL scripts in AWS Glue.
• Familiarity with other AWS services like S3, Redshift, RDS, and Lambda for integration with AWS Glue.
• Understanding of IAM roles and permissions for secure access to AWS services.
• Skills in planning and executing data migration from Informatica to AWS Glue.
• Ability to translate Informatica workflows and mappings into AWS Glue jobs.
• Experience with AWS CodePipeline or similar tools for automating deployment and integration processes.

Shortlisted candidate will be offered a 1 Year agency contract employment.

License No : 12C6060