This website uses cookies to ensure you get the best experience on our website. By continuing to use this site, you agree to our cookie  & privacy policy.Accept

checked This is a sample alert

Consultant-ADL Developer

  • Full Time
  •  On-Site - Bengaluru
  • 6 months
  • Project posted on: 27/05/2025
add_new View Project Details

Consultant-ADL Developer

  • Information Technology
  • Software Development - web technologies
  • DBA/datawarehousing
  • Software architect

On-Site - Bengaluru, Bengaluru

Full Time

6 months

 27/05/2025

Assignment Details

Key Responsibilities: 

 

  • This is a strong technology and solution delivery role, accountable for the successful design, development, and delivery of ETL solutions on the corporate Data Platform – not only for self, also for a team of developers working on specific projects. 
  • Lead and guide an Informatica based ETL architecture to handle complex business rules while balancing the fulfillment of stringent performance requirements.
  • Drive design and determine the ETL requirements for BI projects.
  • Partners with ETL developers through the development of complex ETL routines to load a dimensional star schema (and supporting layers) and develops error handling processes.
  • Perform an active, leading role in shaping and enhancing overall ETL Informatica architecture, including ETL standards, patterns and best practices.
  • Work with team to ensure standards and patterns are followed.
  • Determines organizational strategies for data integrity validation processes.
  • Establishes policies and best practices for optimizing ETL data throughput/accessibility
  • Identifies opportunities for new architectural initiatives; makes recommendations on the increasing scalability and robustness of ETL platforms and solutions.
  • Partner with the Data architect to drive improvements and enhancements to the current data landscape and future strategy.
  • Partner with Leadership team to ensure the successful delivery of projects.
  • Remain current on new ETL techniques and methodologies and communicate trends and opportunities to management and other developers as needed.
  • Identify opportunities for uses of those technologies to enhance current or anticipated information systems and business goals needs
  • Support ETL developers by providing technical assistance, troubleshooting and alternative development solutions.
  • Playing a key role in mentoring other staff members and a proven track record in knowledge transfer to other team members and departments.
  • Evaluates existing applications that could address client requirements and makes recommendations from complex projects.
  • Identifies alternative uses of technologies that will enhance current or anticipated information systems and that support overall corporate and business goals that are appropriately aligned with the enterprise architecture.
  • Identifies necessary changes to current business process.
  • Identifies opportunities for solution sharing and reuse.
  • Assists in the development of ETL-related Service Level Agreements.
  • Communicates risks and ensures understanding of these risks.

Skills Required

Qualifications:

 

  • 7 years of experience in SQL, analytical (STAR schema) data modeling and Informatica PowerCenter.
  • 5 years hands on experience in Informatica PWC / IICS ETL development.
  • 5 years of Oracle (or comparable database) experience with BI/DW deployments.
  • Must have proven experience with STAR and SNOWFLAKE schema techniques.
  • Good to know cloud like AWS Services.
  • Proven track record as an ETL developer potentially to grow as an Architect, leading development teams to deliver successful business intelligence solutions with complex data sources.
  • Strong analytical skills and enjoys solving complex technical problems.
  • Knowledge on additional ETL tools (Qlik Replicate), End to End understanding of data from ingestion to transformation to consumption in Analytics will be great benefits. 

About the Client

A leading global specialist in energy management and automation

Industry

Electricial Utilities and Power Producers

Minimum Experience:

8+ years

Additional Skills:

  • Building Information Modeling
  • Cloud Storage
  • STAR
  • Snowflake
  • AWS
  • SQL

No of open positions:

1

How it works

  • 1

    Build your
    skill profile

  • 2

    Strengthen it
    with feedback

  • 3

    Determine your
    optimal fee level

  • 4

    Apply for matching
    projects

  • 5

    Get finalized

  • 6

    Stay Engaged

Build your skill prodile

Project
step1
shape_step

Request feedback from prior projects and/or work stints

shape_step

Determine your optimal fee level

  • starFeeBee helps consultants understand how to price their services.
  • starEnter your skill & location to get ranges for what similar professionals have charged on projects.
  • starUnlock more details e.g., best paying sub-skills, ranges by projects durations, by simply adding a benchmark from a orior projects.
graph_step2
shape_step

Apply for matching projects

shape_step

Get finalized!

Project
step5
shape_step

Stay Engaged!

Project
step6
shape_step

Similar Freelance Projects you can apply to.

View More Projects btn btn

More than 3000 clients rely on Flexing It today

Frequently asked questions.

We host both full-time & part-time projects from top clients for 100+ skill categories. We also help connect experts like you with clients for short consultation calls called Flexperts

You just need to create a ‘boutique firm’ account during the registration process. The rest of the application process remains the same.

Our freelancers fee benchmarking tool, FeeBee helps our freelancers and consultants find out what their peers charged for similar projects. Built on 600K+ verified benchmarks, registered users get unlimited access to it.

As a freelancing platform, we do not provide permanent positions or full-time job to our consultant network.

Flexing It will be involved end to end right from contracts to invoicing. Once you are finalized, your payment details are transparently laid out in your contract terms with your client and our team actively liaises with the client finance team to ensure timely payments.

We do not charge any fee or commission from you. Your fee quote will be paid out to you in full as per your project contract.