Frederick, MD




Title: Sr Informatica Business Analysis Location: Frederick, MD Duration: 6 months + ext. Visa: GC/USC/H1B (If he is ready for transfer) Skills: Strong Informatica technical knowledge in the areas on Informatica Designer Components -Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet Designer, Transformation Developer, Workflow Manager , Workflow Monitor, Development Experience in Power Center and Informatica Cloud environment Understand reusability, parameterization, workflow design, ETL Extensive experience in scheduling and managing Informatica Jobs Demonstrated skill and ability in the development of data warehouse projects/applications (Oracle & SQL Server) Strong database Analysis skill using SQL/PLSQL (Oracle) Develops ETL processes using Informatica, ETL control tables, error logging, auditing, data quality, etc. Familiar with Cloud technology (AWS) and knowledge of Python & PySparc. Good familiarity with Cognos, Power BI and SSAS Cubes development Experience in managing teams of different developers in end to end life cycle execution of Data Warehouse projects Must have good communication skills and ability to communicate with remote teams involving business and IT Must be able to look beyond the detailed requirements to understand what the business is trying to do and don't get lost in the details Must be able to develop and maintain documentation to our standards, checklist and provide feedback on standards where they can be improved Experience Overall 8 years of experience in the Data Warehouse development environment 6 8 years of experience at Enterprise-level ETL development & architecture in Informatica PC 9.x, 10.x 3 4 years' experience in managing teams in implementing data warehouse projects 2 - 3 years of Project Management experience (Agile/Waterfall) 1-2 years of experience in Informatica Cloud development environment 4 - 6 years of SQL/PLSQL development with Oracle 10g, 11g 2 3 Data Profiling / Data Analysis and Unix shell scripting. Knowledge of extract development against ERPs - SAP, Siebel, JDE, BAAN preferred