Questronix Corporation
Questronix Corporation

Informatica Admin  

Questronix Corporation

  • Makati, Philippines
    178 Yakal St. Brgy. San Antonio, Makati, Metro Manila, Philippines
    Metro Manila
  • Full timeFULL_TIME

Expired 3 months ago

Job closed.

Job Description

  • Design, develop and maintain Informatica cloud data integration processes using the appropriate data load technique, including Push-Down Optimization for performance optimization
  • Analyzes the impact of changes on existing ETL/ELT processes and systems. Assesses the compatibility with goals in all areas. Analyzes cost effectiveness and feasibility
  • Debug and tune data integration processes; analyze data warehouse architecture, normalized/de-normalized, star schemas and snowflakes, slowly changing dimensions, dimensional surrogate key handling, exception data processing, troubleshoot and recommend improvements and alternate methodologies
  • Requirement analysis for Data Integration, Design ETL documents and develop jobs as per the requirement
  • Design the incremental and historical load strategy
  • Ensure adherence to client standard policies and quality compliance enterprise metadata definition
  • Participate in Framework design, building solution, issue clarification, unit test cases preparation and testing
  • Update JIRA at the user story level every day and drive it to completion
  • Resolve all the technical impediments like requirement dependency, data dependency environments, UAT QA support
  • Create impact analysis document for simple change to understand the impact on the existing functionality as required

Minimum Qualifications

  • Strong analytical and planning skills;
  • Good communication and presentation skills;
  • Excellent problem-solving skills;
  • Strong skills and robust experience in Informatica Intelligent Cloud Services (IICS), Informatica Power Center and SQL;
  • Azure SQL Data Warehouse experience;
  • Data migration to Microsoft Azure; prior experience and expertise with this platform will be an advantage;
  • Working knowledge on scheduling tools like AutoSys & Control-M is preferred;

  • Knowledge of PL/SQL, SQL and hands on of Unix commands and Shell Scripting;

  • Knowledge of SQL tuning including the ability to write stored procedures triggers functions;

  • Knowledge of relational and dimensional database structures theories principles and practices;

  • Knowledge on data model to develop Dimension and Fact mappings jobs;

Perks and Benefits

  • Work from HomeWork from Home

Jobs Summary

Job Level
Entry Level / Junior, Apprentice
Job Category
IT and Software
Educational Requirement
Bachelor's degree graduate
Office Address
178 Yakal St. Brgy. San Antonio
IT and Software
1 opening

Feel secure when applying: look for the verified icon and always do your research on a company. Avoid and report situations when employers require payment or work without compensation as part of their application process.

About Questronix Corporation

Founded in 1987, Questronix Corporation has grown to be one of the largest IT solution provider and systems integrator in the Philippines. We offer best of breed solutions from IT infrastructure to business applications, built on world class technology companies and supported by our certified technical team with proven Filipino expertise and skills available in the country today. In 1990, Questronix was appointed by IBM as its first business partner for IBM UNIX platform and the company evolved in providing end-to-end solutions that run on IBM technology. After a decade of investment, skills and commitment in working with IBM, Questronix was awarded the Premier Business Partner status, making our company the first Business Partner in the country to be elevated to this exclusive circle. Our methodology on selecting our technology partners and implementation team for our services ecosystem allows us to deliver consulting-led systems integration focused on open standards, interoperability and proven best practices that result in higher project success rates. Today, Questronix’s solutions suite include Data Center & IT infrastructure, IT Service Management, Security, Business Continuity, Hybrid Cloud Solutions, Mobility Solutions, Enterprise Resource Planning, Business Analytics, Enterprise Asset Management, Enterprise Content Management, Information and Data Management, Business Process Management and Industry Specific Solutions. Approaching its 34th year in business, Questronix Corporation continuously strives to improve and evolve coupled by its enduring drive to deliver Filipino excellence and workmanship to its clients. As such, it has earned prestigious awards and recognitions – a proud testimony to its achievements that have firmly etched its name in the IT corporate landscape.

People also applied to

  1. Home

Other Recommended Jobs

Apply jobs in

Job Categories:

Related to your search: