Sr. Business Intelligence / ETL Developer

Voya Financial   •  

Windsor, CT

Industry: Accounting, Finance & Insurance


8 - 10 years

Posted 156 days ago

This job is no longer available.

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