ETL Developer (Informatica with Big Data) – IT MNC, Gurgaon

2 - 7 Years

Job Description

  • Responsible for developing ETL and Data Warehouse designs for any solution delivery impacting the Business Intelligence space. Responsible for independently leading best practice ETL and Data Warehouse design efforts to continually improve solution delivery.
  • Understanding of Big Data technologies, Hadoop and modern data architectures like Spark and NoSQL structures.
  • Build and optimize models using Data Science, Artificial Intelligence.
  • Experience delivering data pipelines and managing resulting data stores using managed cloud services (like AWS or Google Cloud Services)
  • Responsible for mentoring junior Bl ETL staff ensuring proper technical training, mentoring, and peer reviews are conducted in a positive way to ensure junior team member skills and career growth.
  • Responsible for maintenance of application programs, including reports, forms, alerts & any related interfaces.
  • Primary partner with business teams such as Supply Chain, Purchasing, Logistics, Services, Sales, and Finance to define business requirements.
  • Demonstrate the ability to develop quality technical solutions to support the required business intelligence solution.
  • Maintain peer relationships across IT areas (infrastructure, operations, etc.) to support effective implementations.
  • Provide ownership for development and test instances; ensure production move up process is done in a repeatable, coordinated and flawless manner.
  • Partner with Project and development teams to review new functionalities and develop test scenarios.
  • Responsible for staying on top of rapid technical changes in this field; is able to lead new technology introduction projects, migrate legacy Bl technologies to newer platforms, and recommend go forward technical platforms.
Key Skills:
  • Demonstrated experience with Informatica Power Center, Informatica Cloud Integrator, Oracle PLSQL, SQL Server, Oracle data bases.
  • Demonstrated experience both maintaining and enhancing existing ETL solutions but also in creating new solutions from scratch.
  • Demonstrated Experience with Data science, Big data, Autonomous databases and BI cloud technologies.
  • Demonstrated experience with understanding business operations; candidate must be prepared to detail past successful Bl ETL assignments and projects demonstrating their leadership and independence in solving the target business problem(s).
  • Understanding of change data capture solutions such as Oracle Golden Gate or Informatica CDC.
  • Demonstrated knowledge of analyzing business processes and transactional data systems.
  • Expert understanding of Oracle data base operations such as table indexing, partitioning, SQL tuning and Oracle standard compression.
  • Strong track record of understanding and interest in current and emerging technologies demonstrated through training, job experience and / or industry activities.
  • Demonstrated customer focus - evaluates decisions through the eyes of the customer.
  • Builds strong customer relationships and creates processes with customer viewpoint.
  • Strong analytical and strong problem-solving skills - candidate must be ab e to work effectively in with both the maintenance and change of as is existing solutions as well as lead the definition for new ETL data areas.
  • Change oriented - actively generates process improvements, supports and drives change and confronts difficult circumstances in creative ways

Salary: INR 8,50,000 - 18,50,000 P.A.

Industry:IT-Software / Software Services

Functional Area:IT Software - DBA, Datawarehousing

Role Category:Programming & Design

Role:Software Developer

Employment Type:Permanent Job, Full Time


Desired Candidate Profile

Minimum Requirement
  • Bachelor's Degree in Computer Science, MIS, Business, or IT related field (or minimum 5 years of hands-on, relevant, technical work experience).
  • Minimum 4 years of experience supporting or implementing Informatica solutions with Informatica Admin, and Level1 and Level 2 Developer Training.
  • Minimum 3 years of data warehouse design and Informatica and SQL query development and tuning.
  • Hands on experience in PL/SQL, data modeling and large-scale data warehouse.
  • Good to have experience with OBIEE, Microsoft Power BI, BI Publisher, Thoughtspot, Azure Data lake analytics or any other reporting tools experience.
  • Prior experience with Oracle ERP, Salesforce and Workday is a big plus.
  • Understanding of business processes for Supply Chain, Finance, Sales, HR is a big plus
  • Exposure to Data science, Big data, Autonomous databases and BI cloud technologies is a plus
  • Experience in Agile delivery model
  • Strong communications skills

Company Profile

Leinex Consulting

* Headquartered in US, R&D centres in US, Canada & Gurgaon.
* Tier 1 Telecom company
* Products in Optical Domain, work on technologies like Sonet, SDH, DWDM.
* Competitors in India - Alcatel-Lucent, Huawei, Cisco, Nokia-Siemens, Infinera etc
* Last year revenue of $2.3 Billion.
View Contact Details+

Contact Company:Leinex Consulting