Hi
Hope you are doing great.
Please send me suitable profiles for below position.
Role: Informatica Developer
Location: Indianapolis, IN
Duration: 6-12 months
Duties/Responsibilities:
· Work with Business Analysts to understand functional requirements in order to design ETL and reporting processes
· Utilized report design skills to translate function requirements into useful reporting and analysis
· Troubleshoot issues during ETL development
· Develop and execute unit test plans
Required Skills and Experience
· Bachelors degree required with emphasis in business information systems or computer science
· Experience translating functional requirements into useful reporting analysis
· 3+ years’ experience with ETL, Data Warehousing and Data Mart design and development
· 3+ years development experience using Informatica Power Center (including 2 years of v 9.x or higher) for design, development and performance tuning
· 3+ years developing complex business rules and data quality logic sourcing data from multiple platforms and formats into a targeted database(s)
· 3+ years’ troubleshooting existing ETL programs and workflows in a production environment
· 3+ years’ experience defining and conducting performance testing and tuning of ETL programs and databases
· Experience writing SOL queries to validate reports and research data
· Experience using Open Source Report Tools (BIRT, Pentaho, Jaspersoft)
· Ability to write file manipulation scripts and setup scheduling in a Windows environment
· Excellent interpersonal, verbal, and written communication skills
· Proficient in MS Office applications with strong emphasis on MSExcel, MSWord and MSVisio
Optional Skills and Experience
· Informatica Certified Professional
· Experience with Cognos 10 and later suite of tools on Windows as both Report Developer and Business Analyst
· Experience in creation of dimensional and relational models using IBM Cognos Framework Manager and Transformer cubes
· Experience in Dashboards, Scorecards, and Reports using Report Studio
· Experience working with business users to design and develop correct, well
· performing Cognos reports, frameworks and cubes using Report, Event, Query, Analysis, and Metric Studio with data drill-down and slice & dice capabilities
· Experience using Tableau
· Experience using an RDMS – preferably Oracle 12c
· Experience using Java
· Knowledge in OLTP/OLAP and ODS systems
Thanks
Rajashekar Pasula
Lead IT
Corporation - IT Services & Solutions
1999 Wabash Avenue, Suite 210, Springfield, IL 62704
Direct: (217)-993-8048
Email: she...@leaditgroup.com