informatica AdminQuestronix Corporation

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
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;
Work from Home
Entry Level / Junior, Apprentice IT and Software IT and Software 1 opening Bachelor's degree graduate
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.
Kalibrr

Makati City, Metro Manila
Permanent
Full-time