Wipro Limited (NYSE: WIT, BSE: 507685, NSE: WIPRO) is a leading technology services and consulting company focused on building innovative solutions that address clients' most complex digital transformation needs. Leveraging our holistic portfolio of capabilities in consulting, design, engineering, and operations, we help clients realize their boldest ambitions and build future-ready, sustainable businesses. With over 230,000 employees and business partners across 65 countries, we deliver on the promise of helping our customers, colleagues, and communities thrive in an ever-changing world. For additional information, visit us at www.wipro.com.
Job Description
Job Description:
The ETL Senior Developer leads planning, analysis, design, implementation, maintenance and control of ETL processes involved in Encounter Data Processing System(EDPS). The ETL Senior Developer consults with technical manager on product requirements and applies technical expertise in ETL development, SQL and data analysis to develop new encounter type process and enhance existing system to add new features. Having healthcare claim data knowledge is desired to perform activities efficiently of this role.
Want more jobs like this?
Get jobs in Jefferson City, MO delivered to your inbox every week.
Roles and responsibilities:
- Understand functional requirements for EDPS system and prepare high level and detailed design document including various transformations and mappings involved to achieve the functionality.
- Breakdown development activities into smaller tasks and prioritize to assign to development team.
- Develop transformation logic and mappings using Informatica PowerCenter, develop workflows to execute those mappings concurrently.
- Review developed ETL components (maps, transformations, tasks, and workflows) and make sure review comments have been addressed before promoting to QA environment.
- Develop complex SQL queries for data aggregation and fine tune existing SQL queries to improve system performance.
- Support customer questions by analyzing encounters data and provide answers and fix if any issues found by aligning to BAU process.
- Learn and support Informatica PowerCenter version upgrade on all environments, when needed.
Experience:
- 5 to 7 years of Informatica PowerCenter(10x version and above) experience in developing complex ETL mappings.
- 5 to 7 years of experience working with relational databases like DB2, Oracle, PostgreSQL etc. Should be able to write complex logic in SQL to get data insights and do data analysis.
- 5 to 7 years of experience working with flat files as source and targets using Informatica PowerCenter.
- 3 to 4 years of experience in data analysis, data quality.
- Minimum of 2 years of experience in performance tuning aspects of PowerCenter mappings.
- 1 to 2 years of shell scripting experience preferably on Linux OS.
- Minimum of 2 years of experience in healthcare domain is good to have.
- Good to have skills: Experience in migration of PowerCenter to IICS, Experience in BI solutions like Cognos, Power BI.
Deliver
NoPerformance ParameterMeasure1ProcessNo. of cases resolved per day, compliance to process and quality standards, meeting process level SLAs, Pulse score, Customer feedback, NSAT/ ESAT2Team ManagementProductivity, efficiency, absenteeism3Capability developmentTriages completed, Technical Test performance
Expected annual pay for this role ranges from $60,000 to $1,35,000 . Based on the position, the role is also eligible for Wipro's standard benefits including a full range of medical and dental benefits options, disability insurance, paid time off (inclusive of sick leave), other paid and unpaid leave options.
Reinvent your world. We are building a modern Wipro. We are an end-to-end digital transformation partner with the boldest ambitions. To realize them, we need people inspired by reinvention. Of yourself, your career, and your skills. We want to see the constant evolution of our business and our industry. It has always been in our DNA - as the world around us changes, so do we. Join a business powered by purpose and a place that empowers you to design your own reinvention. Come to Wipro. Realize your ambitions. Applications from people with disabilities are explicitly welcome.
If you encounter any suspicious mail, advertisements, or persons who offer jobs at Wipro, please email us at helpdesk.recruitment@wipro.com. Do not email your resume to this ID as it is not monitored for resumes and career applications.
Any complaints or concerns regarding unethical/unfair hiring practices should be directed to our Ombuds Group at ombuds.person@wipro.com.
We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, caste, creed, religion, gender, marital status, age, ethnic and national origin, gender identity, gender expression, sexual orientation, political orientation, disability status, protected veteran status, or any other characteristic protected by law.
Wipro is committed to creating an accessible, supportive, and inclusive workplace. Reasonable accommodation will be provided to all applicants including persons with disabilities, throughout the recruitment and selection process. Accommodations must be communicated in advance of the application, where possible, and will be reviewed on an individual basis. Wipro provides equal opportunities to all and values diversity.