Live chat
The Hartford Financial Services Group, Inc.

SSIS ETL Developer

The Hartford Financial Services Group, Inc. - Wayne, PA

SSIS ETL Developer','1800519','!*!Overview of the role: We are seeking an SSIS ETL Developer who will be responsible for analyzing source data against business requirements to design the most appropriate ETL solution. This role will also lead offshore developers through the implementation process to yield a highly efficient, scalable ETL processes. Additionally, the position will be responsible for supporting existing ETL processes as well as providing creative ideas to improve and optimize existing processes. Responsibilities of the role: • Design, develop and support data acquisition (ETL) processes in SQL Server Integration Services (SSIS) 2012 • Responsible for navigating large sets of data, complex ETLs, as well as data transfer and scheduling mechanisms • Develop detailed technical specifications and ETL documentation in collaboration with the data warehouse architect and business analysts • Provide expertise and leadership to offshore ETL developers. Supply requirements to offshore team and review solutions. Assist offshore team with testing, implementation and production support • Assist QA team to conduct appropriate functional and performance testing to identify and resolve process bottlenecks and data quality issues • Write Ad-hoc reports (T-SQL queries), complex stored procedures and functions to perform database tasks such as inserts, updates and deletes • Work with multiple team members across organization (onsite and offsite) in order to deliver and support ETL applications • Work on multiple projects and assignments simultaneously • Responsible for production support, including off hours and weekend 'on call' on a rotational basis. Work with offshore production support team to communicate incidents and statuses to management, business and other extended teams ','!*!• Bachelor’s Degree or equivalent experience • 5 years of SQL Server programming experience including SSIS, T-SQL, SSRS • Strong knowledge of SSIS development, T-SQL, Views, Stored Procedures, Functions and Triggers • ETL / data warehouse development, SSIS is key • Complex Data Mapping, Complex Data Transformation experience required • Any Agile experience a plus • Knowledge of physical database administration with SQL Server a plus • Excellent written and verbal communications skills required Candidates should have domain knowledge in at least one of the following areas: • Sales Analytics • Marketing Analytics • Accounting / Financial Services • Information Technology Should have experience with: • Data Warehousing Concepts • Star and Snowflake schemas • Writing technical documentation • ERwin • Software Development Life Cycle PREFERRED SKILLS/EXPERIENCE: • Knowledge of job schedulers and experience in developing batch and real time integrations (Flat Files, EDI, XML) is a plus • Knowledge of Data modeling concepts (e.g. Entity Relationship Diagrams) is a plus • XML/XSLT experience is a plus • Familiarity with ASP.NET, C# platform is a plus WHY JOIN HARTFORD FUNDS? Founded in 1996 and headquartered in Wayne, PA, Hartford Funds is a leading provider of mutual funds, strategic beta ETFs and 529 college savings plans. The company offers a broad range of strategies designed to provide solutions for a variety of investment needs. Hartford Funds has total assets under management of $95.6 billion as of September 30, 2017 (excluding assets used in certain annuity products). Hartford Funds are primarily sub-advised by Wellington Management or Schroder Investment Management, two leading investment advisors. At Hartford Funds, we believe in human-centric investing—a unique approach that utilizes deep research and insights to understand the rational and emotional ways investors think about money, their investments and their financial advisors, and then create solutions and advisor tools designed to serve those investors and their mindsets. Hartford Funds embraces a true entrepreneurial spirit where all employees are encouraged to ‘act like an owner’ of the firm, and live Hartford Funds’ human-centric investing approach. Employees work in a fast-paced, dynamic environment, that is focused on strengthening financial advisor-client relationships by helping investors better realize their true life goals. WHAT IS THE COMPENSATION OPPORTUNITY? At Hartford Funds, our compensation philosophy is simple: we pay competitive base salaries and reward performance. In addition, you will be eligible to participate in our comprehensive benefits program including Medical, Dental, Life and Disability Insurance, a 401K Plan, and more. This position may be subject to The Hartford Funds political contributions policy. Hartford Funds is an Equal Employment Opportunity and Affirmative Action Employer. Equal Opportunity Employer/Females/Minorities/Veterans/Disability/Sexual Orientation/Gender Identity or Expression Hartford Funds maintains a drug-free workplace. Committed to Building Inclusion and Leveraging Diversity ** NO AGENCIES PLEASE ** ','Application Development','United States-Pennsylvania-Wayne','','Full-time','Individual Contributor','Bachelor's Degree (±16 years)','Standard','Day Job','Regular','Exempt','Exempt','No','Feb 13, 2018','No','No','SSIS ETL Developer

11 days

The Hartford Financial Services Group, Inc.


SSIS ETL Developer The Hartford Financial Services Group, Inc. - Wayne, PA, United States


Location: Wayne, PA

Company Profile:
The Hartford is in business to protect what is most valuable to customers—their homes, cars, businesses, income, and employees. We help individuals and businesses prepare for the unforeseen with insurance and income protection so they can prevail through loss, accident, or disability.