What are the responsibilities and job description for the Sr. Informatica ETL Developer position at USG Corporation?
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
Salary : $145,610 - $155,000