Sr. Informatica Developer
Irving, TX

Job Description

Company Overview:

The ADT Corporation (NYSE: ADT) is a leading provider of security and automation solutions in the United States and Canada for homes and businesses, people on-the-go and their network. Making security more accessible than ever before, and backed by 24/7 customer support, ADT delivers same-day service and live answer within seconds in customer operations, helping customers feel more safe and empowered. ADT is headquartered in Boca Raton, Florida and employs approximately 17,500 people throughout North America. More information is available at www.adt.com.

Position Summary:

Summary: Lead, coordinates and supports effort to optimize performance in a multiple architecture environment.

Duties and Responsibilities:

* Responsible for the ETL data integration process through the use of Informatica Powercenter and Data Quality
* Perform data object analysis by defining, analyzing, and validating data objects and relationships through the use of Informatica toolset
* Run, manage and support Production Support ETL processes.
* Modify and maintain ETL data integration process with the Business Intelligence and IT team.
* Maintain data management standards and conventions, data dictionaries, data element naming standards and data dictionary metadata standards
* Implement data objects and integrating data shared across multiple source and target systems.


* Validates ETL by developing and executing test plans and scenarios including data design and data quality.


* Works with Business Analysts to come up with a solution to implement business requirements.


* Perform other duties as assigned. .



Requirements:

Education: Four (4) year degree or higher

Experience: 6-9 yrs

Sills/Requirements:

* Highly knowledgeable in all aspects of enterprise data warehouse concepts, design, implementation, deployment and maintenance, both in theory and practice.


* Must have minimum 6+ years of experience with designing and developing data warehouse solutions using Informatica


* Expertise in performance tuning and optimization of ETL processes in Informatica


* Expert Experience with Informatica power exchange, Informatica Data explorer, Informatica Data Quality and Address Doctor


* Proven, in-depth, enterprise-level data architecture skills (logical & physical, dimensional and entity-relationship models).


* Expertise on Hadoop systems.


* Must have working experience on database concepts including Oracle 11g PL-SQL programming


* Must have working experience on Unix Shell scripting.


* Knowledge of Tidal Scheduler is a plus



Competencies:

* Customer Focus
* Drive for Results
* Ethics & Values
* Peer Relationships
* Conflict Management
* TQM/Re-Engineering
* Technical Learning
* Functional/Technical Skills
* Self-Development

ADT LLC is an EEO Employer

Want to learn more about ADT?

Visit us online at www.adt.com