ETL Informatica Developer

• Individual should be able to demonstrate technical and analytical skill in developing complex ETL workflows using Informatica Powercenter.
• Create data mapping to ingest data from disparate data sources ranging from flat files to RDMS, Hive or REST APIs. Responsible for developing Unix scripting.
• Proficiency in MuleSoft tools desired. Must be able to work independently with minimum supervision. Responsible to develop test cases and perform unit testing.
• Must be able to interact and co-ordinate with distributed team. Must have good communication skills. Responsible to provide regular task status update to the management.

Desired skills:

• Source control repository - SVN/BitBucket, Continuous Build integration tools (IBM UBuild/Jenkins, IBM UDeploy/Ansible).

• Expert in PL/SQL programming and Database design, with strong data analysis skills

• Self-managed and proactive communicator

• Unix scripts

• Autosys

• Informatica for ETL

• Previous experience of working in a data warehouse project is a plus

• Python programming

• Tableau/reporting experience

• Experience in working with Mulesoft and other API technologies.

• Source control repository - SVN/BitBucket, Continuous Build integration tools (IBM UBuild/Jenkins, IBM UDeploy/Ansible)

The ideal candidate will have: < Mulesoft, PL/SQL, Informatica, UNIX.>

Mandatory skills:

• Technically strong in Informatica Power center.
• Technically strong in performance tuning of targets, sources, mappings and SQL queries.
• Conceptually good in PL/SQL, Functions, and writing complex SQLs, and creating and exposing views/materialized views.
• Strong in UNIX commands and Scripting.
• Good in MuleSoft Integration.

Benefits: Innova Solutions offers benefits( based on eligibility) that include the following: Medical & pharmacy coverage, Dental/vision insurance, 401(k), Health saving account (HSA) and Flexible spending account (FSA), Life Insurance, Pet Insurance, Short term and Long term Disability, Accident & Critical illness coverage, Pre-paid legal & ID theft protection, Sick time, and other types of paid leaves (as required by law), Employee Assistance Program (EAP). ABOUT INNOVA SOLUTIONS: Founded in 1998 and headquartered in Atlanta, Georgia, Innova Solutions employs approximately 50,000 professionals worldwide and reports an annual revenue approaching $3 Billion. Through our global delivery centers across North America, Asia, and Europe, we deliver strategic technology and business transformation solutions to our clients, enabling them to operate as leaders within their fields. Recent Recognitions: * Named One of America's Best Employers for New Grads by Forbes (2024 * Named One of the Best Companies to Work for by U.S. News & World Report (Private Companies List, 2024-2025) * One of the Largest IT Staffing Firms in the US - Ranked #3 by Staffing Industry Analysts (SIA, 2024) * One of the Largest Staffing Firms in the US - Ranked #13 by Staffing Industry Analysts (SIA, 2024; includes Innova Solutions, Volt, & HireGenics) * Named One of the Top Ten Private Companies in Atlanta by the Atlanta Business Chronicle (2023) * One of the Largest Certified Minority Business Enterprises (MBEs) in the United States (NMSDC, 2024) * AWS Advanced Tier Services Partner with 100+ certifications Website: https://www.innovasolutions.com, employment opportunities. Innova Solutions (HireGenics/Volt) does not discriminate against applicants based on citizenship status, immigration status, or national origin, in accordance with 8 U.S.C. § 1324b. The company will consider for employment qualified applicants with arrest and conviction records in a manner that complies with the San Francisco Fair Chance Ordinance, the Los Angeles Fair Chance Initiative for Hiring Ordinance, and other applicable laws. By applying for this job, you agree to receive calls, AI-generated calls, text messages, or emails from Innova Solutions and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy at Privacy Policy - innovasolutions.