Sr. Informatica ETL Developer

USG Corporation•Chicago, IL

17h•$145,611 - $155,000•Hybrid

About The Position

USG Corporation is seeking a Sr. Informatica ETL Developer in Chicago, IL with the following requirements: Bachelor’s degree in Computer Science, Information Technology, Electrical and/or Computer Engineering or related field or foreign equivalent degree. 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 requests; Turn functional data mappings into reporting, analytic and warehousing solutions; Conduct performance tuning on new and existing systems to ensure optimal efficiency; Maintain existing warehouse, reporting and analytic solutions by providing production support; Develop and maintain ETL workflows using Informatica PowerCenter, Intelligent Data Management Cloud, and Ab Initio, utilizing Autosys scheduling to automate data processing and improve workflow efficiency; Optimize data operations by writing and refining complex PL/SQL queries, stored procedures, and reconciliation models in Oracle 11g and MS SQL Server, ensuring consistency and automating deployments using GitHub and Informatica Repository Manager; Create advanced SQL queries and architect complex ETL processes; Lead the design, development and modification of complex systems using ETL Solutions, Informatica, Intelligent Data Lake and MS SQL Server.; Automate deployments using GitHub and Informatica Repository Manager. 60% remote work allowed; Must live within normal commuting distance of Chicago, IL. Salary: $145,611-$155,000/year. Rate of pay may be adjusted based on the qualifications and experience of the candidate. USG employees enjoy a number of benefit options for themselves and their families. These include two medical insurance options, as well as vision and dental coverage. The cost of these optional programs varies based on coverage level - employees generally pay 25% of the monthly premium cost, USG pays the rest. These coverage options are offered on the first day of employment with no waiting period. Additionally, USG employees enjoy both a 401(k) Investment Plan with company match and a pension plan. Beyond these main features, employees may also choose from a number of additional programs like life insurance, accident insurance, legal insurance, even pet insurance, just to name a few. USG also offers Quarterly (hourly) / Annual (salary) bonus potential for all employees based on performance metrics tied to safety, quality, and productivity. USG also provides employees with paid time off and paid holidays. Since 1902, Chicago-based USG has been a leader in producing innovative, award-winning products and systems to build everything from major commercial developments and residential housing to home improvements. USG's employees are committed to the highest levels of customer satisfaction and quality in everything we do. Our steadfast commitment to the company's core business values – innovation, quality, integrity, service, diversity, efficiency and safety – have helped us become the company we are today. EOE including disability/veteran

Requirements

Bachelor’s degree in Computer Science, Information Technology, Electrical and/or Computer Engineering or related field or foreign equivalent degree
5 years of related experience
Agile
SCRUM methodologies
Erwin
Informatica platform and tools requests
Informatica PowerCenter
Intelligent Data Management Cloud
Ab Initio
Autosys scheduling
PL/SQL queries
stored procedures
reconciliation models in Oracle 11g and MS SQL Server
GitHub
Informatica Repository Manager
ETL Solutions
Informatica
Intelligent Data Lake
MS SQL Server
Must live within normal commuting distance of Chicago, IL

Responsibilities

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 requests
Turn functional data mappings into reporting, analytic and warehousing solutions
Conduct performance tuning on new and existing systems to ensure optimal efficiency
Maintain existing warehouse, reporting and analytic solutions by providing production support
Develop and maintain ETL workflows using Informatica PowerCenter, Intelligent Data Management Cloud, and Ab Initio, utilizing Autosys scheduling to automate data processing and improve workflow efficiency
Optimize data operations by writing and refining complex PL/SQL queries, stored procedures, and reconciliation models in Oracle 11g and MS SQL Server, ensuring consistency and automating deployments using GitHub and Informatica Repository Manager
Create advanced SQL queries and architect complex ETL processes
Lead the design, development and modification of complex systems using ETL Solutions, Informatica, Intelligent Data Lake and MS SQL Server
Automate deployments using GitHub and Informatica Repository Manager