Employer: U.S. Cellular Corporation
Job Title: Sr. BI/ETL Developer - Informatica [job # INF001125]
Location: 8410 W. Bryn Mawr Avenue, Chicago, IL 60631
Job Duties: Develop and maintain the interfaces and data extracts for business processes. Design and write programs and scripts required to extract, transform, clean, and move data from the business systems into the enterprise data warehouse, data mart and operational data stores. Provide ongoing support, maintenance, and related information technology endeavors such as data migration, data cleansing, and data modeling. Participate in requirements meetings with Business Analysts to understand analytical content needs. Assist in documenting requirements, resolving ambiguities and conflicts, and ensuring requirements are complete. Provide strategic thinking leadership pertaining to new ways of leveraging information to improve business practices. Design and document detailed ETL specifications based on business requirements. Design and develop using procedural and record based patterns. Analyze functional specifications and assists in designing potential technical solutions. Work with source system developers and business owners to define data extraction methodologies. Work with Data Modelers to develop data warehouse models, design specifications, metadata processes and documentation. Define, document, develop, enhance, and maintain Software application modules in Informatica, Perl, SQL. Develop high performance applications using tuning ETL methods related to Informatica and SQL. Develop test plans and test all code following standards and best practices. Perform design validation, reconciliation, and error handling for all code. Understand and execute release management and change management processes for changes to applications. Identify, troubleshoot, and resolve application issues and code defects. Participate in 24/7 on-call support rotation. Understand SDLC concepts and complies with the process. Demonstrate success working in a team-based environment by following standardized processes. Participate and share expertise in peer reviews of documentation and code. Manage individual workload and deliver to agreed project milestones. Coach and mentor other team members as appropriate. Communicate status and risks to manager regarding timely delivery of solutions.Position requires less than 10% domestic travel for U.S. Cellular meetings and/or training.
Requirements: The position of Sr. BI/ETL Developer - Informatica requires a Bachelor's degree or its foreign equivalent in Computer Science, Information Systems, Electrical Engineering, or related field and Seven (7) years of progressively responsible, post-baccalaureate related experience.
Specific Skills or Other Requirements: Additionally, the applicant must have experience with: i) BI/ETL development in the IT industry with recent development, system administration, application tuning and debugging experience; ii) Database engines including Oracle; iii) ETL Development, Informatica Programming, Database (Modeling, SQL), Oracle, SQL, and PL/SQL; iv) Database performance factors, monitoring tools, and tuning procedures; and v) Data Warehousing methodology and techniques.
Interested applicants may apply online through the career page at uscellular.jobs
(reference job # INF001125).
U.S. Cellular® is an EEO employer and gives consideration to qualified applicants without regard to race/color/age/religion/sex/sexual orientation/gender identity/national origin/disability/veteran status, pregnancy or genetic information.