AustinRecruiter Since 2001
the smart solution for Austin jobs

ETL / Data Warehouse Developer

Company: New York Life
Location: Austin
Posted on: April 6, 2021

Job Description:

A career at New York Life offers many opportunities. To be part of a growing and successful business. To reach your full potential, whatever your specialty. Above all, to make a difference in the world by helping people achieve financial security. It's a career journey you can be proud of, and you'll find plenty of support along the way. Our development programs range from skill-building to management training, and we value our diverse and inclusive workplace where all voices can be heard. Recognized as one of Fortune's World's Most Admired Companies, New York Life is committed to improving local communities through a culture of employee giving and service, supported by our Foundation. It all adds up to a rewarding career at a company where doing right by our customers is part of who we are, as a mutual company without outside shareholders. We invite you to bring your talents to New York Life, so we can continue to help families and businesses "Be Good At Life." To learn more, please visit LinkedIn, our Newsroom and the Careers page of www.NewYorkLife.com. General Overview: The primary job function is to develop, test, tune, and maintain database software applications in support of the achievement of business requirements. The position is expected to develop both data warehouse and ETL artifacts based on a defined architecture. This would include database tables, views, stored procedures, etc., and SSIS packages. This role is also expected to meet with their business counterparts to discuss requirements and understand their needs to provide recommendations on a solution to support the requirements. Primary Responsibility: * Contributes to the development and executes to deliver a future state architecture that transforms our current technology landscape to service oriented decoupling presentation layers and business logic from systems of record.* Provide technical expertise and recommendations in analyzing customer needs, document requirements, and design technical solutions.* Contributes to solution design discussions* Supports application teams in utilizing the integration layer effectively to facilitate speed to delivery of business capabilities* Create SSIS packages to import/export data, and load and process data.* Prepare data for job runs. Support jobs in process. Troubleshoot, analyze and repair job issues.* Develop and enhance stored procedures. Write ad-hoc SQL queries to support report requests.* Create test plans, test cases, test scripts and perform data testing and validation.* Experience creating technical design documentation.* Excellent work ethics, self-motivated, quick learner, and team oriented. Experience: * A minimum of 3 years of data warehouse / ETL development experience.* Experience in a BI/Data Warehouse environment with involvement in design and architecture.* Experience developing ETL solutions utilizing SSIS including Requirement Gathering, Analysis, Design, Development and Implementation of Enterprise solutions.* Experience in Performance Tuning and Query Optimization by Indexing, Partitioning and Denormalization.* Experience working in a highly collaborative environment, proactively innovating solutions that support the goals and desired outcomes that provide business value Skills: * Excellent Programming experience in writing Complex Stored Procedures, Queries, Views, User Defined Functions, Cursors and Common Table Expressions using T-SQL.* Expert in creating tables, indexes, keys, constraints and triggers to facilitate efficient data manipulation, integration and consistency.* Excellent understanding of Entity-Relationship/Multidimensional Data Modeling (Star schema, Snowflake schema), Data Warehouse Life Cycle and SQL Server Analysis Services (SSAS).* Worked on Design, Development, Deployment & Maintenance of ETL process using SSIS to Extract, Transform and Load (ETL) data from various sources (Flat/XML/SQL/Oracle) to different targets (SQL/HDFS).* Excellent written and oral communications* Excellent listening and interpersonal skills* Ability to build and maintain exceptional working relationships in a diverse environment* Highly self-motivated and directed with ability to facilitate or independently research application issues* Proven ability to work in a team-oriented environment* Possess high level of organizational skill and keen attention to detail Education - Degrees/Certificates * Bachelor's degree in an engineering, computer science, or related discipline. SF:LI-KV1 EOE M/F/D/V If you have difficulty using or interacting with any portions of this Web site due to incompatibility with an Assistive Technology, if you need the information in an alternative format, or if you have suggestions on how we can make this site more accessible, please contact us at: (212) 576-5811. Job Requisition ID: 83196

Keywords: New York Life, Austin , ETL / Data Warehouse Developer, IT / Software / Systems , Austin, Texas

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other IT / Software / Systems Jobs


Mainframe System Programmer
Description: About AltranAltran is the world leader in engineering and R D services. We offer our clients a unique value proposition to meet their transformation and innovation challenges. We support our clients, (more...)
Company: Altran
Location: Austin
Posted on: 04/12/2021

Backend Java Developer (W2)
Description: Title: Backend Java DeveloperLocation:--Austin TX Remote till covid Duration: 6 months possible extensionMust have skills:10 yrs experience Core Java / Rest services / SOAP / SQL / Agile / Bachelors (more...)
Company: Collabera
Location: Austin
Posted on: 04/12/2021

Computer Systems Architect (Johnson City)
Description: The professionals at the National Security Agency NSA have one common goal: to protect our nation. The mission requires a strong offense and a steadfast defense. The offense collects, processes and (more...)
Company: National Security Agency
Location: Johnson City
Posted on: 04/12/2021


Senior Network Performance Architect
Description: Senior Network Performance ArchitectLocation: Austin, TXContract type: PermanentRate: Competitive with bonus, benefits and cash awards br Your new companyArm technology is at the heart of a computing (more...)
Company: Arm
Location: Austin
Posted on: 04/12/2021

Software Development Intern (Summer 2021)
Description: University of Texas students only br br RF Code develops software and sensor networks that provide world-class environmental monitoring and data center operational management solutions for hundreds (more...)
Company: RF Code
Location: Austin
Posted on: 04/12/2021

Software Engineer (REMOTE)
Description: Temporarily REMOTE DUE TO COVID-- WILL BE IN OFFICE. South Austin Area br ---The ideal candidate will be responsible for developing high-quality applications. They will develop, create, test,
Company: Olson Resources
Location: Austin
Posted on: 04/12/2021

Remote Principal Software Architect
Description: Join the leaders of pay-over-time payment plans in healthcare br br This Jobot Job is hosted by Conner Ferguson br Are you a fit Easy Apply now by clicking the Apply button and sending us your (more...)
Company: Jobot
Location: Austin
Posted on: 04/12/2021

Sr. Software Engineer, OS Design
Description: Build the future of home entertainment now. Roku is changing how the world watches TV Roku is the 1 TV streaming platform in the US, and we've set our sights on powering every television in the world. (more...)
Company: Roku
Location: Austin
Posted on: 04/12/2021

Sr. Team Manager-Software Development and Engineering
Description: Your Opportunity Schwab is looking for a Sr. Manager who will be responsible to lead software development team s creating the future of Online Security, Risk and Fraud, and Integration technologies. (more...)
Company: Charles Schwab & Co., Inc.
Location: Austin
Posted on: 04/12/2021

Senior Web Developer
Description: POSITION OVERVIEW br Senior Web Developer - Remote ul li Angular Experience Required li Must reside in one of the following states Texas, Virginia, Maryland, Pennsylvania, Georgia, or Washington, (more...)
Company: Artemis Consulting, Inc.
Location: Austin
Posted on: 04/12/2021

Log In or Create An Account

Get the latest Texas jobs by following @recnetTX on Twitter!

Austin RSS job feeds