Application Programmer V

$121,181 - $137,821/Yr

Genesis10 - Plano, TX

Full-time - Mid Level

Plano, TX

251-500 employees

Professional, Scientific, and Technical Services

About the position

Genesis10 is seeking an experienced Application Programmer V for a 12+ month contract position in the financial industry. The role involves translating business requirements into technical specifications, designing and implementing ETL processes, and ensuring software stability through various testing methods. The ideal candidate will have strong data analysis skills and experience with SQL, ETL tools, and database design, while collaborating with multiple teams to maintain data quality and resolve technical complexities.

Responsibilities

• Translate business requirements into technical specifications
• Design and implement ETL (Informatica) processes using SQL, ETL tools, and Linux shell scripting
• Conduct data analysis and resolve defects by collaborating with multiple teams
• Manage interdependencies and set up test cases while maintaining data quality
• Ensure software stability through documentation, code reviews, and various testing methods
• Perform logical and physical data modeling and database design
• Lead and develop complex Informatica PowerCenter ETL flows connecting to heterogeneous databases
• Develop complex Oracle procedures, functions, and packages for database applications
• Conduct performance tuning activities for new and existing applications
• Perform data analysis and profiling to identify data quality issues
• Guide the team in estimating work necessary for delivery
• Contribute to story refinement and defining requirements
• Perform proof of concept to mitigate risks or implement new ideas
• Code solutions and unit test to meet defined acceptance criteria
• Utilize multiple architectural components in design and development
• Assist the team in resolving technical complexities involved in realizing story work

Requirements

• 8+ years of experience with Informatica or other ETL tools
• 6+ years of professional experience with SQL/PLSQL
• Understanding of Data Federations, Data Lake, Data Mesh, and Advanced Cloud concepts
• Experience automating ETL with job scheduling tools, preferably Autosys
• Experience working with large data sets using big data solutions such as Hadoop and Spark
• Self-starter with the ability to work independently in a fast-paced environment
• Exceptional analytical and problem-solving skills
• Excellent organizational and communication skills
• Team player who values and cultivates relationships
• Demonstrated ability to get things done and innovate
• Hands-on experience with Unix Shell Scripting
• Understanding of scheduler (Autosys)

Nice-to-haves

• Document and communicate required information for deployment and maintenance
• Strong experience in data warehousing, data architecture, and optimizing advanced SQL queries
• Contribute to existing test suites and analyze test reports
• Exposure to tools like Trino or Starburst

Benefits

• Access to hundreds of clients
• Opportunity for a career-home in Genesis10
• Experienced recruiting team
• Behavioral Health Platform
• Medical, Dental, Vision insurance
• Health Savings Account
• Voluntary Hospital Indemnity
• Voluntary Term Life Insurance
• 401K
• Sick Pay
• Commuter Benefits
• Remote opportunities available