Lead CDC Developer – Teradata/Informatica
Frontier Communications - Allen, TX

This job posting is no longer available on Frontier Communications. Find similar jobs: Frontier Communications jobs

Join our LinkedIn Group, Frontier Technology: Networking, Forum, and Jobs.

Frontier Communications is seeking a a Senior ETL/Teradata Lead to join our Data warehouse team.. The Senior ETL/Teradata Lead will focus on ETL design, development and support. Responsible for ETL processes and tools as well as database loading and manipulation to ensure that the data needs are met throughout the course of the projects and production support. Understands business problems and opportunities in the context of the requirements and recommends solutions that enable the organization to achieve its goals. Interprets and transforms information based on business requirements and provides the data for delivery. Conducts detailed research of vendor products and assists with general project management. The developer will be responsible for analyzing, designing, developing, unit testing, integration testing, and documenting Informatica code related to Enterprise Data Warehouse. The Lead is responsible for understanding the business problem to be solved and providing a technical solution using Informatica as the main tool, but also integrating other technologies as necessary and as approved by technical leadership. The deliverables could require cross-functional service integration at a data level across a broad variety of applications. Must support the implementation of robust scalable data architecture, integration and management processes that meet the business goals of the organization. This role requires excellent non-technical communication and problem-solving skills.

  • Primary role would be to Lead development of ETL Mappings, Workflows and prepare them for deployment into test and production environments.
  • Design Informatica workflows and mappings for optimal performance in a large scale Unix/Oracle environment.
  • Collaborate with developers, project managers and business analysts in conceptualizing and developing new software applications and enhancements.
  • Ability to design and implement solutions that are reliable, scalable, and perform at a high-level to meet the service levels associated with mission-critical Oracle/Teradata and Informatica-based solutions.
  • Ability to tune Informatica workflows; knowledge of optimal mapping techniques.
  • Very Strong SQL Skills. Candidate should be able to craft extremely efficient SQL's.
  • Knowledge of database architecture and best practices for Oracle SQL and application tuning.
  • Extensive experience with all CDC implementation, Power Center transformation types and reusable components.
  • Ability to design, code and unit test complex Power Center applications.
  • Ability to troubleshoot problems with Informatica objects.
  • Experience with scheduling tools is a plus.
  • Ability to deliver results with minimum supervision.
  • Excellent communication skills.
  • Design the technical solution and effort estimates based on business requirements
  • Responsible for writing technical design documents and follow the software development life cycle and coding standards.
  • Must be able to work in a team environment to maintain and troubleshoot ETL and database systems.\
  • Support QA/UAT support and defect resolution
  • Respond to support tickets and resolve issues based on the urgency and the importance of the issue
  • Understanding the problems user or business is facing with the business data and processes and find ways to correct them.
  • Support the business groups by resolving issues and providing guidance and feedback to the user.
  • Handle business and user inquires about data and processes

Required Skills
  • Familiarity with any Cognos BI tool
  • Database skills
  • Design and Architecture
  • Good understanding of Data Warehouse concepts
  • Good understanding of software development life cycle and coding standards
  • Demonstrated thorough understanding of modern enterprise architecture, hands-on experience with enterprise application integration middleware and platforms.
  • Demonstrated level of technical knowledge and understanding of architecture, application systems design and integration
  • Strong understanding of relational data structures, theories, principles, and practices.
  • Knowledge and skills in data warehousing methodologies and tools, implementation strategies, and integration
  • Excellent client/user interaction skills to determine requirements
  • Strong written and oral communications skills.
  • Proven ability and initiative to learn and research new concepts, ideas, and technologies quickly.
  • Strong systems/process orientation with demonstrated analytical thinking, organization skills and problem solving skills.
  • Ability to work in a team-oriented, collaborative environment.
  • Ability to quickly pick up new tools and technologies.
  • Willingness and ability to train and teach others.
  • Ability to facilitate meetings and follow up with resulting action items.
  • Ability to prioritize and execute tasks in a high-pressure environment.
  • Strong presentation and interpersonal skills.
  • Ability to work effectively in a multi-cultural environment, and to lead and influence cross-organizationally with and without direct authority.
  • Ability to effectively move forward on tasks even with ambiguous or changing requirem
Required Experience
  • At least 5 years of working with Informatica Power Center version 8.6+, Power Exchange 8.6+
  • At least 5 years of working with Teradata and performance tuning
  • At least 2 years of working with Oracle and performance tuning
  • Experience with Unix platform
  • Experience with tools like Data Profiling or Data Cleansing
  • Experience with RDBMS concepts and data modeling
  • Experience in developing SQL scripts and stored procedures in Teradata/Oracle
  • Experience in evaluation of SQL Execution plans and providing recommendations for tuning of SQL statements
  • Experience with end user analytic tools
  • Experience in working with high volume data load is a plus
  • Experience in creating requirements, analysis, design and deployment documents based on standard and rapid development methodologies
  • Experience with business requirements analysis, entity relationship planning, database design, reporting structures, and so on
  • Excellent client/user interaction skills to determine requirements
  • Experience working in a team-oriented, collaborative culture

About this company
313 reviews
Frontier Communications Corporation (NASDAQ: FTR) offers voice, broadband, satellite video, wireless Internet data access, data security...