Sr. Informatica Developer

1 month ago

Bangalore, India TribolaTech Inc Full time

Looking for candidates who can join immediately or within 30 days Location: Bangalore or Hyderabad Experience : 8+ Years Our client believes in connecting people and business to Insurance in ways that are Innovative, Hyper-Relevant, Compelling and Personal. They bring together the brightest minds to build the future of Insurance; a world where Insurance makes life and business easier, more connected, and better protected. Sr ETL Profile – PowerCenter: Must know about the architecture of Power Center. Should have good understanding of SDLC and agile methodologies Should know the output files that are created by the Informatica server at runtime. ex. Logs and Cache files. Should know about all the transformations, workflows, mappings, mapplets and their use in Informatica? Must have to know about Session, Command, Email, Event-Wait and Event-Raise tasks. Must have to know unit test case scenarios to UAT with quality deliverables. Admin activities like connection setup, Repository backup, restore and working experience on configuring databases like Oracle, MS SQL Server and file systems and good to have experience on Sales Force, Cloud Applications. Good to have Unix scripting skills for writing shell scripts and troubleshoot of existing scripts Should analyze data warehouse architecture, normalized/de-normalized, star schemas and snowflakes, slowly changing dimensions, surrogate key handling, exception data processing, troubleshoot and recommend improvements and alternate methodologies. IICS: Should explain how the data integration process works and the architecture of IICS. Experienced with Informatica Intelligent Cloud Services. Must have hands-on on Application and Data integration services. Should define Informatica Cloud Secure Agent Configuration and load balancing. Must have to debug and tune data in the integration processes. Should know Rest API / API Calling experience / API Connectors. Experience in preparing the Test plan, Detailed Test cases, writing Test Scripts by decomposing Business Requirements and developing Test Scenarios to support quality deliverables. Should participate in code reviews and ensure that all solutions are aligned to pre-defined architectural and requirement specifications Should possess understanding on REST Calls – GET/POST/PUT/DELETE, OAUTH validations, Pagination URLs. Good to have understanding on Mass Ingestion. PL/SQL: Should lead the planning, design and implementation of complex data interfaces, transformations, and OLTP and OLAP databases. Must be proficient in creating Tables, Packages, Functions, Procedures, Views and Materialized Views. Must know on performance tuning to optimize a slow-running query. Should have to write complex queries using Subqueries, Correlated Subqueries, Merge statements and WITH clause statements. Must have to know different joins, Keys, Indexes used in SQL Queries. // *** Informatica + IICS experience + CDI *** // CAI is optional 1.Strong experience in Informatica Power center Version 10 and above , Control M. 2. Good experience in data Load from OLTP systems to OLAP systems. 3. Dimensional modeling experience 4. Strong experience in SQL. 5. Basic understanding on PL/SQL. 6. Basic understanding on Administrations (Source to Target connections & Import and Export the codes to Server. //* Please look for someone very strong in PowerCenter (Informatica ETL) *// Bachelor’s degree in engineering, or a related scientific or technical discipline with at least 6 years of relevant experience Experience extracting and summarizing data from a variety of data source types using Oracle SQL Experience in using Oracle PLSQL or SQL Plus Dimensional modeling experience Experience interfacing with business users and understanding their requirements Experience with Informatica 10 And or higher, Control-M , OBIEE, DAC ,Oracle 11.2.0.2 of higher Ability to learn and implement new and different techniques Strong Project Management skills Must have Understanding of business intelligence development in the IT industry Outstanding written and verbal communication skills ETL routines, Database skills Good to have: Tableau, Power BI Duties and responsibilities: Supporting data warehousing, data modeling, data integration, business intelligence and ETL processes Use Informatica Mapping Designer to create/update mapping using different transformations required to move data into data warehouse As the senior most ETL developer, take leadership of ETL tasks and supervise other ETL developers and solve difficult problems Develops ETL’s using Informatica to facilitate Extraction Transformation and data Load from OLTP systems to OLAP Responsible for installing, configuring, developing, support and maintenance of the BI Determine data storage needs – evaluate the exact storage needs to have clear picture of the current data situation and analyze different options to determine the best Design and create a data warehouse – designs a data warehousing system that meets needs and work with a development team to build the warehouse – conceptual, logical and physical data models to include data conversion, data conversion and data mining. Extract, Transformation and Load data – extract necessary data and transfer it to new Test and troubleshoot – test designs of new system to ensure smooth operations and fix any issues that Design schema using KPIs, Fact, Dimensions, Physical, Logical, Alias and Extension tables. Built Business Model and established relationships & Foreign Keys (Physical & Logical) between tables Identify and capture lessons learned, best practices, and information gained during performance

  • Informatica | Software Engineer | bangalore

    2 weeks ago

    bangalore, India Informatica Full time

    We're looking for a Software Engineer candidate with experience in Java to join our team in Bangalore Location. You will report to the Sr. Development Manager You will aspire to achieve challenging goals as part of your career objective. We are looking to hire a Software Engineer for the On-Prem Team, Informatica. Your Role Responsibilities? Here's What...

  • Informatica | Software Engineer | bangalore

    2 weeks ago

    bangalore, India Informatica Full time

    We're looking for a Software Engineer candidate with experience in Java to join our team in Bangalore Location.You will report to the Sr. Development ManagerYou will aspire to achieve challenging goals as part of your career objective. We are looking to hire a Software Engineer for the On-Prem Team, Informatica.Your Role Responsibilities? Here's What You'll...

  • Informatica | Product Specialist | bangalore

    7 days ago

    bangalore, India Informatica Full time

    Build Your Career at Informatica We're looking for a diverse group of collaborators who believe data has the power to improve society. Adventurous minds who value solving some of the world's most challenging problems. Here, employees are encouraged to push their boldest ideas forward, united by a passion to create a world where data improves the quality of...

  • Informatica | Product Specialist | bangalore

    23 hours ago

    bangalore, India Informatica Full time

    Build Your Career at Informatica We're looking for a diverse group of collaborators who believe data has the power to improve society. Adventurous minds who value solving some of the world's most challenging problems. Here, employees are encouraged to push their boldest ideas forward, united by a passion to create a world where data improves the quality of...

  • Informatica | Product Specialist | bangalore

    1 week ago

    bangalore, India Informatica Full time

    Build Your Career at InformaticaWe're looking for a diverse group of collaborators who believe data has the power to improve society. Adventurous minds who value solving some of the world's most challenging problems. Here, employees are encouraged to push their boldest ideas forward, united by a passion to create a world where data improves the quality of...

  • Informatica | Senior SDET | bangalore

    4 days ago

    bangalore, India Informatica Full time

    Build Your Career at Informatica We're looking for a diverse group of collaborators who believe data has the power to improve society. Adventurous, work-from-anywhere minds who value solving some of the world's most challenging problems. Here, employees are encouraged to push their boldest ideas forward, united by a passion to create a world where data...

  • Informatica | Senior SDET | bangalore

    4 days ago

    bangalore, India Informatica Full time

    Build Your Career at Informatica We're looking for a diverse group of collaborators who believe data has the power to improve society. Adventurous, work-from-anywhere minds who value solving some of the world's most challenging problems. Here, employees are encouraged to push their boldest ideas forward, united by a passion to create a world where data...

  • Informatica | Senior SDET | bangalore

    4 days ago

    bangalore, India Informatica Full time

    Build Your Career at InformaticaWe're looking for a diverse group of collaborators who believe data has the power to improve society. Adventurous, work-from-anywhere minds who value solving some of the world's most challenging problems. Here, employees are encouraged to push their boldest ideas forward, united by a passion to create a world where data...

  • Informatica | Principal Software Engineer | bangalore

    6 days ago

    bangalore, India Informatica Full time

    Build Your Career at InformaticaWe're looking for a diverse group of collaborators who believe data has the power to improve society. Adventurous, work-from-anywhere minds who value solving some of the world's most challenging problems. Here, employees are encouraged to push their boldest ideas forward, united by a passion to create a world where data...

  • Sr. Informatica Developer

    2 weeks ago

    Bangalore, India TribolaTech Inc Full time

    Sr. Informatica Developer Location: Bangalore or Hyderabad Experience : 6 to 8 Years Our client believes in connecting people and business to Insurance in ways that are Innovative, Hyper-Relevant, Compelling and Personal. They bring together the brightest minds to build the future of Insurance; a world where Insurance makes life and business easier,...

  • Sr. informatica developer

    3 weeks ago

    Bangalore, India TribolaTech Inc Full time

    Sr. Informatica Developer Location: Bangalore or Hyderabad Experience : 6 to 8 Years Our client believes in connecting people and business to Insurance in ways that are Innovative, Hyper-Relevant, Compelling and Personal. They bring together the brightest minds to build the future of Insurance; a world where Insurance makes life and business easier,...

  • Sr. Informatica Developer

    2 weeks ago

    bangalore, India TribolaTech Inc Full time

    Sr. Informatica Developer Location: Bangalore or Hyderabad Experience : 6 to 8 Years Our client believes in connecting people and business to Insurance in ways that are Innovative, Hyper-Relevant, Compelling and Personal. They bring together the brightest minds to build the future of Insurance; a world where Insurance makes life and business easier, more...

  • Sr. informatica developer

    1 month ago

    Bangalore, India TribolaTech Inc Full time

    Looking for candidates who can join immediately or within 30 days Location: Bangalore or Hyderabad Experience : 8+ Years Our client believes in connecting people and business to Insurance in ways that are Innovative, Hyper-Relevant, Compelling and Personal. They bring together the brightest minds to build the future of Insurance; a world where Insurance...

  • Sr. Informatica Developer

    3 weeks ago

    bangalore, India TribolaTech Inc Full time

    Sr. Informatica DeveloperLocation: Bangalore or HyderabadExperience : 6 to 8 YearsOur client believes in connecting people and business to Insurance in ways that are Innovative, Hyper-Relevant, Compelling and Personal. They bring together the brightest minds to build the future of Insurance; a world where Insurance makes life and business easier, more...

  • Sr. Informatica Developer

    3 weeks ago

    bangalore, India TribolaTech Inc Full time

    Sr. Informatica DeveloperLocation: Bangalore or HyderabadExperience : 6 to 8 YearsOur client believes in connecting people and business to Insurance in ways that are Innovative, Hyper-Relevant, Compelling and Personal. They bring together the brightest minds to build the future of Insurance; a world where Insurance makes life and business easier, more...

  • Sr. Informatica Developer

    4 weeks ago

    Bangalore City, India TribolaTech Inc Full time

    Sr. Informatica Developer Location: Bangalore or HyderabadExperience : 6 to 8 YearsOur client believes in connecting people and business to Insurance in ways that are Innovative, Hyper-Relevant, Compelling and Personal. They bring together the brightest minds to build the future of Insurance;a world where Insurancemakes life and business easier, more...

  • Sr. informatica developer

    3 weeks ago

    Bangalore City, India TribolaTech Inc Full time

    Sr. Informatica Developer Location: Bangalore or Hyderabad Experience : 6 to 8 Years Our client believes in connecting people and business to Insurance in ways that are Innovative, Hyper-Relevant, Compelling and Personal. They bring together the brightest minds to build the future of Insurance; a world where Insurancemakes life and business easier, more...

  • Sr. Informatica Developer

    4 weeks ago

    bangalore, India TribolaTech Inc Full time

    Sr. Informatica Developer Location: Bangalore or Hyderabad Experience : 6 to 8 Years Our client believes in connecting people and business to Insurance in ways that are Innovative, Hyper-Relevant, Compelling and Personal. They bring together the brightest minds to build the future of Insurance; a world where Insurance makes life and business easier, more...

  • Sr. Informatica Developer

    4 weeks ago

    bangalore, India TribolaTech Inc Full time

    Sr. Informatica Developer Location: Bangalore or HyderabadExperience : 6 to 8 YearsOur client believes in connecting people and business to Insurance in ways that are Innovative, Hyper-Relevant, Compelling and Personal. They bring together the brightest minds to build the future of Insurance; a world where Insurance makes life and business easier, more...

  • Sr. Informatica Developer

    2 weeks ago

    bangalore, India TribolaTech Inc Full time

    Sr. Informatica Developer Location: Bangalore or Hyderabad Experience : 6 to 8 Years Our client believes in connecting people and business to Insurance in ways that are Innovative, Hyper-Relevant, Compelling and Personal. They bring together the brightest minds to build the future of Insurance; a world where Insurance makes life and business easier, more...