Requisition ID: 26125
Country/Region: US
About Wipro:
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. We leverage our holistic portfolio of capabilities in consulting, design, engineering, operations, and emerging technologies to help clients realize their boldest ambitions and build future-ready, sustainable businesses.
A company recognized globally for its comprehensive portfolio of services, strong commitment to sustainability and good corporate citizenship, we have over 250,000 dedicated employees serving clients across 66 countries.
Role: DBA (ETL/Informatica)
Job Description:
The role is responsible for the design, development, coding, testing, debugging and documentation of data-warehouse/database/business intelligence applications. Duties include hands-on new development as well as support, maintenance, or enhancement of existing applications.
- Translate business requirements into technical specifications.
- Design and implement ETL (Informatica) process using SQL, ETL tool and Linux shell scripting to deliver high-quality solutions.
- Strong data analysis, advanced SQL query writing skills, and resolving defects by working across multiple teams.
- Collaborate with other development teams to manage interdependency, set up test cases, debug, and maintain data quality.
- Ensure software stability via documentation, code reviews, regression, unit, and user acceptance testing.
- Hands-on logical and physical data modeling and database design responsibilities.
- Good understanding of Dimensional modeling.
- Lead and develop Informatica PowerCenter ETL complex flows connecting to heterogeneous databases such as Oracle/MS SQL Server.
- Develop complex Oracle procedures, functions, and packages to support database applications (API calls / DW reporting).
- Conduct both proactive and reactive performance tuning activities during the development of new applications and existing legacy applications.
- Hands-on experience to develop and support Unix Shell Scripting.
- Understanding of scheduler (Autosys).
- Perform data analysis and data profiling. Identify data quality issues.
Required Skills:
- Participate and guide the team in estimating work necessary to realize a story/requirement through the delivery lifecycle.
- Contribute to story refinement/defining requirements.
- Perform spike/proof of concept as necessary to mitigate risk or implement new ideas.
- Code solutions and unit test to deliver a requirement/story per the defined acceptance criteria and compliance requirements.
- Utilize multiple architectural components (across data, application, business) in design and development of client requirements.
- Assist team with resolving technical complexities involved in realizing story work.
- Experience with Informatica or other ETL tools.
- Professional experience with SQL/PLSQL.
- Understanding of Data Federations, Data Lake, Data Mesh, and Advanced Cloud concepts.
- Experience automating ETL with job scheduling tools. Autosys Preferred.
- Experience working with large data sets using big data solutions such as Hadoop, Spark, etc. is a plus.
- Demonstrate exceptional analytical skills and problem-solving skills; excellent organizational and communication skills.
- A good team player who seeks input and involves others in communications; values and cultivates relationships.
- Resourceful individual who seizes opportunities and is an innovator.
Desired Skills:
- Document and communicate required information for deployment, maintenance, support, and business functionality.
- Strong experience in Informatica, Data warehousing, data architecture, databases, and writing/optimizing advanced SQL queries in a business environment with large-scale, complex datasets.
- Contribute to existing test suites (integration, regression, performance), analyze test reports, identify any test issues/errors, and triage the underlying cause.
- Using Trino, Starburst, or similar vendor tool exposure would be a plus.
Wipro is an Equal Employment Opportunity employer and makes all employment and employment-related decisions without regard to a person's race, sex, national origin, ancestry, disability, sexual orientation, or any other status protected by applicable law.
#J-18808-Ljbffr