Business Analyst-SQL & Informatica
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.