ETL Developer

• Responsible for designing, developing, testing and implementing modifications to our existing Data Warehouse and Data Mart ETL Loads and processing for the Data Services team.

• Modernize our development code for the future to migrate to AWS and Cloud tools and data structures (Snowflake/DBT)

• Maintains application code required to load & balance our data warehouse daily and serve as the source of truth for historical data for the enterprise.

• Participating in Business Requirements review, assistance with system specifications, development of technical specifications, development of code changes in Informatica Power Center as well as DBT Cloud, unit testing and implementation in production.

• Follow the defined Informatica development standards and best practices and attend code reviews to assure compliance.

• Implement code changes based on system specifications.

• Analyze problems and propose solutions.

• Work with DBA’s to implement database changes.

• Develop code changes using Informatica Power Center and DBT Cloud.

• Perform in-depth unit testing prior to promoting to QA.

• Responsible for supporting and taking direction from manager.

• Look for opportunities to enhance existing code & processes.

• Participation in System and User acceptance testing.

• Ability to performance tune internal and user queries and ETL loads.

• Production implementation, including all required documentation.

Bachelor’s degree in Computer Science, Computer Engineering or related field, Position requires a Bachelor’s degree in Computer Science, Computer Engineering or related field and five (5) years of progressive, post-baccalaureate experience in the job offered or in an ETL Developer-related occupation. Alternatively, employer will accept a Master’s degree in Computer Science, Computer Engineering or related field and three (3) years of experience in the job offered or in an ETL Developer-related occupation.

Position requires demonstrable experience with the following:

• Demonstrable experience with Informatica PowerCenter/IICS to develop & optimize mappings, workflows, and sessions.

• Demonstrable experience with SQL (Oracle/DB2) to perform queries, stored procedures, performance tuning, and SQL optimization for reporting.

• Demonstrable experience with Data Warehousing including Data Mart design, data quality checks/profiling.

• Demonstrable experience with Scripting including Unix & Python for automation.

• Demonstrable experience with Snowflake to perform migration planning, validation, performance tuning.

• Demonstrable experience with dbt supported POCs, translated Informatica logic into dbt models, and validation.

• Demonstrable experience with Version Control including Git & SVN for branching, merging, and release management.

• Demonstrable experience with Testing & Release Management including unit, system, UAT, and change control.

• Demonstrable experience with Informatica ETL support and ETL optimization to perform debugging and code changes.

• Demonstrable experience with SAP Business Objects Administration for users, security, Universe design, and Crystal reports.

• Demonstrable experience with System performance monitoring & tuning for BI/reporting environments, and UAT requirement gathering with functional teams.

• Demonstrable experience with Change management & production support for BI systems.

20% Telecommuting permitted.