Sr. Business Intelligence/ETL Developer

As part of the application process, a candidate account is required to log in and view application(s). Please be sure to check email regularly for information regarding our employment process.

If you're ready for your next challenge and want to be part of a cutting-edge Big Data team, this is the role for you. As a Sr. Business Intelligence/ETL Developer you will be working in one of the industry's largest and most complex data warehouse environments. This is an exciting opportunity for a skilled, experienced professional to join VOYA's Enterprise Architecture and Data Integration Team

The role will be a key resource for VOYA's Financial Data services team. He/She will support ETL, BI, Middleware design, transformation and movement between applications and databases.

* Architect/Develop ETL, Middleware/API, BI solutions to process/load source systems data into multiple databases and mainframe files using Informatica, Sync sort, Business Objects, Tableau.

* Hands on Lead ETL developer responsible for design and development of ETL components and provide support for maintenance and Enhancements.

* Hands on BI developer responsible for design and development of BI Reports, multidimensional cubes. Create Data design and provide support for maintenance and Enhancements using, Business Objects, Essbase/MSFT, Tableau and others.

* Convert Business requirements to Functional, Tech design and translate to specific development activities and communicate progress to management and project leads

* Follow Software SDLC process.

* ETL, Middleware, BI performance tuning, Implement Performance optimizations through multiple techniques.

* Support QA team's test cases and test data preparation. Carries out unit and Integration test support.

* Problem solving attitude.

* Proactively research and evaluate emerging and evolving technologies

* Deliver hands-on components to support strategic and project-centric prototyping, and solution prescriptions across emerging platforms

* Delivers the required documentation during each stage of the project.

Who is our ideal candidate?

* Bachelor degree in Computer Science, Mathematics, Science preferred or equivalent work experience.

* 8+ years progressive experience in system/data design, architect related to ETL, Middleware, BI data management, data integration and data delivery work.

* 5+ ETL experience using Informatica Power Center version 9.6 or higher

* 3+ BI OLAP, Report developing experience using Business objects, Essbase/MSFT Analysis cube Tableau or similar.

* 2+ Middleware/API experience in Java/Web methods or similar technologies

* Skilled in Informatica ETL tool suite to design and develop work flows, transformation mappings.

* Strong skills in BI , ETL design and development - understanding the tradeoffs of various design options on multiple platforms using multiple protocols

* Experience Code Deployment best practices

* Expertise in UNIX shell scripting

* Must have experience in two or more of the databases UDB, Sqlserver, Oracle, Exadata,

* Must have experience in one of the BI tools: Business objects, Tableau.

* Familiarity with Big Data platforms is a plus

* Familiarity with Hadoop and other components like Hive, Impala, Pig, Sqoop, Map-Reduce, Flume, H2O, Spark and Kafka and others is a plus

* Functional work in and familiarity with enterprise architecture, Data warehouse, data modeling concepts

* Solution design experience for large scale initiatives

* Excellent communication skills – need to be able to interface with business as well as technical leaders

* Successful in a matrix work environment

* Excellent documentation skills

* Ability to collaborate and work in a multi-site environment

* Experience working in an agile or continuous improvement environment

* Eagerness to learn new tools and technologies

* Prior experience with financial services, retirement, insurance, or medical records industry highly desirable

#LI-ND1

#CB

Critical Skills

At Voya, we have identified the following critical skills which are key to success in our culture:

* Customer Focused: Passionate drive to delight our customers and offer unique solutions that deliver on their expectations.

* Critical Thinking: Thoughtful process of analyzing data and problem solving data to reach a well-reasoned solution.

* Team Mentality: Partnering effectively to drive our culture and execute on our common goals.

* Business Acumen: Appreciation and understanding of the financial services industry in order to make sound business decisions.

* Learning Agility: Openness to new ways of thinking and acquiring new skills to retain a competitive advantage.

Learn more about Critical Skills.