Informatica Developer

29 Oct 2024

Vacancy expired!

Experience - 6+ YearsThe IT Specialist will primarily provide technical expertise in data warehousing and dashboard generation using various data sources.• Develop and support an extract, transform, load (ETL) process for data warehouse structures that support reporting and data analytic systems. • Collaborate with a diverse team of business analysts and report developers to develop and build enterprise data warehouse (EDW) artifacts such as SQL code, logical and physical data models, and business intelligence reports. • Contribute to software design and architecture while following development specifications and standards. • Perform administration, analyst and developer responsibilities as needed within the full stack supporting the data warehouse. • Perform complex analysis and design across multiple database platforms and technologies covering DB2, oracle, SQL and other databases. • Instruct and guide those with less experience. • To conduct research into new data warehouse applications and determine viability for adoption. • Identify and describe business intelligence (BI) problems and requirements from across the organization. • Collaborate with data providers to ensure the right data is in the warehouse and is updated as changes occur in the data providers’ source system applications. • Profile and understand large volumes of source data, including structured and unstructured data. Sources will include MySQL, Microsoft SQL Server, flat files, web application API’s and the Cloud. • Regularly conduct ETL and database performance tuning. Look for ways to improve overall performance. • Identify opportunities to leverage existing metrics and develop new metrics to help move the organization forward by identifying waste in our processes. • Provide insight into creating and maintain a system that helps ad-hoc metrics providers move to a more robust and shareable reporting interface. • Assist in the development of metrics and processes to ensure quality standards are met on new and existing data. • Develop complex Dashboards for the agency using various data structures and sources. • Develop and support an extract, transform, load (ETL) process for data warehouse structures that support reporting and data analytic systems. • Collaborate with a diverse team of business analysts and report developers to develop and build enterprise data warehouse (EDW) artifacts such as SQL code, logical and physical data models, and business intelligence reports. • Contribute to software design and architecture while following development specifications and standards. • Perform administration, analyst and developer responsibilities as needed within the full stack supporting the data warehouse. • Perform complex analysis and design across multiple database platforms and technologies covering DB2, oracle, SQL and other databases. • Instruct and guide those with less experience. • To conduct research into new data warehouse applications and determine viability for adoption. • Identify and describe business intelligence (BI) problems and requirements from across the organization. • Collaborate with data providers to ensure the right data is in the warehouse and is updated as changes occur in the data providers’ source system applications. • Profile and understand large volumes of source data, including structured and unstructured data. Sources will include MySQL, Microsoft SQL Server, flat files, web application API’s and the Cloud. • Regularly conduct ETL and database performance tuning. Look for ways to improve overall performance. • Identify opportunities to leverage existing metrics and develop new metrics to help move the organization forward by identifying waste in our processes. • Provide insight into creating and maintain a system that helps ad-hoc metrics providers move to a more robust and shareable reporting interface. • Assist in the development of metrics and processes to ensure quality standards are met on new and existing data. • Develop complex Dashboards in Micro strategy and Business Objects for the agency using various data structures and sources.• Experience in managing the life cycle of Business Objects server environment and report generation process including generation of reports and dashboards independently -CONTRACT JOB DESCRIPTIONResponsibilities:1. Demonstrates expertise in conveying technical and functional concepts for a specific technical specialty.2. Identifies improvements to project standards to achieve high quality services/ products. This is a professional position which may require subject matter expertise consistent with demanding and rare technological skills.3. May require coordination of programming activities being conducted by the application development team4. Confers with other business and technical personnel to resolve problems of intent, inaccuracy, or feasibility of computer processing and project design.5. Works with necessary personnel to determine if modifications are necessary with interested personnel to determine necessity for modifications or enhancements.6. Leverages excellent written and verbal communication skills to develop new business process and programming solutions as directed by business and technical stakeholders.7. May coordinate activities of application developers.8. Able to identify best practices and standards for the use of the product.9. Proven track record of hands-on technical design and code work within large complex systems.10. Proven hands-on technical work with a variety of technologies.11. Demonstrated technical expertise integrating a variety of diverse technical environments and cross-platform technologies.12. Delivers support and design for industry specific applications that require integration with statewide systems or applications.13. Interacts with executive level business users or technical experts.14. Advanced experience in the required technical subject matter.15. May function as a niche technical SME (Subject Matter Expert).16. Has proven experience across large and complex implementations and systems. Minimum Education/Certification Requirements:Bachelor’s degree in Information Technology or related field with 5-8 years of solid experience in report/Dashboard generation on MicroStrategy and Business Objects platforms