Associate Informatica

4 weeks ago


Chicago, United States BlueCloud Full time

We are looking for a candidate to provide Informatica PowerCenter development and production support, 2 years of Informatica Center experience

Nice to have:
Data Quality (IDQ), IICS,Control M, SSMS expertise to design and build the required Solutions for our Clients.

Responsibilities

  • Independently plans, designs, develop, executes and monitor complex data integration activities to support project delivery and daily operation.
  • Experience in defining, implementing, debugging and optimizing data integration mappings and scripts from a variety of data sources.
  • Development of ETL code, metadata definition and models, queries, scripts, schedules, work processes and maintenance procedures and identify opportunities to optimize the sizing, performance and efficiency of existing processes/procedures.
  • Perform the unit testing, system integration testing, regression testing and assist with user acceptance testing.
  • Consults with the business to develop documentation and communication materials to ensure accurate usage and interpretation of data.
  • Develops technical understanding of how the data flows from various source systems and source types to fine tune data integration solution.
  • Work independently or as part of a team to deliver data warehouse ETL projects.
  • Adhere to established standards and best practices and provide input for improvement of those processes.
  • Self-motivated team player who can work with minimal supervision and can adapt to a quickly changing environment.
  • Maintain a high-volume data warehouse application.
  • Ability to work on multiple task simultaneously, ability to switch between tasks and work in conflicting priorities
Experience and Education:
  1. At least 2 plus years of relevant experience is desired.
  2. Having a Bachelors/Master's degree in Computer Science/Information Systems from a reputed University
  3. Strong computer science fundamentals.
  4. Strong in communications with business stakeholders
  5. Excellent technical, analytical and organizational skills.
  6. Effective written and verbal communication skills, including technical writing.
Technical Skills & Competencies
  • Must have hands-on experience with commercial integration products including,
    • PowerCenter 10.x (REQUIRED)
    • Data Integration Hub (nice to have)
    • PowerExchange (nice to have)
    • Informatica Cloud (nice to have)
    • Data Quality (nice to have)
    • Go Anywhere (nice to have)
    • experience in Windows PowerShell / UNIX Shell Scripting, Control-M to automate the job runs.
    • basic hands on MSSQL Server Database development experiences including:
      • Stored Procedures
      • Explain Plans
      • Constraints
      • Views
      • Materialized Views
      • Export/Import Utilities
    • Must have strong knowledge of Software Development Life Cycle including requirement analysis, design, development, testing, and implementation. Hands on experience in performance tuning of sources, targets, mappings and sessions.
    • Azure Data factory is a plus.
    • Support:
      • Ability to identify critical system health issue and flag them for discussion and resolution.
      • Constantly questioning due to fluid processes and complexity of environment.
      • Proven experience in common support activities including
        • User Management
        • Access management
        • Object management (folder, connections, rules etc..)
        • Backing up the repositories
        • Code migration across multiple environments
        • Performance diagnosis/improvement
        • Ability to handle and co-ordinate Sev1 tickets
    • Maintaining standards:
      • Proven experience in following standards and helping other adopt standards
      • Making sure that code is sync across all three environments.
      • Ensure development teams are following appropriate standards


  • Chicago, United States BlueCloud Full time

    We are looking for a candidate to provide Informatica PowerCenter development and production support, 2 years of Informatica Center experience Nice to have: Data Quality (IDQ), IICS,Control M, SSMS expertise to design and build the required Solutions for our Clients. ResponsibilitiesIndependently plans, designs, develop, executes and monitor complex data...


  • Chicago, United States Blue Cross Blue Shield Association Full time

    Blue Cross and Blue Shield Is currently seeking a ETL Systems Analyst in Washington, DC, or Chicago.Blue Cross Blue Shield Association, also known as BCBS, BCBSA, or The Blues, is a United States-based federation with 34 independent and locally operated BCBSA companies that provide health insurance in the United States to more than 115 million people as of...


  • Chicago, United States Blue Cross Blue Shield Association Full time

    Blue Cross and Blue Shield Is currently seeking a ETL Systems Analyst in Washington, DC, or Chicago.Blue Cross Blue Shield Association, also known as BCBS, BCBSA, or The Blues, is a United States-based federation with 34 independent and locally operated BCBSA companies that provide health insurance in the United States to more than 115 million people as of...


  • Chicago, Illinois, United States UL Solutions Full time

    JOB DESCRIPTIONDuties: Plan and lead data management activities such as designing data models and developing new data management practices. Conduct source system analysis and data profiling for lifecycle management. Define processes for data cleansing, validating, and transforming. Define requirements and implement data matching, merging rules, and...


  • Chicago, Illinois, United States AbbVie Full time

    Company DescriptionAbbVie's mission is to discover and deliver innovative medicines and solutions that solve serious health issues today and address the medical challenges of tomorrow. We strive to have a remarkable impact on people's lives across several key therapeutic areas immunology, oncology, neuroscience, and eye care and products and services in our...


  • Chicago, Illinois, United States AbbVie Full time

    Company DescriptionAbbVie's mission is to discover and deliver innovative medicines and solutions that solve serious health issues today and address the medical challenges of tomorrow. We strive to have a remarkable impact on people's lives across several key therapeutic areas – immunology, oncology, neuroscience, and eye care – and products and services...


  • North Chicago, United States AbbVie Full time

    Company Description AbbVie's mission is to discover and deliver innovative medicines and solutions that solve serious health issues today and address the medical challenges of tomorrow. We strive to have a remarkable impact on people's lives across several key therapeutic areas – immunology, oncology, neuroscience, and eye care – and products and...


  • North Chicago, United States AbbVie Full time

    Company DescriptionAbbVie's mission is to discover and deliver innovative medicines and solutions that solve serious health issues today and address the medical challenges of tomorrow. We strive to have a remarkable impact on people's lives across several key therapeutic areas immunology, oncology, neuroscience, and eye care and products and services in...


  • North Chicago, United States AbbVie Full time

    Job DescriptionAbbVie Information Research is seeking an Associate Data Engineer who would contribute to the architecture, design, and development of the Data & Analytics Platform, supporting world-class research and development at AbbVie. As an Associate Data Engineer, you will be a core member of a high-performance team of data engineers and architects...


  • North Chicago, United States Abbvie Full time

    Company DescriptionAbbVie's mission is to discover and deliver innovative medicines and solutions that solve serious health issues today and address the medical challenges of tomorrow. We strive to have a remarkable impact on people's lives across several key therapeutic areas – immunology, oncology, neuroscience, and eye care – and products and services...


  • North Chicago, IL, United States Abbvie Full time

    Company DescriptionAbbVie's mission is to discover and deliver innovative medicines and solutions that solve serious health issues today and address the medical challenges of tomorrow. We strive to have a remarkable impact on people's lives across several key therapeutic areas – immunology, oncology, neuroscience, and eye care – and products and services...


  • North Chicago, United States AbbVie Full time

    Job DescriptionJob DescriptionCompany DescriptionAbbVie's mission is to discover and deliver innovative medicines and solutions that solve serious health issues today and address the medical challenges of tomorrow. We strive to have a remarkable impact on people's lives across several key therapeutic areas – immunology, oncology, neuroscience, and...

  • DevOps Engineer

    5 days ago


    Chicago, United States McDonald's Corporation Full time

    Company Description McDonald’s evolving Accelerating the Arches growth strategy puts our customers and people first, and uses our competitive advantages to strengthen our brand. We are recognized on lists like Fortune’s Most Admired Companies and Fast Company’s Most Innovative Companies. Doubling Down on the 4Ds (Delivery, Digital, Drive Thru, and...


  • Chicago, United States PatientPoint Full time

    Job DescriptionJob DescriptionJoin PatientPoint to be part of a dynamic team committed to empower better health. As a leading digital health company, we innovate to positively impact patient behaviors. Our purpose-driven approach offers an inspirational career opportunity where you can contribute to improving health outcomes for millions of patients...


  • Chicago, United States Mars Full time

    Job Description:At Mars Snacking, we are on an ambitious journey to rewire and almost double the size of our business by 2030.  We see digital and data as an increasing multiplier of value across not just Mars Wrigley, but also the Health and Wellness and Retail global business units of Mars Snacking.With this in mind, we recently established the Chief Data...

  • Data Engineer

    5 days ago


    Chicago, Illinois, United States Danaher Full time

    Leica Biosystems' mission of "Advancing Cancer Diagnostics, Improving Lives" is at the heart of our corporate culture. We're a global leader in cancer diagnostics with the most comprehensive portfolio from biopsy to diagnosis. Our easy-to-use and consistently reliable offerings help improve workflow efficiency and diagnostic confidence.Our associates know...

  • DevOps Engineer

    5 days ago


    Chicago, Illinois, United States McDonald's Global Technology Full time

    Job DescriptionCompany Description:McDonald's new growth strategy, Accelerating the Arches, encompasses all aspects of our business as the leading global omni-channel restaurant brand. As the consumer landscape shifts we are using our competitive advantages to further strengthen our brand. One of our core growth strategies is to Double Down on the 4Ds...


  • Chicago, United States Mars Full time

    Job Description:At Mars Snacking, we are on an ambitious journey to rewire and almost double the size of our business by 2030.  We see digital and data as an increasing multiplier of value across not just Mars Wrigley, but also the Health and Wellness and Retail global business units of Mars Snacking.With this in mind, we recently established the Chief Data...


  • Chicago, United States Mars Full time

    Job Description:At Mars Snacking, we are on an ambitious journey to rewire and almost double the size of our business by 2030.  We see digital and data as an increasing multiplier of value across not just Mars Wrigley, but also the Health and Wellness and Retail global business units of Mars Snacking. With this in mind, we recently established the Chief...


  • Chicago, United States Mars Full time

    Job Description:Locations:Chicago (US), New Jersey (US), Slough (UK), London (UK)Job Description:At Mars Snacking, we are on an ambitious journey to rewire and almost double the size of our business by 2030.  We see digital and data as an increasing multiplier of value across not just Mars Wrigley, but also the Health and Wellness and Retail global business...