Roles & Responsibilities:
- Informatica PowerCenter developer needed to develop and enhance ETLs from various sources to MSSQL database & Postgresql.
- Perform advanced ETL development activities using Informatica, MSSQL Database tuning, SQL tuning, Informatica Server. administration Create, maintain, and optimize stored procedures, functions, inline SQL, database structures, and ETL processes to adapt to changes in needs and requirements.
- MSSQL experience from the development perspective (database and application).
- Plans and conducts Informatica ETL unit and development tests.
- Uses standard data modeling, data flow, and data documentation tools to analyze, document and present data analysis work.
- Works cooperatively with others to resolve data and process issues.
- Works with non-technical, subject matter experts to understand underlying data behavior and characteristics in ways that will be new for such non-technical people.
- Responsible for developing and managing ETL configurable artifacts (code, environment, configuration files, documentation)
- Provide post-production application support as required
- Work as team lead or part of team to deliver the projects
- Follow established standards and best practices and provide input for improvement of those processes
Requirements And Qualifications
- Must have 4 years of ETL experience
- Current experience with Informatica PowerCenter v10.3+
- Experience with migration of Informatica PowerCenter to Informatica Intelligent Cloud is a plus
- Experience with Data Architecture and Data Modeling concepts Experience with performance tuning of sources, mappings, targets and sessions
- Excellent understanding of T-SQL programming
- Familiarity with Microsoft SQL Server
- Knowledge of git Source Control. and Knowledge of CI/CD pipelines or deployment automation tools.
- Ability to work with development and operations teams to tune production queries for optimal performance.
Kelly Vu
EA Licence Number: 23C2060
Registration ID is R1109308
Disclaimer: The company is committed to ensuring the privacy and security of your information. By submitting this form, you consent to the collection, processing, and retention of the information you provide. The data collected (which may include your contact details, educational background, work experience and skills) will be used solely for the purpose of evaluating your qualifications for the position you're applying for. Your data will be stored securely and retained for the duration necessary to fulfill our hiring process. If you are not selected for the position, your data will be kept on file for a limited period in case future opportunities arise. You have the right to access, correct, or delete your data at any time by contacting us at Quess Singapore | A Leading Staffing Services Provider in Singapore (quesscorp.sg)
