This project is currently inactive. You can reapply when the client reopens it and begins accepting applications. Dismiss
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: 30/10/2024

Consultant — ADL Developer

  • Information Technology
  • DBA/datawarehousing

On-Site - Bengaluru

Full Time

6 months

 30/10/2024

Assignment Details

Our client, a global leader in energy management and automation, is seeking a skilled Data Warehousing Developer with expertise in AWS Redshift and Informatica ETL.

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

 5 years hands on experience in Informatica PWC ETL development.
 7 years of experience in SQL, analytical (STAR schema) data modeling and Informatica
PowerCenter.
 5 years of Redshift / Oracle (or comparable database) experience with BI/DW
deployments.
 Good to know cloud like AWS Services.
 Must have proven experience with STAR and SNOWFLAKE schema techniques.

About the Client

A leading global specialist in energy management and automation

Industry

IT Services & Consulting

Minimum Experience:

6+ years

Additional Skills:

  • AWS
  • ETL Architecture
  • Data Warehousing
  • Powercentre
  • SQL
  • AWS Redshift
  • Data Modeling
  • Informatica ETL

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.