Sinclair is one of the leading companies in Broadcast technologies. We are hiring a talented Sr Informatica Administrator to join our team. If you're excited to be part of a winning team, Sinclair is a great place to grow your career. You'll be glad you applied to Sinclair.
Job Description
The Sr Informatica Administrator will be part of the team that supports a growing Master Data Management platform using Informatica, Azure SQL Services, classic SQL Servers and other data platforms.
Responsibilities

• Administering the Informatica cloud platform
• Making changes to cleansing rules, flow changes, schema changes, and implementing new entities
• Monitor performance, troubleshoot, and tune Informatica processes
• Will be responsible for 24x7 support
• Work with Informatica vendor on any issues that arise
• Support the data development team as needed

Qualifications

• Excellent oral and written English communication skills
• Specifically needs to be able to communicate well on phone calls
• Must be able to thrive under pressure and have a strong sense of ownership and responsibility for the project
• Minimum of 3-5 years of experience in the administration, architecture, design, and development of Informatica's data integration tools
• Informatica experience must include working with large mission critical data systems (multiple terabytes in size with millions of rows processing per day)
• Must be able to demonstrate mastery of quickly debugging and resolving issues that can arise with Informatica programs.
• Minimum 2 full lifecycle project experience with small development groups, e.g., leading ground up development of Informatica standards in one or more previous projects.
• Demonstrated ability to navigate through organizational and technical uncertainty
• Strong Customer MDM resource with hands-on in Informatica Customer 360 or Informatica multi domain. This will be a hands-on role w.r.to development
• Strong knowledge on Design, develop, test informatica processes and deploy informatica objects using deployment groups/github.
• Develop/Implement the coding of Informatica mappings for different stages of ETL. Move staging table to the target table.
• Design, code, unit test ETL packages, triggers, and stored procedures, views, SQL transactions
• Utilize Informatica repository manager, designer, workflow manager & workflow monitor, to manage and administer ETL jobs
• Design, schedule, execute and monitor ETL jobs, including necessary exception handling & balance and control measures
• Perform troubleshooting, debugging, and performance tuning
• Create, test and refine SQL queries to support data profiling and data management
• Perform data profiling, data standardization, data transformations, data loads.
• Perform detailed data profiling and end-to-end data management analysis to understand data issues, and to identify potential options to resolve issues.
• Support phases of the project lifecycle including requirements gathering, analysis, design, development, testing, deployment, support, and documentation
• Analyze, document and define data management processes, both batch and real-time.
• Create clear deliverable materials for a range of recipients including technical teams, business teams, project leads and executives.

Preferred Qualifications

• Fluency with business concepts related to relational and dimensional data models
• BA/BS in computer science or equivalent experience
• Experience with large scale database application like Exadata would be a plus

Sinclair Broadcast Group, Inc. is proud to be an Equal Opportunity Employer and Drug Free Workplace!

About Us

Make your mark in Media with Sinclair Broadcast Group, a diversified media company dedicated to connecting people with content everywhere! We have consistently led the broadcast industry since our inception, and now Sinclair owns the largest regional sports network business and one of the largest television broadcast portfolios in the country. In addition, we have affiliations with all of the major broadcast networks, own Tennis Channel, and several multicast networks including TBD and Comet. Our content is distributed over-the-air, on multi-video providers, and through our industry-leading digital media platforms. We also recently launched a free TV streaming service called STIRR. Our success is the direct result of our extraordinary employees and management team who believe in our vision and are dedicated to ensuring a great future for our employees. We are advancing the world of Media and want YOU to join our winning team!

About the Team

The life-blood of our organization is our people. We have a compelling story, a goal-oriented culture, and we take really good care of people. How good? Here is a glimpse: great benefits, open door policy, upward mobility and a strong desire to see you succeed. Ready to be part of a winning team? Let's talk.