1) (primary-must have) Oracle, PL/SQL and Advanced SQL is a must (minimum 10+) exp à Vendor or Candidate ranking for this would be at least 8 and above (10 is the max)
2) (secondary) ETL Informatica
3) Agile experience
4) BoA experience
5) Any DB vendor tool experience (For Ex: Starburst)
6) Great attitude, willing to learn, full accountability, self starter. This is not a jr developer role. Client facing so great communication skill is MUST
Hybrid- Regular hours
This is NOT a Jr role where developer is awaiting step
The role is responsible for the design, development, coding, testing, debugging and documentation of data-warehouse/database/business intelligence applications.
Duties include hands-on new development as well as support, maintenance, or enhancement of existing applications.
• Translate business requirements into technical specifications.
• Design and implement ETL (Informatica) process using SQL, ETL tool and Linux shell scripting to deliver high quality solutions.
• Strong data analysis, advance SQL query writing skill and resolving the defects by working across multiple teams
• Collaborate with other development teams to manage interdependency, set up test cases, debug and maintain data quality.
• Ensure software stability via documentation, code reviews, regression, unit and user acceptance testing.
• Hands on logical and physical data modeling and database design responsibilities.
• Good understanding of Dimensional modeling
• Be able to lead and develop Informatica PowerCenter ETL complex flows connecting to heterogenous database such as oracle/MS SQL server.
• Develop complex oracle procedures ,functions, and packages to support database applications(API calls / DW reporting )
• Conduct both proactive and reactive performance tuning activities during course of development of new applications and existing legacy applications.
• Hands on experience to develop and support Unix Shell Scripting.
• Should have understanding of scheduler (Autosys)
• Perform data analysis and data profiling. Identify data quality issues.
• Participate and guide team in estimating work necessary to realize a story/requirement through the delivery lifecycle.
• Contribute to story refinement/defining requirements.
• Perform spike/proof of concept as necessary to mitigate risk or implement new ideas.
• Code solutions and unit test to deliver a requirement/story per the defined acceptance criteria and compliance requirements.
• Utilize multiple architectural components (across data, application, business) in design and development of client requirements.
• Assist team with resolving technical complexities involved in realizing story work.
Required (hard) skills/experience
Primary Skill- Oracle SQL / PLSQL
• 8+ years Informatica or other ETL tool
• 6+ years of professional experience with SQL/PLSQL
• Understand Data Federations, Data Lake, Data Mesh and Advance Cloud concepts.
• Experience automating ETL with job scheduling tools. Autosys Preferred
• Experience working with large data sets using big data solutions such as Hadoop, Spark etc. is a plus
Preferred skills/experience
• Document and communicate required information for deployment, maintenance, support, and business functionality.
• Strong experience in Informatica, Datawarehousing, data architecture, databases and writing/optimizing advanced SQL queries in a business environment with large-scale, complex datasets
• Contribute to existing test suites (integration, regression, performance),analyze test reports, identify any test issues/errors, and triage the underlying cause.
• Using Trino, Starburst or similar vendor tool exposure would be a plus
Characteristics of the top performer
• Self starter, able to work on fast paced complex setup, able to function independently and deliver the work by proactively resolving the impediments.
• Demonstrate exceptional analytical skills and problem solving skills; excellent organizational, communication skills
• A good team-player who seeks input and involves others in his/her communications; a person who values and cultivates relationships.
• An individual with a demonstrated ability to get things done and make things happen; a person who is resourceful, seizes opportunities and is an innovator.
