Senior ETL Developer
4 days ago
Senior ETL Developer
Senior ETL DeveloperWho are we?
Versant Health is one of the nation's leading administrators of managed vision care, serving millions of our clients' members nationwide. We are driven by our mission to help members enjoy the wonders of sight through healthy eyes and vision.
As a Versant Health associate, you can enjoy a comprehensive Total Rewards package, which includes health and dental insurance, tuition reimbursement, 401(k) with company match, pet insurance, no-cost-to-you vision insurance for you and your qualified dependents. We are also invested in your success. There are many opportunities for advancement and development throughout all stages of your career with us.
See how you can make a difference with the support of strong leadership and a team environment.
See Everything, Be Anything.
What are we looking for?
Senior Informatica ETL Developer is primarily responsible for supporting ETL development using Informatica PowerCenter and IICS and support activities. Job assignments will include analyzing, designing, development, and delivery of data using Informatca ETL tool from operational systems and files into a staging area, operational data stores, data warehouse, data marts and files and developing ETL mapping, mapping documents and SQL queries. The Senior Informatica ETL Developer will also assist in the design, development
and implementation of the enterprise integration architecture and will provide ETL
expertise to other areas of the organization.
Where you will have an impact
- ETL developers are responsible for designing and creating the data warehouse and all related extraction, transformation and load of data functions in the company
- After development work completes, developers also must test their designs to ensure the system runs smoothly
- Developers must be experts at taking a big-picture view of a company's data situation
- Design, develop and maintain database objects such as the tables, views and stored procedures needed to support reporting and/or analytics solutions
- Analyze data to understand gaps, inconsistencies and other quality issues, and devise data quality improvement solutions
- Analyze and remedy database and query performance issues
- Developers need to be able to read, analyze and digest what a business wants to accomplish with its data, and design the best possible ETL process around those goals
- Work with business users and gathering data and reporting requirements.
- Work with business users and QA team with user-acceptance testing and issue resolution.
- Must be proficient with SQL Queries
- Needs to have greater understanding and experience of Data warehousing, data transformation, and business intelligence.
- Must have experience working with dimensional modeling
- Must have some experience in Python scripting
- Must be a team-player and willing to work under tight timeline
- Other duties as assigned
What's necessary to do the job?
- Bachelor's Degree in Computer Science, Computer Engineering,
- Information Systems or related field or equivalent relevant experience.
- 8 years of hands-on experience using Informatica Power center, IICS IDQ tools
- 3 years of experience in Python with data science libraries is plus
- Should have worked on complex reporting scenarios involving Multiple Tables, Loops, Contexts, Prompts, Aggregate Awareness, Derived Tables, Charts, Ranking, and Percentages etc.
- Solid Hands on experience in SQL programming and writing stored procedures, functions, views, SQL queries is required.
- Ability to quickly assess data structures and processes to interpret how business data sets relate to each other
- Strong desire to learn how things work and to apply that knowledge to problem resolution
HIPAA & Security Requirements
All Associates must comply with the Health Insurance Portability Accountability Act of 1996 (HIPAA) as it pertains to disclosures of protected health information (PHI) as described in the Notice of Privacy Practices and HIPAA Privacy Policies and Procedures. As a component of job roles and responsibilities, Associates may have access to covered information, cardholder data or other confidential customer information which must be protected at all times. As a result, Associates must explicitly adhere to all data security guidelines established within the Company's Privacy & Security Training Program.
Versant Health will never request money from candidates who seek employment with us and will never ask for any payment as part of the recruitment process.
Versant Health is a proud Equal Employment Opportunity and Affirmative Action employer dedicated to attracting, retaining, and developing a diverse and inclusive workforce. All qualified applicants will receive consideration for employment at Versant Health without regards to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity or expression, age, disability, national origin, marital or domestic/civil partnership status, genetic information, citizenship status, uniformed service member or veteran status, or any other characteristic protected by law.
The wage range for applicants for this position is [$125,000.00 to $130,000.00].
All incentives and benefits are subject to the applicable plan terms.
-
Senior Desktop Support Specialist
1 week ago
Troy, Michigan, United States Tokio Marine HCC Full time $60,000 - $100,000 per yearSenior Desktop Support Specialist and Network AdministratorIMPORTANT:We are only considering applicants who reside within a reasonable commuting distance of our Troy, Michigan office and are able to work a hybrid schedule three days in-office and two days remote. Additionally, applicants must not require, now or in the future, work sponsorship.Tokio Marine...
-
Development Engineer l
1 week ago
Troy, Michigan, United States BTI Solutions Full time $80,000 - $120,000 per yearWhy work with us?Proven people.Everyone on our team has earned a CPC (Certified Personnel Consultant) or CTS (Certified Temporary Staffing Specialist) accreditation from the National Association of Personnel Services. We are experts at staffing and recruiting with more than 16 years of experience serving employers.Proven process.Our approach to staffing...
-
Senior Gameplay Animator
6 days ago
Troy, Michigan, United States Velan Studios Full time $120,000 - $180,000 per yearAt Velan Studios, we foster a culture of curiosity. Our games embrace diversity and are fueled by the adventurous spirit of our team. We are the creative minds behind titles like Mario Kart Live: Home Circuit, Knockout City, Hot Wheels Rift Rally, Midnight Murder Club as well as the VR game Bounce Arcade, and our journey continues Our studio's mission is to...
-
Senior Director of Benefits
5 days ago
Troy, Michigan, United States Kelly Services Internal Full time $120,000 - $180,000 per yearTogether we change lives.Kelly is a team of experts driven by our belief that the impact of the right person in the right job is limitless.No matter where you are in your career journey you can apply your knowledge and passion to move people, organizations, and communities forward. You'll have opportunities to grow your expertise and capabilities, both...
-
NSNA Senior Manager of Finance
6 days ago
Troy, Michigan, United States N.S. International, Ltd Full time $105,000 - $145,000 per yearCompany OverviewThis role is categorized as a hybrid position, 2 days onsite / 3 days offsiteNippon Seiki is a world-class manufacturer of instruments for vehicles, agricultural, and construction equipment. Established in 1946, Nippon Seiki Co., Ltd. is headquartered in Japan, with numerous facilities worldwide. N.S. International, Ltd. ("NSI"), a group...
-
NSNA Senior Manager of Finance
1 week ago
Troy, Michigan, United States Nippon Seiki (Europe) B.V. Full time $120,000 - $180,000 per yearCompany OverviewNippon Seiki is a world-class manufacturer of instruments for vehicles, agricultural, and construction equipment. Established in 1946, Nippon Seiki Co., Ltd. is headquartered in Japan, with numerous facilities worldwide. N.S. International, Ltd. ("NSI"), a group company of Nippon Seiki, located in Troy, MI, is a tier one supplier of...
-
Senior Audit Associate
6 days ago
Troy, Michigan, United States Doeren Mayhew CPAs and Advisors Full time $85,000 - $170,000 per yearDoeren Mayhew is a $200 million tax, assurance and advisory firm headquartered in Troy, Michigan with 18 offices across the country and abroad. Founded in 1932, Doeren Mayhew is recognized as the 46th largest CPA firm in the U.S. and is positioned for successful future growth. If you want to join a rising firm that is consistently named among the 50...
-
Senior Field Service Technician
6 days ago
Troy, Michigan, United States Xylem Full time $40,000 - $70,000 per yearXylem is a Fortune 500 global water solutions company dedicated to advancing sustainable impact and empowering the people who make water work every day. As a leading water technology company with 23,000 employees operating in over 150 countries, Xylem is at the forefront of addressing the world's most critical water challenges. We invite passionate...
-
Senior Manager
1 week ago
Troy, Michigan, United States Aptiv Full time $120,000 - $180,000 per yearSenior Manager – Cybersecurity OperationsImportant Company Update – Please Read Before Applying . On January 22, 2025, Aptiv announced its decision to separate its EDS division to form two separate independent companies: to-separate-its-electrical-distribution-systems-business/This role is within the EDS segment, and you will be joining that segment as...
-
Troy, Michigan, United States American Marketing and Publishing Full time $60,000 - $70,000 per yearBuild a career with unlimited earning potential as you get paid to call, connect with, educate, and close sales to local business owners. Develop your sales skills and grow your income fast.Earn $60–$70K your first year with base pay, uncapped commissions, bonuses, and full benefits — top performers make even more. We provide paid training, a proven...
