Senior Software Engineer (Informatica, ETL, IICS Data integration)

About this role:

Wells Fargo is seeking a Senior Software Engineer...

In this role, you will:
Lead moderately complex initiatives and deliverables within technical domain environments
Design, code, test, debug, and document for projects and programs associated with technology domain, including upgrades and deployments
Review moderately complex technical challenges that require an in-depth evaluation of technologies and procedures
Resolve moderately complex issues and lead a team to meet existing client needs or potential new clients needs while leveraging solid understanding of the function, policies, procedures, or compliance requirements
Collaborate and consult with peers, colleagues, and mid-level managers to resolve technical challenges and achieve goals
Act as an SME and escalation point, provide guidance and direction to less experienced staff
Contribute to large scale planning of strategies
Required Qualifications, International:
Overall 8+ years of experience in Data Warehousing and ETL
Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
Atleast 4 years of hands on experience in IICS Data integration / Cloud Application integration.
Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
Extensive experience in Oracle SQL, PL/SQL, Unix .
Experience with tools like Jenkins, UCD and autosys
Working experience in HR Systems ( HCM) and integrating HCM applications like Workday is a big plus.
Familiar with Agile Methodology, SDLC process, Release Management.
Job Expectations:
Analyzing the business requirements, Data profiling and preparing the design document with an additional emphasis given to the solution integrity and effective data analytics.
Designing and develop code to integrate data between disparate applications built on different platforms and technologies. Build integration workflows using Data integration Hub (DIH), Intelligent Informatica Cloud Services (IICS), etc.
Design & document complex technical design requirements for integration in Data warehousing.
Develop DI/CAI for Consuming web services and APIs exposed by various vendors/SAAS solutions to integrate enterprise data.
Write complex SQL/PLSQL for database sources .
Responsible for all activities related to the development, implementation and support of ETL processes for large scale data warehouses..
We Value Diversity

At Wells Fargo, we believe in diversity, equity and inclusion in the workplace; accordingly, we welcome applications for employment from all qualified candidates, regardless of race, color, gender, national origin, religion, age, sexual orientation, gender identity, gender expression, genetic information, individuals with disabilities, pregnancy, marital status, status as a protected veteran or any other status protected by applicable law.

Employees support our focus on building strong customer relationships balanced with a strong risk mitigating and compliance-driven culture which firmly establishes those disciplines as critical to the success of our customers and company. They are accountable for execution of all applicable risk programs (Credit, Market, Financial Crimes, Operational, Regulatory Compliance), which includes effectively following and adhering to applicable Wells Fargo policies and procedures, appropriately fulfilling risk and compliance obligations, timely and effective escalation and remediation of issues, and making sound risk decisions. There is emphasis on proactive monitoring, governance, risk identification and escalation, as well as making sound risk decisions commensurate with the business unit's risk appetite and all risk and compliance program requirements.

Candidates applying to job openings posted in US: All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

Candidates applying to job openings posted in Canada: Applications for employment are encouraged from all qualified candidates, including women, persons with disabilities, aboriginal peoples and visible minorities. Accommodation for applicants with disabilities is available upon request in connection with the recruitment process.

Drug and Alcohol Policy

Wells Fargo maintains a drug free workplace. Please see our Drug and Alcohol Policy to learn more.