Title: Informatica Developer
Location: Hybrid, Troy MI (Local to MI)
Duration: 6+ Months
MOI: Phone then Video
Visa: No H1B
Full education info in resume is must
LinkedIn is must
Experience Level 5-10 years
Skills & Job Responsibilities -
The Flagstar Informatica ETL Developer is responsible for developing, enhancing, debugging, maintaining, documenting, and testing software applications that will support various business units using IICS (Informatica Intelligent Cloud Services).
• Create Informatica mappings with Oracle database objects to incorporate critical business functionality to load the data into the Salesforce application.
• Create/Use connections to retrieve data from various sources.
• Work with relational databases like Oracle to understand the data and be able to analyze/troubleshoot data issues.
• Actively participate in all phases of SDLC from requirements gathering, architecture design, development, testing, and data migration.
• Provide documented operation and user procedures, when required, and perform supporting training for respective users.
• Provide data flow diagrams describing the solution, when required.
• Document implementation instructions for production and lower-environment deployments.
• Run jobs and facilitate procurement of test data, when needed, in order to test code to satisfaction.
• Be available for occasional off-hours (Eastern time zone) production deployments in order to support dev ops team if questions/issues arise with ETL code.
• Import/export objects using IICS and knowing the impacts of all of the options.
• Troubleshoot and analyze error logs and job results that do not meet the requirements.
• Communicate effectively and in a timely, respectful, professional manner with all teammates.
Required experience:
• 3-5 years of ETL experience using Informatica IICS
• 3-5 years practical experience with SQL (standard query language) on relational databases
• Effectively communicate in English, both written and spoken language Preferred experience:
• Using Salesforce Developer Console with SOQL (Salesforce Object Query Language)
• Maintaining production systems
• Data modeling
• Creating and maintaining business reports
• Intermediate-level expertise in Microsoft Excel (vlookups, pivot tables, etc)
• Running Salesforce DataLoader
• Promoting code between environments
• Working with MSDOS batch files as pre- and post-conditions for IICS jobs
• IICS server configurations
• Analyzing and retrieving full production error logs from server
Thank You!
Udit Dabas| Sr. Technical Recruiter
D: 215-278-8860| E: udit.dabas@firstringsolutions.com
First Ring Solutions LLC | Philadelphia, PA 19102