ETL Developer/Data Engineer at Ascendion Inc.

About Ascendion

Ascendion is a full-service digital engineering solutions company. We make and manage software platforms and products that power growth and deliver captivating experiences to consumers and employees. Our engineering, cloud, data, experience design, and talent solution capabilities accelerate transformation and impact for enterprise clients. Headquartered in New Jersey, our workforce of 6,000+ Ascenders delivers solutions from around the globe. Ascendion is built differently to engineer the next.

Ascendion | Engineering to elevate life

We have a culture built on opportunity, inclusion, and a spirit of partnership. Come, change the world with us:

• Build the coolest tech for world’s leading brands


• Solve complex problems – and learn new skills


• Experience the power of transforming digital engineering for Fortune 500 clients


• Master your craft with leading training programs and hands-on experience

Experience a community of change makers!

Join a culture of high-performing innovators with endless ideas and a passion for tech. Our culture is the fabric of our company, and it is what makes us unique and diverse. The way we share ideas, learning, experiences, successes, and joy allows everyone to be their best at Ascendion.

About the Role:

Tittle – Data Engineer/ETL Developer

Job Description

• Must have hands-on experience with Informatica PowerCenter 10.x or later utilizing SQL Server database or a similar RDBMS.  
  Must have hands-on experience with Control M enterprise scheduler.


• Follows the company’s required standards and guidelines regarding the use of the tools, including technical documentation.


• Develops simple, efficient and manageable automated solutions for highly complex database projects.


• Analyzes and transforms business requirements into automated solutions per development standards.


• Design, develop, test and support from SQL stored procedures, views, Informatica workflows, Control-M flows or script objects.


• Researches and resolves data issues identified by business users, IT operations, or partners.


• Executes unit and system test scripts, analyzes, captures, and publishes test results.


• On-Call rotation to support Data Engineering solutions.


• Mentors junior staff members in all areas of database engineering.


• Ensures development standards are maintained and best practices in development are demonstrated through official peer review.


• Identifies opportunities to create efficiencies in technical work streams as well as in operational procedures of team.

Requirements:

• Bachelor’s degree in IT related fields preferred.


• Minimum 5 years of Informatica PowerCenter development experience with SQL Server or other relational databases.


• Minimum 3 years of Control M development experience.


• Excellent SQL coding abilities to write SQL, T-SQL, stored procedures, and views.


• Development experience must be full-lifecycle experience, including business requirements gathering, data sourcing, testing/data reconciliation, deployment, and data automation practices.


• Outstanding analytical and problem-solving skills.


• Excellent written and verbal communication skills.


• Able to lead multiple complex projects and communicate clearly with leaders and team members.


• Ability to handle a fast-paced environment.


• Ability to maintain confidentiality


• Ability to work well with people from many different disciplines with varying degrees of technical experience.


• Contribute towards projects by getting involved in technical details and performing hands on tasks.


• Be able to understand the business needs and become an SME in their areas.


• Take ownership of their assigned projects and be responsible for successful delivery.

Nice to have skills:

• Experience Data Governance, Risk & Regulatory projects.


• Financial Services (Lending) experience.


• Experience with Cloud & Big Data technologies.

Location : Dallas TX (Hybrid)

Salary Range: The salary for this position is between $70,000 to $80,000 annually. Factors which may affect pay within this range may include geography/market, skills, education, experience, and other qualifications of the successful candidate.

Benefits: The Company offers the following benefits for this position, subject to applicable eligibility requirements: [medical insurance] [dental insurance] [vision insurance] [401(k) retirement plan] [long-term disability insurance] [short-term disability insurance] [5 personal days accrued each calendar year. The Paid time off benefits meet the paid sick and safe time laws that pertains to the City/ State] [10-15 days of paid vacation time] [6 paid holidays and 1 floating holiday per calendar year] [Ascendion Learning Management System]

Want to change the world? Let us know.

Tell us about your experiences, education, and ambitions. Bring your knowledge, unique viewpoint, and creativity to the table.

Let’s talk!