- 3-7 years ETL design, development - experience in Informatica preferred
- Experience in Database development using DB2, SQL Server & Snowflake/RedShift
- Exposure to Data Warehousing a plus
- Experience using a software development life cycle (SDLC) methodology
- Analytical, problem solving and testing skills.
- Effective oral & written communication skills
- Ability to multi-task
- Attention to detail and quality
- Must be a team player
- Knowledge of Jira and AWS components & tools
- Desire to Learn and Grow
- Scripting Tools (ie.Python)
- Experience is using API’s
- Data Modeling Principles
Duties and Responsibilities
Specific responsibilities include:
- Ability to 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 Informatica 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.
- Ability to provide effort and duration estimates
Other highly valued skills would include:
- Knowledge of the Property and Casualty Insurance industry is a plus
- Stored Procedures/Unix/Perl script knowledge is a plus
- Knowledge of balancing and Control and the importance of implementing them.
- Ability to develop Metrics and Visualizations is a plus