Blank

Principal Application (ETL) Developer

Principal Application (ETL) Developer

POSITION: Principal Application Developer
DEPARTMENT: Enterprise Technology Partners
REPORTS TO: Director, Information Development
MATRIXED RELATIONSHIP: TBD
PREFERRED LOCATION: Dallas, TX

POSITION SUMMARY:
The Principal Application Developer’s role is to provide advanced technical skills and leadership in the
design, development, monitoring, and use of the company’s enterprise data warehouse. He/she will be
accountable for the full cycle of design, data modeling, coding, testing and documentation of the
enterprise data warehouse. He/she must work with the business to fully understand the business
requirements and translate them into technical specifications. This individual is also responsible for
defining coding standards in the development of the extraction, transformation and load (ETL) processes
for the data warehouse and working with the Database ETL Developers to ensure those standards are
followed. He/she must also demonstrate a willingness to work with and mentor associates of varying
levels of technical expertise within the organization. Above all, this individual makes certain that the data
warehouse design and ETL processes meet our business objectives while ensuring data integrity and
security.
RESPONSIBILITIES:
? Data architecture and design
? Act as SME for specified applications
? Review BRDs and provide LOE for deliverables
? Manage small to medium-sized data integration projects
? Assist in knowledge transfer activities
? Provide ETL Development expertise and data warehousing best practices and tools using
Informatica Version 9.6 and above.
? Adhere to ETL design standards, procedures and best practices in Informatica; transformations,
mappings, sessions, workflows, implementing business rule as per requirement, building RTM,
data model documentation and data integration strategy.
? Development of Source-to-Target mapping design specifications, data dictionaries, review
database schemas
? Develop and test Extract, Transformation, and Loading (ETL) modules based on design
specifications using Informatica Version 9.5x and above.
? Develop, maintain knowledge of data available from upstream sources and data within various
? Review of Informatica ETL design documents and working closely with development to ensure
correct standards are followed. This could be automated using mappings to parse code and
report on exceptions.
? Mentor peers in building skills
? Assist in resolving complex data and application issues
? Performance tuning of Informatica mappings, SQL queries
? Support development teams with troubleshooting issues. On Call Support as required
? Scheduling jobs through scheduling tool (i.e. Control-M, Robot) for monthly and daily job cycles.
? Root Cause analysis for ETL job failures/Data issues raised by business.
REQUIRED SKILLS INCLUDE:
? Expert understanding of BI/DW system architectures, methodologies and data modeling

? Current and hands-on experience with Informatica PowerCenter 9.6 and higher on Unix platforms
? Strong Unix shell scripting
? Proficiency in RDBMS, complex SQL, PL/SQL, performance tuning and troubleshooting
? Problem-solving skills with minimal supervision
? Demonstrated skill and ability in the development of data warehouse projects/applications
? Strong analytical skills and eagerness to learn domain and functional aspects
? Excellent communication skills, both verbal and written
? Analytical and problem solving
? Proficient verbal and written communication
? Mentorship
? Team building & Collaboration
? Organizational and Time Management
? Effectiveness in both independent and collaborative settings
? Ability to understand a complex application portfolio and integration of systems in facilitating
business operations
? Ability to work independently or in a team environment with geographically dispersed teams at
various times
Nice to have:
? AWS Redshift, S3, EC2
? Informatica Cloud
? Informatica Big Data Edition
? Informatica PowerCenter Adminstration
? Big Data (Hadoop and Hive/Impala) – Cloudera Distribution
EDUCATION
? Bachelor’s or Technical Degree Required (computer science, information systems, business
administration or other industry related curriculum)
Note: Sufficient and relevant work experience may be considered in lieu of the educational
requirements
EXPERIENCE
? 8 or more years of work experience in delivering data integration solutions using ETL tools such
as Informatica PowerCenter on Unix platforms
? 5 years of current and hands-on experience with complex SQL and high-volume Relational
databases and SQL Query performance tuning
? 3 years of current and hands-on UNIX shell scripting experience.
? 3 years of current and hands-on experience with an enterprise job scheduler (Control-M, Autosys,
Redwood, etc).
? 1 plus years in AWS Redshift, S3, EC2 or Big Data (Hadoop and Hive/Impala)
TRAVEL
? Domestic travel, approximately less than 25%