American Equity Sr ETL Designer/Developer - Data Management in West Des Moines, Iowa
GENERAL PURPOSE OF THE JOB:
The Senior ETL (Extract, Test and Load) Designer/Developer designs, develops, tests, implements, troubleshoots, optimizes and maintains enterprise level ETL jobs that implement complex ETL processes which reference a targeted centralized data warehouse. The incumbent analyzes data transformation requirements leveraged to build, refine, deploy and/or configure ETL architectural design patterns that maximize reuse and minimize change impact. The senior developer utilizes SQL, tools, and/or technology to implement robust, maintainable solutions that meet business and technical requirements.
ESSENTIAL DUTIES AND RESPONSIBILITIES:
Serves as subject matter expert in Informatica ETL tool, mapping design, architectural design, coding, implementation, performance tuning and debugging.
Develops complex data extracts, applications and ad-hoc queries using Informatica Power Center and/or Informatica Cloud.
Maintains a strong understanding of ETL design principles required in building an enterprise data warehouse environment, including an understanding of the relationship between different data warehouse architectural layers, constructs and data design concepts.
Creates complex SQL queries required to access tabular structures in Relational Database Management Systems (RDBMS).
Provides technical guidance in the ongoing development of technical best practices for data movement, data quality, data cleansing and other ETL-related activities.
Transforms functional specifications into ETL technical specifications and source to target mappings.
Communicates effectively with Business Analysts, Data Modelers and Solution Architects to convert the ETL design into specific development activities.
Constructs/refines ETL processes related to loading data into warehouse and provides ETL development guidance to junior level ETL developers.
Documents ETL process thoroughly, including steps needed to migrate ETL/database objects between various environments including Development, UAT, Staging, and Production.
Leads Unit and Integration Testing activities and assists in User Acceptance Testing as needed.
Coaches, mentors and provides work direction to other junior level ETL designer/developers.
Performs other related work as assigned.
Direct Reports: None
General Description of Indirect Reports (2 and 3-downs): None
EDUCATION AND/OR EXPERIENCE:
Bachelor's degree in Computer Science, MIS, Mathematics, Information Management or related filed of study; plus five (5) years of progressively responsible related experience; or equivalent combination of education and/or experience.
Three (3) years prior senior level experience working with Informatica or similar tool.
Experience creating test plans for ETL processes plus strong understanding of regression testing methods.
Expert level development experience working with SQL scripting.
CERTIFICATES, LICENSES, PROFESSIONAL DESIGNATIONS:
KNOWLEDGE, SKILLS AND ABILITIES:
Advanced knowledge of Informatica and ETL design/development best practices.
Knowledge of Informatica development and administration tools, including basic and complex transformations.
Working knowledge of RDBMS and data warehouse front-end tools.
Proficient in ETL methodology in performing Data Profiling, Data Migration, and Data Conversion.
Strong analytical and problem-solving skills.
Ability to work with various ETL frameworks.
Basic data model knowledge. (relational, dimensional, historical data support, etc.)
Knowledge of data reporting tools.
Strong customer service orientation.
Effective verbal and written communication skills.
Mathematical skills and strong attention to detail.
Ability to work cooperatively and successfully with employees, customers, and other outside third parties.
Strong organizational and planning skills.
Proficient in the use of MicroSoft Office Suite.
Ability to write reports, business correspondence, and procedure manuals.
Ability to effectively present information and respond to questions.
Ability to define problems, collect data, establish facts, and draw valid conclusions.
Ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists.
Ability to successfully handle pressure and meet deadlines in a fast-paced work environment.
This description covers the major purpose and essential functions of the job. It is not intended to give all details or a step-by-step account of the way each task is to be performed. Employees may receive other job related instructions and be required to perform other job related work requested by their manager. All requirements are subject to possible modification to provide reasonable accommodation to qualified individuals with disabilities.