Send me more jobs like this

Keywords / Skills : Informatica

8 - 12 years
Posted: 2019-07-21

Industry
ITES/BPO
Function
IT
Role
Team Leader/ Technical Leader
Education
Bachelors
Degree
Posted On
21st Jul 2019
Job Ref code
126470
Job Description
Job Description :

Key areas:
  • Informatica integration for integration (specifically callidus sales commissions experience would be ideal)
  • SAP BODS (ETL tool)
  • Cognos (Reporting)

  • Responsibilities include, but are not limited to:
    · Design, develop, test, and deliver self-service infrastructure and business intelligence (BI) content including reports and dashboards to business professional using the IBM Cognos BI and Qlikview
    · Gather requirements from business users, build out process analysis, schedules and assignments, communicate status updates, and coordinate user acceptance testing and issue management.
    · Develop best practices for solutions that help end users access and analyze data in data warehouse, data marts, and operational systems.
    · Assist business users with Ad-Hoc reporting and troubleshooting post-production issues
    · Provide training and data warehousing space to business users
    · Promote and provide support for BI solutions/capabilities to the business user community as well as executives
    · Interact with other BI team members, and cross-IT staff on support and project activities.
    · Perform early stage analysis of reporting requests to formulate high level approach and estimates
    · Design and support the data model required for reports
    · Work primarily with Data Architect, Data Integration Engineer, and BI Manager to design business intelligence and operational reporting solutions
    · Articulate data sourcing and data model requirements to ETL and database resources and collaborates on development.
    · Optimize query performance as needed for ETL jobs.
    · Contribute to the ongoing development and improvement of BI reporting processes and standards
    · Execute rapid prototyping for new report requirements using open source, Hadoop, etc.
    · Design, develop, and implement data-integration jobs to effectively process high-volume disparate data sources
    · Define and develop scalable, maintainable & innovative data-integration solutions
    · Build new data pipelines based on business requirements and input from the rest of the team
    · Maintain existing data pipelines into our data warehouse
    · Develop and Document all ETL jobs and processes according to ETL standards and best practices
    · Define and implement monitoring and self-recovery strategies for ETL and Scheduled reports
    · Interact closely with business partners and Engineering teams to determine analytics needs and translate those needs into efficient & scalable ETL processing needs
    · Ensure ETL requirements are clearly understood and documented
    · Proactively focus on data integrity, data hygiene and performance improvement of existing processes
    · Validate and enforce integration standards and best practices that meet the needs of the business and guarantee consistent results across projects
    · Provide technical leadership for solution development and review data integration architecture design
    · Implement automated data quality checks, as part of ETL, and iteratively improve upon them as needs evolve
    · Write scripts to retrieve data from non-proprietary systems using APIs (i.e. SOAP, REST, etc.) and build pipelines into the DW for the same
    Minimum Requirements:
    · 4 year degree in Computer Science, Information Systems, or in a related discipline
    · 10+ years of relevant work experience in data warehousing, data modeling and reporting services
    · At least 5 years’ experience with Cognos with excellent development skills, including Framework Manager.
    · At least 4 years’ of experience supporting Data Warehouse, Data Integration and Business Intelligence reporting.
    · At least 4 years’ working with ETL Pipeline tools such as Data Manager, Data Services and SSIS.
    · At least 4 years’ experience with Extract, Transform, Load/ETL best practices and cutting edge Data Integration tools, technologies, and techniques is required.
    · At least 3 years’ experience developing ETL and/or reports based on SAP data in a manufacturing company
    · At least 3 years’ experience developing ETL and/or reports based on Salesforce data.
    · At least 2 years’ working experience with SAP BODS
    · Strong problem solving and analytical skills even with no business requirements
    · Strong presentation skills including the ability to interact with top-C level business leaders
    · Must exemplify leadership and salesmanship qualities to promote BI solutions throughout the organization
    · Strong competence in gathering and documenting business requirements, defining optimal BI solutions to business problems
    · Strong understanding of SDLC best practices with an emphasis on DW/BI practices and excellent at SQL Skills
    · Excellent verbal and written communication skills with the proven ability to multitask, prioritize work
    · Hands on Framework Manager Dimensional Modeling, Dashboard and report development experience
    · Proficient in Microsoft Office
    · Proven and strong Oracle and MS SQL development
    · Very strong analytical and SQL skills
    · Strong shell scripting experience.
    · Strong Data Architecture background.
    · Flexibility to work with customers and peers across time zones (India, Europe, APAC and Latin-American)
    · We are a global company and require overlap hours on regular basis is expected to interact with business and peers
    · On call availability to address job failures
    Preferred/Nice to Have:
    · Experience with Informatica, Power BI, SharePoint, Performance Point, Excel Services, PowerPivot, Qlikview, SSIS, Crystal Reports
    · Proven experience with SQL and advanced database topics including: performance tuning, partitioning, data warehousing, server maintenance
    · Strong understanding of OLAP database/cube architecture, Normalization & Data mining
    · Excellent working knowledge of Oracle, SAP FICO, SD, MM, or equivalent modules
    · High level understanding of the .NET framework and .NET technologies including: C#, VB.NET, ASP.NET, Web Services, JavaScript
    · Experience with Machine Learning, Predictive analytics, Azure BI and Data Services
    ·Rapid prototyping and agile methodology
    Other Requirements
    · Adaptability, creativity, versatility, self-starter and a collaborative attitude
    · Solid communication skills: must enjoy working with stakeholders, eliciting requirements and solving problems around data / reporting automation.
    · Hands one experience with multiple Data Integration tools and technologies, some examples include Domo, Hadoop, Amazon RedShift, Talend, Apatar, CloverETL, GoKettle, KETL, and Pentaho Data Integration for Big Data. The team looking for individuals with a strong blend of knowledge, tell us about what you have done.
    · This is a full time position reporting directly to the Director of BI within an extraordinary organization. The team is looking for someone to evolve with them long term, and they are interested in keeping you once you join the team by reminding you of how valuable you and your talents are to their mission.
    Key Skill(s)

    Similar Jobs
    View All Similar Jobs
    Walkin for you