Blue.cloud
Overview
We are looking for a candidate to provide Informatica PowerCenter development and production support, with 2 years of Informatica Center experience. Nice to have: Data Quality (IDQ), IICS, Control M, SSMS expertise to design and build the required solutions for our clients.
Responsibilities
- Independently plans, designs, develops, executes and monitors complex data integration activities to support project delivery and daily operation.
- Experience in defining, implementing, debugging and optimizing data integration mappings and scripts from a variety of data sources.
- Development of ETL code, metadata definition and models, queries, scripts, schedules, work processes and maintenance procedures; identify opportunities to optimize the sizing, performance and efficiency of existing processes.
- Perform unit testing, system integration testing, regression testing and assist with user acceptance testing.
- Consult with the business to develop documentation and communication materials to ensure accurate usage and interpretation of data.
- Develops technical understanding of how the data flows from various source systems to fine-tune data integration solutions.
- Work independently or as part of a team to deliver data warehouse ETL projects.
- Adhere to established standards and best practices and provide input for improvement of those processes.
- Self-motivated team player who can work with minimal supervision and adapt to a quickly changing environment.
- Maintain a high-volume data warehouse application.
- Ability to work on multiple tasks simultaneously and handle conflicting priorities.
Experience and Education
- At least 2+ years of relevant experience is desired.
- Bachelor's/Master's degree in Computer Science/Information Systems from a reputed university.
- Strong computer science fundamentals.
- Strong in communications with business stakeholders.
- Excellent technical, analytical and organizational skills.
- Effective written and verbal communication skills, including technical writing.
Technical Skills & Competencies
- Must have hands-on experience with commercial integration products including:
- PowerCenter 10.x (REQUIRED)
- Data Integration Hub (nice to have)
- PowerExchange (nice to have)
- Informatica Cloud (nice to have)
- Data Quality (nice to have)
- Go Anywhere (nice to have)
- Experience in Windows PowerShell / UNIX Shell Scripting, and Control-M to automate job runs.
- Basic MSSQL Server Database development experience including:
- Stored Procedures
- Explain Plans
- Constraints
- Views
- Materialized Views
- Export/Import Utilities
- Must have strong knowledge of Software Development Life Cycle including requirement analysis, design, development, testing, and implementation. Hands-on experience in performance tuning of sources, targets, mappings and sessions.
- Azure Data Factory is a plus.
Support
- Ability to identify critical system health issues and flag them for discussion and resolution.
- Constantly questioning due to fluid processes and complexity of the environment.
- Proven experience in common support activities including
- User Management
- Access management
- Object management (folder, connections, rules, etc.)
- Backing up repositories
- Code migration across multiple environments
- Performance diagnosis/improvement
- Ability to handle and coordinate Sev1 tickets
Maintaining standards
- Proven experience in following standards and helping others adopt standards.
- Ensuring code is synced across all three environments.
- Ensuring development teams follow appropriate standards.