Informatica + SQL Professional
We are seeking an experienced Informatica + SQL Professional with 6-7+ years of relevant experience to join our team. The ideal candidate will possess strong ETL skills with Informatica, advanced SQL and PL/SQL capabilities, and experience with TIBCO. This role requires excellent analytical and communication skills, with a proven ability to work independently and collaboratively in a fast-paced environment.
Key Responsibilities:
- ETL Development:Design, develop, and maintain ETL processes using Informatica, with 5+ years of hands-on experience.
- Work with TIBCO for data integration solutions.
- SQL & PL/SQL Expertise:Write complex SQL statements for data extraction, transformation, loading, and validation.
- Develop and optimize PL/SQL code, including stored procedures, functions, and packages.
- Data Warehousing & Modeling:Apply strong knowledge of Data Warehousing concepts, Kimball methodology, and Dimensional modeling concepts like star/snowflake schema.
- (Good to have) Experience with Control-M for job scheduling (4-5 years experience if applicable).
- Problem Solving & Analysis:Utilize strong analytical and problem-solving skills to troubleshoot data issues and optimize processes.
- Collaboration & Communication:Work independently and effectively within a team in a diverse, fast-paced, and collaborative environment.
- Demonstrate excellent written and verbal communication skills.
- Proven success working in on/off-shore development teams.
- Tooling & Best Practices:Possess good knowledge of industry tools relevant to ETL and data warehousing.
- BI Reporting (Added Advantage):Knowledge on any BI reporting tool is an added advantage.
Required Skills & Experience:
- Total Years of Experience: 6-7+ years relevant experience.
- Relevant Experience:5+ years experience on ETL (Informatica).
- 7-8+ years in PL/SQL and writing SQL statements.
- (Optional, if applicable): 4-5 years each in Tibco, Control-M, and Data Modeling.
- Mandatory Skills:Informatica, SQL, TIBCO.
- Soft Skills: Strong analytical, problem-solving, verbal, listening, and interpersonal skills. Excellent written and verbal communication skills.
Additional Information:
- Vendor Billing Rate: INR 10,500 per day.
- Background Check: Post onboarding.
- Notice Period: 15 days, not more than that.
