GDH Consulting has an enterprise client needing an ETL Informatica Developer.The preferred timezone is PST.This is a 100% remote role.
JOB SUMMARY: Designs and develops computer programs and monitors the work of junior staff to ensure accuracy of program logic and efficient use of computer resources; performs preliminary evaluation of packaged software; conducts system studies, analyzes and evaluates existing manual and computerized systems / procedures to improve efficiency, develops techniques for automating processes as appropriate; conducts Rough Order of Magnitude on application enhancements; determines the need for system security, backup/recovery, data conversion, etc. and makes recommendations; manages system development projects and supports the implementation activities and training, as required; works with business and responds to Production Support issues as necessary.
Work under the direction of Software Engineering Manager/Project Technical Lead on the successful delivery of multiple ETL related projects and processes. Independently manage development of ETL processes - development to delivery. Interface with Business and Business Analysts to understand functional requirements. Translate requirements into technical specifications for ETL development; develop source-to-target mappings and actively work with Development, Test and Implementation efforts. Review design, code and migration objects for smooth project delivery.
JOB RESPONSIBILITES AND REQUIREMENTS:
Codes instructions for computer programs/objects/components; configures packaged software; tests and implements all changes to ensure they meet specifications.
Documents and implements programs according to installation standards and conventions.
Quality checks program code, related objects and documentation.
Responds to Production Support issues.
Works with business as required.
Analyzes programs to ensure that they efficiently use computer and storage resources; recommends appropriate changes as necessary.
Conducts preliminary estimates / Rough Order of Magnitude for the level of effort of new/change to application functionality.
Analyzes and makes recommendations for the need for system backup, security, restart/recovery, balancing & controls; recommends approaches for meeting such needs.
Analyzes and documents the requirements and approaches to data conversion and data modeling.
Conducts system studies, analyzes existing computerized and manual processes to improve efficiency; researches and develops techniques for automation, as approved.
Monitors the work of junior staff to ensure efficiency, and compliance with specification.
Designs and develops documentation of proposed procedures and systems.
Performs preliminary evaluation of packaged software.
Manages and controls system development projects.
Supports implementation/training activities; troubleshoots system environmental issues, as required.
Production Support: Support of Operations Team with data manipulation and ad-hoc reporting. Work with IT team and end-users to help troubleshoot problems. Participate in on-call rotation and respond to critical ETL incidents. After-hours support for application release and change management activities.
Level III: Four (4) years of experience in application development
Five (5) plus years of experience in developing data integrations and ETL with Informatica Power Center.
Experience with Informatica Power Center 10.x, Power Exchange 10.1, Information Analyst, Metadata Manager, Informatica MDM
Good in Customer Master Data Management Experience.
Knowledge of DevOps CI/CD would be a plus.
MDM or ETL implementation experience is important.
Strong expertise with advanced SQL on Oracle/DB2/Microsoft SQL Server.
Experienced in effective management of multiple competing and frequently changing assignments and priorities.
Strong analytical skills (able to read/write complex SQL queries to analyze data, investigate defects, validate data quality, etc.)
Experienced with agile project methodologies.
Strong understanding of data warehousing basics and concepts.
Exposure to Data modeling - dimensional and relational modeling.
Interested candidates please send resume in Word format to Please reference job code 87134 when responding to this ad.
GDH Consulting, Inc. provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, genetic information, veterans status or any other category protected by law. In addition to federal law requirements, GDH Consulting, Inc. complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities and/or employees. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, benefits and training.