Experience: 2+ years

Minimum Education Requirement: This is a professional position, and as such, we require, at minimum, a Bachelor’s degree in computer science, information technology, or a combination of education and experience equating to the U.S. equivalent of a Bachelor’s degree in one of the aforementioned subjects.

Salary Range: $114754.00 to $114800.00 per year

Job Description:

• Design, develop, and maintain ETL workflows, mappings, and task flows using Informatica PowerCenter and IDMC/IICS.
• Build and optimize data integration solutions to load data into Data Warehouses and Data Lakes.
• Develop and maintain SQL queries, PL/SQL procedures, database tables, views, and stored programs.
• Create real-time integrations using Informatica Cloud Application Integration (CAI).
• Design dimensional data models including Star Schema, Snowflake Schema, Fact and Dimension tables.
• Develop Unix shell scripts and Python scripts for file processing, automation, and data movement.
• Implement cloud-based data ingestion solutions using Google Cloud Storage and Google BigQuery.
• Perform data validation, unit testing, SIT, UAT, and production support activities.
• Monitor data quality, resolve data issues, and ensure data integrity across systems.
• Analyze and optimize ETL performance through tuning, pushdown optimization, and process enhancements.
• Troubleshoot production issues, perform root cause analysis, and implement corrective actions.
• Manage source code and deployments using GitHub and CI/CD pipelines across multiple environments.
• Collaborate with Business Analysts, QA teams, and stakeholders to gather requirements and deliver solutions.
• Create technical design documents, maintain project documentation, and update JIRA/Confluence artifacts.
• Participate in code reviews, data lineage analysis, release management, and mentor junior team members.

Share your resumes at career@cloudbridgeusa.com