ETL Developer - Informatica/Data Warehousing @ Advance Immigrations

Job Description

Design, develop, and maintain efficient, reusable, and reliable ETL processes using Informatica IICS. Work closely with business analysts, data architects, and other stakeholders to understand data requirements and translate them into technical specifications. Implement complex ETL logic to facilitate the extraction, transformation, and loading of data from a wide variety of data sources into a centralized data warehouse. Perform data profiling and quality checks to ensure accurate and clean data is loaded. Optimize and tune ETL processes to improve performance and reduce load times. Collaborate with IT and data governance teams to ensure compliance with data security and privacy policies. Develop and maintain documentation for ETL processes, including data flow diagrams, data models, and ETL specifications. Provide technical leadership and mentorship to junior ETL developers. Stay current with the latest trends and. technologies in ETL and data integration to recommend improvements and innovations. Business Intelligence developer in ETL areas, contributing to the development and able to identify avenues for automation. Implement best practices and drive adoption around coding, design, quality, and performance. Work collaboratively with other teams to foster an environment of respect, open communication, and cross-functional expertise. What You Know 1+ years experience working on Hyperion Essbase Planning cloud along with data loads and metadata load automation. Should have experience on Calc Script, Report scripts, Rules files and application optimization. 1+ years in developing data warehousing applications using ODI or any Enterprise ETL Tools like DataStage Informatica in extracting, ingesting, processing of large data sets by building data pipelines. 1+ years of experience in migration process, Lifecycle Management and Hyperion Financial Reporting. 1+ years Working experience of Data warehousing, Data modelling, Governance and Data Architecture in designing data base objects. Experience in building modern dimensional models to improve accessibility, efficiency, and quality of data. Exposure to automation efforts using Configuration Management, and Continuous Integration (CI) / Continuous Delivery (CD) tools such as Jenkins, Codefresh etc. Experience working in Agile and Scrum development process. (ref:hirist.tech

Employement Category:

Employement Type: Full time
Industry: Others
Role Category: Statistics / Analytics
Functional Area: Not Applicable
Role/Responsibilies: ETL Developer - Informatica/Data Warehousing

+ View Contact

Keyskills:   ETL Data Warehousing ODI DataStage Data Architecture Dimensional Modeling Configuration Management Continuous Integration Continuous Delivery Agile Scrum Informatica IICS Data Modelling Hyperion Essbase Planning Calc Script Report scripts Rules files