This is a sample alert
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.
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.
A leading global specialist in energy management and automation
IT Services & Consulting
6+ years
1
Build your
skill profile
Strengthen it
with feedback
Determine your
optimal fee level
Apply for matching
projects
Get finalized
Stay Engaged
IT Services & Consulting
Healthcare Technology
IT Services & Consulting
IT Services & Consulting
IT Services & Consulting
Electricial Utilities and Power Producers
IT Services & Consulting
IT Services & Consulting
IT Services & Consulting
Oil & Gas - Services and Distribution
Construction & Engineering
More than 3000 clients rely on Flexing It today
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.