Application Programmer V

$124,800 - $145,600/Yr

BCforward - Plano, TX

Full-time - Mid Level

Plano, TX

5,001-10,000 employees

Professional, Scientific, and Technical Services

About the position

The Application Programmer V role at BCforward involves translating business requirements into technical specifications, primarily focusing on ETL processes using Informatica and SQL. The position requires strong data analysis skills and collaboration with development teams to ensure software stability and data quality. The role also includes responsibilities for database design, performance tuning, and leading complex ETL flows.

Responsibilities

• Translate business requirements into technical specifications.
• Design and implement ETL 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 to maintain data quality.
• Ensure software stability through documentation, code reviews, and testing.
• Lead and develop complex ETL flows connecting to heterogeneous databases.
• Develop complex Oracle procedures, functions, and packages for database applications.
• Perform proactive and reactive performance tuning during application development.
• Support Unix Shell Scripting and understand job scheduling with Autosys.
• Identify data quality issues through data analysis and profiling.
• Guide the team in estimating work necessary for delivery lifecycle.
• Contribute to story refinement and define 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.

Requirements

• 8+ years of experience with Informatica or other ETL tools.
• 6+ years of professional experience with SQL/PLSQL.
• Strong understanding of Data Federations, Data Lake, and Data Mesh concepts.
• Experience with job scheduling tools, preferably Autosys.
• Experience working with large datasets using big data solutions like Hadoop or Spark.

Nice-to-haves

• Strong experience in data warehousing, data architecture, and optimizing advanced SQL queries.
• Experience with Trino, Starburst, or similar vendor tools.
• Ability to document and communicate information for deployment and support.
• Contribute to existing test suites and analyze test reports.

Benefits

• Major medical insurance
• Health Savings Account (HSA)
• Dental insurance
• Vision insurance
• Employer-provided group life insurance
• Voluntary life insurance
• Short-term disability
• Long-term disability
• 401k