Programmer/Analyst - ETL (77443)

This role will be responsible for the design, development, evaluation, and optimization of programs for functional areas, including but not limited to sales, finance and marketing. Responsibilities include analyzing existing programs or formulating logic for new systems, devising logic procedures, preparing flowcharts, coding, and testing programs. Job Requirements Essentials: • 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 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 • Design, develop and maintain Snowflake database objects (tables, views, stored procedures, etc.) and SQL scripts. • Participate in code reviews and ensure that all solutions are aligned to pre-defined architectural and requirement specifications • Provide L2 and L3 support of ETL processes to ensure timely completion and availability of data in data warehouse for reporting use. Analyzes and resolves problems and provides technical assistance as is necessary. Implements corrective actions • May prepare or review product documentation, written instructions or technical literature for accuracy and completeness • Data Quality management • Maintenance of business rules associated with data integration • Participate in the fulfillment of ad-hoc data requests from internal business owners

Participate in design reviews and provide input to the design recommendations; provide input to information/data flow, understand, and comply with Project Life Cycle Methodology in all planning steps.