Required Skills

Informatica Cloud MS SQL Server SSIS SSRS SSAS

Work Authorization

  • Us Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 5th Jan 2021

JOB DETAIL

Role:ETL Informatica Developer
Location:Milwaukee, WI 53209
Duration:6+Months
Job Description:-
•Informatica Cloud
•SSIS
•SSAS
Power BI
• Proficient in Informatica Cloud, MS SQL Server Development, and Microsoft BI suite of products -SSIS, SSRS, SSAS, and Power BI with atleast 7+ years of experience in ETL technologies.
• Design and development of Complex Mappings, Reusable Objects (Mappings, Lookups, Transformations, Tasks), transformations, extractions and loads.
• Analyze Source, Requirement, existing OLTP system and Identification of required dimensions and facts from the Database.
• Conduct Data Quality Tests. Oversee mappings and workflows, check data integrity and accuracy, and perform data cleansing procedures as needed. Maintain up-to-date documentation of implementation, troubleshooting, and ETL processes related to Informatica systems. Review data storage and access procedures and use Informatica tools to update, test, and provide solutions for data issues
• Provide recommendations and expertise of Cloud data integration
• Support SIT, UAT and Production deployment. Support, maintain and enhance existing ETL process built in Informatica Cloud and SSIS & SSRS.

Company Information