Specialist Software Engineer - IDMC_ 26000HTW

Unlock New Career Horizons with SA Technologies Inc. We're Hiring in Bangalore At SA Technologies Inc., we believe in turning career aspirations into reality. As an NSE Listed company, recognized as a CMMI Level 5 organization, a Great Place to Work Certified company, and one of the Best Places for Women, we are committed to creating a workplace that is inclusive, excellent, and supportive. Job Summary: Job Description - Specialist Software Engineer - IDMC ( Missions Informatica Data Management Cloud (IDMC) developer with good Database and UNIX knowledge JD: · Strong experience in ETL design, data analysis, ETL logic development, deployment, and support of Data Warehouse solutions using Informatica Intelligent Data Management Cloud (IDMC), SQL, and Unix. · Good hands-on experience with Snowflake and strong proficiency in Snowflake SQL. · Having good UNIX shell scripting knowledge. · Good understanding of fundamental Data-Warehousing concepts such as Dimensional Modelling, Star and Snowflake Schemas, Data marts, deployment, FACT and Dimensional tables. · Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes. · Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions. · Extensive experience in ETL design, development, maintenance & optimization of ETL processes for performance. · Well versed in developing the complex SQL queries, unions and multiple tables joins and experience with Views. · Control M(Scheduling) – Should have basic knowledge in creating control-m jobs and creating dependencies. · GIT(Version control) – Should have basic knowledge on maintaining versions via GIT · Familiarity with CI/CD processes and DevOps practices - Good to Have · Exposure to Cloud Platforms - Good to Have Responsibilities: · Responsible for the development, implementation, and support of ETL processes and data warehouse solutions using Informatica IDMC. · Collaborate with business analysts, developers, and stakeholders to understand requirements and deliver high-quality data integration solutions. · Design, develop, optimize, and troubleshoot ETL workflows and mappings. · Develop and optimize complex SQL queries with a strong understanding of database concepts. · Develop, maintain, and enhance Unix shell scripts to meet business requirements. · Support and contribute to CI/CD pipelines, ensuring smooth deployment, automation, and operational stability across environments. Skill set: · Informatica Data Management Cloud (IDMC), Snowflake, Unix, Control-M, Git What Makes SA Technologies Inc. Special: A Celebrated Workplace: A Great Place to Work Certified and recognized as one of the Best Places for Women. A Beacon of Excellence: A CMMI Level 5 Company, ensuring we deliver only the best. Global Impact: A Microsoft Gold Partner and Google Partner, with a 20-year history of delivering global IT consulting and development solutions.