IT Engineer

Job Summary:

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.

Responsibilities:

1. ETL/ELT Development:
   
   • Design, develop, and maintain ETL/ELT processes using Informatica PowerCenter or relevant tools.
   • Utilize Informatica for data integration, transformation, and loading tasks from various sources.
2. 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.
3. ETL Optimization:
   
   • Optimize and troubleshoot Informatica workflows and mappings for performance and reliability.
   • Implement best practices for Informatica development to ensure efficiency and scalability.
4. 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.
5. 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.
6. 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
7. 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.

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/ELT processes, and data modeling.
• Proficiency in Informatica PowerCenter and other Informatica tools.
• Experience with database systems (MS SQL, Oracle, Snowflake) and database design principles.

Preferred Skills:

• Experience with Informatica PowerCenter, Python, SQL, and Snowflake.
• Experience with Tableau and other data visualization tools and concepts.

• Understanding of data governance and compliance standards related to Informatica development.
• Familiarity with version control systems.

• 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.
• Understanding of agile development methodologies.
• Ability to learn and adapt to new technologies quickly.