Business Analyst-SQL & Informatica

| Chicago
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Rightpoint, a Genpact company, is the digital consultancy with technology at its core. We design and engineer end-to-end experiences that help our clients succeed at the speed of innovation. Rightpoint serves more than 250 Fortune 1000 companies. We've partnered with brands like 3M, Sanofi, Azek, Chamberlain, Grant Thornton, Six Flags, Johnson Controls, Aon, B&H, and Abbott, just to name a few. Rightpoint has 500 employees across 10 offices. Check out our Sizzle Reel showcasing some of our latest work here. For more information, visit rightpoint.com and connect with us on LinkedIn, Twitter, Facebook and Instagram. 

 

Job Description

Required Skills:

  • The Role is that of a BA to work on Informatica (on the data mart layer over an existing data warehouse)
  • To get technically involved in the Design and Development of Database objects such as Tables, Views, Index, Stored Procedures, Packages, Functions, Triggers, and Integrity Constraints.
  • Skills/access needed for testing support of integration work
  • Basic SQL (write some queries, execute complex queries and add a simple filter, copy results to Excel)
  • Basic Informatica (override query, execute workflow, check status of workflow)
  • Basic Salesforce (write simple query in Workbench, execute and export to CSV)
  • Intermediate Excel (import data from SQL and Salesforce, manipulate/vlookup data to confirm the data matches)

 

Preferred skills 

  • Strong Expertise in Informatica PowerCenter – ETL Tool.
  • Define Universes, Contexts, Database Views and other objects of the tool
  • Create Stored Procedures with complex SQL Joins and use of Cursors
  • Define data relationships, mappings, and definitions.
  • Knowledge of Advanced RT, XML, Web services.
  • Understand the usage, nuances, and architecture of the reporting tool is used
  • Data Model knowledge – an understanding of the structure of the data, what's contained in the DataWarehouse, data sources and data quality issues 
  • Data Extraction, Transformation, and Load – an understanding of how to extract transform and load data; this would also involve obtaining and making available new data sources
  • Tool support and installation – Monitor tool usage and perform tool upgrades.
  • Good communication (written & verbal English) skills
  • Ability to work independently and as part of a team
  • Should have experience in Cloud.

Who We Are 

Intrapreneurship is defined as creating from within, starting something from nothing. And it is at the heart of the people at Rightpoint. We are a values-led organization driven by innovation, rooted in technology and relentlessly curious. We're a start-up at heart and we're able to move quickly to build unique, innovative customer experiences that evolve the way our clients do business.  

Humble Brag 

  • Top Workplace Awards: Chicago Tribune – 5 Years!, Dallas Business Journal, Chicago Timmy Awards, and Crain's Business Detroit 
  • Crain's Chicago Fast Fifty of "Fastest Growing Companies," 4 Years! 
  • Best Charitable Organization/Non-Profit Website – Webby Awards 
  • Top Partners with Microsoft, Sitecore, and EpiServer 
  • Google Developers Certified Agency – 4 years running! 

 

Who We Are 

Intrapreneurship is defined as creating from within, starting something from nothing. And it is at the heart of the people at Rightpoint. We are a values-led organization driven by innovation, rooted in technology and relentlessly curious. We're a start-up at heart and we're able to move quickly to build unique, innovative customer experiences that evolve the way our clients do business.  

Humble Brag 

  • Top Workplace Awards: Chicago Tribune – 5 Years!, Dallas Business Journal, Chicago Timmy Awards, and Crain's Business Detroit 
  • Crain's Chicago Fast Fifty of "Fastest Growing Companies," 4 Years! 
  • Best Charitable Organization/Non-Profit Website – Webby Awards 
  • Top Partners with Microsoft, Sitecore, and EpiServer 
  • Google Developers Certified Agency – 4 years running! 
  •  

Benefits and Perks at Rightpoint 

  • Flexible PTO 
  • Casual and open office environment 
  • Flexible Work Schedule 
  • Great insurance coverage and flexible spending accounts 
  • 401k with Company Matching 
  • Weekly Snack/Drink delivery 
  • Regular Cultural & Social Events including: Volunteering, Game Nights, Cultural and Diversity Spotlights, Happy Hours, Team Outings, Intramural Sports, etc. 
  • Bi-Weekly Catered Lunches 
  • Continuous Training, Certifications, and Learning Opportunities  

Our Commitment to You 

No matter who you  are, where you come from, who you love, what you believe, or what you geek out about, we bring people together to make great work. That's what makes us Rightpoint! 

 

EEO Statement: 

Rightpoint, a Genpact Company, is an Equal Opportunity Employer and considers applicants for all positions without regard to race, color, religion or belief, sex, age, national origin, citizenship status, marital status, military/veteran status, genetic information, sexual orientation, gender identity, physical or mental disability or any other characteristic protected by applicable laws. We are committed to creating a dynamic work environment that values diversity and inclusion, respect and integrity, customer focus, and innovation.  

 

 

 

Read Full Job Description
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • .NETLanguages
    • C#Languages
    • JavaLanguages
    • JavascriptLanguages
    • KotlinLanguages
    • PythonLanguages
    • RubyLanguages
    • SqlLanguages
    • SwiftLanguages
    • SitecoreLanguages
    • ReactLibraries
    • AngularJSFrameworks
    • ASP.NETFrameworks
    • HadoopFrameworks
    • Node.jsFrameworks
    • Ruby on RailsFrameworks
    • AxureDesign
    • BalsamiqDesign
    • InVisionDesign
    • SketchDesign
    • ConfluenceManagement
    • Microsoft ProjectManagement
    • TrelloManagement
    • SitecoreCMS
    • EpiServerCMS
    • Microsoft DynamicsCRM
    • SalesforceCRM

Location

We’re located in the Loop, across the street from the Lyric Opera House and the Chicago River and just steps from the L and both Metra stations.

What are Rightpoint Perks + Benefits

Rightpoint Benefits Overview

Flexible PTO

Casual and open office environment

Flexible Work Schedule

Great insurance coverage and flexible spending accounts

401k with Company Matching

Weekly Snack/Drink delivery

Regular Cultural & Social Events including: Volunteering, Game Nights, Cultural and Diversity Spotlights, Happy Hours, Team Outings, Intramural Sports, etc.

Bi-Weekly Catered Lunches

Continuous Training, Certifications, and Learning Opportunities 

Culture
Volunteer in local community
Friends outside of work
Eat lunch together
Daily stand up
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Open office floor plan
Diversity
Unconscious bias training
Diversity manifesto
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Rightpoint employees can contribute up to $2700 annually to their FSA.
Disability Insurance
Disability insurance covers 60% of annual salary up to $10,00 monthly maximum payout for Long-Term, and $1,500 per week for Short-Term.
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Rightpoint provides life insurance is equal to 1x times an employee's annual salary.
Wellness Programs
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Rightpoint provides employees with a 401(k) matching plan
Performance Bonus
Rightpoint has an annual performance bonus plan.
Child Care & Parental Leave Benefits
Child Care Benefits
Rightpoint provides backup child care assistance.
Generous Parental Leave
We provide up to 4 weeks of parental leave for the primary caretaker, and also provide 2 weeks of leave for the secondary caretaker. This is in addition to other benefits that layer on top of these.
Flexible Work Schedule
Rightpoint provides employees with a flexible work schedule that includes Core hours, Flexible start and end times.
Remote Work Program
Our remote work program includes work from home Work remotely, typically 1-2 days per week. Team members remotely on occasion as needed.
Family Medical Leave
Employees who have been with the company for 12 months are eligible for 12 weeks of family medical leave.
Company sponsored family events
Rightpoint sponsors family oriented events periodically throughout the year.
Vacation & Time Off Benefits
Generous PTO
Rightpoint offers a Flexible Time Off (FTO) policy which operates on the “honor system.” The policy is intended to provide team members with more flexibility to manage work schedules and personal
Paid Holidays
Paid Sick Days
Rightpoint has a Flexible Time Off Policy
Perks & Discounts
Beer on Tap
Casual Dress
Commuter Benefits
Rightpoint offers pre-tax commuter and parking benefits for all team members.
Company Outings
Rightpoint hosts company outings Semi-annually.
Stocked Kitchen
Rightpoint has a very well stocked pantry with deliveries from Peapod 2x per week. We also have Cold Brew, Kombucha, and Beer on Tap
Happy Hours
Happy hours are hosted regularly throughout the year
Professional Development Benefits
Job Training & Conferences
Rightpoint offers support for ongoing training and support for job training and conferences.
Diversity Program
Lunch and learns
Rightpoint hosts lunch and learn meetings regularly.
Cross functional training encouraged
Promote from within
Mentorship program
Rightpoint's mentorship program includes 1-to-1 program, Career mentoring, Leadership mentoring.
Online course subscriptions available
More Jobs at Rightpoint25 open jobs
All Jobs
Data + Analytics
Design + UX
Dev + Engineer
Marketing
Operations
Project Mgmt
Sales
Content
Data + Analytics
new
Chicago
Developer
new
Chicago
Marketing
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Sales
new
Chicago
Content
new
Chicago
Project Mgmt
new
Chicago
Design + UX
new
Chicago
Operations
new
Chicago
Project Mgmt
new
Chicago
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView Rightpoint's full profileSee more Rightpoint jobs