Sr. Informatica Developer

7 months ago


WinstonSalem, United States Herbalife-International-of-America Full time

Overview

POSITION SUMMARY STATEMENT:

The Sr. Informatica Developer (with Snowflake) / Sr. Data Engineer role is responsible for data modelling, design, optimization, security and administration of ETL/ELT tools and data engineering interfaces. The role will be responsible for building data interfaces focusing on data accuracy, completeness and availability. The role will analyze source and target systems design, build and test solutions to make data available Business intelligence systems, websites mobile apps and other applications.

DETAILED RESPONSIBILITIES/DUTIES:

Level III


• Design, Build, Test and migrate ETL/ELT systems and data interfaces
• Analyze and design source and target systems data architectures
• Design and implement data tables, functions, views, procedures and routines to deliver accurate and complete data to BI and data applications.
• Identify opportunities for technical innovation that make valuable contributions to the platform.
• Assist in establishing and embedding data management and governance processes.
• Enhance performance in the Applications environment. 
• Meet service level agreements for production support response and resolution.
• Research, Design and Develop technical solutions to a pre-defined requirement and develop components including extensions, views, customizations, modifications, reports, and workflows independently or as a part of a team.
• Follow documentation, software development methodology, version control and testing, and migration standards.
• Develop and improve the current data architecture, emphasizing data security, data quality and timeliness, scalability, and extensibility.
• Provide technical guidance and mentoring to others in areas of expertise.
• Deploy and use various technologies and run pilots to design low latency data architectures at scale
• Collaborate with BI teams, business analysts, product managers, and application teams to provide data for BI, web, mobile applications
• Collaborate with business analysts, data scientists, product managers, and BI teams to develop, implement, and validate KPIs, statistical analyses, data profiling, prediction, forecasting, clustering.
• Develops a collaborative environment that champions knowledge sharing.
 

Qualifications

QUALIFICATIONS:

Skills Required:


• Expert proficiency in building data pipelines and ETL/ELT using tools such as Informatica, ODI, Azure Data Factory etc. 
• Experience in administration and migration activities of data movement and transformation tools. 
• Expert knowledge in advanced SQL, stored procedures, views, functions, indexes etc.
• Expert knowledge of Entity Relationship Diagrams and data modeling techniques (type 1,2,3,4), dimensions, facts and aggregations. 
• Proficiency in relational and non-relational databases such as OLTP, MPP appliances, NoSQL, DaaS, Cloud etc.
• Proficiency in data movement techniques such as replication, switching, pipelines etc.
• Proficiency in data integrity, profiling and storage and mining techniques.
• Proficiency in change data capture techniques including timestamp, log and trigger-based mechanisms.
• Proficiency in working with different types of large and small sets of data; structured, semi structured and unstructured.
• Proficiency in working with scheduling tools.
• Proficiency in working with change management tools and processes include source control, versioning, defect tracking and release management.
• Proficiency in analyzing impact of smaller and large-scale initiatives. 
• Good working knowledge of Unix/Linux/PowerShell scripting.
• Ability to handle multiple priorities.
• Excellent written and verbal communication skills.

Experience Required:

Level III


• 5+ year’s experience in working with data in a data mart, warehousing, OLTP environment. 
• 5+ year’s experience working with ETL/ELT and data movement tools.

• Hands-on development experience with Snowflake features such as Snow SQL, Snow Pipe, Time travel, Zero Copy Cloning, Optimizer, Metadata Manager, and stored procedures
• Exposure to Python, Snow park, Snowflake Tasks, Streams, and data sharing 

Education Required: 


• Bachelor’s Degree in information technology, computer science or related field

#LI-JH1

US Benefits Statement

Herbalife offers a variety of benefits to eligible employees in the . (limited to the 50 States and the District of Columbia), which includes Group Health Programs, other Voluntary Benefit Programs, and Paid Time Off. Group Health Programs include Medical, Dental, Vision, Health Savings Account (HSA), Flexible Spending Accounts (FSA), Basic Life/AD&D; Short-Term and Long-Term Disability, and an Employee Assistance Program (EAP). Other Voluntary Benefit Programs include a 401(k) plan, Wellness Incentive Program, Employee Stock Purchase Plan (ESPP), Supplemental Life/Critical Illness/Hospitalization/Accident Insurance, and Pet Insurance. Paid time off includes Company-observed . Holidays, Floating Holidays, Vacation, Sick Time, a Volunteer Program, Paid Maternity and Paternity Leave, Bereavement Leave, Personal Leave and time off for voting.

  • Winston-Salem, United States Sparks Group Full time

    Job DescriptionJob DescriptionJob Summary/Company:Sparks Group in partnership with a financial services company is seeking a Senior Developer, Strategic Product Engineering. As the Sr Developer, you will be responsible for enhancing and maintaining specific applications as well as supporting the migration to Cloud based computing. The ideal candidate will...


  • Winston-Salem, United States Sparks Group Full time

    Job DescriptionJob DescriptionJob Summary/Company:Sparks Group in partnership with a financial services company is seeking a Senior Developer, Strategic Product Engineering. As the Sr Developer, you will be responsible for enhancing and maintaining specific applications as well as supporting the migration to Cloud based computing. The ideal candidate will...


  • Winston-Salem, United States Rizing Consumer Industries Full time

    We are seeking a very talented and experienced SAP IS-Retail and S/4 Fashion Sr. Consultant!At Rizing Consumer Industries, we are continuing to build our SAP consulting team and actively recruiting SAP Functional Consultants, preferably with experience in Retail and/or Fashion (FMS) solutions for S/4 HANA projects. If you are looking for an opportunity to...


  • Winston-Salem, United States Rizing Consumer Industries Full time

    We are seeking a very talented and experienced SAP IS-Retail and S/4 Fashion Sr. Consultant!At Rizing Consumer Industries, we are continuing to build our SAP consulting team and actively recruiting SAP Functional Consultants, preferably with experience in Retail and/or Fashion (FMS) solutions for S/4 HANA projects. If you are looking for an opportunity to...


  • Winston-Salem, North Carolina, United States Saxon Global Full time

    Job SummarySr. IBM BPM/Integration Designer Architect/Developer will play a key role in the analysis, design, configuration, upgrade, and implementation of complex business processes using IBM Business Process Manager Version 8.6.ResponsibilitiesAnalyze, design, and implement business processes using business process modeling tools.Creation of custom user...


  • Salem, Oregon, United States BECU Full time

    Company OverviewBECU is a leading financial services cooperative that prioritizes people helping people. With over 80 years of experience, we have grown to serve more than 1.3 million members and manage over $30 billion in assets. Our mission remains the same: to work together to best serve our members and improve their financial well-being.SalaryThe...


  • Winston-Salem, United States Raytheon Technologies Full time

    Date Posted: 2024-09-13 Country: United States of America Location: HNC31: US095-Winston-Salem (Fairchild 1455 Fairchild Road , Winston-Salem, NC, 27105 USA Position Role Type: Onsite Collins Aerospace is hiring for a Sr Analyst, Customer Service . This role is onsite in Winston-Salem, NC. What You Will Do: Works to solve the daily issues...


  • winston-salem, United States Rizing Consumer Industries Full time

    We are seeking a very talented and experienced SAP IS-Retail and S/4 Fashion Sr. Consultant!At Rizing Consumer Industries, we are continuing to build our SAP consulting team and actively recruiting SAP Functional Consultants, preferably with experience in Retail and/or Fashion (FMS) solutions for S/4 HANA projects. If you are looking for an opportunity to...


  • Winston Salem, United States Cognizant Full time

    Why choose cognizant? It takes a lot to succeed in today’s fast-paced market, and Cognizant has become a leader in the industry. We love big ideas and even bigger dreams. We stand out because we put human experiences at the core. We help clients engage customers by envisioning and building creative products and services. But we do not stop there. We...


  • Winston Salem, United States Cognizant Full time

    Why choose cognizant? It takes a lot to succeed in today’s fast-paced market, and Cognizant has become a leader in the industry. We love big ideas and even bigger dreams. We stand out because we put human experiences at the core. We help clients engage customers by envisioning and building creative products and services. But we do not stop there. We...


  • Winston-Salem, United States Atrium Health Wake Forest Baptist Full time

    The Department of Pediatrics within Atrium Health Wake Forest School of Medicine/Brenner Children's Hospital (BCH) is seeking to hire an additional faculty member to our section of Pediatric Endocrinology. We are seeking a clinician-educator or clinician-scientist who is passionate about expanding a program academically and developing community-partnered...

  • Sr Internal Auditor

    2 weeks ago


    Winston-Salem, United States Truist Full time

    The position is described below. If you want to apply, click the Apply Now button at the top or bottom of this page. After you click Apply Now and complete your application, you'll be invited to create a profile, which will let you see your application status and any communications. If you already have a profile with us, you can log in to check status.Need...

  • Sr Internal Auditor

    1 week ago


    Winston-Salem, United States Truist Full time

    The position is described below. If you want to apply, click the Apply Now button at the top or bottom of this page. After you click Apply Now and complete your application, you'll be invited to create a profile, which will let you see your application status and any communications. If you already have a profile with us, you can log in to check status.Need...


  • Salem, United States SPX Full time

    Building the people that build the world. With platforms in HVAC and Detection and Measurement, SPX Technologies builds innovative solutions that enable a safer, more efficient, sustainable world. Through our RiSE talent development framework, we Reach, Identify, Strengthen, and Engage our employees to support them in their continued development. We're a...


  • Winston-Salem, United States DSJ Global Full time

    Title: Sr. Packaging Engineer Industry: Nutraceuticals Location: Winston-Salem, NC Position Overview: DSJ Global is currently partnered with an industry leading Nutraceutical company who is seeking a talented and experienced Senior Packaging Engineer to join their dynamic team. You will work onsite in their state of the art innovation and manufacturing...

  • Sr. Audit Manager

    1 week ago


    Winston-Salem, United States Truist Full time

    The position is described below. If you want to apply, click the Apply Now button at the top or bottom of this page. After you click Apply Now and complete your application, you'll be invited to create a profile, which will let you see your application status and any communications. If you already have a profile with us, you can log in to check status.Need...


  • Winston-Salem, United States Black & Veatch Full time

    Job Summary Black & Veatch has an exciting opportunity for a Sr. Water Resources Professional focused on the Carolinas water supply management and water resilience Black & Veatch has an exciting opportunity for a Sr. Water Resources Professional focused on the Carolinas water supply management and water resilience initiatives. This position will...


  • winston-salem, United States eXcell Full time

    Find out why CompucomStaffing is the employer of choice for contractors! Join our team and enjoy our generous employee benefits!Our client has a brand-new opportunity for a Senior Service Desk Support Technician to support their team in a remote role. The ideal candidate is preferably located in the CST or EST time zones. They should also be able to work...

  • IBM BPM Architect

    5 months ago


    Winston-Salem, United States Saxon Global Full time

    Position Description: Sr. IBM BPM/ Integration Designer Architect/ Developer will have a primary role in the analysis, design, configuration, upgrade and implementation of complex business processes using IBM Business Process Manager Version 8.6. Candidate must be experienced in all phases of BPM implementation lifecycle Simulation, Modeling, Implementation,...


  • Winston-Salem, United States Freese And Nichols Full time

    Freese and Nichols is currently searching for a Sr. Water/Wastewater Project Manager for water infrastructure engineering projects in Charlotte, Raleigh and Winston Salem, North Carolina or Atlanta and Duluth, Georgia. Typical projects include project management and technical oversight for studies, design, and construction phase services for water/sewer...