Associate Informatica / ETL Developer (India) Job at BlueCloud, Chicago, IL

OGlydUdPUmNlWko3T0Z6OEIyUmlqa2xpeFE9PQ==
  • BlueCloud
  • Chicago, IL

Job Description

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

Job Tags

Similar Jobs

ENGINEERINGUK

Director, Expedia Brand Analytics Job at ENGINEERINGUK

You will need to login before you can apply for a job.Employer: Expedia GroupLocation: Seattle, Washington, United StatesSalary: USD 224,000.00 - 313,500.00; USD 358,500.00Closing date: 23 Jan 2025Expedia Group brands power global travel for everyone, everywhere. We... 

Lorven Technologies

Web Developer Job at Lorven Technologies

Hi, Our client is looking Web Developer for Full-time project in Austin, TX / Sunnyvale, CA (Onsite) below is the detailed...  ...: Full-time Note: Candidate should be expertise in Web development in both front end and backend development with DB experience.... 

SUNSHINE ENTERPRISE USA LLC

Fire Alarm Tester & Inspector Job at SUNSHINE ENTERPRISE USA LLC

 ...Job Description Company Summary: Our client is a leading provider of fire protection solutions to businesses, that also specialize in uniforms, facility services, and first aid and safety products. Position Summary: An ideal candidate shall have NICET Licensing... 

AMEEN AL-OBAIDI DENTISTRY PROFESSIONAL CORPORATION

Dental Receptionist - Redwood Dental Job at AMEEN AL-OBAIDI DENTISTRY PROFESSIONAL CORPORATION

 ...Job Description Job Description Redwood Dental is looking for a full-time dental receptionist to help take care of our amazing patients. We appreciate our team players and their hard work and we have an excellent work family environment. The ideal candidate is an enthusiastic... 

CoolSys

HVAC Install Manager - Commercial & Industrial Job at CoolSys

 ...solutions company. Our full spectrum of best-in-class services includes HVAC & refrigeration installations, remodels, service & maintenance;...  ...Responsibilities: Reports to Director of Service . Manage revenue, margins and PM adds by tech. Recruiting, hiring and...