Position Overview Informatica /Alteryx Developer will be responsible for software development activities typically associated with various SDLCs. The core focus for this position will be development, testing and rollout of the developed products/applications. The position will require deep collaboration with internal team members and some stakeholders outside of the core team. Proven experience coordinating multiple data integration projects/assignments simultaneously under minimal supervision and completing assigned tasks accurately and on a timely basis. Must demonstrate strong attention to detail with excellent organization skills. This role will primarily support the Automation team for Corporate Audit.
Required Skills: Informatica Power center, Informatica data quality tool, Hadoop, SQL Server, Oracle and Unix/PowerShell scripting
Desired skills: Familiar with all informatica suite of tools and Python.
Develop, test, debug, migrate, document and help operationalize ETL codes by leveraging industry best practices and ensure adherence to internally defined SDLC practices.
Work closely and collaborate with internal team members and some stakeholders outside of the core team in implementing solutions.
Develop codes across various platforms like informatica power center, Informatica data quality tools and Alteryx.
Create data profiles, write scripts, and develop workflows to support the data quality program.
Will be creating indexes, data models etc and other features of ETL tools that help structure the data based on the business needs.
Develop Linux/Unix shell scripts to support automation.
Work on Hadoop (Hive), SQL server and oracle platforms on a regular basis.
Write code for enhancing existing programs or developing new programs.
Review code developed by other Developers.
Provide input and drive programming standards.
Write detailed technical specifications for subsystems. Identify integration points.
Do production support and report on code errors, missing elements found in system and functional requirements and explain impacts to team members.
Occasionally supports transition of application throughout the product development life cycle (version upgrade and platform migrations)
5+ years of progressive experience in using data integration/ETL tools like Informatica (Version 10 or greater) and Alteryx.
Should have Knowledge of setting up, configuring, and maintaining ETL processes from Linux.
5+ years of experience with Linux/power shell scripting is required.
Experience working with relational data sources (i.e., SQL Server, Teradata, Oracle), Big Data sources (i.e., Hive, Hadoop), and unstructured data sources .Should have Hands on experience in Big data and Hadoop technologies
At least 3-5 years relevant experience with data analytics, with demonstrated experience and proficiency in the use of data analytics tools.
Well-versed in writing queries in an efficient and optimized manner
Excellent command over developing, maintaining and scheduling ETL jobs
Knowledge of importing data from external sources in an efficient manner (use of multiple connection types)
Candidate must possess Data Extraction and Analytics skills across multiple database platforms.
Experience writing SQL queries required
Proven experience coordinating multiple projects/assignments simultaneously under minimal supervision and completing assigned tasks accurately and on a timely basis.
Fluency in written and spoken English.
Strong communication, analytical and interpersonal skills.
Proactive in nature, assertive, inquisitive, analytical, has excellent attention to details.
Ability to develop a data-driven approach during audits.
Strong technical and analytical abilities, including a detailed understanding of application data quality controls, technical environments and project management.
About Bank of America
At Bank of America, our customers are at the center of everything we do. Our focus is on helping each one find the right financial solutions. With a wide range of career opportunities available, we invite you to realize your career goals with us while assisting customers with what matters most to them.