Senior Data Engineer- ETL

Location: Omaha, NE

Job Description: We are looking for a skilled and detail-oriented Data Engineer to join our team. As a Data Engineer, you will be responsible for designing, developing, and maintaining our data architecture and infrastructure. The ideal candidate should have a strong understanding of data management, ETL processes, and data modeling, along with proficiency in relevant programming languages and tools. Key Responsibilities: Informatica Development:

Design, develop, and maintain ETL processes using Informatica PowerCenter. Utilize Informatica for data integration, transformation, and loading tasks.

Data Architecture and Design:

Collaborate with stakeholders to understand data requirements and design scalable and efficient data architectures using Informatica. Implement and maintain data models, database schemas, and structures within the Informatica environment.

ETL Optimization:

Optimize and troubleshoot Informatica workflows and mappings for performance and reliability. Implement best practices for Informatica development to ensure efficiency and scalability.

Database Management:

Experience with database systems (MS SQL, Oracle, Snowflake, etc.) Develop and manage large-scale databases within the Informatica environment, ensuring data integrity and security. Implement and maintain database solutions, including indexing, partitioning, and optimization, using Informatica tools.

Data Quality and Testing:

Implement data quality standards and best practices within the context of Informatica development. Conduct testing procedures using Informatica tools to validate data accuracy, completeness, and consistency.

Collaboration:

Collaborate with cross-functional teams, including data scientists, analysts, and business stakeholders, to understand data needs and deliver effective Informatica solutions. Work closely with the IT team to integrate Informatica data solutions into existing systems.

Documentation:

Create and maintain technical documentation for Informatica data architectures, ETL processes, and data models. Document data flows, transformations, and dependencies within the Informatica environment.

Education and Qualifications:

Bachelor's or Master's degree in Computer Science, Data Science, Management Information Systems, or a related field. Proven experience as a Data Engineer with a focus on Informatica development. Strong understanding of data management concepts, ETL processes, and data modeling within the Informatica environment. Proficiency in Informatica PowerCenter and other Informatica tools. Experience with database systems (MS SQL, Oracle, Snowflake) and database design principles.

Preferred Skills:

Familiarity with Informatica PowerCenter Understanding of data governance and compliance standards related to Informatica development. Familiarity with version control systems as applied to Informatica projects. Strong problem-solving and critical-thinking skills. Excellent communication and interpersonal skills. Ability to drive technical discussions and decisions. Experience with RESTful APIs and integration. Ability to learn and adapt to new technologies quickly.

Equivalent combinations of education and experience that result in the required level of knowledge skill and competence will be considered.

Required Skills : ETL Informatica PowerCenter database systems (MS SQL, Oracle, Snowflake) Must be local to Omaha or willing to travel to Omaha from surrounding states Background Check :Yes Drug Screen :Yes Notes : Selling points for candidate : Project Verification Info : Candidate must be your W2 Employee :Yes Exclusive to Apex :Yes Face to face interview required :No Candidate must be local :No Candidate must be authorized to work without sponsorship ::No Interview times set : :No Type of project : Master Job Title : Branch Code :