ETL Developer - Operations at Sammons Financial Group Companies (Des Moines, IA)

Sorry, this job was removed at 11:22 p.m. (CST) on Tuesday, May 17, 2022
Find out who's hiring in Des Moines, IA.
See all Developer + Engineer jobs in Des Moines, IA
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Job Title:ETL Developer - Operations

Location: Des Moines, IA, Chicago, IL, Sioux Falls or Remote

What you can expect as a ETL Developer:

  • As a ETL developer you would be responsible for developing the ETL mappings as per the Technical Specs.
  • Test the ETL mappings developed as per the Specs to ensure quality of the mappings and the data.
  • Provide inputs to continuously improve ETL process discipline and resulting output quality.
  • Tuning of ETL performance.
  • Collaborate with the Architects on POC of new tools and technologies.

Experience Requirements:

  • 5+ years of experience in designing and delivering Data Warehouses and reporting solutions.
  • High Level of SQL experience is must.
  • Experience with Database technologies such as Oracle, DB2, SQL server a must.
  • Experience with Extract, Transform and Load and ELT development is required.
  • 5+ years of hands on experience with Informatica Power Center.
  • Data modelling experience with dimensional modeling is required.
  • Understanding of Metadata, Data Governance, Data Quality and Data security is required.
  • Exposure to cloud based DW Snowflakes highly preferred.
  • Exposure to CDC tools like Attunity Replicate, AWS DMS, Goldengate etc. is good to have.
  • Experience with Python nice to have.

  • Experience of working in Agile Environment.
  • Understanding of Life Insurance or Annuities business is good to have.

Job Summary:

    Under general direction, formulates and defines system scope and objectives. Devises or modifies procedures to solve highly complex problems considering computer equipment capacity and limitations, operating time and form of desired results. Prepares detailed specifications to write programs. Designs, codes, tests, debugs, documents and maintains those programs. Competent to work on and responsible for nearly all phases of applications systems analysis and programming projects. Regularly provides guidance and training to less experienced analysts/programmers.

Essential Functions:

  • Trouble shoot and fix issues in Informatica code, as part of Production support team Analyze data to understand issues and fix them- using SQL or ETL code Coordinate with other team members in code elevation and performance improvements
  • Collaborate with analysts, designers, and programmers in conceptualizing and development of new software programs, applications and automated test scripts.
  • Perform technical tasks, detailed analyses, and interpretation of technical problems requiring expertise and/or specialized knowledge in a systematic manner; apply subject matter expertise unique to the discipline.
  • Exhibit expert understanding of the organizations Systems Development Life Cycle.
  • Play a leading role in the definition, development, and documentation of softwares requirements, objectives, deliverables, and specifications on a project-by-project basis in collaboration with internal users and departments.
  • Play a leading role in defining software development project plans, including scoping, scheduling, and implementation.
  • Prepare and/or interpret business, functional, and non-functional requirements; create and maintain user-oriented applications and design specifications.
  • Develop, test, document and implement applications according to standards and methodologies.
  • Design, develop and test automation scripts. Follow automated test script guidelines and research issues in software through testing.
  • Design, implement and maintain databases. Follow database standards and integrity controls, analyze information requirements, and develop database specifications.
  • Plan, coordinate, and implement security measures to safeguard information resources against accidental or unauthorized modification, destruction, or disclosure.
  • Design, run and monitor software functional and performance tests on new and existing programs for the purposes of correcting errors, isolating areas for improvement, and general debugging; administer critical analysis of test results and deliver solutions to problem areas.
  • Recommend, schedule, and perform software improvements and upgrades.
  • Must be on call during scheduled times and may be required to work for extended periods at night and on weekends in support of conversion, assisting in operational problems, or testing a new program.
  • Maintain currency of professional, technical and business skills.
  • Utilize established status report, time accounting and collaborative process to provide data for management.
  • Exhibit expert understanding of application, data, and integration, plus deep understanding of security, operational, and systems management architectural and design domains.
  • Meet with decision makers, systems owners, and end users to define business requirements and systems goals, and identify and resolve business systems issues.
  • Ensure compatibility and interoperability of systems.
  • Review and analyze the effectiveness and efficiency of existing systems and develop strategies for improving or further leveraging these systems.
  • Create and describe system design and models utilizing commonly used industry mechanisms like E-R Diagrams, UML models, flow charts, etc.
  • Perform cost-benefit and return on investment analysis for proposed systems to aid management in making implementation decisions.
  • Direct research on emerging application development software products, languages, and standards in support of procurement and development efforts.
  • Liaise with companys software and hardware suppliers for prompt rectification of any problems or emergencies.
  • Take an active role in cross-departmental projects when needed.
  • Cultivate and disseminate knowledge of application development best practices; Train, mentor, and provide guidance to junior software development staff.
  • Oversee the quality assurance of program logic, data processing, and error resolution.
  • Commitment to embrace Sammons Financial Group Companies shared values (Respect, Accountability, Integrity, and Openness)
  • As stated within the Company Attendance and Punctuality policy, regular attendance is required and expected in order to meet the business service levels and workflow demands.


  • College Degree in the field of computer science, information science, management information systems preferred
  • Minimum 8 years' IT development experience or equivalent preferred
  • Effective verbal and written communications skills and the ability to communicate with business partners and other IT staff
  • Problem solving skills sufficient to perform research and recommend a proposed solution to problems
  • Able to work on multiple tasks and meet established deadlines
  • Able to effectively direct and coordinate the work of other team members on a project without having HR management responsibility for them
  • Knowledge of computer programming languages as required for the system
  • $75,248 - $156,766 - Range includes data points from multiple labor markets. Specific range is dependent on the labor market where the incumbent will be hired to perform the position. Starting salary is dependent on candidate qualifications and experience. For a narrower salary range specific to your labor market, please inquire.
  • Sammons Financial Group offers incentive programs for defined goals subject to eligibility and performance. Monetary rewards are based on individual and/or overall company performance.
  • Our competitive benefit package includes: Health, Dental, Vision, Company Paid Retirement, PTO and Holiday Pay.
  • Criminal background check required.
More Information on Sammons Financial Group Companies
Sammons Financial Group Companies operates in the Fintech industry. The company is located in West Des Moines, IA, Chicago, IL, Sioux Falls, SD and Fargo, ND. Sammons Financial Group Companies was founded in 2022. It has 1001 total employees. It offers perks and benefits such as Flexible Spending Account (FSA), Disability Insurance, Dental Benefits, Vision Benefits, Health Insurance Benefits and Life Insurance. To see all 14 open jobs at Sammons Financial Group Companies, click here.
Read Full Job Description
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Similar Jobs

Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView Sammons Financial Group Companies's full profileFind similar jobs