USG Corporation - Sr. Informatica ETL Developer

Developer is needed in Chicago, United States.

Client: USG Corporation

Location: Chicago, IL

Job Description

USG Corporation is seeking a Sr. Informatica ETL Developer in Chicago, IL. The role involves analyzing user requirements and defining functional specifications using Agile and SCRUM methodologies; designing and developing solutions to support reporting, analytic and warehouse needs using Informatica platform and tools; and providing production support for existing warehouse, reporting and analytic solutions.

Requirements

Educational Background: Bachelor’s degree in Computer Science, Information Technology, Electrical and/or Computer Engineering or related field or foreign equivalent degree.

Experience: Minimum 5 years of related experience.

Required Skills:

• Analyze user requirements and define functional specifications using Agile and SCRUM methodologies.
• Utilize modeling tools like Erwin to analyze and solve complex problems.
• Design and develop solutions to support reporting, analytic and warehouse needs using Informatica platform and tools.
• Conduct performance tuning on new and existing systems to ensure optimal efficiency.
• Develop and maintain ETL workflows using Informatica PowerCenter, Intelligent Data Management Cloud, and Ab Initio.
• Optimize data operations by writing complex PL/SQL queries and stored procedures in Oracle 11g and MS SQL Server.
• Lead the design and development of complex systems using ETL Solutions, Informatica, Intelligent Data Lake and MS SQL Server.
• Automate deployments using GitHub and Informatica Repository Manager.

Work Arrangement

60% remote work is allowed; candidates must live within normal commuting distance of Chicago, IL.

Salary

The salary range for this position is $145,611-$155,000 per year. Rate of pay may be adjusted based on the qualifications and experience of the candidate.

Benefits

USG employees enjoy a range of benefit options including:

• Two medical insurance options, as well as vision and dental coverage with employees generally paying 25% of the monthly premium cost.
• 401(k) Investment Plan with company match and a pension plan.
• Additional benefit options such as life insurance, accident insurance, legal insurance, and pet insurance.
• Quarterly (hourly) / Annual (salary) bonus potential based on performance metrics tied to safety, quality, and productivity.
• Paid time off and paid holidays.

Company Overview

Since 1902, Chicago-based USG has been a leader in producing innovative, award-winning products and systems for major commercial developments, residential housing, and home improvements. Our employees are committed to high levels of customer satisfaction and quality, underpinned by core business values of innovation, quality, integrity, service, diversity, efficiency and safety.

Equal Employment Opportunity

EOE including disability/veteran