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
search

Select a Skill

Talent

Join as Talent Post a project

checked This is a sample alert

logo

Data Engineer- AWS Red Shift

  • Full Time
  •  On-Site - Bangalore
  • 6 months
  • Project posted on: 30/10/2024

Data Engineer- AWS Red Shift

  • Information Technology
  • DBA/datawarehousing

On-Site - Bangalore

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:

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

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.

Data Engineer- AWS Red Shift

IT Services & Consulting

  • DBA/datawarehousing
clock_icon 6 month(s)
exp_icon6+ years
location_icon On-Site
SKILLS REQUIRED
  • #Powercentre
  • #AWS Redshift
  • #ETL Architecture
  • #Informatica ETL
  • #AWS
  • #SQL
Apply

Consultant—Agile Hardware Leader

Electricial Utilities and Power Producers

  • Software Development - web technologies
  • DBA/datawarehousing
  • Project/Program Management
  • Quality Assurance & Testing
  • Technology Operations and Support
clock_icon 6 month(s)
exp_icon6+ years
location_icon Remote
SKILLS REQUIRED
  • #Agile/Scrum
  • #Product Management
  • #Hardware Development
  • #Hardware Design & Testing
  • #Embedded Hardware Development Lifecycle
  • #Industrial Automation Controller
Apply

Consultant - Database Administrator (Postgres + Oracle)

IT Services & Consulting

  • DBA/datawarehousing
  • Technology Operations and Support
clock_icon 12 month(s)
exp_icon4+ years
location_icon On-Site
SKILLS REQUIRED
  • #Security
  • #Oracle
  • #SQL
  • #Postgres
  • #Compliance
  • #Database
Apply

Consultant—AWS Serverless Developer

IT Services & Consulting

  • Software Development - web technologies
  • DBA/datawarehousing
  • Technology Operations and Support
  • Software architect
  • Software Development - Python
clock_icon 4 month(s)
exp_icon4+ years
location_icon Hybrid
SKILLS REQUIRED
  • #AWS Glue
  • #Redshift
  • #Aurora
  • #PySpark
  • #Python
  • #Data Engineering
Apply

GCP Architect Consultant

Oil & Gas - Services and Distribution

  • Software Development - C/C#/.NET
  • Software Development - Mainframe
  • Software Development - web technologies
  • Software Development - mobile/telecom
  • DBA/datawarehousing
clock_icon 3 month(s)
exp_icon10+ years
location_icon Remote
SKILLS REQUIRED
  • #Google Cloud Platform
  • #Google Cloud
  • #Cloud Architect
  • #GCP
  • #Cloud Storage
  • #Architect
Apply

Consultant - MES Engineer

Construction & Engineering

  • Software Development - web technologies
  • DBA/datawarehousing
  • ERP/CRM
  • Project/Program Management
  • Technology Operations and Support
clock_icon 6 month(s)
exp_icon3+ years
location_icon Hybrid
SKILLS REQUIRED
  • #ERP
  • #MQTT
  • #networking
  • #AVEVA Pi systems
  • #solution architecture
  • #IT systems
Apply

Consultant : Data Engineer

Healthcare Providers & Services (Hospitals, clinics, diagnostics)

  • DBA/datawarehousing
  • Data Science
clock_icon 6 month(s)
exp_icon4+ years
location_icon On-Site
SKILLS REQUIRED
  • #azure db
  • #Data querying
  • #SQL
  • #oracle
  • #aws
  • #oracle db
Apply

Consultant - Salesforce Health Cloud Technical Lead

IT Services & Consulting

  • Software Development - web technologies
  • DBA/datawarehousing
  • Business Analysis
  • Technology Operations and Support
  • Software architect
clock_icon 6 month(s)
exp_icon5+ years
location_icon On-Site
SKILLS REQUIRED
  • #Salesforce Health Cloud
  • #Computer Science
  • #software development
  • #Salesforce
  • #Information Systems
  • #SOQL
Apply

Consultant - Business Analyst Healthcare

IT Services & Consulting

  • DBA/datawarehousing
  • ERP/CRM
  • Business Analysis
  • Technology Operations and Support
  • Product Management
clock_icon 6 month(s)
exp_icon3+ years
location_icon On-Site
SKILLS REQUIRED
  • #Healthcare
  • #Product management
  • #EMR/EHR
  • #CRM
  • #Business Analyst
  • #Health Management Information Systems
Apply

Consultant : Shiny Engineer

Professional Services - Consulting

  • Software Development - Java/J2EE
  • DBA/datawarehousing
  • UI/UX
  • Software Development - Javascript
  • Software Development - HTML, CSS
clock_icon 6 month(s)
exp_icon7+ years
location_icon Remote
SKILLS REQUIRED
  • #Tidyverse dialect
  • #Tidyverse
  • #sql
  • #html
  • #javascript
  • #css
Apply

Consultant—Data Tester

IT Services & Consulting

  • DBA/datawarehousing
  • Project/Program Management
  • Quality Assurance & Testing
  • Technology Operations and Support
  • Technology Management
clock_icon 4 month(s)
exp_icon5+ years
location_icon Remote
SKILLS REQUIRED
  • #Data Validity
  • #Dashboard/Reports
  • #Data Quality Management
  • #Data Warehouse Testing
  • #Quality Assurance Metrics
  • #Python
Apply

Consultant Power BI (Azure)

IT Services & Consulting

  • DBA/datawarehousing
  • Business Analysis
clock_icon 6 month(s)
exp_icon3+ years
location_icon On-Site
SKILLS REQUIRED
  • #Data visualization
  • #Azure Cosmos
  • #Azure Data engineering
  • #Power BI Analytics
  • #AAS
  • #SQL
Apply
View More Projects btn btn

More than 3000 clients rely on Flexing It today

item_1
item_2
item_3
item_4
item_5
item_6
item_8
item_9

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.