ETL IICS/ IDMC Specialist

2 weeks ago

Gurugram, India Axtria - Ingenious Insights Full time

Job Role: ETL Technical Lead

ELIGIBILITY CRITERIA:

Work Experience: Overall 5+ years of experience working on Databases, Data Warehouse, Data Integration and BI/Reporting solutions with relevant experience in Lifesciences/Pharma domain .

Technical:

  • Design and implement effective database solutions and data models to store and retrieve data.
  • Hands on experience in the design of reporting schemas, data marts and development of reporting solutions.
  • Prepare scalable database design and architecture in terms of defining multi-tenants’ schemas, data ingestion, data transformation and data aggregation models.
  • Should have expertise and working experience in at least ETL tools among Informatica IICS/ IDMC
  • Should have expertise and working experience in at least 2 DBMS/appliances among Redshift, SQL Server, PostgreSQL, Oracle.
  • Should have strong Data Warehousing, Reporting and Data Integration fundamentals.
  • Advanced expertise with SQL
  • Experience on DB/DW related service offerings.
  • Should have knowledge and experience of Big Data Technologies (Hadoop ecosystem) and NO SQL databases.
  • Should have technical expertise and working experience in at least 2 Reporting tools among Power BI, Tableau, Jasper soft and QlikView/QlikSense
  • Advanced technical Competencies in SQL


Education: BE/B.Tech/Master of Computer Application

Role & Responsibilities

  • To be a Data expert/Architect in implementing solutions using Databases/ETL/DWH/Data Integration/Reporting tools with prior experience in the Pharma/Lifesciences domain. Should have an overall 4+ years of relevant experience in Databases, Data Warehousing, Data Integration and BI/Reporting solutions with experience in pharma or life sciences domain.
  • Technology Leadership – Independently he/she should be able to architect, design, implement deliver complex Databases/Data Warehousing/Data Lake, Data Integration and BI/Reporting Solutions.
  • Work with stakeholders to understand business objectives and develop value-added data driven solutions, frameworks and reporting solutions.
  • Architecture/Technical Design and Development – Expertise in any 2 ETL tools (Informatica, Talend, Matillion, Data Stage), and cloud-based technologies like AWS S3 is mandatory.
  • Expert knowledge of SQL with the capability to performance tune complex SQL queries in tradition and distributed RDDMS systems is must.
  • Hands on experience across Python, PySpark and Unix/Linux Shell Scripting.
  • Logical Thinking – Able to think analytically, use a systematic and logical approach to analyse data, problems, and situations.
  • Communication – Able to convey ideas and information clearly and accurately to self or others whether in writing or verbal.
  • Task/Team Management/Collaboration – Should be able to manage technical team and delegate tasks to accomplish milestones as per plan. Should be comfortable in discussing and prioritizing work items with team members in an onshore-offshore model.

  • IICS Developer

    1 month ago

    Gurgaon/Gurugram, India Randstad Digital Full time

    Role : IICS Developer Experience : 4-6 YearsLocation : Gurgaon (Hybrid)Notice Period : Looking for Immediate Joiners only.Job Description : We are seeking an experienced IICS Developer to design, develop, and maintain robust data integration solutions using Informatica Intelligent Cloud Services (IICS). The ideal candidate will have a strong background...

  • ETL Tester

    2 weeks ago

    Gurugram, India Appzlogic Full time

    Salary : 12-13lpaAbout the Role :1. We are seeking an experienced ETL QA Engineer with a solid background in ETL testing using Informatica PowerCenter, Informatica IDMC, and a strong foundation in SQL and PL/SQL. 2. The ideal candidate should have expertise in data warehousing concepts and ETL processes and should be able to work in an Agile environment....

  • Business Technology Solutions Associate- Iics

    1 month ago

    Gurugram, Haryana, India ZS Associates Full time

    Gurgaon, India India Technology Business Technology Solutions - 21382 ZS is a place where passion changes lives. As a management consulting and technology firm focused on improving life and how we live it, our most valuable asset is our people. Here you’ll work side-by-side with a powerful collective of thinkers and experts shaping life-changing solutions...

  • Business Intelligence Developer

    1 month ago

    Gurgaon/Gurugram/Delhi NCR/Delhi/Pune/Hyderabad, India Globner Consulting LLP Full time

    Job Description : Your key tasks & responsibilities : - Working in an international project team for the implementation of the OneBI (Centralize BI Services) to enhance the reporting solutions in an agile development environment - Design & implement BI solutions with ETL/ELT pipelines, database model, Streaming and CDC, independently/self-contained with...

  • IICS Senior Developer

    2 months ago

    Gurugram, India Invokhr Full time

    Software Developer Senior – Financial Systems From coast-to-coast, our inspiring colleagues are at the heart of what we do best: helping people, businesses and society prosper in good times and be resilient in bad times. With our team, you’ll bring this purpose to life every day by living our Values, being open to change, and pursuing your goals. At...

  • Data Integration Specialist

    2 weeks ago

    Bangalore/Delhi NCR/Delhi/Gurgaon/Gurugram, India Saarthee Full time

    Position Summary : We are seeking an experienced Data Integration Specialist / ETL Data Engineer with expertise in integrating data from SAP BW, HANA, and external sources into SAP Analytics Cloud (SAC). The ideal candidate will have extensive experience with ETL processes and tools, as well as a strong understanding of data governance and compliance...

  • ETL Data Quality Specialist

    1 month ago

    Pune/Noida/Gurgaon/Gurugram, India Spectral Consultants Full time

    Key Responsibilities:As an ETL Tester at Spectral Consultants, you will play a crucial role in ensuring the seamless integration of data from various sources into our data warehouse. Your primary focus will be on requirement analysis, test planning, and execution to guarantee the accuracy and reliability of our ETL processes.Key Responsibilities:-...

  • Software Developer Senior – Financial Systems

    2 months ago

    gurugram, India RSA India (An Intact Company) Full time

    You’ll also handle many key responsibilities: Design, develop and maintain Informatica cloud assets using the appropriate data load techniques. Debug and tune Data Integration, Application Integration and Mass Ingestion assets; analyze data warehouse architecture, troubleshoot and recommend improvements and alternate methodologies. Participate in code...

  • Software Developer Senior – Financial Systems

    2 months ago

    Gurugram, India RSA India (An Intact Company) Full time

    You’ll also handle many key responsibilities: Design, develop and maintain Informatica cloud assets using the appropriate data load techniques.Debug and tune Data Integration, Application Integration and Mass Ingestion assets; analyze data warehouse architecture, troubleshoot and recommend improvements and alternate methodologies.Participate in code...

  • Software Developer Senior – Financial Systems

    2 months ago

    gurugram, India RSA India (An Intact Company) Full time

    You’ll also handle many key responsibilities: Design, develop and maintain Informatica cloud assets using the appropriate data load techniques.Debug and tune Data Integration, Application Integration and Mass Ingestion assets; analyze data warehouse architecture, troubleshoot and recommend improvements and alternate methodologies.Participate in code...

  • Software Developer Senior – Financial Systems

    1 month ago

    gurugram, India RSA India (An Intact Company) Full time

    You’ll also handle many key responsibilities: Design, develop and maintain Informatica cloud assets using the appropriate data load techniques. Debug and tune Data Integration, Application Integration and Mass Ingestion assets; analyze data warehouse architecture, troubleshoot and recommend improvements and alternate methodologies. Participate in code...

  • Software Developer Senior – Financial Systems

    2 months ago

    Gurugram, India RSA India (An Intact Company) Full time

    You’ll also handle many key responsibilities: Design, develop and maintain Informatica cloud assets using the appropriate data load techniques. Debug and tune Data Integration, Application Integration and Mass Ingestion assets; analyze data warehouse architecture, troubleshoot and recommend improvements and alternate methodologies. Participate in code...

  • Software Developer Senior – Financial Systems

    2 months ago

    Gurugram, India RSA India (An Intact Company) Full time

    You’ll also handle many key responsibilities: Design, develop and maintain Informatica cloud assets using the appropriate data load techniques.Debug and tune Data Integration, Application Integration and Mass Ingestion assets; analyze data warehouse architecture, troubleshoot and recommend improvements and alternate methodologies.Participate in code...

  • Oracle Hyperion Developer

    1 month ago

    Gurugram, India ZKonsult Innovative Solutions Private Limited (ZISPL) Full time

    4.5+ Years of strong development skill with Essbase and Hyperion Planning Experience in Hyperion EPM Cloud (PBCS/EPBCS) is MUST scripting and integration (use of API / EPM Automate) with on-premise systems Strong knowledge on Business rules Good Windows Batch / PowerShell scripting experience Strong understanding & hands-on skills on ETL & Integration...

  • ETL Tester

    3 days ago

    Pune/Noida/Gurgaon/Gurugram, India Spectral Consultants Full time

    About Spectral ConsultantsWe are a leading consulting firm providing expert services in data transformation and management.Job Description:Key ResponsibilitiesValidate data extracted from source systems to ensure accuracy and consistency.Develop comprehensive test plans to outline the scope, objectives, resources, schedule, and testing strategy for ETL...

  • PLM Application Specialist

    4 months ago

    Gurugram, India Siemens Energy Full time

    PLM Application Specialist About the Role Location India Haryana Gurugram Company Siemens Energy Industrial Turbomachinery India Private Limited Organization EVP Global Functions Business Unit Digital Core Full / Part time Full-time Experience Level Experienced Professional Snapshot of Your Day: As a PLM Teamcenter Migration...

  • Data Engineer

    5 days ago

    Remote/Gurgaon/Gurugram, India StatusNeo Technology Consulting Pvt. Ltd Full time

    Job DescriptionRole: Data EngineerWe are seeking an experienced Data Engineer to join our team at StatusNeo Technology Consulting Pvt. Ltd.About the RoleThis role involves assisting in data retrieval from multiple source systems, data processing and cleansing, constructing automated data pipelines, and updating the serving layer for analytics and...

  • Data Specialist Integration

    6 months ago

    Gurugram, India Sun Life Full time

    Job Description : The role is of Data Specialist, Integration who has hands-on experience AWS DMS, Glue and Athena. The candidate must be familiar at least in one Data ware housing concepts such as ODS/Marts and must have done at least one end to end data processing pipeline designing. Nice to have familiarity with AutoSys (job scheduler) and MDM (master...

  • MDM Developer

    3 months ago

    Gurugram, India Corestaffing Solutions Full time

    Job Description :- Develop and support MDM solutions - Contribute to a team responsible for designing, developing, optimizing, and maintaining the master data (MDM) processes- Understand overall data strategies and roadmaps- Assemble large, complex sets of data to meet non-functional and functional requirements- Partners with Solution Architects to perform...

  • Assoc. Manager, Data Engineering

    3 months ago

    Gurugram, India Yum! Brands Full time

    As Associate Manager, Data Engineering, you will:  Lead the team of Data Engineers and develop innovative approaches on performance optimization & automation  Analyzing enterprise specifics to understand current-state data schema and data model and contribute to define future-state data schema, data normalization and schema integration as required...