Apply on Employer Site

Royal Cyber Inc. · 1 month ago

Informatica Lead Engineer

Naperville, Illinois, United States

Full-time

Onsite

Lead/Staff

10+ years exp

Royal Cyber Inc. is seeking an experienced Lead Informatica Engineer to join their Data Engineering team. The ideal candidate will design, develop, and maintain complex data integration solutions using Informatica tools to support business applications and analytics.

AnalyticsDevOpsInformation TechnologyInternetSoftware

Growth Opportunities

H1B Sponsor Likely

Responsibilities

Design, develop, and implement ETL (Extract, Transform, Load) workflows using Informatica PowerCenter & Informatica Developer to support data integration and data warehousing initiatives

Optimize and tune Informatica mappings, sessions, and workflows for performance and scalability

Collaborate with data architects, analysts, and business stakeholders to gather requirements and translate them into technical specifications

Ensure data quality, integrity, and security across all data integration processes

Troubleshoot and resolve issues in ETL processes, providing root cause analysis and implementing solutions

Lead the migration of legacy ETL processes to modern Informatica solutions or cloud-based platforms (e.g., Informatica Cloud)

Mentor junior engineers and provide technical guidance on best practices for Informatica development

Maintain documentation for ETL processes, data flows, and system architecture

Stay updated on Informatica product advancements and industry trends to recommend innovative solutions

Qualification

Informatica PowerCenterETL developmentSQLData warehousingPerformance tuningInformatica certificationsCloud platformsLeadership skillsProblem-solving skillsCommunication skills

Required

Should have knowledge on Talend ETL

Bachelor's degree in Computer Science, Information Systems, or equivalent experience

10+ years of experience in ETL development with Informatica PowerCenter or Informatica Cloud

Proficiency in designing and developing complex mappings, transformations, and workflows

Strong knowledge of SQL, PL/SQL, and relational database systems (e.g., Oracle, SQL Server, MySQL)

Experience with data warehousing concepts and tools (e.g., Snowflake, Redshift)

Familiarity with cloud platforms (e.g., AWS, Azure, Google Cloud) and Informatica Cloud (IICS) is a plus

Expertise in performance tuning and optimization of ETL processes

Strong understanding of data modeling, data integration, and data governance principles

Excellent problem-solving, communication, and leadership skills

Informatica certifications (e.g., PowerCenter Developer, Data Integration) are highly desirable

Preferred

Experience with other ETL tools (e.g., Talend, SSIS) or big data technologies (e.g., Hadoop, Spark)

Knowledge of scripting languages (e.g., Python, Shell) for automation

Experience with Power BI

Experience with Agile development methodologies

Company

Royal Cyber Inc.

Glassdoor4.1

Royal Cyber is a trusted global IT consulting & digital transformation partner, empowering enterprises for over two decades to evolve with agility, security, and innovation.

Founded in 2002

Naperville, Illinois, USA

1001-5000 employees

http://www.royalcyber.com/

H1B Sponsorship

Royal Cyber Inc. has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2025 (39)

2024 (35)

2023 (32)

2022 (35)

2021 (21)

2020 (34)