Job description

· Understand pain points from a customer/vertical perspective for developing specific solutions. Identify the customer segment to position the new offering and develop business case for the new service offering

· Analyzing data integration requirements, analyzing data sources and targets, business rules, and transformation logic

· Analyzes the impact of changes on existing ETL/ELT processes and systems. Assesses the compatibility with goals in all areas. Analyzes cost effectiveness and feasibility

· Create functional design for overall business intelligence solutions

· Design, develop and maintain Informatica cloud data integration processes using the appropriate data load technique, including Push-Down Optimization for performance optimization

· Design data integration and conversion strategy, exception handing mechanism, data retention and archival strategy

· Designing and developing data extraction, cleansing, transformation, and loading processes and workflows to load data

· Debug and tune data integration processes; analyze data warehouse architecture, normalized/de-normalized, star schemas and snowflakes, slowly changing dimensions, dimensional surrogate key handling, exception data processing, troubleshoot and recommend improvements and alternate methodologies

· Create artifacts from perspective of technology, product, domain and infrastructure as applicable

· Data Quality management

· Guiding other team members and external vendors to perform the same

· Ability to effectively work in a fast-paced, energetic team environment

Job Type: Full-time

Pay: $100,734.36 - $120,314.50 per year

Benefits:

• 401(k)
• Dental insurance
• Health insurance
• Vision insurance

Schedule:

• 8 hour shift
• Weekend availability

Ability to commute/relocate:

• Dallas, TX: Reliably commute or planning to relocate before starting work (Required)

Experience:

• REST: 1 year (Preferred)
• Java: 1 year (Preferred)

Work Location: Hybrid remote in Dallas, TX

caravetterealestate.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, caravetterealestate.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, caravetterealestate.com is the ideal place to find your next job.